db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Merwin Yap" <m...@gluecode.com>
Subject Re: Torque - Oracle
Date Thu, 13 Nov 2003 23:05:12 GMT
Hi David. First of all thanks for replying.

I can't seem to find any fault with the properties. A lot of people say that
errors are probably due to the property file.

I'm using torque 3.0 for Turbine.
Do I need to recompile OM classes of Turbine?

I've also tried Jdbc2Pool, but getting the same result.

I do have the class12.jar of oracle in my lib.  I'm sure that the db in
oracle is running fine as I have accessed it via sql*plus.

What else do I need to do or can do?

Thanks!



----- Original Message ----- 
From: "David Hainlin" <dhainlin@comcast.net>
To: "Apache Torque Users List" <torque-user@db.apache.org>
Sent: Wednesday, November 12, 2003 4:29 AM
Subject: Re: Torque - Oracle


> 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.TorqueDataSourceFa
ctory
> 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.TorqueDataSource
Factory
> >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(TorqueDataSourc
eFactory.java:129)
> > at
org.apache.torque.dsfactory.TorqueDataSourceFactory.initialize(TorqueDataSou
rceFactory.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.j
ava:220)
> > at
org.apache.stratum.component.ComponentLoader.load(ComponentLoader.java:179)
> > at
org.apache.turbine.services.component.TurbineComponentService.init(TurbineCo
mponentService.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
>


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