db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Hainlin <dhain...@comcast.net>
Subject Re: Torque - Oracle
Date Wed, 12 Nov 2003 12:29:01 GMT
Merwin,
I have recenlty used the following to connect to oracle. HTH

torque.database.default=orcl
torque.database.orcl.adapter=oracle
torque.dsfactory.orcl.factory=org.apache.torque.dsfactory.TorqueDataSourceFactory
torque.dsfactory.orcl.pool.defaultMaxConnections=5
torque.dsfactory.orcl.pool.maxExpiryTime=3600
torque.dsfactory.orcl.pool.connectionWaitTimeout=10
torque.dsfactory.orcl.connection.driver = oracle.jdbc.driver.OracleDriver
torque.dsfactory.orcl.connection.url = jdbc:oracle:thin:<server>:1521:<sid>
torque.dsfactory.orcl.connection.user = <user>
torque.dsfactory.orcl.connection.password = <pass>

I did not have any other torque.database.* entries...

Merwin Yap wrote:

>Im trying to use Oracle as our database for torque. We've successfully implemented torque
using hsql and mysql but no luck with oracle. 
>
>As written in the guide, I've edited torque.properties
>
>torque.database.default=PFS
>torque.database.PFS.adapter=oracle
>torque.database.PFS.url=jdbc:oracle:thin:@<servername>:1521:<sid>
>torque.database.PFS.driver=oracle.jdbc.driver.OracleDriver
>torque.database.PFS.user=<username>
>torque.database.PFS.password=<password>
>
>torque.dsfactory.PFS.factory=org.apache.torque.dsfactory.TorqueDataSourceFactory
>torque.dsfactory.PFS.pool.defaultMaxConnections=10
>torque.dsfactory.PFS.pool.maxExpiryTime=3600
>torque.dsfactory.PFS.pool.connectionWaitTimeout=10
>
>torque.database.PFS.connection.driver=oracle.jdbc.driver.OracleDriver
>torque.database.PFS.connection.url=jdbc:oracle:thin:@<servername>:1521:<sid>
>torque.database.PFS.connection.user=<username>
>torque.database.PFS.connection.password=<password>
>
>And I'm getting this in my log file:
>
>[2003-11-12 15:35:12,873 DEBUG] Torque:initAdapters- Starting initAdapters
>[2003-11-12 15:35:12,964 DEBUG] Torque:initDataSourceFactories- Starting initDSF
>[2003-11-12 15:35:12,964 DEBUG] Torque:initDataSourceFactories- handle: PFS DataSourceFactory:
org.apache.torque.dsfactory.TorqueDataSourceFactory
>[2003-11-12 15:35:12,984 DEBUG] TorqueDataSourceFactory:initCPDS- Starting initCPDS
>[2003-11-12 15:35:13,014 ERROR] TorqueDataSourceFactory:initCPDS- 
>java.lang.NullPointerException
> at org.apache.torque.dsfactory.TorqueDataSourceFactory.initCPDS(TorqueDataSourceFactory.java:129)
> at org.apache.torque.dsfactory.TorqueDataSourceFactory.initialize(TorqueDataSourceFactory.java:108)
> at org.apache.torque.Torque.initDataSourceFactories(Torque.java:323)
> at org.apache.torque.Torque.initialize(Torque.java:237)
> at org.apache.stratum.component.ComponentLoader.loadComponent(ComponentLoader.java:220)
> at org.apache.stratum.component.ComponentLoader.load(ComponentLoader.java:179)
> at org.apache.turbine.services.component.TurbineComponentService.init(TurbineComponentService.java:163)
>
>I'm sure that my servername, username, password are valid. I also have the jar (class12)
for oracle in my project lib.
>
>Thank you very much.
>
>
>  
>




---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message