aspose file tools
The moose likes JDBC and Relational Databases and the fly likes Problem executing prepareStatement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Groovy Fundamentals video training course this week in the Groovy forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Problem executing prepareStatement" Watch "Problem executing prepareStatement" New topic
Author

Problem executing prepareStatement

Gopi Rajesh
Greenhorn

Joined: Dec 09, 2003
Posts: 6
hi,
i tried to execute the code given below but seem to get the following error
java.sql.SQLException: General error
at sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(JdbcOdbc.java:6235)
at sun.jdbc.odbc.JdbcOdbc.SQLAllocStmt(JdbcOdbc.java:163)
at sun.jdbc.odbc.JdbcOdbcConnection.prepareStatement(JdbcOdbcConnection.java:460)
at sun.jdbc.odbc.JdbcOdbcConnection.prepareStatement(JdbcOdbcConnection.java:438)
at VM.NewVersionCreation.updateSysVersionsDB(NewVersionCreation.java:346)
at VM.NewVersionCreation.createDraftVersion(NewVersionCreation.java:612)
at VM.NewVersionCreation.main(NewVersionCreation.java:621)

Where have i missed?
any solutions to this problem will be helpful
regards
Gopi
Wayne L Johnson
Ranch Hand

Joined: Sep 03, 2003
Posts: 399
I didn't see anything wrong with either the SQL or the Java code, so I must assume that you are trying to do something that your database+driver combination doesn't allow.
What database are you using? Also, is there are type 4 JDBC driver available for this database?
Gopi Rajesh
Greenhorn

Joined: Dec 09, 2003
Posts: 6
hi,
I found the mistake. My connection object was closed before executing this method. Thats why it shows an error. Thanks for ur effort
Regards
Gopi
 
Don't get me started about those stupid light bulbs.
 
subject: Problem executing prepareStatement