Hmm, at this point, I'd try doing a simple jsp page
to manually open the DB and do a simple query with
straight JDBC calls using the DB URL and other info
in the Torque properties. Something like:
<%@ page import="java.sql.*" %>
<%
Driver driver = (Driver)Class.
forName(<mysql driver>).newInstance();
Connection conn =
DriverManager.getConnection(<url>,<user>,<pwd);
PreparedStatement stmt = conn.prepareStatement(
"SELECT * FROM <a new table>");
ResultSet rs = stmt.executeQuery();
if (rs != null) {
%>
Found <%=rs.size()%> results.
<% } else %>
ResultSet was null!
<% } %>
If this page works from the same WebApp, then you
know it's not a connection, class path, driver issue
and can go from there.
One other thought is that it might be a case
sensitivity issue. Do the tables you restored have
the same case as the original/production names?
> -----Original Message-----
> From: Bryce Nesbitt [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 16, 2006 1:15 PM
> To: Apache Torque Users List
> Subject: Re: What are possible causes of: IDBroker ... does
> not support transactions.
>
>
> Greg Monroe wrote:
> > log4j statements in the Torque.properties have never
> > worked for me.. try creating a separate log4j.properties
> > file in the class path. It generates tons of output
> > for me under Tomcat.
> >
> Got it. But it is the exact same, less than detailed, error message:
>
>
>
> DEBUG tcpConnection-6809-0 org.apache.commons.beanutils.BeanUtils -
> setProperty([EMAIL PROTECTED],
> userid, [5403]) DEBUG tcpConnection-6809-0
> org.apache.commons.beanutils.ConvertUtils - Convert string
> '5403' to class 'java.lang.String' DEBUG tcpConnection-6809-0
> org.apache.commons.beanutils.ConvertUtils -
> Using converter
> [EMAIL PROTECTED]
> DEBUG tcpConnection-6809-0 org.apache.commons.beanutils.BeanUtils -
> setProperty([EMAIL PROTECTED],
> pin, [XXXX]) DEBUG tcpConnection-6809-0
> org.apache.commons.beanutils.ConvertUtils - Convert string
> 'XXXX' to class 'java.lang.String' DEBUG tcpConnection-6809-0
> org.apache.commons.beanutils.ConvertUtils -
> Using converter
> [EMAIL PROTECTED]
> DEBUG tcpConnection-6809-0
> org.apache.struts.action.RequestProcessor -
> Validating input form properties
> DEBUG tcpConnection-6809-0
> org.apache.struts.action.RequestProcessor -
> No errors detected, accepting input
> DEBUG tcpConnection-6809-0
> org.apache.struts.action.RequestProcessor -
> Looking for Action instance for class
> com.myclient.xxx.v2.web.member.LoginAction
> DEBUG tcpConnection-6809-0
> org.apache.struts.action.RequestProcessor -
> Creating new Action instance
> DEBUG Thread-0 org.apache.torque.oid.IDBroker - IDBroker
> thread was started. WARN tcpConnection-6809-0
> org.apache.torque.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. DEBUG tcpConnection-6809-0
> org.apache.struts.util.PropertyMessageResources -
> getMessage(en_US,unhandledException)
>
>
>
> ---------------------------------------------------------------------
> 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]
