• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

No suitable driver?

 
kelvin cheung
Ranch Hand
Posts: 120
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 45
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 120
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 120
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
can anyone help me?
i am stuck with this
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic