Re: [xmlblaster] Oracle : no suitable driver

Mon, 25 Jun 2007 23:57:03 -0700 

I have in my CLASSPATH

  /home/oracle/oracle/product/10.2.0/db_1/jdbc/lib/ojdbc14_g.jar

using in xmlBlaster.properties

 JdbcDriver.drivers=oracle.jdbc.driver.OracleDriver

and  an url
JdbcStorage[Oracle]=org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin,\ 
                   url=jdbc:oracle:thin:@localhost:1521:xmlb,\
                   user=xmlblaster,\
                   password=xxxx,\
                   connectionPoolSize=1,\
                   connectionBusyTimeout=90000,\
                   maxWaitingThreads=300,\
                   tableNamePrefix=XB_,\
                   entriesTableName=ENTRIES,\
                   dbAdmin=true
  StoragePlugin[JDBC][1.0]=${JdbcStorage[Oracle]}
  QueuePlugin[JDBC][1.0]=${JdbcStorage[Oracle]}

and this works fine for me,

regards
Marcel

[EMAIL PROTECTED] wrote:


Hello
I try to use Oracle as persistence layer. I'v add the ojdbc14.jar in the lib directory of xmlblaster. I still get the following error : (I tried with SQLServer and got the same error) java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@benotesdev:1521:orcl 
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
at org.xmlBlaster.util.queue.jdbc.JdbcConnectionPool.addConnectionToPool(JdbcConnectionPool.java:362) at org.xmlBlaster.util.queue.jdbc.JdbcConnectionPool.connect(JdbcConnectionPool.java:392) at org.xmlBlaster.util.queue.jdbc.JdbcConnectionPool.initialize(JdbcConnectionPool.java:613) at org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin.getJdbcQueueManagerCommonTable(JdbcQueueCommonTablePlugin.java:161) at org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin.initialize(JdbcQueueCommonTablePlugin.java:223) at org.xmlBlaster.util.queue.QueuePluginManager.getPlugin(QueuePluginManager.java:84) at org.xmlBlaster.util.queue.QueuePluginManager.getPlugin(QueuePluginManager.java:60) at org.xmlBlaster.util.queue.cache.CacheQueueInterceptorPlugin.initialize(CacheQueueInterceptorPlugin.java:292) at org.xmlBlaster.util.queue.QueuePluginManager.getPlugin(QueuePluginManager.java:84) at org.xmlBlaster.util.queue.QueuePluginManager.getPlugin(QueuePluginManager.java:74) at org.xmlBlaster.authentication.SubjectInfo.createSubjectQueue(SubjectInfo.java:275) at org.xmlBlaster.authentication.SubjectInfo.toAlive(SubjectInfo.java:247) at org.xmlBlaster.authentication.Authenticate.unsecureCreateSession(Authenticate.java:160) at org.xmlBlaster.engine.RequestBroker.<init>(RequestBroker.java:233) at org.xmlBlaster.engine.XmlBlasterImpl.<init>(XmlBlasterImpl.java:68) at org.xmlBlaster.authentication.Authenticate.<init>(Authenticate.java:98) at org.xmlBlaster.engine.runlevel.RunlevelManager.initPluginManagers(RunlevelManager.java:127) 
        at org.xmlBlaster.Main.init(Main.java:185)
        at org.xmlBlaster.Main.<init>(Main.java:122)
        at org.xmlBlaster.Main.main(Main.java:604)
Jun 25, 2007 4:40:10 PM SEVERE 10-XmlBlaster.MainThread RL0 org.xmlBlaster.util.queue.cache.CacheQueueInterceptorPlugin initialize: subject:/node/xmlBlaster_10_110_21_7_3412/client/__RequestBroker_in ternal[xmlBlaster_10_110_21_7_3412]: Could not initialize the persistent queue 'subject:/node/xmlBlaster_10_110_21_7_3412/client/__RequestBroker_internal[xmlBlaster_10_110_21_7_3412]'. Is the JDBC Dri ver jar file in the CLASSPATH ? Is the DB up and running ? We continue RAM based ...XmlBlasterException errorCode=[resource.db.unavailable] serverSideException=true location=[org.xmlBlaster.util.queue .jdbc.JdbcQueueCommonTablePlugin-subject:/node/xmlBlaster_10_110_21_7_3412/client/__RequestBroker_internal[xmlBlaster_10_110_21_7_3412]/type 'JDBC' version '1.0'] message=[#exported getJdbcCommonTable QueueManager: sql exception when initializing the connection pool : java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@benotesdev:1521:orcl] [See URL http://www.xmlblaster.org/xmlBl aster/doc/requirements/admin.errorcodes.listing.html#resource.db.unavailable] The propery settings are: 
 <queue relating='subject'/>
errorCode=resource.db.unavailable message=#exported getJdbcCommonTableQueueManager: sql exception when initializing the connection pool : java.sql.SQLException: No suitable driver found for jdbc:oracl 
e:thin:@benotesdev:1521:orcl
at org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin.getJdbcQueueManagerCommonTable(JdbcQueueCommonTablePlugin.java:185)
As another trial, I've add the ojdbc14.jar file to the CLASSPATH directory. This gave the same problem. 

What am I doing wrong ?

Best regards
*
Koen Boutsen *



--
Marcel Ruff
http://www.xmlBlaster.org

Reply via email to