SQL-Criteria howto

Hi all, I'd like to express this SQL in criteria syntax, but smth. is still missing: SELECT VORAVIS.VAVI_ID, VORAVIS.SEQUENZ FROM VORAVIS WHERE VORAVIS.AUFT_ID=67537 AND VORAVIS.SEND_SEQUENZ IN ( SELECT MAX(va.SEND_SEQUENZ) FROM VORAVIS va WHERE va.AUFT_ID=VORAVIS.AUFT_ID AND

AW: Antwort: SQL-Criteria howto

not understand why you need the alias. Following sql works for me (on tutorial tables, on oracle) select * from book where book_id in (select max(book_id) from book); Thomas Sperlich, Tino [EMAIL PROTECTED] schrieb am 22.11.2004 11:40:18: Hi all, I'd like to express this SQL in criteria

AW: Antwort: SQL-Criteria howto

by title); which gives you the book with the maximal author_id for each distinct title If that does not work within torque, do it in two calls (in one transaction): select max(author_id) from book group by title; select book_id from book where author_id in(result of 1st query); Thomas Sperlich, Tino

AW: Antwort: blocking calls, query timeout

rows with the SELECT ... FOR UPDATE NOWAIT statement. I believe there has already been some discussion around that theme complex in this list. Gruss Arne Sperlich, Tino wrote: Hi all, my problem is this: My app using torque accesses an oracle db that is shared with other apps. These apps

AW: Antwort: blocking calls, query timeout

Hi Arne, how, or better where do I specify that with torque? in torque.properties? Gruesse, Tino -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 7. September 2004 10:37 An: Apache Torque Users List Betreff: Antwort: blocking calls, query

AW: defaultIdMethod=none

Hi Henning, I agree that autoincrement would be the right choice to use, because it doesn't create a key and retrieves the key after the record is written. But, how does autoincrement work for DBOracle? I have debugged into some sample code and it looked like the dbMap had the Sequence

How to set a pooled connection's timeout

Hi, how may I set the query time-out for a connection, i.e. the time it waits for locks in the DB before throwing an exception? My torque.properties is: torque.database.btos.adapter=oracle ## Using commons-dbcp

AW: How to set a pooled connection's timeout

connection's timeout Hi Tino, I use torque.dsfactory.???.pool.maxWait=1 Cheers, Siegfried Goeschl -Original Message- From: Sperlich, Tino [mailto:[EMAIL PROTECTED] Sent: Freitag, 16. Juli 2004 13:31 To: Apache Torque Users List Subject: How to set a pooled connection's timeout Hi, how

use of schema.xml varchar sizes

Hi all, in the torque db schema there are size attributes for varchars: ... column name=U_VERSION javaName=UVersion required=false type=VARCHAR size=10 / ... These are translated into java string objects in the peer classes, and the size information is gone. Is there a way to have the

AW: use of schema.xml varchar sizes

extra logic that requires extra code, machine resources and so on? Cheers, Alex -Original Message- From: Sperlich, Tino [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 3:56 PM To: Apache Torque Users List Subject: use of schema.xml varchar sizes Hi all, in the torque

AW: Torque, building Criteria for query ...

Hi Chris. you have probably fixed the problem; but just for my info: in the API of criteria there is a method like this public Criteria addNotIn(java.lang.String column, java.util.List values) is there something wrong with this or would that do the job, too? Kind

AW: Creating XML Database schema file from existing Database schema.

Hi, try setting up your Torque project as described in the user guide. (especially edit torque.properties to reflect your db-setting) then run the build-torque.xml with ant using the task jdbc , that connects to your db and generates and xxx-schema.xml On my machine it took a while for the

AW: Creating XML Database schema file from existing Database schema.

(0)208 542 5818 Email [EMAIL PROTECTED] Reuters Messaging [EMAIL PROTECTED] -Original Message- From: Sperlich, Tino [mailto:[EMAIL PROTECTED] Sent: 29 January 2004 12:00 To: Apache Torque Users List Subject: AW: Creating XML Database schema file from existing

AW: Problem with CLOB retreival

Hi Bill, sorry to also bother you for the attachment; would you mind sending me the adjusted village.jar as well? Thank you, Tino Sperlich -Ursprüngliche Nachricht- Von: Bill Leng [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 17. Dezember 2003 17:00 An: Apache Torque Users List

Update on ID-Table when using idMethod=native

Hi, I am using Torque with the native method (i.e. Sequence), so I didnt bother to setup the id-table. still I am getting this error message when trying to insert some permission using turbine. Any hints would be appreciated. Thanks, Tino 11:12:08,509 DEBUG - updateQuantity: UPDATE