Problem using Oracle Thin Driver

[pjeypal]

Hi

I am using ORacle thin driver to establish connection to Oracle 9.0.1 but found that the connection is extremely slow and i have problems accessing table in database. Does anyone have the coding for using oracle thin driver with oracle 9.0.1

This is my coding

Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbcracle:thin"+_sSID+":"+_sPort+":"+_sServer, _sUsername, _sPassword);


Thanks
Priya

 

[sedj]

That code is how you connect correctly.
If the connection is slow, it is more likely one of the following :

1) Network problems - slow/overloaded/poor connectors
2) DB is overloaded
3) Client computer is slow

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk