java.sql.SQLException: ERROR parser: parse error at or near

roysun Apr 16, 2002 6:23 PM

findAll()method got java.sql.SQLException when I use a pk class. The log message as the following.

Roy
===========

[2002-04-16 17:46:33,271,CMP,DEBUG] findAll command executing: SELECT FROM log_parameter
...

org.jboss.resource.adapter.jdbc.local.JDBCManagedConnection@bfbbe3.
[2002-04-16 17:46:33,321,CMP,DEBUG] java.sql.SQLException: ERROR: parser: parse error at or near "FROM"

1. Re: java.sql.SQLException: ERROR parser: parse error at or n

dsundstrom Apr 18, 2002 12:17 PM (in response to roysun)

You need to provide more info.

What version of JBoss?
CMP 1.1 or CMP 2.0?

Did you define a primary key?
Actions
2. Re: java.sql.SQLException: ERROR parser: parse error at or n

roysun Apr 18, 2002 2:03 PM (in response to roysun)

jboss3.0.0alpha. cmp2.0

Roy
Actions
3. Re: java.sql.SQLException: ERROR parser: parse error at or n

roysun Apr 18, 2002 2:06 PM (in response to roysun)

I defined <primkey-class>xxPK, not <primkey-field> in ejb-jar.xml.

Roy
Actions
4. Re: java.sql.SQLException: ERROR parser: parse error at or n

dsundstrom Apr 18, 2002 2:51 PM (in response to roysun)

Upgrade to JBoss3.0 RC1.
Actions

Go to original post