Hello,
I have downloaded weblogic JDBC driver for MS SQL version 7 and am trying
to use it to connect to our MS SQL database in my XML-based web
application. THe environment I am using is Apache/Tomcat/Cocoon. I can
connect to database directly in my XML/XSP pages via esql:connection with
no problem. However, when I try to use pool connection via esql:pool, I
get a nullpointer exception error. As a test, I tried to connect to Oracle
database with oracle.jdbc.driver.OracleDriver using pool and it worked
fine. So, is this a problem with Turbine dbadaptor for weblogic??????
I have noticed that in cocoon.properties, the following is set for weblogic
adaptor:
processor.xsp.pool.database.adaptor.DBWeblogic=weblogic.jdbc.pool.Driver
However, the weblogic driver I am using is
weblogic.jdbc.mssqlserver4.Driver
Does it mean I can't simply set the adaptor to my driver, i.e. do I have to
use weblogic.jdbc.pool.Driver? If so, is there a way I can get it work with
my driver? I don't have weblogic.jdbc.pool.Driver and I am assuming it's
part of weblogic app server that we can't afford to buy right now!
Any pointers or help on how I can resolve my problem is greatly
appreciated.
Below is the changes I did to my cocoon.properties for my 'testDB'.
processor.xsp.pool.database.default.driver=weblogic.jdbc.mssqlserver4.Driver
processor.xsp.pool.database.default.url=jdbc:weblogic:mssqlserver4:<host>:<port>
processor.xsp.pool.database.default.username=<username>
processor.xsp.pool.database.default.password=<password>
processor.xsp.pool.database.default.maxConnections=1
processor.xsp.pool.database.default.expiryTime=3600000
processor.xsp.pool.database.adaptor.DBWeblogic=weblogic.jdbc.mssqlserver4.Driver
processor.xsp.pool.database.testDB.driver=weblogic.jdbc.mssqlserver4.Driver
processor.xsp.pool.database.testDB.url=jdbc:weblogic:mssqlserver4:<host>:<port>
processor.xsp.pool.database.testDB.username=<username>
processor.xsp.pool.database.testDB.password=<password>
processor.xsp.pool.database.testDB.maxConnections=1
processor.xsp.pool.database.testDB.expiryTime=3600000
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
