Re: [xmlblaster] Oracle : no suitable driver

[Michele <michele at laghi.eu>]

Hi Koen,
it seems a configuration problem.

Have you changed the xmlBlaster.properties file ? In this you should
have a line:

JdbcDriver.drivers=org.hsqldb.jdbcDriver:.....

Could this line have been deleted or (since it is a multiline) could one
'\' at the end of the line be missing ?

If you are only using oracle for your tests you could try:

JdbcDriver.drivers=org.hsqldb.jdbcDriver:oracle.jdbc.driver.OracleDriver

Then of course make sure the ojdbc14.jar is explicitly put into the
classpath (it is not sufficient to put it in the lib directory).

Are you also setting the property jdbc.drivers explicitly somewhere in
your code ? If yes try to remove that or add to it the oracle driver.

I hope this helps, otherwise try to start the xmlBlaster with traces on
for example by putting the line:

logging/org.xmlBlaster.util.queue.jdbc=FINE

Regards
Michele

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 *