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 16:37:42 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.

Class12.jar is only for jdk1.2 and 1.3.  If you use other JDK versions
download the correct JDBC from Oracle.

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

Yes.

> 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



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