Torque not passing setLimit() on to mysql?

2006-07-11 Thread Bryce Nesbitt
Our application sets a limit: criteria.setLimit (25); List results = CcsReservationPeer.doSelect(criteria); logger.debug(Searching up to + criteria.getLimit() + reservations: + criteria.toString()); The debug shows the limit:

Problem with DB connection

2006-07-11 Thread Rafal Markut
Hello, I use Turbine 2.3.2 and Torque 3.1.1, Tomcat and MySQL 4.1.7. Very often I got the exception: Caused by: org.apache.torque.TorqueException: java.sql.SQLException: Lost connection to server during query or java.net.SocketException: Software caused connection abort: recv failed. When I

Re: Problem with DB connection

2006-07-11 Thread Andras Balogh
Hello, Check here: http://dev.mysql.com/doc/refman/4.1/en/cj-configuration-properties.html You should add the autoReconnect or autoReconnectForPools in the connection URL of mysql. Best regards, Andras. Rafal Markut wrote: Hello, I use Turbine 2.3.2 and Torque 3.1.1, Tomcat and MySQL

Problem with SQL Task jdbc

2006-07-11 Thread Thoralf Rickert
Hi! I try to generate a XML schema for a Sybase database. The problem is that the task runs without an error but the generated schema.xml is empty. I think, I forgot a property but I don't know which one. Here are my torque properties and the generated output: # torque.database.type=

AW: Problem with SQL Task jdbc

2006-07-11 Thread Thoralf Rickert
Okay, the property torque.database.schema has to be null - otherwise the driver returns an empty list of tables. But I cannot set it to null (comment out torque.database.schema results in a String with the content ${torque.database.schema}). I think this is a bug too - maybe sybase specific

Re: AW: Problem with SQL Task jdbc

2006-07-11 Thread Andras Balogh
Hello, Do not set torque.database.schema to null. Try to set it to the name of the user who connects to the DB or to value DBO (or dbo) I had to add to SQL server so it might work for Sybase also. Best regards, Andras. Thoralf Rickert wrote: Okay, the property torque.database.schema has