I'm trying to create a simple EJB application. I'm using Oracle 8i, JBoss 4.0.0 (and 3.2.5 without any difference), Eclipse 3.0 (WinXP) and JBossIDE 1.3.0.
I wrote a simple entity bean for an existing table, created and deployed the datasource MyDS file in JBoss. I used Standard EJB for XDoclet, with jboss tag (Version=4.0 / 3.2, datasource=java:/WiS2DS, datasourceMapping=Oracle8). /** * @ejb.bean name="PLZ_Basisdaten" * display-name="PLZ_Basisdaten" * description="Entitybean for table PLZ_BASISDATEN" * jndi-name="ejb/PLZ_Basisdaten" * type="CMP" * cmp-version="2.x" * view-type="both" * primkey-field = "id_Plz_Basisdaten" * * @ejb.persistence table-name="PLZ_BASISDATEN" * * @jboss.persistence table-name = "PLZ_BASISDATEN" * @ejb.util generate = "physical" */ public abstract class PLZ_BasisdatenBean implements EntityBean { ... /** * @ejb.interface-method view-type = "both" * @ejb.persistent-field * @ejb.persistence column-name = "ID_PLZ_BASISDATEN" * @ejb.pk-field * * @return */ public abstract Integer getId_Plz_Basisdaten(); /** * @ejb.interface-method view-type = "both" * * @param name */ public abstract void setId_Plz_Basisdaten(Integer id); /** * @ejb.interface-method view-type = "both" * @ejb.persistent-field * @ejb.persistence column-name = "BEZEICHNUNG" * * @return */ public abstract String getBezeichnung(); ... DataSource: <local-tx-datasource> <jndi-name>WiS2DS</jndi-name> <connection-url>jdbc:oracle:thin:@192.168.1.66:1521:lotto</connection-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> <user-name>xxxx</user-name> xxxx <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> <type-mapping>Oracle9i</type-mapping> </local-tx-datasource> I can deploy the jar without a problem. But when I call the finder method from a client or a session bean I get the following exception. 13:31:48,078 DEBUG [PLZ_Basisdaten#findByPrimaryKey] Executing SQL: SELECT t0_PLZ_Basisdaten.id_Plz_Basisdaten FROM PLZ_BASISDATEN t0_PLZ_Basisdaten WHERE t0_PLZ_Basisdaten.id_Plz_Basisdaten=? 13:31:48,078 INFO [STDOUT] javax.ejb.ObjectNotFoundException: No such entity! 13:31:48,078 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntityCommand.execute(JDBCFindEntityCommand.java:50) 13:31:48,078 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntity(JDBCStoreManager.java:589) 13:31:48,078 INFO [STDOUT] at org.jboss.ejb.plugins.CMPPersistenceManager.findEntity(CMPPersistenceManager.java:300) 13:31:48,078 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntity(CachedConnectionInterceptor.java:298) 13:31:48,078 INFO [STDOUT] at org.jboss.ejb.EntityContainer.findSingleObject(EntityContainer.java:1086) 13:31:48,078 INFO [STDOUT] at org.jboss.ejb.EntityContainer.findLocal(EntityContainer.java:663) The SQL statement is running in SQL*Plus, so it can't be a database problem. Does anyone know something about this problem? Regards, Michael View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3849417#3849417 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3849417 ------------------------------------------------------- This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Project Admins to receive an Apple iPod Mini FREE for your judgement on who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user