db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryce Nesbitt <bry...@obviously.com>
Subject What are possible causes of: IDBroker ... does not support transactions.
Date Thu, 16 Feb 2006 16:48:29 GMT
This application used to work on this machine.  Has worked on other
machines for years.  On other machines it works fine on table types that
don't even support transactions.  Yet now have spent 10+ hours on this
error message which appeared on an otherwise working server after a data
source upgrade:::

$ tail -f stderr.log
srun listening to
http listening to *:8080
9624 [tcpConnection-6809-0] INFO action.RequestProcessor  - Processing a
'POST' for path '/member/login'
9758 [Thread-1] DEBUG oid.IDBroker  - IDBroker thread was started.
9839 [tcpConnection-6809-0] WARN oid.IDBroker  - IDBroker is being used
with db 'default', 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.
9876 [tcpConnection-6809-0] WARN action.RequestProcessor  - Unhandled
Exception thrown: class java.lang.NullPointerException

$ cat torque.properties

#  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.
# -------------------------------------------------------------------


## Using Jdbc2Pool
torque.dsfactory.default.pool.defaultMaxActive = 10
torque.dsfactory.default.pool.testOnBorrow     = true
torque.dsfactory.default.pool.validationQuery  = SELECT 1
torque.dsfactory.default.connection.driver     = com.mysql.jdbc.Driver
torque.dsfactory.default.connection.url        =
torque.dsfactory.default.connection.user       = xxx
torque.dsfactory.default.connection.password   = xxxxxxxx

$ ls WEB-INF/*/to*

$ mysql --version
mysql  Ver 12.22 Distrib 4.0.17, for pc-linux (i686)
$ mysql -u xxx -p
| ASSET_TABLE | InnoDB | Dynamic    | 218129 |             93 |    20496384

$ telnet localhost 3306
Connected to localhost.localdomain (
Escape character is '^]'.

$ startserver
command-line: /usr/java/j2sdk1.4.2_06/bin/java  -Xms1536m -Xmx1536m 
-Dresin.home=/opt/resin-2.1.12 com.caucho.server.http.HttpServer -conf
resun-xxxxxxx.conf  -stdout stdout.log -stderr stderr.log

We're confused by the use of the term 'default' in the DB error message,
among other things.  Is there a way to get a more verbose or useful
error message?
What are typical causes of this type of failure to find a datasource?
And no, this application has run for years, upgrading all the versions
is not an option, sorry.

To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

View raw message