Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: pass (hermes.apache.org: local policy)
To: torque-user@db.apache.org
Subject: Prepared Statements with Oracle
MIME-Version: 1.0
Message-ID: 
 <OF4982CCAE.57CF540E-ONC1256F9C.00445B7B-C1256F9C.004E084C@ip3k.de>
From: a.winter@telenet-ag.de
Date: Wed, 2 Feb 2005 15:12:19 +0100
Content-Type: text/plain; charset="us-ascii"

Hi torque-users,

I want to use prepard statements with an oracle database.
When executing a doPSSelect query
 
        Criteria crit = new Criteria();
        recordList = UsersPeer.doPSSelect(crit);
        list = new UsersList((List)UsersPeer.populateObjects(recordList));

I get the following exception:

+------------------
| | Nested Exception: org.apache.torque.TorqueException
| | Message: java.sql.SQLException: ORA-00936: missing expression

| | Stack trace:
org.apache.torque.TorqueException: java.sql.SQLException: ORA-00936: 
missing expression

                 at 
org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236)
                 at 
org.apache.torque.util.BasePeer.doPSSelect(BasePeer.java:2208)


Using the doSelect-Method

        list = UsersPeer.doSelect(crit);

works fine.

Is there a bug in torque or is there something wrong in my code ?

My second question is, how I can insert or update records using prepared 
statements. I was looking for a method
like doPSInsert or doPSUpdate but there aren't such methods.

I still saw those threads where the problems with Oracle and prepared 
statements are described. Does anyone used
prepared statements with an Oracle database successfully ? 

Thanks a lot,
Arndt

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org