Colin Thanks for your help. This + using the torque-3.0-b3-dev.jar from the Jakarta OJB fixed the problems.
William > -----Original Message----- > From: Colin Chalmers [mailto:[EMAIL PROTECTED]] > Sent: 13 August 2002 19:49 > To: Turbine Torque Users List > Subject: Re: There was no DataSourceFactory configured for the > connection BMV > > > 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.Torqu > eDataSourc > 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.Torq > ueDataSour > > 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]> > > > > --- > Incoming 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 > --- 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]>
