Torque, Derby and unit tests

2014-08-17 Thread Graham Leggett
Hi all, I am trying to test some torque code against an in-memory derby database, and am running into a chicken-and-egg situation with respect to the database schema. When the torque code runs it assumes the database has had a schema loaded, which in the case of the in-memory derby database isn

Strange missing spaces in a Criteria based query

2014-04-15 Thread Graham Leggett
Hi all, I am having some bizarre behaviour from torque v3.3. On a specific machine (RHEL6, Java SE 7u51), an attempt to generate a query from a Criteria object using a join results in the bogus query below, notice the missing spaces between "payment_note", "JOIN", and "note": Criteria:: note.e

org.apache.torque.engine.EngineException: java.net.SocketException: Connection reset

2014-04-15 Thread Graham Leggett
Hi all, I have an old project that I am trying to build using torque v3.3 that now fails during the maven build with the error "java.net.SocketException: Connection reset". Unfortunately the error message from xerces is useless because it tells us there was a connection reset without giving us

Re: Torque LEFT JOIN with multiple clauses

2012-06-04 Thread Graham Leggett
On 04 Jun 2012, at 2:50 PM, Graham Leggett wrote: > The attached patch is what I came up with so far. > > As it ultimately turned out, my query eventually didn't need the join clause, > so I haven't developed this further. Ideally it should be possible to support > n

Re: Torque LEFT JOIN with multiple clauses

2012-06-04 Thread Graham Leggett
On 02 Jun 2012, at 4:52 PM, Thomas Fox wrote: > No, they aren't. The curren implementation is you can use one condition but > choose the operator. > > If you want to create a patch for this, I'd advocate to use a > org.apache.torque.criteria.Criterion to hold the join clause for the most > gener

Torque LEFT JOIN with multiple clauses

2012-05-19 Thread Graham Leggett
Hi all, From what I can see, torque currently is unable to support the following kind of join containing multiple clauses: SELECT ... FROM a LEFT JOIN b ON a.id = b.id AND b.foo IS NULL ... Is this possible in torque 4 as yet? Just want to check before I create a patch that this isn't supporte

Re: Nested queries (was: Re: Change semantics of Criteria.add() and Criteria.or())

2011-12-12 Thread Graham Leggett
On 12 Dec 2011, at 2:02 PM, Thomas Fox wrote: > Do you mean subselects ? This already works in Torque 3.3. > E.g. > Criteria.add(AUTHORPeer.ID, someNestedCriteria, Criteria.IN); That's exactly what I meant, and wasn't aware of it, thanks for that :) Regards, Graham -- -

Re: Change semantics of Criteria.add() and Criteria.or()

2011-12-12 Thread Graham Leggett
On 11 Dec 2011, at 9:01 PM, Thomas Fox wrote: > I propose to change the semantics of the Criteria.add() and Criteria.or() > methods. > > In my opinion, both behave counter-intuitively. My opinion of an intuitive > behaviour would be: > - Criteria.or(someCondition) should result in a where clause

Re: Continuous integration

2011-11-22 Thread Graham Leggett
On 22 Nov 2011, at 5:37 AM, Thomas Fox wrote: The gump build for torque 4 fails for a long time now. Do we think we need a gump build ? If yes, does anybody have hints why the build fails ? If not, how do we remove it ? Gump is good :) According to the error at the bottom of the gump mail

Re: template changes to add filler methods

2011-06-21 Thread Graham Leggett
On 21 Jun 2011, at 11:15 PM, Thomas Fox wrote: These two approaches also have problems - they also bloat a class API which is already big - If one table has several foreign keys, user could want some relations to be filled and some not. This can not be achieved with the above approach. Thi

Re: template changes to add filler methods

2011-06-21 Thread Graham Leggett
On 19 Jun 2011, at 1:57 PM, Thomas Fox wrote: I have locally implemented filler methods for associated objects and would like to commit the changes. The filler methods efficiently read related objects. E.g. for the author and book tables in the tutorial, the generated methods are AuthorPeer

Solving a problem with Torque

2011-05-15 Thread Graham Leggett
Hi all, When I do a search using torque, I am given a List of objects back, which I can iterate through at will. These objects are linked with foreign key relationships to other objects, and so I can call getFoo() on each object in my result set, and torque will initiate a query and fetch

[SOURCE] Issue #TRQS238 - Generated code PMD warning Avoid unused local variables...

2004-10-19 Thread Graham Leggett
You can view the issue detail at the following URL: http://nagoya.apache.org/scarab/issues/id/TRQS238 Type Defect Issue ID TRQS238 (Generated code PMD warning Avoid unused local variables such as 'offset4') Reported by Graham Leggett [EMAIL PROTECTED] ([EMAIL PROTECTED])

[SOURCE] Issue #TRQS237 - Generated code PMD warning Avoid unused local variables...

2004-10-19 Thread Graham Leggett
You can view the issue detail at the following URL: http://nagoya.apache.org/scarab/issues/id/TRQS237 Type Defect Issue ID TRQS237 (Generated code PMD warning Avoid unused local variables such as 'newCriteria') Reported by Graham Leggett [EMAIL PROTECTED] ([EMAIL PROTEC

[SOURCE] Issue #TRQS236 - Generated code contains javadoc error @param tags incor...

2004-10-19 Thread Graham Leggett
You can view the issue detail at the following URL: http://nagoya.apache.org/scarab/issues/id/TRQS236 Type Defect Issue ID TRQS236 (Generated code contains javadoc error @param tags incorrect) Reported by Graham Leggett [EMAIL PROTECTED] ([EMAIL PROTECTED]) New issue details

[SOURCE] Issue #TRQS235 - Generated code contains Javadoc error sentence is diffe...

2004-10-19 Thread Graham Leggett
You can view the issue detail at the following URL: http://nagoya.apache.org/scarab/issues/id/TRQS235 Type Defect Issue ID TRQS235 (Generated code contains Javadoc error sentence is different from what will be interpreted) Reported by Graham Leggett [EMAIL PROTECTED] ([EMAIL

[SOURCE] Issue #TRQS229 - torque v3 1 commons configuration v1 0 don't play nice...

2004-10-14 Thread Graham Leggett
You can view the issue detail at the following URL: http://nagoya.apache.org/scarab/issues/id/TRQS229 Type Defect Issue ID TRQS229 (torque v3 1 commons configuration v1 0 don't play nice together) Reported by Graham Leggett [EMAIL PROTECTED] ([EMAIL PROTECTED]) New issue de

Re: Criteria and OR

2004-04-02 Thread Graham Leggett
David Zverina wrote: You're probably adding criteria instead of making Criterions and or-ing them first. The following code fragment works and will probably do what you need. Thanks! Is it possible to add this to the documentation of the or() methods in Criteria? It implies by the name of the me

Criteria and OR

2004-04-01 Thread Graham Leggett
Hi all, I have a criteria that is to generate a SQL statement "where x=a or y=a" like so: criteria.or(PolicyNoteReversalPeer.REVERSAL_ID, a); criteria.or(PolicyNoteReversalPeer.ORIGINAL_ID, a); This criteria generates the following sql: SELECT FROM policy_note_reversal WHERE policy_note_rever

java.sql.SQLException: Connection is closed.

2003-12-09 Thread Graham Leggett
Hi all, One of my system users has reported a spurious error that said "the connection is closed". Is this a known problem with Torque? I have Tomcat v4.1.27 provide a connection pool to my webapp, which is in turn accessed by my Torque v3.1 based application. The exception is as follows, any

Subtle bug: torque and transactions

2003-12-01 Thread Graham Leggett
Hi all, I have been trying to hunt down why attempts to set a field on a database row object have been ignored, and have uncovered why. What I have is a table that is updated inside a transaction. First, a certain set of date rows in the table are set to null. Then, a second set of date rows a

Scarab down

2003-12-01 Thread Graham Leggett
Hi all, The scarab bugtracker has been down for a number of days. Anyone know why to ask that it be fixed? Regards, Graham -- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Bug: NullpointerException in BaseManager

2003-11-30 Thread Graham Leggett
Hi all, Out of the blue, my torque application has suddenly decided to bomb out with a NullPointerException when saving a specific object to the database. The bombout occurs in the generated code BaseManager.java, where on about line 145, it says this: public static void putInstance(Persis

[DOCUMENTATION] Issue #TRQD1 - Pool HOWTO docs omit required torque database default pa...

2003-11-15 Thread Graham Leggett
You can view the issue detail at the following URL: http://scarab.werken.com:8080/scarab/issues/id/TRQD1 Type Defect Issue ID TRQD1 (Pool HOWTO docs omit required torque database default parameter) Reported by Graham Leggett [EMAIL PROTECTED] ([EMAIL PROTECTED]) New issue details

Re: The dreaded BIT and PostgreSQL

2003-11-03 Thread Graham Leggett
Henning P. Schmiedehausen wrote: Personally, I'd very much prefer applying this patch to Torque (3.2 and 3.1) because IMHO it fixes a bug. A definite +1 on a fix. I've had to scrap BIT columns and replace them with INTEGERs as BITs just don't work with Torque - yuck. Regards, Graham -- -

Configuring pools - how?

2003-10-28 Thread Graham Leggett
Hi all, Having read the pools howto in the docs from an end user point of view, I can say they do not answer the question "how to". Specifically, it highlights a number of ways in which pools can be configured, but neglects to mention clearly the recommended way to configure pools. In additio

Re: Torque.shutdown() doesn't.

2003-10-28 Thread Graham Leggett
Scott Eade wrote: Can you please try upgrading to commons-pool-1.1 and commons-dbcp-1.1 and see if the problem is still there. I am unsure if this specific problem has been addressed so please report back as to whether or not this resolves the problem for you. Tried to upgrade both jars, and t

Torque.shutdown() doesn't.

2003-10-27 Thread Graham Leggett
Hi all, I am having a problem with Torque v3.1 and the Torque.shutdown() method. This is run during a WAR container cleanup, and step by step debugging shows that this method is being called. After the call however, pooled connections to the database remain open. This forces us to shut our en

FYI: broken links to mail archives

2003-10-27 Thread Graham Leggett
Hi all, I just tried to search the mail archives, but got "archives.apache.org domain does not exist". Regards, Graham -- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[SOURCE] Issue #TRQS185 - Postgres boolean type handled as an int instead of a boo...

2003-09-20 Thread Graham Leggett
You can view the issue detail at the following URL: http://scarab.werken.com/issues/id/TRQS185 Type Defect Issue ID TRQS185 (Postgres boolean type handled as an int instead of a boolean) Reported by Graham Leggett [EMAIL PROTECTED] ([EMAIL PROTECTED]) New issue details

Re: Equivalent of "make clean" for torque

2003-07-15 Thread Graham Leggett
Graham Leggett wrote: Yet when I run torque, it still insists on doing nothing, saying everything is "up to date". Is there a way of overriding this and forcing OM file generation? Doh! Turns out my schema file was called mydb.schema.xml instead of mydb-schema.xml. Is it possi

Equivalent of "make clean" for torque

2003-07-15 Thread Graham Leggett
Hi all, I am trying to create a new project skeleton for a new project, based on an existing working project. Having copied the required files over to the new project, and made what I can see are the required changes, I have asked torque to generate my OM files for me - which it stubbornly ref

Postgres' bit handling hosed

2003-07-12 Thread Graham Leggett
Hi all, I have defined a column in a table like so: When using criteria to query this column like so: criteria.add(CompanyPeer.ACTIVE, true); It results in the following added to the query: WHERE company.ACTIVE=1 This causes the following SQLException: java.sql.SQLException: ERROR: Una

Peer.doDelete() is a void instead of an int

2003-06-23 Thread Graham Leggett
Hi all, The BasePeer.doDelete() method returns void, while PreparedStatement.executeUpdate() returns an int containing the number of rows that were "touched" by the update. Can this be changed at some point to return int instead of void? Regards, Graham -- -

Torque and transaction support

2003-06-22 Thread Graham Leggett
Hi all, Torque allows me to get a java.sql.Connection object from the pool using Torque.getConnection(). It also allows me to use the connection in the Peer objects, eg SomethingPeer.doSelect(Criteria, Connection). Does this mean I can use Connection.setAutoCommit(false) to support transaction

[SOURCE] Issue #TRQS166 - create db sql script created empty torque create db fai...

2003-06-20 Thread Graham Leggett
You can view the issue detail at the following URL: http://scarab.werken.com/issues/id/TRQS166 Type Defect Issue ID TRQS166 (create db sql script created empty torque create db fails) Reported by Graham Leggett [EMAIL PROTECTED] ([EMAIL PROTECTED]) New issue details

torque:create-db goal hosed in v3.1

2003-06-20 Thread Graham Leggett
Hi all, Up till now I have been using "maven torque" with torque v3.0 to regenerate my om files, my sql schema, and the sql to drop and create the database. I upgraded to the latest snapshot of torque v3.1, and the torque:create-db goal, or one of it's dependancies is now hosed - the resultan

URL to mailing list archives currently broken

2003-06-20 Thread Graham Leggett
Hi all, The link to this mailing list's archive is set to http://archives.apache.org/eyebrowse/[EMAIL PROTECTED], which gives an error: "Required parameter "listId" or "listName" is missing or invalid" The archive for the user's list is also broken. Regards, Graham --

Torque bombs out with a NullPointerException

2003-06-20 Thread Graham Leggett
Hi all, Having made some changes and added some new tables to my database schema, I ran "maven torque", which then proceeded to bomb out with this exception: --- Nested Exception --- java.lang.NullPointerException at org.apache.torque.engine.database.model.Database.doFinalInitialization(Datab