db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Shilpa Tisgaonkar <shilpatisgaon...@yahoo.com>
Subject Need help on torque and oracle
Date Mon, 10 Apr 2006 21:35:29 GMT
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


Mime
View raw message