Links

Lists

Latest Updates

Ruby On Rails List
Python list
Advanced Java
The JavaScript List
Apache Users
Full Disclosure
Linux Security

Search the archives!


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

JDBC-ODBC bridge and prepared statements


  • From: Ian_J_Dickinson@xxxxxxxxxxxxxxx (Dickinson, Ian J)
  • Subject: JDBC-ODBC bridge and prepared statements
  • Date: Thu, 30 Mar 2000 18:25:04 +0100

Hi,
I'm using the JDBC-ODBC bridge in JDK 1.2.2, and I find that if I use a
prepared statement instead of creating a statement each time I query the DB,
I get SQLException 2400 "invalid cursor state" the second time I do an
executeQuery() on the statement. Searching around on the web, I can find
other examples of people having the same problem, but no solutions.  Has
anyone got prepared statements working (more than once through :-) with
JDBC-ODBC?

Thanks in advance,
Ian


______________________________________________________________
Ian Dickinson        Hewlett-Packard Laboratories, Bristol, UK
Mailto:Ian_J_Dickinson@xxxxxxxxxx    Phone: +44 (117) 312 8796

---
To unsubscribe, mail advanced-java-unsubscribe@xxxxxxxxxxxxxxxx
To get help, mail advanced-java-help@xxxxxxxxxxxxxxxx