Expansion on datadump

2004-12-17 Thread Ben Bookey
Dear list, There is a tool which reads all data from the torque generated database, and writes it to an .xml file. Is there the possibility to provide a parameter to this? and say retrieve everything where a PK primary key value = x ? kind regards Ben ---

AW: Torque 3 Database datadump to XML

2004-12-13 Thread Ben Bookey
No longer a problem. I worked it out. Thanks. Ben -Ursprüngliche Nachricht- Von: Ben Bookey Gesendet: Dienstag, 14. Dezember 2004 09:42 An: Torque User List Cc: Ralf Schäfer Betreff: Torque 3 Database datadump to XML Dear Torque user List, We have used Torque in our project. Thanks

Torque 3 Database datadump to XML

2004-12-13 Thread Ben Bookey
direction ? Kind regards Ben Bookey - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

AW: AW: Village for Oracle patch.

2004-11-04 Thread Ben Bookey
t for my part. > See Arne's comments here: > <http://www.mail-archive.com/[EMAIL PROTECTED]/msg03288.html> > > HTH, regards, > > Tino > > -Ursprüngliche Nachricht- > Von: Ben Bookey [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 2. November 200

AW: AW: Village for Oracle patch.

2004-11-04 Thread Ben Bookey
of > Arne Siegel I've solved it for my part. > See Arne's comments here: > <http://www.mail-archive.com/[EMAIL PROTECTED]/msg03288.html> > > HTH, regards, > > Tino > > -Ursprüngliche Nachricht- > Von: Ben Bookey [mailto:[EMAIL PROTECTED] > Gese

AW: Village for Oracle patch.

2004-11-02 Thread Ben Bookey
Hi Saravana, > >>Is this hanging noticed only in tables with LOBs or does it hang on any > >>table where locking is performed? > > This is a very good question :-) I think that this table with the LOB is the > only one where any locking is taking place in my application. My > understanding is t

RE: Village for Oracle patch.

2004-11-01 Thread Ben Bookey
s, and not another instance of myApp. However, when one user is uploading a larger file to the table file, it could result in another scratching his head, and it would be nice to stop this hanging process. regards, Ben Bookey -

Village for Oracle patch.

2004-11-01 Thread Ben Bookey
cle session timeout), the torque Databasetable object class hangs until the other "user" unlocks the row. Is there a way to get around this. e.g. torque throws an exception which I can then check ?Or must my app hang until the lock has been released. Hope someone can give me a clue.

AW: mySQL support 4 triggers ?

2004-09-20 Thread Ben Bookey
triggers ? T E Schmitz <[EMAIL PROTECTED]> writes: >Ben Bookey wrote: >> Dear List, >> >> This is outside of the torque realm, but it will take me too long >> to write to another forum with the same level of database expertise. >Good idea. Better waste our time

mySQL support 4 triggers ?

2004-09-20 Thread Ben Bookey
Dear List, This is outside of the torque realm, but it will take me too long to write to another forum with the same level of database expertise. I have searched through the mySQL docs, and am still unclear about there support for database triggers. I suspect there is no absolutely no support for

mySQL --> CASCADE DELETE

2004-09-20 Thread Ben Bookey
uld anyone tell me if this is supported by Torque and the mysql db driver. regards Ben Bookey - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Setting "Windows-1250" character encoding via the database URL.

2004-09-03 Thread Ben Bookey
Dear list. We are using oracle, and Torque to perform updates, deletes and inserts of db. rows. My oracle database is set to Windows-1250 which supports the Euro symbol, but I am updating at the moment and it sets question marks :( I would like to hard-code, the character encoding Windows-1250 in

Oracle --> Torque --> UPDATE constraint question

2004-08-23 Thread Ben Bookey
Dear list, We are using Torque with oracle. Its possible to define a CASCADE Delete constraint in the database-schema .xml file and this works great. We would like to perform an update of another table (T2) when an update is performed on another table(T1). Is this possible to configure via Torqu

AW: ON DELETE CASCADE is missing from our torque Oracle scripts. WORKS !!!! sorry.

2004-08-12 Thread Ben Bookey
ondelete cascade functionality ? i.e. SQLserver and mySQL. regards Ben -Ursprüngliche Nachricht- Von: Ben Bookey [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 12. August 2004 17:08 An: [EMAIL PROTECTED] Betreff: ON DELETE CASCADE is missing from our torque Oracle scripts. Dear List

ON DELETE CASCADE is missing from our torque Oracle scripts.

2004-08-12 Thread Ben Bookey
Dear List, We have set for oracle our oracle Torque configuration This fails to generate .sql files with the required "on delete cascade" DDL. Is this a known problem ?Is the functionality indicated by the database_3_1.dtd at all available ? We have noticed that in the torque tutorial, the

Help required :- Oracle sid 's ??

2004-01-09 Thread Ben Bookey
Dear list, 1) When using oracle with Torque, we have come to the conclusion that when generating the java code, the Oracle service name (SID) is hard-coded into the java code itself. This means that we must re-compile the java classes for each new SID? Can anyone confirm if I am correct with this

Re: Toruqe supports BLOB ????

2003-08-14 Thread BEN BOOKEY
illage, not in torque. > > If you do not have an solution yet, contact me. > > > regards from frankfurt. > > joachim/wemove > > > > -Ursprüngliche Nachricht- > > Von: BEN BOOKEY [mailto:[EMAIL PROTECTED] > > Gesendet: Montag, 4. August 2003 19:41 &g

Apologies but I still have a small question regarding UPDATES using torque

2003-08-14 Thread BEN BOOKEY
know if his update had "failed" because user2 has deleted the row. Could anyone comment on this. Oracle returns no error when this happens, what about other databases like DB2 or Mysql ? Would appreciate any help, Ben Bookey

Re: Toruqe supports BLOB ????

2003-08-14 Thread BEN BOOKEY
to apply a patch to > do so. I think I read in the mailing list that the current > CVS version has this fix already. > > actually it's in village, not in torque. > > If you do not have an solution yet, contact me. > > > regards from frankfurt. > > joachim/w

Re: Master-Details with torque

2003-08-14 Thread BEN BOOKEY
nt seem to work. Any help out there ? Kind regards, Ben Bookey. - Original Message - From: "Michel Beijlevelt / Lucka" <[EMAIL PROTECTED]> To: "Apache Torque Users List" <[EMAIL PROTECTED]> Sent: Tuesday, August 05, 2003 9:24 AM Subject: Re: Master-

Re: Toruqe supports BLOB ????

2003-08-07 Thread BEN BOOKEY
; It possible to save an image to a blob with the current version ? Could > >> someone give a small example. We have done this using BC4J and with > >> JDBC on > >> its own, does the current version of torque help me? > >> > >> Kind regards, > >&

Toruqe supports BLOB ????

2003-08-04 Thread BEN BOOKEY
done this using BC4J and with JDBC on its own, does the current version of torque help me? Kind regards, Ben bookey. - Original Message - From: "Michel Beijlevelt / Lucka" <[EMAIL PROTECTED]> To: "Apache Torque Users List" <[EMAIL PROTECTED]> Sent: Monday,

Master-Details with torque

2003-08-04 Thread BEN BOOKEY
Dear List, Can anyone tell me how you deal with multi-user master-detail tables using torque. ? and if there is anyone who has done this ? I would be very grateful for someone to explain how they overcame this. ie. USER 1 is not allowed to DELETE parent T1 table while USER2 is editting child t

Peerobject.executeQuery not working as hoped..?

2003-07-31 Thread Ben Bookey
Hi All, I am a new torque user and have just try making a query using peer class' executeQuery" method by passing sql string as its parameter. I do get the list of record objects back but when i try to iterate through these record objects and cast it to the bean object automatically generate