Some additional quick thoughts...
You will also see the Broker message if you are doing two calls to
Torque init, e.g. Torque is being initialized in two different web
apps. They should be wrapped in a check to see if Torque has already
been initialized.
I noticed that your properties has:
torque.database.default=default_stupid_thing
I assume this is a debug statement? I think with 3.0 and above
the new syntax applies, so this should be =default to associate
all the xxx.xxx.default.xxx settings.
As to the "Default" name, this is the name used in the schema
that created the Java classes. It does not match a physical
Database on MySQL, but is a Torque "logical" grouping id.
To get more debug information, create a log4j.properties
file in your classpath with something like:
log4j.rootLogger=debug, RollingFile
log4j.appender.RollingFile=org.apache.log4j.RollingFileAppender
log4j.appender.RollingFile.File=${catalina.home}\\logs\\debug.log
log4j.appender.RollingFile.MaxFileSize=2000KB
log4j.appender.RollingFile.MaxBackupIndex=3
log4j.appender.RollingFile.layout=org.apache.log4j.PatternLayout
log4j.appender.RollingFile.layout.ConversionPattern=%p %t %c - %m%n
log4j.logger.org.apache.torque=DEBUG
Another odd possiblity is the location of your JDBC driver. I have
had some strange class loader related problems if it's located in
the Web Application lib. You might try putting it at the server
level. (Equivalent of Tomcat's common/lib directory).
Good luck.
> -----Original Message-----
> From: Bryce Nesbitt [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 16, 2006 11:48 AM
> To: torque-user@db.apache.org
> Subject: What are possible causes of: IDBroker ... does not
> support transactions.
>
>
> 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 127.0.0.1:6809
> 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.
> # -------------------------------------------------------------------
>
> torque.database.default=default_stupid_thing
> torque.database.default.adapter=mysql
>
> ## Using Jdbc2Pool
> torque.dsfactory.default.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 = com.mysql.jdbc.Driver
> torque.dsfactory.default.connection.url =
> jdbc:mysql://localhost:3306/ccs
> torque.dsfactory.default.connection.user = xxx
> torque.dsfactory.default.connection.password = xxxxxxxx
>
>
> $ ls WEB-INF/*/to*
> WEB-INF/lib/torque-3.0-b4.jar
>
> $ mysql --version
> mysql Ver 12.22 Distrib 4.0.17, for pc-linux (i686)
> $ mysql -u xxx -p
> > SHOW TABLE STATUS;
> ...
> | ASSET_TABLE | InnoDB | Dynamic | 218129 | 93
> | 20496384
> ...
>
> $ telnet localhost 3306
> Trying 127.0.0.1...
> Connected to localhost.localdomain (127.0.0.1).
> Escape character is '^]'.
> 0
> 4.0.17-standard
>
> $ 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
Duke CE Privacy Statement
Please be advised that this e-mail and any files transmitted with it are
confidential communication or may otherwise be privileged or confidential and
are intended solely for the individual or entity to whom they are addressed.
If you are not the intended recipient you may not rely on the contents of this
email or any attachments, and we ask that you please not read, copy or
retransmit this communication, but reply to the sender and destroy the email,
its contents, and all copies thereof immediately. Any unauthorized
dissemination, distribution or copying of this communication is strictly
prohibited.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
