8.0 + JDBC3 Driver
От | Dave Held |
---|---|
Тема | 8.0 + JDBC3 Driver |
Дата | |
Msg-id | 49E94D0CFCD4DB43AFBA928DDD20C8F902618573@asg002.asg.local обсуждение исходный текст |
Ответы |
Re: 8.0 + JDBC3 Driver
|
Список | pgsql-jdbc |
First, I have an oddity with the 8.0-310.jdbc3 driver. When I query the db, I have to explicity specify the ResultSet type and concurrency if I want something other than a FORWARD_ONLY ResultSet. This was not necessary in 7.4. How do I tell when a table will return a FORWARD_ONLY ResultSet by default? Second, I'm having a problem with a query, which I will get to in a second. However, I notice from the stack trace that calls are being made into the jdbc2 portion of the driver, even though I am using the JDBC3 Jar with JDK 1.5. Is this normal, or is there something wrong? Third, this is my actual problem: INSERT INTO my_table (my_fields, ...) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ; SELECT currval('my_schema.my_seq') ; I do a prepareStatement() with the above query, I fill in the params, and I call executeQuery() hoping to get a ResultSet. However, instead I get: PSQLException: No results were returned by the query. But if I run the query in pgAdmin, it works just fine, not to mention that this worked perfectly under 7.4, and works just fine under 8.0 in another app. Any suggestions welcome. __ David B. Held Software Engineer/Array Services Group 200 14th Ave. East, Sartell, MN 56377 320.534.3637 320.253.7800 800.752.8129
В списке pgsql-jdbc по дате отправления: