Criteria anomale

[Chris McCann]

Greetings,

I am experiencing an odd issue with an extremely simple criteria usage.  For
some
odd reason, the '*' is not being added to the select statement in the
following
code fragment:

    Criteria crit = new Criteria();
    crit.add(ProductsPeer.PRODUCTNUMBER, productNumber);
    Vector v=ProductsPeer.doSelect(crit);

Torque throws an exception due to the lack of '*'.  Hypersonic gets pissed
too,
here's the proof:

    7:SELECT  FROM Products WHERE (Products.PRODUCTNUMBER='Product_1')
    java.sql.SQLException: Unexpected token: FROM
        at org.hsqldb.Trace.getError(Trace.java:180)
        at org.hsqldb.Trace.getError(Trace.java:144)
        at org.hsqldb.Trace.error(Trace.java:205)
        at org.hsqldb.Parser.readTerm(Parser.java:1295)
        at org.hsqldb.Parser.readFactor(Parser.java:1141)
        at org.hsqldb.Parser.readSum(Parser.java:1109)
        at org.hsqldb.Parser.readConcat(Parser.java:1086)
        at org.hsqldb.Parser.readCondition(Parser.java:963)
        at org.hsqldb.Parser.readAnd(Parser.java:920)
        at org.hsqldb.Parser.readOr(Parser.java:897)
        at org.hsqldb.Parser.parseExpression(Parser.java:881)
        at org.hsqldb.Parser.parseSelect(Parser.java:529)
        at org.hsqldb.Parser.processSelect(Parser.java:80)
        at org.hsqldb.Database.execute(Database.java:250)
        at org.hsqldb.ServerConnection.run(ServerConnection.java:124)
    SQLException: SQLState(37000)

This exact same code block works for a different table/peer set, which is 
extremely intriguing...

Any ideas?

Thanks in advance.

-chris

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