Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

websphere and jdbc

Status
Not open for further replies.

davinia1

Programmer
Jul 2, 2004
12
ES
Hi,
first of all, I'm sorry for my english.

Could you tell me how configurate websphere and jdbc?

DriverManager.registerDriver (new Oracle.jdbc.driver.OracleDriver());

conn = DriverManager.getConnection ("jdbc:eek:racle:thin:mad:host:port:SID", "user", "password");

but I get "JavaCompile oracle can not be resolved or is not a type" in DriverManager. If I use Class.forName("oracle.jdbc.OracleDriver"); no errors appears but the conexion doesn't work.

I add a JDBC Provider, and in implementation class name I write oracle.jdbc.OracleDriver or oracle.jdbc.pool.OracleConnectionPoolDataSource.
In the section DataSource, in JNDI name, what do I have to write? I have no idea about it.
In Resource Properties, in the URL I have:
jdbc:eek:racle:thin:mad:host:port:SID

In Server Settings, in Class path I've put the path to
classes12.zip, ojdbc14.jar and nls_charset12.jar (for Java 1.4). I don't mind to use Java 1.3, in fact, I've proof with 1.3 but it doesn't work either.

Any help, please
Thanks in advance.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top