Question about Connection.commit() & rollback()

Dear all,Does anyone know if it is neccessary to call the commit() or rollback() method or not, after i pass a select statement to a PreparedStatement object instead of a insert/update statement?Thanx.Joey

[240 byte] By [joey829] at [2007-9-26 1:15:53]

«« the applet is not running correct
»» to compile java -> exe win32

# 1

It's not necessary. Normally you want to call rollback (just like pressing cancel button in a dialog box when you just took a look at the settings). The finalizer closes the connection anyway and the close includes a rollback. At least in my opinion.Kurta

h230561 at 2007-6-29 0:42:54 >

Java Database Connectivity (JDBC)

Inconsistent results-calling stored procedures in CallableStatement
Showing different exceptions for different ResultSetTypes?
Using Prepared Statement to pass array of primary key
automatic restart of tomcat ?
Image Problem, please help

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

Question about Connection.commit() & rollback()

Database Connectivity New Topic

Database Connectivity

All Classified