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 No suitable driver? 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 "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
 
jQuery in Action, 2nd edition
 
subject: No suitable driver?
 
Similar Threads
Starting The Cloudscape database
How do you connect to database(sql) from an ejb application
How to config when use Oracle in J2EE?
Start J2EE server : null.open error
Please help me