Join or Where Clause

Hello, I have 2 tables. In one table stand numbers in the secound table stand adresses. The have a foreign key NumberTable N_ID N_Number AdressesTable A_ID A_N_ID A_Name The adresses table have the foreign key A_N_ID=N_ID. In the number table stand very much numbers. Now i wont to find out

Re: Introducing JoinHelper

Vitzethum, Daniel [EMAIL PROTECTED] writes: Hi, this looks really interesting. Could you please open an Issue in the bug tracker with this class attached, so it does not get lost. And I'd appreciate an explict ASF 2.0 license in the header (or does your company has a CCLA on file?).

Torque tries to insert 0 into nullable Foreign Key

Hello list, one more question: I have a schema with nullable foreign keys of type INTEGER. When saving a new object, Torque's buildCriteria method inserts 0 as the according column's value, what is wrong as it should be null. Even defaults in DB don't work therefore. My Oracle DB refuses to

RE: Torque tries to insert 0 into nullable Foreign Key

Hi Daniel, I had the same problem before, and as I needed a quick solution, I used string foreign keys instead (String foreign keys can be null). I will open a scarab issue on this problem. Thomas Vitzethum, Daniel [EMAIL PROTECTED] schrieb am 06.12.2004 13:22:17: Hello list, one

Re: Torque tries to insert 0 into nullable Foreign Key

Hi Thomas, thanks for the quick answer (as usual ;-) I had the same problem before, and as I needed a quick solution, I used string foreign keys instead (String foreign keys can be null). I will open a scarab issue on this problem. my quick workaround: I have overridden and copied

RE: Join or Where Clause

Hi Daniel, I have looked through the source code and it seems that your query cannot be generated generically with torque. The problem is that Torque does not support join conditions other than equal (=). My suggestion for a quick solution would be to use any of the methods

RE: Best Practices for read-only operations and concurrency?

Even if a writer commits during a long read operation Oracle will still retain the session's read consistency. The mechanism Oracle uses for read consistency utilizes the rollback segments and the one caveat for this lies in the necessity for properly sizing rollback segments. If they are too

RE: Torque tries to insert 0 into nullable Foreign Key

Daniel- When generating you object using the om task, make sure you're using database name=xxx defaultJavaType=object project-schema.xml The object java type allows null values. Michael -Original Message- From: Vitzethum, Daniel [mailto:[EMAIL PROTECTED] Sent: Monday,

RE: Torque Maven Plugin Problem

Hi Tod, I finally got a (_VERY_ dirty) solution for your problem. Perhaps some maven guru on the list can create a cleaner solution from this. Find the file /cache/maven-torque-plugin-3.1.1/plugin.jelly somewhere in your maven home directory. Add the path to classes12.jar into the torque

Re: ClassCastException with torque

Problem solved. I thought there was a mismatch between torque 3.1.1 and 3.1. After having reinstalled torque 3.1.1 via maven, it worked again. The version management is really a headache stuff. --- Hoang-Vu PHUNG [EMAIL PROTECTED] a écrit : Hi, I'm new to torque. I have managed to use