Server-Side Development Section Index | Page 8
Check out the jGuru Java400 FAQ.
Check out the jGuru IO FAQ.
Check out the jGuru I18N FAQ.
Check out the jGuru EJB FAQ.
Check out the jGuru CORBA FAQ.
Check out the jGuru Collections FAQ.
Check out the jGuru Certification FAQ.
Check out the jGuru AppServer FAQ.
Check out the jGuru Applets FAQ.
JDBC - General Error. I am getting java.sql.SQLException: General error when working with my database. Please help me.
JDBC - General Error I am getting java.sql.SQLException: General error when working with my database. Please help me.
Yes. SQLWarning is a subclass of SQLException. After the first warning is retrieved via getWarnings(), subsequent warnings are obtained in a way identical to SQLException chaining. You can see a...more
Connections, Statements and ResultSets all have a getWarnings method that allows retrieval. Keep in mind that prior ResultSet warnings are cleared on each new read and prior Statement warnings are...more
There are often multiple reasons for a JDBC problem. SQLException has a method, getNextException, which returns either the next exception or null when all exceptions have been retrieved. Obtaini...more
Does catching an SQLException mean that the transaction was definitely not completed and/or that the invoked method did not execute?
Not necessarily, and, unfortunately, there is no generic means of determining current state. As noted in JDBC API Tutorial and Reference, 2nd Ed: Java 2, "The safest course is to call the met...more
JDBC functionality is completely dependent on the functionality of the JDBC driver AND the underlying DBMS engine. At one time there was a 4k restriction on LOBs. It's not clear from the documen...more