File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes EJB and other Java EE Technologies and the fly likes Prolems connecting to the Oracle database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Prolems connecting to the Oracle database" Watch "Prolems connecting to the Oracle database" New topic
Author

Prolems connecting to the Oracle database

vishwak rajgopalan
Greenhorn

Joined: Nov 19, 2003
Posts: 8
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

Joined: Aug 27, 2001
Posts: 94
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 ]

Marco Barenkamp<br />_ _ _ _ _ ________________________ _ _ _ _ _ <br />L M I N T E R N E T S E R V I C E S AG<br /> <br />Head of Software Development<br /> <br /> <br />BEA Certified Enterprise Developer<br />Sun Certified Programmer for the Java2 Platform<br />Sun Certified Web Component Developer for the Java2 Platform<br />Sun Certified Developer for the Java 2 Platform <br />Sun Certified Business Component Developer for the Java 2 Platform <br />Sun Certified Enterprise Architect for the Java 2 Platform Enterprise Edition<br /> <br />LMIS AG
vishwak rajgopalan
Greenhorn

Joined: Nov 19, 2003
Posts: 8
Hi,
Thanks a lot. I am now able to connect to oracle and make my entity beans
work
vishwak
 
 
subject: Prolems connecting to the Oracle database