wood burning stoves 2.0*
The moose likes EJB and other Java EE Technologies and the fly likes No suitable driver? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "No suitable driver?" Watch "No suitable driver?" New topic
Author

No suitable driver?

kelvin cheung
Ranch Hand

Joined: Mar 27, 2004
Posts: 120
hello,
i want to use Oracle as the DB-server,
with my Entiry Beans.

And I have copied the driver "ojdbc14.jar" in to the folder :
C:\j2sdkee1.3.1\lib\system

and my resource.proterties file is like this :
jdbcDataSource.0.name=jdbc/DB1
jdbcDataSource.0.url=jdbc\:cloudscape\:rmi\:CloudscapeDB;create\=true
jdbcDataSource.1.name=jdbc/DB2
jdbcDataSource.1.url=jdbc\:cloudscape\:rmi\:CloudscapeDB;create\=true
jdbcDataSource.2.name=jdbc/EstoreDB
jdbcDataSource.2.url=jdbc\:cloudscape\:rmi\:CloudscapeDB;create\=true
jdbcDataSource.3.name=jdbc/InventoryDB
jdbcDataSource.3.url=jdbc\:cloudscape\:rmi\:CloudscapeDB;create\=true
jdbcDataSource.4.name=jdbc/Oracle
jdbcDataSource.4.url=jdbc\ racle\:thin\:@oracle.nith.no\:1521\:STUD
jdbcDataSource.5.name=jdbc/OraclePersonal
jdbcDataSource.5.url=jdbc\ racle\:thin\:@localhost\:1521\ RCL
jdbcDriver.0.name=oracle.jdbc.driver.OracleDriver

jdbcDriver.1.name=COM.cloudscape.core.RmiJdbcDriver
jdbcDataSource.5.name=jdbc/EgenDB
jdbcDataSource.5.url=jdbc\:cloudscape\:rmi\:minDB;create\=true
jdbcXADataSource.0.name=jdbc/XACloudscape
jdbcXADataSource.0.classname=COM.cloudscape.core.RemoteXaDataSource
jdbcXADataSource.0.dbpassword=
jdbcXADataSource.0.dbuser=
jdbcXADataSource.0.prop.createDatabase=create
jdbcXADataSource.0.prop.databaseName=CloudscapeDB
jdbcXADataSource.0.prop.remoteDataSourceProtocol=rmi
jdbcXADataSource.1.name=jdbc/XACloudscape2
jdbcXADataSource.1.classname=COM.cloudscape.core.RemoteXaDataSource
jdbcXADataSource.1.dbpassword=
jdbcXADataSource.1.dbuser=
jdbcXADataSource.1.prop.createDatabase=create
jdbcXADataSource.1.prop.databaseName=minDB
jdbcXADataSource.1.prop.remoteDataSourceProtocol=rmi
jdbcXADataSource.2.name=jdbc/XAOracle
jdbcXADataSource.2.classname=oracle.jdbc.xa.client.OracleXADataSource
jdbcXADataSource.2.dbpassword=
jdbcXADataSource.2.dbuser=
jdbcXADataSource.2.prop.databaseName=STUD
jdbcXADataSource.2.prop.driverType=thin
jdbcXADataSource.2.prop.portNumber=1521
jdbcXADataSource.2.prop.serverName=oracle.nith.no
jmsCnxFactory.0.name=QueueConnectionFactory
jmsCnxFactory.0.isQueue=true
jmsCnxFactory.1.name=TopicConnectionFactory
jmsCnxFactory.1.isQueue=false
jmsCnxFactory.2.name=jms/QueueConnectionFactory
jmsCnxFactory.2.isQueue=true
jmsCnxFactory.3.name=jms/TopicConnectionFactory
jmsCnxFactory.3.isQueue=false
jmsDestination.0.name=jms/Queue
jmsDestination.0.isQueue=true
jmsDestination.1.name=jms/Topic
jmsDestination.1.isQueue=false


why do i get the SQLException : No suitable driver
Sujith Kanaparthi
Ranch Hand

Joined: Sep 04, 2005
Posts: 45
A few points as checklist:
1) Have you set the ojdbc14.jar to classpath environment variable
2) Have you Registered the driver in the code before getting connection object (say by using Class.forName())

Regards,
Sujith
kelvin cheung
Ranch Hand

Joined: Mar 27, 2004
Posts: 120
i have set it to the environment variable.
and i have set a JNDI name for it to locate the driver.
kelvin cheung
Ranch Hand

Joined: Mar 27, 2004
Posts: 120
can anyone help me?
i am stuck with this
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: No suitable driver?
 
Similar Threads
How do you connect to database(sql) from an ejb application
How to config when use Oracle in J2EE?
Starting The Cloudscape database
Please help me
Start J2EE server : null.open error