Browsed by
Category: database

Database Connections in Java

Database Connections in Java

    Closing Statements From Oracle JDBC FAQ, http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-faq-090281.html#05_02 Closing a Connection closes all of the associated Statements. Closing a Statement closes all of the associated ResultSets. So, if you are through with a Connection you can just close it and all of the Statements and ResultSets will be closed. This is acceptable programming practice. Better practice is to explicitly close Statements and ResultSets in finally blocks. This makes your application more robust and less likely to leak resources as it evolves…

Read More Read More

sqljdbc.jar Security Errors

sqljdbc.jar Security Errors

 sqljdbc Error: (received during compile/run)  java.lang.SecurityException: invalid SHA1 signature file digest for com/microsoft/sqlserver/jdbc/SQLServerException.class Solution: In the sqljdbc.jar or sqljdbc4.jar file Goto META-INF Folder Open MANIFEST.MF and delete all the lines other than first line and save it Delete other files which exist in the same folder