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>
content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Oracle,
 Torque and PreparedStatements - Potential Patch of Peer.vm
Date: Fri, 5 Dec 2003 18:42:16 +0100
Message-ID: <90B3A0967470D44CB8FDE74907512328F1B955@av1s008.at-work.local>
Thread-Topic: Oracle,
 Torque and PreparedStatements - Potential Patch of Peer.vm
Thread-Index: AcO7UPX0p1OjqmNOTmaUDszaWKQ6RwABdgOQ
From: =?iso-8859-1?Q?=22G=F6schl=2CSiegfried=22?= <Siegfried.Goeschl@drei.com>
To: "Apache Torque Users List" <torque-user@db.apache.org>

Hi folks,

I'm adding the second doPSSelect() with an additional Connection on =
Monday.

Cheers,

Siegfried Goeschl

-----Original Message-----
From: Martin Poeschl [mailto:mpoeschl@marmot.at]
Sent: Friday, December 05, 2003 6:05 PM
To: Apache Torque Users List
Subject: Re: Oracle, Torque and PreparedStatements - Potential Patch of
Peer.vm


please create patches using diff -u

thanx

martin

G=F6schl,Siegfried wrote:

>Hi folks,
>
>we recently had a discussion about Torque and problems with Oracle - it =
seems to have problems with ad-hoc SQL statements filling up an internal =
buffer. There is BasePeer.doPSSelect() which returns a List of Village =
Records.
>
>The following patch could return "proper" TORQUE objects. Have a look =
at it since it is a quick hack and I already had a cup of mulled wine =
... ;-) ... and will have a second one before I do more patches ... :-O
>
>Cheers,
>
>Siegfried Goeschl
>
>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>
>PEER.VM
>
>  ## ------------------------------------------------------------
>  ## Patch by Siegfried Goeschl
>  ## ------------------------------------------------------------
>
>    /**
>     * Do a Prepared Statement select according to the given criteria
>     *
>     * @param criteria
>     * @return Result as Torque generated objects and NOT Village =
Records
>     * @throws TorqueException Any exceptions caught during processing =
will be
>     *         rethrown wrapped into a TorqueException.
>     */
>    public static List doPSSelectEx(Criteria criteria) throws =
TorqueException
>    {
>     	List v =3D null;
>     	List temp =3D null;
>     =09
>    	// add the columns to the criteria
>    	$basePrefix${table.JavaName}Peer.addSelectColumns( criteria );
>    	// invoke the BasePeer to get the list of Village Records
>    	temp =3D $basePrefix${table.JavaName}Peer.doPSSelect( criteria );
>    	// convert the VillageRecords into Torque objects
>	v =3D $basePrefix${table.JavaName}Peer.populateObjects( temp );
>	return v;
>    }
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
> =20
>


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


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