I've peeked through the Torque.properties generated by the tdk2.2-b2 in
newapp.
Here is a Working Torque.properties for the Torque Tutorial, set for the
mysql db
regards,
Slava
##########################################################################
# -------------------------------------------------------------------
# $Id: Torque.properties,v 1.3 2002/06/26 08:07:33 mpoeschl Exp $
#
# This is the configuration file for Torque.
#
# Note that strings containing "," (comma) characters must backslash
# escape the comma (i.e. '\,')
#
# -------------------------------------------------------------------
torque.applicationRoot = .
# -------------------------------------------------------------------
#
# L O G G I N G
#
# -------------------------------------------------------------------
# We use Log4J for all Torque logging and we embed the log4j
# properties within our application configuration.
# -------------------------------------------------------------------
# This first category is required and the category
# must be named 'default'. This is used for all logging
# where an explicit category is not specified.
log4j.category.org.apache.torque = DEBUG, org.apache.torque
log4j.appender.org.apache.torque = org.apache.log4j.FileAppender
log4j.appender.org.apache.torque.file =
${torque.applicationRoot}/logs/torque.log
log4j.appender.org.apache.torque.layout = org.apache.log4j.PatternLayout
log4j.appender.org.apache.torque.layout.conversionPattern = %d [%t] %-5p
%c - %m%n
log4j.appender.org.apache.torque.append = false
# -------------------------------------------------------------------
#
# 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.
# -------------------------------------------------------------------
torque.database.default=bookstore
torque.database.default.adapter=mysql
## Using torque's old pool
torque.dsfactory.bookstore.factory=org.apache.torque.dsfactory.TorqueDataSourceFactory
torque.dsfactory.bookstore.pool.defaultMaxConnections=10
torque.dsfactory.bookstore.pool.maxExpiryTime=3600
torque.dsfactory.bookstore.pool.connectionWaitTimeout=10
torque.dsfactory.bookstore.connection.driver = org.gjt.mm.mysql.Driver
torque.dsfactory.bookstore.connection.url =
jdbc:mysql://localhost:3306/bookstore
torque.dsfactory.bookstore.connection.user = root
torque.dsfactory.bookstore.connection.password = mypass
#
## Using Jdbc2Pool
#torque.dsfactory.bookstore.factory=\
# org.apache.torque.dsfactory.Jdbc2PoolDataSourceFactory
#torque.dsfactory.default.pool.defaultMaxActive=10
#torque.dsfactory.default.pool.testOnBorrow=true
#torque.dsfactory.default.pool.validationQuery=SELECT 1
#torque.dsfactory.default.connection.driver = org.gjt.mm.mysql.Driver
#torque.dsfactory.default.connection.url =
jdbc:mysql://localhost:3306/bookstore
#torque.dsfactory.default.connection.user = root
#torque.dsfactory.default.connection.password = db4jinr
##
## Using jndi
#torque.dsfactory.default.factory=org.apache.torque.dsfactory.JndiDataSourceFactory
#torque.dsfactory.default.jndi.path=jdbc/default
#torque.dsfactory.default.jndi.java.naming.factory.initial =
org.apache.naming.java.javaURLCont
xtFactory
#torque.dsfactory.default.jndi.java.naming.factory.url.pkgs =
org.apache.naming
#torque.dsfactory.default.datasource.classname=org.apache.commons.jdbc2pool.TorqueClassicDataSo
rce
#torque.dsfactory.default.datasource.dataSourceName=jdbc/DBdefault
#torque.dsfactory.default.datasource.jndiEnvironment.java.naming.factory.initial =
org.apache.n
ming.java.javaURLContextFactory
#torque.dsfactory.default.datasource.jndiEnvironment.java.naming.factory.url.pkgs =
org.apache.
aming
#torque.dsfactory.default.datasource.defaultMaxConnections=10
## ConnectionPoolDataSource
#torque.dsfactory.DBdefault.factory=org.apache.torque.dsfactory.JndiDataSourceFactory
#torque.dsfactory.DBdefault.jndi.path=jdbc/DBdefault
#torque.dsfactory.DBdefault.jndi.java.naming.factory.initial =
org.apache.naming.java.javaURLCo
textFactory
#torque.dsfactory.DBdefault.jndi.java.naming.factory.url.pkgs =
org.apache.naming
#torque.dsfactory.DBdefault.datasource.classname=org.apache.commons.jdbc2pool.adapter.DriverAda
terCPDS
#torque.dsfactory.DBdefault.datasource.driver = org.gjt.mm.mysql.Driver
#torque.dsfactory.DBdefault.datasource.url =
jdbc:mysql://localhost:3306/torque
#torque.dsfactory.DBdefault.datasource.user = user
#torque.dsfactory.DBdefault.datasource.password = password
# 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
########################################################################################
On Wed, 2002-08-14 at 03:41, Slava Zimine wrote:
> Hi,
> In my wish to upgrade to a new Torque30-b3 i've tried to set up its
> usual Bookstore project on a mysql db.
>
>
> Beyond the torque-3.0-b3 distrib Exceptions lead me to download from
> jakarta.apache.org/jars
> commons-beanutils-1.4-dev.jar
> ommons-jdbc2pool-1.0-dev.jar
> commons-logging-1.1-dev.jar
>
> and put them in the torque's lib dir
>
> running the Tutorial's bookstore gives:
> #######################
> ava.lang.NullPointerException
> at
>
>org.apache.torque.dsfactory.TorqueDataSourceFactory.initCPDS(TorqueDataSourceFactory.java:117)
> at
>
>org.apache.torque.dsfactory.TorqueDataSourceFactory.initialize(TorqueDataSourceFactory.java:103)
> at
> org.apache.torque.Torque.initDataSourceFactories(Torque.java:305)
> at org.apache.torque.Torque.initialize(Torque.java:229)
> at org.apache.torque.Torque.init(Torque.java:388)
> at org.apache.torque.Torque.init(Torque.java:368)
> at com.slava.bookstore.Bookstore.main(Bookstore.java:17)
> rethrown as org.apache.torque.TorqueException
> at
>
>org.apache.torque.dsfactory.TorqueDataSourceFactory.initCPDS(TorqueDataSourceFactory.java:129)
> at
>
>org.apache.torque.dsfactory.TorqueDataSourceFactory.initialize(TorqueDataSourceFactory.java:103)
> at
> org.apache.torque.Torque.initDataSourceFactories(Torque.java:305)
> at org.apache.torque.Torque.initialize(Torque.java:229)
> at org.apache.torque.Torque.init(Torque.java:388)
> at org.apache.torque.Torque.init(Torque.java:368)
> at com.slava.bookstore.Bookstore.main(Bookstore.java:17)
> Caused by: java.lang.NullPointerException
> at
>
>org.apache.torque.dsfactory.TorqueDataSourceFactory.initCPDS(TorqueDataSourceFactory.java:117)
> ... 6 more
>
>
> ######################
> the snippet from Torque.propeties
> --------------------------
> torque.database.default=bookstore
> torque.database.default.adapter=mysql
>
> ## Using torque's old pool
>
>torque.dsfactory.bookstore.factory=org.apache.torque.dsfactory.TorqueDataSourceFactory
> torque.dsfactory.default.pool.defaultMaxConnections=10
> torque.dsfactory.default.pool.maxExpiryTime=3600
> torque.dsfactory.default.pool.connectionWaitTimeout=10
> torque.dsfactory.default.connection.driver = org.gjt.mm.mysql.Driver
> torque.dsfactory.default.connection.url =
> jdbc:mysql://localhost:3306/bookstore
> torque.dsfactory.default.connection.user = admin
> torque.dsfactory.default.connection.password = pass
> #
>
> Any opinion will be appreciated.
>
>
> regads,
>
> slava
>
>
>
> --
> 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]>
