Releasing DB connections

2004-08-27 Thread Raphael . X . Mankin%GSK%SB
A bit of clarification please. One uses torque.getConnection to get a DB connection from the pool. How and when is it returned to the pool? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

Re: Releasing DB connections

2004-08-27 Thread Raphael . X . Mankin%GSK%SB
Up to now I have assumed that things work as you explained. However opening new connections is typically a fairly slow business. When programming in C or Perl one gets used to using the same connection over and over again, processing transactions in a loop. This does not appear to be possible with

Re: Documentation updates, patches, moving towards a 3.1.1 release

2004-08-20 Thread Raphael . X . Mankin%GSK%SB
I'm not sure whether this should go into the tutorial, the reference docs or the WIKI. It is possible to add any attribute you like to the schema XML; it will be ignored by the generator scripts. I find this useful in order to add extra semantics to the schema, which I then pick up in my own xml

Re: SortedMap in reverse order

2004-07-19 Thread Raphael . X . Mankin%GSK%SB
Hvae you looked at java.util.Collections? See the methods reverse(), which reverses (moodifes) the collection, and reverseOrder(), which just provides a convenient comparator. Try something like // Create a TreeMap that sorts in the reverse order SortedMap sortedMap =

RE: need help

2004-07-13 Thread Raphael . X . Mankin%GSK%SB
It is frequently not quite what is wanted. For instance, I want to find all orphaned objects, so I need to construct a Criteria that is equivalent to WHERE id NOT IN (SELECT id FROM othertable) and to use this in a doSelect() or doDelete(). I do not want to construct an SQL statement by

Inadequate validation in SQL generation

2004-06-17 Thread Raphael . X . Mankin%GSK%SB
I have found a hole in the validation of the schema XML. I used to have a column FORMULAID, which I removed. However there was still a UNIQUE constraint for it in the schema. This was inconsistency was not detected by the ant 'sql' task and was picked up ony when I tried to run the generated

DATE and TIMESTAMP in Oracle with Torque 3.1

2004-06-15 Thread Raphael . X . Mankin%GSK%SB
I am using Torque 3.1 with an Oracle DB. I am trying to create tables that have date/time fields. I find that it makes absolutely no difference whether in the xml I declare the columns as DATE or TIMESTAMP; the DDL and code generated are exactly the same. The effect of this is that the time