• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Prolems connecting to the Oracle database

 
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 94
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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:
jdbc:oracle:thin:@host:1521:<dbname>
[ November 22, 2003: Message edited by: Marco Barenkamp ]
 
vishwak rajgopalan
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
Thanks a lot. I am now able to connect to oracle and make my entity beans
work
vishwak
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic