1:52 p.m.
Hi all,
I'm following through the OReilly's Enterprise JavaBeans 4th Edition using Jboss
4.0.5 GA (configured for J2EE1.4), with JDK 1.4.2_13 andusing the default inbuilt HSQLDB.
I have come across a strange error when trying to find the entity bean I have created:
---------------------------------
18:37:15,046 ERROR [CabinEJB#findByPrimaryKey] Find failed
java.sql.SQLException: Unexpected token: FROM in statement [SELECT FROM CABINEJB
t0_CabinEJB WHERE ]
---------------------------------
I'm guessing the CMP code should have produced SQL which reads something like this:
SELECT * FROM CABINEJB t0_CabinEJB WHERE id = ?
---------------------------------
My ejb-jar.xml looks like this:
---------------------------------
| <enterprise-beans>
| <entity>
| <ejb-name>CabinEJB</ejb-name>
| <home>org.martijnverburg.ejb.CabinHomeRemote</home>
| <remote>org.martijnverburg.ejb.CabinRemote</remote>
| <ejb-class>org.martijnverburg.ejb.CabinBean</ejb-class>
| <persistence-type>Container</persistence-type>
| <prim-key-class>java.lang.Integer</prim-key-class>
| <reentrant>False</reentrant>
| <abstract-schema-name>Cabin</abstract-schema-name>
| <cmp-field>
| <field-name>id</field-name>
| </cmp-field>
| <cmp-field>
| <field-name>name</field-name>
| </cmp-field>
| <prim-key-field>id</prim-key-field>
| <security-identity>
| <use-caller-identity />
| </security-identity>
| </entity>
| </enterprise-beans>
|
---------------------------------
My CabinHomeRemote looks like this:
---------------------------------
| package org.martijnverburg.ejb;
|
| <snip imports>
|
| public interface CabinHomeRemote extends EJBHome {
|
| public CabinRemote create(Integer id) throws CreateException, RemoteException;
|
| public CabinRemote findByPrimaryKey(Integer pk) throws FinderException,
RemoteException;
|
| }
|
---------------------------------
My CabinRemote looks like this:
---------------------------------
| package org.martijnverburg.ejb;
|
| <snip imports>
|
| public interface CabinRemote extends EJBObject {
|
| public String getName() throws RemoteException;
|
| public void setName(String name) throws RemoteException;
| }
|
---------------------------------
My CabinBean looks like this:
---------------------------------
| package org.martijnverburg.ejb;
|
| <snip imports>
|
| public abstract class CabinBean implements EntityBean {
|
| public Integer ejbCreate(Integer id) throws CreateException {
| this.setId(id);
| return null;
| }
|
| public abstract void setId(Integer id);
|
| public abstract Integer getId();
|
| public abstract void setName(String name);
|
| public abstract String getName();
|
| <snip mandatory ejbX() methods>
| }
|
---------------------------------
The calling client looks like this:
---------------------------------
| package org.martijnverburg.ejb.client;
|
| <snip imports>
|
| public class CabinBeanClient {
|
| public static void createCabin(Integer id, String name) {
| try {
|
| Context jndiContext = getInitialContext();
| Object ref = jndiContext.lookup("CabinHomeRemote");
| CabinHomeRemote home = (CabinHomeRemote)PortableRemoteObject.narrow(ref,
CabinHomeRemote.class);
|
| CabinRemote cabin1 = home.create(id);
|
| cabin1.setName(name);
|
| } catch <snip catch blocks>
| }
|
| public static String findCabinName(Integer id) {
|
| String name = null;
|
| try {
| Context jndiContext = getInitialContext();
| Object ref = jndiContext.lookup("CabinHomeRemote");
| CabinHomeRemote home = (CabinHomeRemote)PortableRemoteObject.narrow(ref,
CabinHomeRemote.class);
|
| // Find the bean
| CabinRemote cabin1 = home.findByPrimaryKey(id);
|
| // Get the attribute on that bean
| name = cabin1.getName();
| } catch <snip catch blocks>
|
| return name;
| }
|
| /**
| * Get the initial jndi context for this app server, so we can look
| * up entity beans etc.
| *
| * @return The context
| * @throws NamingException
| */
| private static Context getInitialContext() throws NamingException {
| // Calling this default constructor means that the jndi.properties gets
| // searched for and used on the classpath
| return new InitialContext();
| }
| }
|
Any ideas? :)
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4029954#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...