basic info on driver name, url

hi,

I have java 6 installed as well as Oracle 10.2 on my windows XP. I am trying to write very simple app using jdbc connection. So

first I load jdbc driver : Class.forName(driverName); Where do we get the driver name from. I went as far as copying all the jars from ORACLE_HOME to JRE_HOME/lib and having specific jar's added to classpath. However, where do I get the actual name of the driver?

Same thing with the URL. How do we define URL to use in getConnection method.

thanks in advance.

[525 byte] By [vs777a] at [2007-11-27 6:59:24]
# 1
You can find it all in the documentation of the JDBC driver. Checkout the section "JDBC technical documentation" here http://www.oracle.com/technology/tech/java/sqlj_jdbc/index.html
BalusCa at 2007-7-12 18:49:59 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2

Hi,

I think you got the JDBC jar file. Extract that jar file using winzip and read the documentation or try to use the following URL

oracle.jdbc.driver.OracleDriver

jdbc:oracle:thin:@hostname:port:Instancename

Ex: jdbc:oracle:thin:@localhost:1521:xe

Thanks & Regards,

Santhosh Reddy Mandadi.

santhosh-mcaa at 2007-7-12 18:49:59 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 3
I tried to use it, however still getting "Unable to load a Class" exception. I have both ojdbc14.jar and classes12.jar in my CLASSPATH.
vs777a at 2007-7-12 18:49:59 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...