db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fischer <tfisc...@apache.org>
Subject Re: Need help on torque and oracle
Date Tue, 11 Apr 2006 06:02:02 GMT
I have no experience with turbine, but on the torque side, my guess would 
be you should use "torque.default.XXX" as configuration key names, not 
"torque.defaults.XXX"

     Thomas

On Mon, 10 Apr 2006, Shilpa Tisgaonkar wrote:

> Hi,
>
> I'm using turbine 2.3 , torque 3.1 maven 1.0.2 and
> oracle 9i
>
> I've created the tables by running the sql script and
> inserted the data.
> But i'm getting the problem while logging in. It gives
> following exception.
> org.apache.turbine.modules.actions.LoginUser -
> org.apache.turbine.util.security.DataBackendException:
> Failed to retrieve users
>
> And also when i try to retrieve the data by using
> doSelect method of a om class it gives following
> exception
> java.lang.NullPointerException: There was no
> DataSourceFactory c
> onfigured for the connection newapps
>
> My properties files have the foloowing entries
>
> #
> ------------------------------------------------------------------------
> #
> # Torque Configuration
> #
> # $Id: torque.properties,v 1.3 2004/10/31 16:11:37
> henning Exp $
> #
> #
> ------------------------------------------------------------------------
>
> torque.applicationRoot = .
>
> #
> -------------------------------------------------------------------
> #
> #  D E F A U L T S
> #
> #
> -------------------------------------------------------------------
>
>
> torque.dsfactory.NEWAPPS.pool.defaultMaxConnections=10
> torque.dsfactory.NEWAPPS.pool.maxExpiryTime=3600
> torque.dsfactory.NEWAPPS.pool.connectionWaitTimeout=10
>
>
> torque.defaults.connection.driver =
> oracle.jdbc.driver.OracleDriver
> torque.defaults.connection.url =
> jdbc:oracle:thin:@127.0.0.1:1521:newapps
> torque.defaults.connection.user =      	SYSTEM
> torque.defaults.connection.password =  	system
>
> torque.NEWAPPS.connection.driver =
> oracle.jdbc.driver.OracleDriver
> torque.NEWAPPS.connection.url =
> jdbc:oracle:thin:@127.0.0.1:1521:newapps
> torque.NEWAPPS.connection.user =      	SYSTEM
> torque.NEWAPPS.connection.password =  	system
>
> #
> -------------------------------------------------------------------
> #
> #  T O R Q U E  P R O P E R T I E S
> #
> #
> -------------------------------------------------------------------
> # These are your database settings. Look in the
> # org.apache.torque.pool.* packages for more
> information.
> #
> # The parameters to connect to the default database.
> You MUST
> # configure these properly.
> #
> -------------------------------------------------------------------
>
> # Determines if the quantity column of the IDBroker's
> id_table should
> # be increased automatically if requests for ids
> reaches a high
> # volume.
>
> torque.idbroker.cleverquantity = true
>
> # Determines if IDBroker should prefetch IDs or not.
> If set to false
> # this property has the effect of shutting off the
> housekeeping thread
> # that attempts to prefetch the id's.  It also sets
> the # of id's grabbed
> # per request to 1 regardless of the settings in the
> database.
> # Default: true
>
> torque.idbroker.prefetch = true
>
> # IDBroker can grab its own connection from the pool
> to use when retrieving
> # more id's to minimize the amount of time ID_TABLE
> will be locked.
> # Some usage of IDBroker or assumptions made by
> connection pools or jdbc
> # drivers may disallow this optimization in which case
> the property
> # should be set to false.
>
> torque.idbroker.usenewconnection = true
>
> torque.database.default = 		NEWAPPS
>
> #
> # application database
> #
> torque.database.newapps.adapter = 	oracle
> torque.dsfactory.NEWAPPS.factory =
> org.apache.torque.dsfactory.TorqueDataSourceFactory
>
> My TR properties have following entries
>
> #Torque
>
> torque.database.NEWAPPS.driver =
> oracle.jdbc.driver.OracleDriver
> torque.database.NEWAPPS.url =
> jdbc:oracle:thin:@127.0.0.1:1521:NEWAPPS
> torque.database.NEWAPPS.username = SYSTEM
> torque.database.NEWAPPS.password = system
>
> torque.database.adapter = oracle
> torque.database.adapter.oracle =
> oracle.jdbc.driver.OracleDriver
>
>
> I've no clue why am I getting these errors.
>
> Can you please help me .
>
> Regards
> Shilpa
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> ---------------------------------------------------------------------
> 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