Just use an empty Criteria object.

SomePeer.doSelect (new Criteria())


-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 06, 2002 3:51 PM
To: Jakarta-Turbine
Subject: select * from ...

How do i accomplish a simple select * from sometable without specifing every
selectColumn.

Example:

Criteria criteria = new Criteria();
criteria.addJoin(TbOrtPeer.OLP_ID, TbOrtLookupPeer.OLP_ID);
criteria.add(this.getPeer().ORT_ID, iOrt_ID);
List v = this.getPeer().doSelect(criteria);

i'll get an exception "Syxntaxerror in SQL-Statement"

It looks like the statement misses the * as a wildcard for all columns.

If i try add criteria.addSelectColumn("*");

I get an exception "Malformed column name in Criteria select: '*' is not of
the form 'table.column'"

What's wrong?
How can i do it right?

Thanx for your help
Dieter




--
To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to