Re: [xmlblaster] Oracle : no suitable driver

[Marcel Ruff <mr at marcelruff.info>]

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: at 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

koen.boutsen at ibsbe.be 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: at 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: at 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: at 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