Hi William,
I had a similiar problem a while back.
The name of your database in the schema.xml file should correspond to that
in the propertiesFile. If you ommit the name in the schema.xml file you can
use "default" settings in the proertiesFile without having to specify the
BMV connection. For example:
<snip>
torque.database.default=default
torque.database.default.adapter=oracle
torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataSourc
eFactory
torque.dsfactory.default.pool.defaultMaxConnections=10
torque.dsfactory.default.pool.maxExpiryTime=3600
torque.dsfactory.default.pool.connectionWaitTimeout=10
torque.dsfactory.default.connection.driver = racle.jdbc.driver.OracleDriver
torque.dsfactory.default.connection.url =
jdbc:oracle:thin:@10.0.1.150:1521:dev01.dcm
torque.dsfactory.default.connection.user = xxx
torque.dsfactory.default.connection.password = xxxx
</snip>
*should* work. Let me know how you get on
/Colin
>
> I would like to use torque as part of a standalone servlet connected to an
> oracle 8I database, but I keep getting a "There was no DataSourceFactory
> configured for the connection BMV" when I do a doSelect.
> (my database is called BMV)
>
> The example code is:
>
> Torque.init("Torque.properties");
> log.debug("a");
> Criteria crit = new Criteria();
> log.debug("0");
> List v = BmvCacheMasterPeer.doSelect(crit);
>
> 0 [main ] WARN : ReadEocWeb ReadEocWeb Application Started
> 130 [main ] DEBUG: org.apache.torque.adapter.DBFactory
> org.apache.torque.adapter.DBFactory Using
org.apache.torque.adapter.DBOracle
> 140 [main ] DEBUG: org.apache.torque.adapter.DBFactory
> org.apache.torque.adapter.DBFactory Using
org.apache.torque.adapter.DBOracle
> 140 [main ] DEBUG: org.apache.torque.adapter.DBFactory
> org.apache.torque.adapter.DBFactory Using
org.apache.torque.adapter.DBOracle
> 140 [main ] DEBUG: org.apache.torque.adapter.DBFactory
> org.apache.torque.adapter.DBFactory Using
org.apache.torque.adapter.DBOracle
> 150 [main ] DEBUG: org.apache.torque.Torque
org.apache.torque.Torque
> Starting initAdapters
> 150 [main ] DEBUG: org.apache.torque.Torque
org.apache.torque.Torque
> Starting initDSF
> 150 [main ] DEBUG: ReadEocWeb ReadEocWeb a
> 170 [main ] DEBUG: ReadEocWeb ReadEocWeb 0
> 300 [Thread-1] INFO : org.apache.torque.oid.IDBroker
> org.apache.torque.oid.IDBroker IDBroker thread was started.
> 300 [main ] WARN : org.apache.torque.oid.IDBroker
> org.apache.torque.oid.IDBroker 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 generat
> ion is possible if multiple JVMs are used or other means are used to write
> to the database.
> 370 [main ] DEBUG: org.apache.torque.util.BasePeer
> org.apache.torque.util.BasePeer SELECT BMV_CACHE_MASTER.DCM_ISIN,
> BMV_CACHE_MASTER.DCM_CREATE_DATE, BMV_CACHE_MASTER.DCM_MODIFIED_DATE, FROM
> BMV_CACHE_MASTER
> 370 [main ] WARN : ReadEocWeb ReadEocWeb Failed to init
> 400 [main ] ERROR: ReadEocWeb ReadEocWeb
> java.lang.NullPointerException: There was no DataSourceFactory configured
> for the connection BMV
>
> My torque config file looks like:
>
> torque.earlyInit = true
>
> torque.database.default=default
> torque.database.default.adapter=oracle
> torque.database.BMV.adapter=oracle
>
#torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataSour
> ceFactory
> #torque.dsfactory.default.pool.defaultMaxConnections=10
> #torque.dsfactory.default.pool.maxExpiryTime=3600
> #torque.dsfactory.default.pool.connectionWaitTimeout=10
> #torque.dsfactory.default.connection.driver =
racle.jdbc.driver.OracleDriver
> #torque.dsfactory.default.connection.url =
> jdbc:oracle:thin:@10.0.1.150:1521:dev01.dcm
> #torque.dsfactory.default.connection.user = xxx
> #torque.dsfactory.default.connection.password = xxxx
>
> torque.database.default.driver = oracle.jdbc.driver.OracleDriver
> torque.database.default.url = jdbc:oracle:thin:@10.0.1.150:1521:dev01.dcm
> torque.database.default.user = xxx
> torque.database.default.password = xxxx
>
> torque.database.BMV.driver = oracle.jdbc.driver.OracleDriver
> torque.database.BMV.url = jdbc:oracle:thin:@10.0.1.150:1521:dev01.dcm
> torque.database.BMV.user = xxx
> torque.database.BMV.password = xxx
>
> Any help will be appreciated.
>
> Regards,
>
> William J Shenfield
> DCM-On-line - Security & Technical Architect
> P: +44 (0) 20 7663 1600
> F: +44 (0) 20 7663 1601
> M: +44 (0) 79 7064 2946
>
> Any opinions expressed in the email are those of the individual and not
> necessarily of the company. This email and any files transmitted with it
> are confidential and solely for the use of the intended recipient. It may
> contain material protected by attorney-client privilege. If you are not
the
> intended recipient or person responsible for delivering to the intended
> recipient, be advised that you have received this email in error and that
> any use is strictly prohibited. If you have received this email in error
> please notify the IT manager.
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.381 / Virus Database: 214 - Release Date: 02/08/2002
>
>
> --
> To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
