RE: Somewhat complex query with Criteria

2005-01-31 Thread Michael . Kashambuzi
Robert: You can try this. Criteria c = new Criteria(); Criteria.Criterion A = criteria.getNewCriterion(NotificationPeer.CODE, 0, Criteria.EQUAL); Criteria.Criterion B = criteria.getNewCriterion(NotificationPeer.CODE, 0, Criteria.NOT_EQUAL); Criteria.Criterion C =

RE: [BULK] torque and spring

2005-01-31 Thread Michael . Kashambuzi
Johan- What specifically are you looking for? Michael -Original Message- From: Johan Andries [mailto:[EMAIL PROTECTED] Sent: Monday, January 31, 2005 8:59 AM To: torque-user@db.apache.org Subject: [BULK] torque and spring Hello, Has anyone ever done a successful attempt on

RE: Torque tries to insert 0 into nullable Foreign Key

2004-12-06 Thread Michael . Kashambuzi
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: Problem with configuration for DB2

2004-12-02 Thread Michael . Kashambuzi
Dave: Are you using the JDBC 2.0 driver? Michael -Original Message- From: Dave Gray [mailto:[EMAIL PROTECTED] Sent: Thursday, December 02, 2004 3:06 PM To: [EMAIL PROTECTED] Subject: Problem with configuration for DB2 I have been using Torque with MSSQL. We need to support multiple

RE: Problem with configuration for DB2

2004-12-02 Thread Michael . Kashambuzi
Dave- I think you need to be using the JDBC 2.0 driver which has a DB2 implementation of DataSource. Check in your SQLLIB\java12\ directory for a file called inuse. If this file does not say JDBC 2.0, you will need to run the usejdbc2.bat script to move the db2java.zip for JDBC 2.0 to your

RE: Exclusive Criteria OR Conditions

2004-07-21 Thread Michael . Kashambuzi
If you look at how Torque geenrates or condition when you add one Criterion as an OR condition to another, it looks something like the following: for criteria A, B, C depending on the order in which you add the conditions, you could end up with ( ( A or B ) or C ) or ( A or ( B or C ) ).

Exclusive Criteria OR Conditions

2004-07-19 Thread Michael . Kashambuzi
I've already checked in the mailing list and have not found an answer. Does anyone know how to perform an OR in the following situation. SELECT A, B, C FROM TABLE1 WHERE A IN (1,2,3) OR B IN (4,5,6) OR D in (7,8,9) For each criterion, I want to add it as a criterion to

RE: Subqueries in Torque

2004-06-24 Thread Michael . Kashambuzi
Basically what I am trying to do is avoiding listing all teh columns in the select clause a a result of needing to add a group by clause. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 7:33 PM To: [EMAIL PROTECTED] Subject: Subqueries in

Subqueries in Torque

2004-06-22 Thread Michael . Kashambuzi
Hi- I have searched the archives and have not been able to find a solution to a problem I have. Is anyone familiar with how to produce a subquery in Torque 3.1? I am trying to achieve the following: select * from table1 as a where a.col1 in (

RE: Changes to Support Fully Qualified Tables Names

2004-06-01 Thread Michael . Kashambuzi
a number of identical schemas that we use. It would be much more useful to us here if the schema were able to be assigned at runtime rather than at compile time. -Original Message- From: Michael Kashambuzi [mailto:[EMAIL PROTECTED] Sent: Friday, May 28, 2004 2:34 PM To: [EMAIL PROTECTED

Torque TODO List Regarding Fully Qualified Table Names

2004-05-26 Thread Michael . Kashambuzi
Hi- I've checked the web site but I'm wondering if it's on the to-do list to add fully qualified table functionality to Torque in the near future. It seems as though many users have opted out of using Torque primarily due to this reason. I too have been checking over the last year hoping that

Specifying the table schema in Torque.properties

2004-05-25 Thread Michael . Kashambuzi
Hi- Does anyone know if it's possible to specify a property for the table schema in the Torque.properties file or in the Configuration? I am trying to do something similar to databaseSchema = MYDBSCHEMA like in the build.properties in torque-gen. Any help would be greatly appreciated.

RE: Re: Limit Tables In Schema

2004-05-24 Thread Michael . Kashambuzi
I'm working with a pre-existing database. -Original Message- From: Saravana Krishnan Kannan [mailto:[EMAIL PROTECTED] Sent: Saturday, May 22, 2004 11:22 PM To: [EMAIL PROTECTED] Subject: Re: Re: Limit Tables In Schema Then why do you need to describe the tables in the schema at all? If

Limit Tables In Schema

2004-05-21 Thread Michael . Kashambuzi
Hi- Is it possible to limit the tables which are added to the schema.xml file for a project? I only need to generate Torque classes for a handful of tables but the database has hundreds. Michael - To unsubscribe, e-mail:

Torque Deployed in an EAR on JBOSS 3.0.6

2003-09-03 Thread Michael Kashambuzi
I'm attempting to deploy Torque in an EAR. I have the following EAR structure sample.ear META-INF application.xml sample.jar META-INF MANIFEST.MF