IIRC the oracle thin jdbc connect string is
jdbc:oracle:thin:@hostname:port:sid
You seem to be trying to use a TNS name, for which I think you must use the Oracle OCI driver, which has a different connection string.
-----Original Message-----
From: William Shenfield [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 06, 2002 1:50 PM
To: Turbine Torque Users List
Subject: torque b4 configuration problem.
Hi,
I am using Torque-3.0b4 with oracle in a simple servlet I keep getting :
java.lang.NullPointerException: Connection object was null. This could be due to a misconfiguration of the DataSourceFactory. Check the logs and Torque.properties to better determine the cause.
This happens after calling Toque.init when I try to access the DB.
My config file is:-
log4j.rootLogger=ALL, dcm log4j.appender.dcm=org.apache.log4j.ConsoleAppender
log4j.appender.dcm.layout=org.apache.log4j.PatternLayout
log4j.appender.dcm.layout.ConversionPattern=%-7r [%-8t] %-5p: %m%n
#torque.database.default=bmv
torque.database.bmv.adapter=oracle
torque.dsfactory.bmv.factory=org.apache.torque.dsfactory.Jdbc2PoolDataSource
Factory
torque.dsfactory.bmv.pool.defaultMaxActive=30
torque.dsfactory.bmv.pool.testOnBorrow=true
torque.dsfactory.bmv.pool.validationQuery=SELECT count(*) bmv_cache_master
torque.dsfactory.bmv.connection.driver=oracle.jdbc.driver.OracleDriver
torque.dsfactory.bmv.connection.url=jdbc:oracle:thin:@10.0.1.150:dev01.dcm
torque.dsfactory.bmv.connection.user=xxx
torque.dsfactory.bmv.connection.password=xxxx
Debug output generated is:
1 [main ] INFO : Logging has been configured by Torque.
41 [main ] DEBUG: Using org.apache.torque.adapter.DBOracle
50 [main ] DEBUG: Using org.apache.torque.adapter.DBOracle
51 [main ] DEBUG: Starting initAdapters
53 [main ] DEBUG: Starting initDSF
54 [main ] DEBUG: handle: bmv DataSourceFactory:
org.apache.torque.dsfactory.Jdbc2PoolDataSourceFactory
74 [main ] DEBUG: Starting initCPDS
95 [main ] DEBUG: Setting datasource property: driver
360 [main ] DEBUG: Convert string 'oracle.jdbc.driver.OracleDriver'
to class 'java.lang.String'
361 [main ] DEBUG: Using converter
org.apache.commons.beanutils.converters.StringConverter@6b13c7
479 [main ] DEBUG: Setting datasource property: url
480 [main ] DEBUG: Convert string
'jdbc:oracle:thin:@10.0.1.150:dev01.dcm' to class 'java.lang.String'
481 [main ] DEBUG: Using converter
org.apache.commons.beanutils.converters.StringConverter@6b13c7
481 [main ] DEBUG: Setting datasource property: user
500 [main ] DEBUG: Convert string 'xxx' to class 'java.lang.String'
501 [main ] DEBUG: Using converter
org.apache.commons.beanutils.converters.StringConverter@6b13c7
501 [main ] DEBUG: Setting datasource property: password
502 [main ] DEBUG: Convert string 'xxxx' to class 'java.lang.String'
503 [main ] DEBUG: Using converter
org.apache.commons.beanutils.converters.StringConverter@6b13c7
503 [main ] DEBUG: Starting initTorqueClassic
559 [main ] DEBUG: Setting datasource property: defaultMaxActive
611 [main ] DEBUG: Convert string '30' to class 'int'
612 [main ] DEBUG: Using converter
org.apache.commons.beanutils.converters.IntegerConverter@8fb1f7
613 [main ] DEBUG: Setting datasource property: testOnBorrow
613 [main ] DEBUG: Convert string 'true' to class 'boolean'
614 [main ] DEBUG: Using converter
org.apache.commons.beanutils.converters.BooleanConverter@ed0338
615 [main ] DEBUG: Setting datasource property: validationQuery
616 [main ] DEBUG: Convert string 'SELECT count(*) bmv_cache_master'
to class 'java.lang.String'
617 [main ] DEBUG: Using converter
org.apache.commons.beanutils.converters.StringConverter@6b13c7
619 [main ] INFO : INIT Ok
648 [main ] INFO : Got Crit
649 [main ] INFO : about to get BMV
930 [Thread-1] DEBUG: IDBroker thread was started.
1446 [main ] WARN : IDBroker is being used with db 'bmv', which does
not support transactions. IDBroker attempts to use transactions to limit the possibility of duplicate key generation. Without transactions, duplicate key generation is possible if multiple JVMs are used or other means are used to write to the database.
1547 [main ] ERROR: Failed to use
1548 [main ] ERROR: java.lang.NullPointerException: Connection object
was null. This could be due to a misconfiguration of the DataSourceFactory. Check the logs and Torque.properties to better determine the cause.
Any help will be appreciated.
Regards,
William J Shenfield
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.385 / Virus Database: 217 - Release Date: 04/09/2002
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
