Best unofficial Apache Server developers community

Answers

jdbc stored-procedures

votes

1 answers

44 views

Can't view or edit stored procedures in Netbeans (PostgreSQL connection)

Hi there! I just installed Netbeans (7.0 IDE Dev) on my mac, and I am quite happy that i dont need 2 editors anymore (1 for php, 1 for python) Now,…

postgresql stored-procedures netbeans jdbc plpgsql

asked May 2, 2011 5:30 am CDT

Koen Schmeets

votes

1 answers

51 views

MySQL - Passing UTC timestamps to sprocs via JDBC

I have a MySQL Server set to UTC (@@global.time_zone = '+00:00') and a table with a DATETIME column in which I store dates in UTC. I'm having…

mysql stored-procedures jdbc timezone

asked January 18, 2011 6:54 pm CST

EricM

vote

1 answers

80 views

How to read a UDT from a postgres stored function

I can't seem to read a UDT properly from a stored function with the postgres JDBC driver. This is some sample code: CREATE TYPE u_country AS ENUM…

postgresql stored-procedures jdbc user-defined-types

asked January 10, 2011 5:19 pm CST

Lukas Eder

votes

0 answers

137 views

Arraylist as input param for MYSQL stored procedure

Hi folks, Can I pass an arraylist as mysql stored procedure input parameter with JDBC callable statement? If not what is the possible alternative…

mysql stored-procedures jdbc

asked January 6, 2011 1:26 am CST

Kenneth

jdbc stored-procedures

Tagged: jdbc + stored-procedures

Related Tags

mysql × 175

sql × 36

php × 21

postgresql × 21

triggers × 11

database × 11

plpgsql × 7

cursor × 5

database-design × 5

mysql-query × 4

query × 4

c# × 4

jdbc × 4

mysqli × 4

mysql-error-1064 × 3

sql-server × 3

stored-functions × 3

pdo × 3

database-queries × 3

view × 3

events × 3

java × 3

transactions × 2

concat × 2

temporary-tables × 2

delimiter × 2

error × 2

python × 2

if-statement × 2