db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ramesh Sabeti" ...@reazon.com>
Subject RE: Torque - Oracle
Date Thu, 13 Nov 2003 07:31:26 GMT
A few notes:

- I'm not 100% sure, but at some point, Torque was case sensitive about
username.

- Make sure you have the correct Oracle JDBC driver for your JDK version
(class12 is for JDK 1.2, 1.3).  

- Do a search/replace on all BasexxxPeer.java and change
BasePeer.doSelect to BasePeer.doPSSelect, or Oracle will run out of
share pool quickly.  This has nothing to do with your configuration
though.  

- Here's my entire configuration including logs and other stuff... it's
working with 3.0 version.  Hope it helps:


torque.applicationRoot = .


log4j.rootCategory = DEBUG, default

log4j.category.default=WARN, default
log4j.category.testbed=DEBUG, default
log4j.appender.default=org.apache.log4j.ConsoleAppender

log4j.appender.default.layout=org.apache.log4j.PatternLayout
log4j.appender.default.layout.ConversionPattern=%-4r [%t] %-5p %c %x -
%m%n

log4j.category.org.apache.torque = WARN, org.apache.torque
log4j.appender.org.apache.torque = org.apache.log4j.FileAppender
log4j.appender.org.apache.torque.file =
${torque.applicationRoot}/logs/torque.log
log4j.appender.org.apache.torque.layout = org.apache.log4j.PatternLayout
log4j.appender.org.apache.torque.layout.conversionPattern = %d [%t] %-5p
%c - %m%n
log4j.appender.org.apache.torque.append = false

torque.database.default=default
torque.database.default.adapter=oracle 

torque.dsfactory.default.connection.driver =
oracle.jdbc.driver.OracleDriver 
torque.dsfactory.default.connection.url =
jdbc:oracle:thin:@servername:1521:sid
torque.dsfactory.default.connection.user = username <-- may be case
sensitive
torque.dsfactory.default.connection.password = password <-- case
sensitive

torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataS
ourceFactory
torque.dsfactory.default.pool.defaultMaxConnections=10
torque.dsfactory.default.pool.maxExpiryTime=3600
torque.dsfactory.default.pool.connectionWaitTimeout=10


Ramesh.

> -----Original Message-----
> From: Merwin Yap [mailto:myap@gluecode.com]
> Sent: Thursday, November 13, 2003 3:05 PM
> To: Apache Torque Users List; david.hainlin@icjava.com
> Subject: Re: Torque - Oracle
> 
> 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.TorqueDataSour
ce
> Fa
> 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.TorqueDataSour
ce
> 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:
<s
> id
> >
> > >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(TorqueDataS
ou
> rc
> eFactory.java:129)
> > > at
>
org.apache.torque.dsfactory.TorqueDataSourceFactory.initialize(TorqueDat
aS
> ou
> 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(ComponentLoad
er
> .j
> ava:220)
> > > at
>
org.apache.stratum.component.ComponentLoader.load(ComponentLoader.java:1
79
> )
> > > at
>
org.apache.turbine.services.component.TurbineComponentService.init(Turbi
ne
> Co
> 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



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