Re: [xmlblaster] Oracle : no suitable driver

[Marcel Ruff]

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