Find By Primary Key Query

[richardzheng]

I got an error like this:[org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.User#findByPrimaryKey] Executing SQL: SELECT t0_User.OID FROM USER t0_User WHERE t0_User.OID=? when I tried to retrieve a record by primary key.

It is fine to insert a record.

The envieronment is Jboss 4.0.1 and Oracle 8i.

Thanks in advance

Richard

[websel]

Think you need to post more information about your code.
There is nothing to tell only about the error.
Post your Xdoclet tag that was used for your finder.

My gues is that u probaly used plain SQL for your finder instead of QL :-)


Wessel de Roode

[spoonman464]

Did you write code for this query? It's my understanding that you never have to write any SQL or EJB-QL for either findAll() or findByPrimaryKey() If you have written some SQL or EJB-QL, maybe you are making problems for yourself.

public ComponentIntf findByPrimaryKey(primaryKeyDataType pk) throws RemoteException, FinderException;

in the Home interface should be enough to make it work. At least I've never done anything more than that and mine work all the time.

Spoon