Slow Connection at Startup Only- Oracle JDBC
843854May 13 2003 — edited May 14 2003I am using JDBC classes12.zip. I have an applet that initiates a connections at the start of logging into an applet application. I initiate a database connection and I have encryption turned on.
The problem I have is that it seems that the database constantly loads classes and takes a long time to initiate the database connection. It takes a good minute before the user can access the application and it seems like it is the JDBC portion that is holding up the connection? Does anyone have an idea why it takes so long to initiate the database connection?
At the start of login, I run this..
Class.forName("oracle.jdbc.driver.OracleDriver");
PARAMETERS.put("oracle.net.encryption_client","REQUIRED");
PARAMETERS.put("oracle.net.encryption_types_client","DES40C");
PARAMETERS.put("oracle.net.crypto_checksum_client","REQUESTE");
PARAMETERS.put("oracle.net.crypto_checksum_types_client","MD5");
PARAMETERS.put("user",user);
PARAMETERS.put("password",password);
connect = DriverManager.getConnection(dbUrl,PARAMETERS);
statement = connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
statement1 = connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
CPMonitorStatement = connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
CPResultStatement = connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
MonoStatement = connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
DrugStatement = connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
GoalMasterStatement= connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
AssessStatement = connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
PatientListStatement = connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
PatientStatement = connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
ScreenUtilStatement= connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
Thanks in advance.