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 Fri, 14 Nov 2003 00:58:06 GMT
Thanks... I've check from Oracle regarding class12.jar as the jdbc driver
for oracle 9i.
I'm a new user to oracle by the way.

Would you consider 'sid' to be the database name?

still getting the same error with TorqueDataSourceFactory.






----- Original Message ----- 
From: "Ramesh Sabeti" <rs@reazon.com>
To: "'Apache Torque Users List'" <torque-user@db.apache.org>
Sent: Wednesday, November 12, 2003 11:31 PM
Subject: RE: Torque - Oracle


> 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


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