Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Prolems connecting to the Oracle database

 
vishwak rajgopalan
Greenhorn
Posts: 8
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I am trying to connect to Oracle 9.0.1.0.0 Enterprise edition from the J2EE server provided by Sun. Here are the details
J2EE implementation : j2sdkee1.3.1
Java implematation : jdk1.3.1.04
OS : Linux
I put the classes12.zip JDBC driver in the /lib/system folder of j2sdkee1.3.1. I get following error message
javax.ejb.EJBException:
nested exception is: java.sql.SQLException: No suitable driver
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:172)

How do i connect to the Oracle database. Could some one please help me in this regard
Thanks,
Vishwak Rajgopalan
 
Marco Barenkamp
Ranch Hand
Posts: 94
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
add the zip file explicitly to the CLASSPATH in the j2ee script.
By the way, you should use the new classes12.jar archive instead of the
older classes12.zip file.
Then you are able to access the oracle via the thin driver using the
following jdbc url:
jdbcracle:thin:@host:1521:<dbname>
[ November 22, 2003: Message edited by: Marco Barenkamp ]
 
vishwak rajgopalan
Greenhorn
Posts: 8
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Thanks a lot. I am now able to connect to oracle and make my entity beans
work
vishwak
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic