Thin driver

[sudha javvadi]

Hi all,

I recently downloaded oracle 10g.I dont know how to use thin driver as database connectivity.Can anybody tell step by step how to specify thin driver right after downloading oracle.

Thankyou & Regards,
sudha.

[Stevi Deter]

Sudha,

To access Oracle 10g from your Java application, you'll need to be sure ojdbc14.jar is in your classpath.

Follow the jdbc configuration instructions for your application.

Your driver classname will be oracle.jdbc.OracleDriver

your JDBC URL will probably look something like:

jdbc:oracle:thin:@IPNUMBER:PORT:SID

where IPNUMBER is replaced with your Oracle database's IP number, PORT with the port number, and SID with the SID or Service Name of the database.
[ April 26, 2008: Message edited by: Stevi Deter ]

[sudha javvadi]

Hi Stevi,

This might be a stupid question but I really dont know how to check whether ojdbc14.jar is in my classpath or not. Could you please tell me how to check the classpath.I am using eclipse IDE,do we need to configure oracle 10g with eclipse.If so how to do that.What are the other steps I have to do to create a table in oracle 10g and use it in java.Please help

thanks in advance,
sudha.

[Jeanne Boyarsky]

Sudha,
There are two ways of specifying classpaths. If you are running a java program (with a main method), you right click the Eclipse project, choose properties and the look at the java build path.

If you are running a web page, you need to check the server classpath.