Win a copy of Microservices Testing (Live Project) this week in the Spring forum!
  • 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
  • Tim Cooke
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Liutauras Vilda
  • Henry Wong
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Al Hobbs
  • Carey Brown
Bartenders:
  • Piet Souris
  • Mikalai Zaikin
  • Himai Minh

No suitable driver?

 
Ranch Hand
Posts: 120
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
can anyone help me?
i am stuck with this
reply
    Bookmark Topic Watch Topic
  • New Topic