[JBoss-dev] [ jboss-Bugs-577512 ] JBossCMP - Wrong table mapping
Bugs item #577512, was opened at 2002-07-04 13:07 You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=577512group_id=22866 Category: JBossCMP Group: v3.0 Rabbit Hole Status: Closed Resolution: Invalid Priority: 5 Submitted By: Udo Klinkmüller (ukkm) Assigned to: Dain Sundstrom (dsundstrom) Summary: JBossCMP - Wrong table mapping Initial Comment: My environment: - Linux (SuSe 7.3) - JDK 1.4 - JBoss 3.0 (CMP) I'm working with JBoss 3.0. My small project is based on CMP and I could successfully deploy it. Now in the test I get an error in the findByPrimaryKey method which looks a little strange for me. 2002-07-03 20:33:05,275 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKey Query.UserEJB.findByPrimaryKey] Executing SQL: SELECT userId FROM userejb WHERE userId=? 2002-07-03 20:33:05,430 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKey Query.UserEJB.findByPrimaryKey] Find failed java.sql.SQLException: ERROR: Relation 'userejb' does not exist at org.postgresql.Connection.ExecSQL (Connection.java:533) at org.postgresql.jdbc2.Statement.execute (Statement.java:294) at org.postgresql.jdbc2.Statement.executeQuery (Statement.java:59) at org.postgresql.jdbc2.PreparedStatement.executeQuery (PreparedStatement.java:108) at org.jboss.resource.adapter.jdbc.local.LocalPreparedStat ement.executeQuery(LocalPreparedStatement.java:289) The problem what I can recognize is that the generated SELECT statement uses the wrong table name 'userejb'. In the jbosscmp-jdbc.xml file I have specified the right table name: entity ejb-nameUserEJB/ejb-name table-namet_users/table-name . . . /entity Here are the two lines from the server log saying something about the jbosscmp-jdbc.xml file 2002-07-03 20:32:37,776 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.Cus tomerEJB] Loading standardjbosscmp-jdbc.xml : file:/opt/jboss-3.0.0_tomcat- 4.0.3/server/default/conf/standardjbosscmp-jdbc.xml 2002-07-03 20:32:38,227 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.Cus tomerEJB] jar:njar:file:/opt/jboss-3.0.0_tomcat- 4.0.3/server/default/tmp/deploy/server/default/deploy/CoC oEJB.ear/79.CoCoEJB.ear^/CoCoEJB.jar!/META- INF/jbosscmp-jdbc.xml found. Overriding defaults And here a snip of the content from my jar file. META-INF/ META-INF/MANIFEST.MF META-INF/ejb-jar.xml META-INF/jboss.xml META-INF/jbosscmp-jdbc.xml coco/ coco/base/ coco/base/CocoAppException.class coco/base/CocoSysException.class ... Because the projecte has more an educational character I attach the complete project sources. The attached jar file does not contain following necessary libraries: - xercesImpl.jar - log4j-1.2.3.jar - avalon-framework-4.1.2.jar - avalon-excalibur-4.1.jar The test client is coco.ejb.test.CustomerServiceTest.java -- Comment By: Dain Sundstrom (dsundstrom) Date: 2002-09-26 15:37 Message: Logged In: YES user_id=251431 No responce, so closing. -- Comment By: Dain Sundstrom (dsundstrom) Date: 2002-09-02 13:25 Message: Logged In: YES user_id=251431 I'm sorry but I am unable to build your code as I don't use JDK 1.4. Also can you trim the code down to only what is failing for you. -- Comment By: Udo Klinkmüller (ukkm) Date: 2002-07-25 05:54 Message: Logged In: YES user_id=573151 Sorry for my impatience. Is there already a resolution or does exist at least a workaround for this problem ? Best Regards Udo -- Comment By: Udo Klinkmüller (ukkm) Date: 2002-07-25 05:52 Message: Logged In: YES user_id=573151 Sorry for my impatience. Is there already a resolution or does exist at least a workaround for this problem ? Best Regards Udo -- Comment By: Dain Sundstrom (dsundstrom) Date: 2002-07-04 13:27 Message: Logged In: YES user_id=251431 This is the one with the example code. I'll delete the other one. -- Comment By: Dain Sundstrom (dsundstrom) Date: 2002-07-04 13:26 Message: Logged In: YES user_id=251431 This is a duplicate of [ 577508 ] JBossCMP - Wrong table mapping. -- You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=577512group_id=22866 --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
[JBoss-dev] [ jboss-Bugs-577512 ] JBossCMP - Wrong table mapping
Bugs item #577512, was opened at 2002-07-04 13:07 You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=577512group_id=22866 Category: JBossCMP Group: v3.0 Rabbit Hole Status: Open Resolution: Postponed Priority: 5 Submitted By: Udo Klinkmüller (ukkm) Assigned to: Dain Sundstrom (dsundstrom) Summary: JBossCMP - Wrong table mapping Initial Comment: My environment: - Linux (SuSe 7.3) - JDK 1.4 - JBoss 3.0 (CMP) I'm working with JBoss 3.0. My small project is based on CMP and I could successfully deploy it. Now in the test I get an error in the findByPrimaryKey method which looks a little strange for me. 2002-07-03 20:33:05,275 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKey Query.UserEJB.findByPrimaryKey] Executing SQL: SELECT userId FROM userejb WHERE userId=? 2002-07-03 20:33:05,430 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKey Query.UserEJB.findByPrimaryKey] Find failed java.sql.SQLException: ERROR: Relation 'userejb' does not exist at org.postgresql.Connection.ExecSQL (Connection.java:533) at org.postgresql.jdbc2.Statement.execute (Statement.java:294) at org.postgresql.jdbc2.Statement.executeQuery (Statement.java:59) at org.postgresql.jdbc2.PreparedStatement.executeQuery (PreparedStatement.java:108) at org.jboss.resource.adapter.jdbc.local.LocalPreparedStat ement.executeQuery(LocalPreparedStatement.java:289) The problem what I can recognize is that the generated SELECT statement uses the wrong table name 'userejb'. In the jbosscmp-jdbc.xml file I have specified the right table name: entity ejb-nameUserEJB/ejb-name table-namet_users/table-name . . . /entity Here are the two lines from the server log saying something about the jbosscmp-jdbc.xml file 2002-07-03 20:32:37,776 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.Cus tomerEJB] Loading standardjbosscmp-jdbc.xml : file:/opt/jboss-3.0.0_tomcat- 4.0.3/server/default/conf/standardjbosscmp-jdbc.xml 2002-07-03 20:32:38,227 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.Cus tomerEJB] jar:njar:file:/opt/jboss-3.0.0_tomcat- 4.0.3/server/default/tmp/deploy/server/default/deploy/CoC oEJB.ear/79.CoCoEJB.ear^/CoCoEJB.jar!/META- INF/jbosscmp-jdbc.xml found. Overriding defaults And here a snip of the content from my jar file. META-INF/ META-INF/MANIFEST.MF META-INF/ejb-jar.xml META-INF/jboss.xml META-INF/jbosscmp-jdbc.xml coco/ coco/base/ coco/base/CocoAppException.class coco/base/CocoSysException.class ... Because the projecte has more an educational character I attach the complete project sources. The attached jar file does not contain following necessary libraries: - xercesImpl.jar - log4j-1.2.3.jar - avalon-framework-4.1.2.jar - avalon-excalibur-4.1.jar The test client is coco.ejb.test.CustomerServiceTest.java -- Comment By: Dain Sundstrom (dsundstrom) Date: 2002-09-02 13:25 Message: Logged In: YES user_id=251431 I'm sorry but I am unable to build your code as I don't use JDK 1.4. Also can you trim the code down to only what is failing for you. -- Comment By: Udo Klinkmüller (ukkm) Date: 2002-07-25 05:54 Message: Logged In: YES user_id=573151 Sorry for my impatience. Is there already a resolution or does exist at least a workaround for this problem ? Best Regards Udo -- Comment By: Udo Klinkmüller (ukkm) Date: 2002-07-25 05:52 Message: Logged In: YES user_id=573151 Sorry for my impatience. Is there already a resolution or does exist at least a workaround for this problem ? Best Regards Udo -- Comment By: Dain Sundstrom (dsundstrom) Date: 2002-07-04 13:27 Message: Logged In: YES user_id=251431 This is the one with the example code. I'll delete the other one. -- Comment By: Dain Sundstrom (dsundstrom) Date: 2002-07-04 13:26 Message: Logged In: YES user_id=251431 This is a duplicate of [ 577508 ] JBossCMP - Wrong table mapping. -- You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=577512group_id=22866 --- This sf.net email is sponsored by: OSDN - Tired of that same old cell phone? Get a new here for FREE! https://www.inphonic.com/r.asp?r=sourceforge1refcode1=vs3390 ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
[JBoss-dev] [ jboss-Bugs-577512 ] JBossCMP - Wrong table mapping
Bugs item #577512, was opened at 2002-07-04 20:07 You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=577512group_id=22866 Category: JBossCMP Group: v3.0 Rabbit Hole Status: Open Resolution: Accepted Priority: 7 Submitted By: Udo Klinkmüller (ukkm) Assigned to: Dain Sundstrom (dsundstrom) Summary: JBossCMP - Wrong table mapping Initial Comment: My environment: - Linux (SuSe 7.3) - JDK 1.4 - JBoss 3.0 (CMP) I'm working with JBoss 3.0. My small project is based on CMP and I could successfully deploy it. Now in the test I get an error in the findByPrimaryKey method which looks a little strange for me. 2002-07-03 20:33:05,275 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKey Query.UserEJB.findByPrimaryKey] Executing SQL: SELECT userId FROM userejb WHERE userId=? 2002-07-03 20:33:05,430 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKey Query.UserEJB.findByPrimaryKey] Find failed java.sql.SQLException: ERROR: Relation 'userejb' does not exist at org.postgresql.Connection.ExecSQL (Connection.java:533) at org.postgresql.jdbc2.Statement.execute (Statement.java:294) at org.postgresql.jdbc2.Statement.executeQuery (Statement.java:59) at org.postgresql.jdbc2.PreparedStatement.executeQuery (PreparedStatement.java:108) at org.jboss.resource.adapter.jdbc.local.LocalPreparedStat ement.executeQuery(LocalPreparedStatement.java:289) The problem what I can recognize is that the generated SELECT statement uses the wrong table name 'userejb'. In the jbosscmp-jdbc.xml file I have specified the right table name: entity ejb-nameUserEJB/ejb-name table-namet_users/table-name . . . /entity Here are the two lines from the server log saying something about the jbosscmp-jdbc.xml file 2002-07-03 20:32:37,776 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.Cus tomerEJB] Loading standardjbosscmp-jdbc.xml : file:/opt/jboss-3.0.0_tomcat- 4.0.3/server/default/conf/standardjbosscmp-jdbc.xml 2002-07-03 20:32:38,227 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.Cus tomerEJB] jar:njar:file:/opt/jboss-3.0.0_tomcat- 4.0.3/server/default/tmp/deploy/server/default/deploy/CoC oEJB.ear/79.CoCoEJB.ear^/CoCoEJB.jar!/META- INF/jbosscmp-jdbc.xml found. Overriding defaults And here a snip of the content from my jar file. META-INF/ META-INF/MANIFEST.MF META-INF/ejb-jar.xml META-INF/jboss.xml META-INF/jbosscmp-jdbc.xml coco/ coco/base/ coco/base/CocoAppException.class coco/base/CocoSysException.class ... Because the projecte has more an educational character I attach the complete project sources. The attached jar file does not contain following necessary libraries: - xercesImpl.jar - log4j-1.2.3.jar - avalon-framework-4.1.2.jar - avalon-excalibur-4.1.jar The test client is coco.ejb.test.CustomerServiceTest.java -- Comment By: Udo Klinkmüller (ukkm) Date: 2002-07-25 12:54 Message: Logged In: YES user_id=573151 Sorry for my impatience. Is there already a resolution or does exist at least a workaround for this problem ? Best Regards Udo -- Comment By: Udo Klinkmüller (ukkm) Date: 2002-07-25 12:52 Message: Logged In: YES user_id=573151 Sorry for my impatience. Is there already a resolution or does exist at least a workaround for this problem ? Best Regards Udo -- Comment By: Dain Sundstrom (dsundstrom) Date: 2002-07-04 20:27 Message: Logged In: YES user_id=251431 This is the one with the example code. I'll delete the other one. -- Comment By: Dain Sundstrom (dsundstrom) Date: 2002-07-04 20:26 Message: Logged In: YES user_id=251431 This is a duplicate of [ 577508 ] JBossCMP - Wrong table mapping. -- You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=577512group_id=22866 --- This sf.net email is sponsored by: Jabber - The world's fastest growing real-time communications platform! Don't just IM. Build it in! http://www.jabber.com/osdn/xim ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
[JBoss-dev] [ jboss-Bugs-577512 ] JBossCMP - Wrong table mapping
Bugs item #577512, was opened at 2002-07-04 20:07 You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=577512group_id=22866 Category: JBossCMP Group: v3.0 Rabbit Hole Status: Open Resolution: Accepted Priority: 7 Submitted By: Udo Klinkmüller (ukkm) Assigned to: Dain Sundstrom (dsundstrom) Summary: JBossCMP - Wrong table mapping Initial Comment: My environment: - Linux (SuSe 7.3) - JDK 1.4 - JBoss 3.0 (CMP) I'm working with JBoss 3.0. My small project is based on CMP and I could successfully deploy it. Now in the test I get an error in the findByPrimaryKey method which looks a little strange for me. 2002-07-03 20:33:05,275 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKey Query.UserEJB.findByPrimaryKey] Executing SQL: SELECT userId FROM userejb WHERE userId=? 2002-07-03 20:33:05,430 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKey Query.UserEJB.findByPrimaryKey] Find failed java.sql.SQLException: ERROR: Relation 'userejb' does not exist at org.postgresql.Connection.ExecSQL (Connection.java:533) at org.postgresql.jdbc2.Statement.execute (Statement.java:294) at org.postgresql.jdbc2.Statement.executeQuery (Statement.java:59) at org.postgresql.jdbc2.PreparedStatement.executeQuery (PreparedStatement.java:108) at org.jboss.resource.adapter.jdbc.local.LocalPreparedStat ement.executeQuery(LocalPreparedStatement.java:289) The problem what I can recognize is that the generated SELECT statement uses the wrong table name 'userejb'. In the jbosscmp-jdbc.xml file I have specified the right table name: entity ejb-nameUserEJB/ejb-name table-namet_users/table-name . . . /entity Here are the two lines from the server log saying something about the jbosscmp-jdbc.xml file 2002-07-03 20:32:37,776 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.Cus tomerEJB] Loading standardjbosscmp-jdbc.xml : file:/opt/jboss-3.0.0_tomcat- 4.0.3/server/default/conf/standardjbosscmp-jdbc.xml 2002-07-03 20:32:38,227 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.Cus tomerEJB] jar:njar:file:/opt/jboss-3.0.0_tomcat- 4.0.3/server/default/tmp/deploy/server/default/deploy/CoC oEJB.ear/79.CoCoEJB.ear^/CoCoEJB.jar!/META- INF/jbosscmp-jdbc.xml found. Overriding defaults And here a snip of the content from my jar file. META-INF/ META-INF/MANIFEST.MF META-INF/ejb-jar.xml META-INF/jboss.xml META-INF/jbosscmp-jdbc.xml coco/ coco/base/ coco/base/CocoAppException.class coco/base/CocoSysException.class ... Because the projecte has more an educational character I attach the complete project sources. The attached jar file does not contain following necessary libraries: - xercesImpl.jar - log4j-1.2.3.jar - avalon-framework-4.1.2.jar - avalon-excalibur-4.1.jar The test client is coco.ejb.test.CustomerServiceTest.java -- Comment By: Udo Klinkmüller (ukkm) Date: 2002-07-25 12:52 Message: Logged In: YES user_id=573151 Sorry for my impatience. Is there already a resolution or does exist at least a workaround for this problem ? Best Regards Udo -- Comment By: Dain Sundstrom (dsundstrom) Date: 2002-07-04 20:27 Message: Logged In: YES user_id=251431 This is the one with the example code. I'll delete the other one. -- Comment By: Dain Sundstrom (dsundstrom) Date: 2002-07-04 20:26 Message: Logged In: YES user_id=251431 This is a duplicate of [ 577508 ] JBossCMP - Wrong table mapping. -- You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=577512group_id=22866 --- This sf.net email is sponsored by: Jabber - The world's fastest growing real-time communications platform! Don't just IM. Build it in! http://www.jabber.com/osdn/xim ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
[JBoss-dev] [ jboss-Bugs-577512 ] JBossCMP - Wrong table mapping
Bugs item #577512, was opened at 2002-07-04 20:07 You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=577512group_id=22866 Category: JBossCMP Group: v3.0 Rabbit Hole Status: Open Resolution: None Priority: 5 Submitted By: Udo Klinkmüller (ukkm) Assigned to: Nobody/Anonymous (nobody) Summary: JBossCMP - Wrong table mapping Initial Comment: My environment: - Linux (SuSe 7.3) - JDK 1.4 - JBoss 3.0 (CMP) I'm working with JBoss 3.0. My small project is based on CMP and I could successfully deploy it. Now in the test I get an error in the findByPrimaryKey method which looks a little strange for me. 2002-07-03 20:33:05,275 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKey Query.UserEJB.findByPrimaryKey] Executing SQL: SELECT userId FROM userejb WHERE userId=? 2002-07-03 20:33:05,430 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKey Query.UserEJB.findByPrimaryKey] Find failed java.sql.SQLException: ERROR: Relation 'userejb' does not exist at org.postgresql.Connection.ExecSQL (Connection.java:533) at org.postgresql.jdbc2.Statement.execute (Statement.java:294) at org.postgresql.jdbc2.Statement.executeQuery (Statement.java:59) at org.postgresql.jdbc2.PreparedStatement.executeQuery (PreparedStatement.java:108) at org.jboss.resource.adapter.jdbc.local.LocalPreparedStat ement.executeQuery(LocalPreparedStatement.java:289) The problem what I can recognize is that the generated SELECT statement uses the wrong table name 'userejb'. In the jbosscmp-jdbc.xml file I have specified the right table name: entity ejb-nameUserEJB/ejb-name table-namet_users/table-name . . . /entity Here are the two lines from the server log saying something about the jbosscmp-jdbc.xml file 2002-07-03 20:32:37,776 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.Cus tomerEJB] Loading standardjbosscmp-jdbc.xml : file:/opt/jboss-3.0.0_tomcat- 4.0.3/server/default/conf/standardjbosscmp-jdbc.xml 2002-07-03 20:32:38,227 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.Cus tomerEJB] jar:njar:file:/opt/jboss-3.0.0_tomcat- 4.0.3/server/default/tmp/deploy/server/default/deploy/CoC oEJB.ear/79.CoCoEJB.ear^/CoCoEJB.jar!/META- INF/jbosscmp-jdbc.xml found. Overriding defaults And here a snip of the content from my jar file. META-INF/ META-INF/MANIFEST.MF META-INF/ejb-jar.xml META-INF/jboss.xml META-INF/jbosscmp-jdbc.xml coco/ coco/base/ coco/base/CocoAppException.class coco/base/CocoSysException.class ... Because the projecte has more an educational character I attach the complete project sources. The attached jar file does not contain following necessary libraries: - xercesImpl.jar - log4j-1.2.3.jar - avalon-framework-4.1.2.jar - avalon-excalibur-4.1.jar The test client is coco.ejb.test.CustomerServiceTest.java -- You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=577512group_id=22866 --- This sf.net email is sponsored by:ThinkGeek Caffeinated soap. No kidding. http://thinkgeek.com/sf ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
[JBoss-dev] [ jboss-Bugs-577512 ] JBossCMP - Wrong table mapping
Bugs item #577512, was opened at 2002-07-04 13:07 You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=577512group_id=22866 Category: JBossCMP Group: v3.0 Rabbit Hole Status: Deleted Resolution: Duplicate Priority: 5 Submitted By: Udo Klinkmüller (ukkm) Assigned to: Dain Sundstrom (dsundstrom) Summary: JBossCMP - Wrong table mapping Initial Comment: My environment: - Linux (SuSe 7.3) - JDK 1.4 - JBoss 3.0 (CMP) I'm working with JBoss 3.0. My small project is based on CMP and I could successfully deploy it. Now in the test I get an error in the findByPrimaryKey method which looks a little strange for me. 2002-07-03 20:33:05,275 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKey Query.UserEJB.findByPrimaryKey] Executing SQL: SELECT userId FROM userejb WHERE userId=? 2002-07-03 20:33:05,430 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKey Query.UserEJB.findByPrimaryKey] Find failed java.sql.SQLException: ERROR: Relation 'userejb' does not exist at org.postgresql.Connection.ExecSQL (Connection.java:533) at org.postgresql.jdbc2.Statement.execute (Statement.java:294) at org.postgresql.jdbc2.Statement.executeQuery (Statement.java:59) at org.postgresql.jdbc2.PreparedStatement.executeQuery (PreparedStatement.java:108) at org.jboss.resource.adapter.jdbc.local.LocalPreparedStat ement.executeQuery(LocalPreparedStatement.java:289) The problem what I can recognize is that the generated SELECT statement uses the wrong table name 'userejb'. In the jbosscmp-jdbc.xml file I have specified the right table name: entity ejb-nameUserEJB/ejb-name table-namet_users/table-name . . . /entity Here are the two lines from the server log saying something about the jbosscmp-jdbc.xml file 2002-07-03 20:32:37,776 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.Cus tomerEJB] Loading standardjbosscmp-jdbc.xml : file:/opt/jboss-3.0.0_tomcat- 4.0.3/server/default/conf/standardjbosscmp-jdbc.xml 2002-07-03 20:32:38,227 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.Cus tomerEJB] jar:njar:file:/opt/jboss-3.0.0_tomcat- 4.0.3/server/default/tmp/deploy/server/default/deploy/CoC oEJB.ear/79.CoCoEJB.ear^/CoCoEJB.jar!/META- INF/jbosscmp-jdbc.xml found. Overriding defaults And here a snip of the content from my jar file. META-INF/ META-INF/MANIFEST.MF META-INF/ejb-jar.xml META-INF/jboss.xml META-INF/jbosscmp-jdbc.xml coco/ coco/base/ coco/base/CocoAppException.class coco/base/CocoSysException.class ... Because the projecte has more an educational character I attach the complete project sources. The attached jar file does not contain following necessary libraries: - xercesImpl.jar - log4j-1.2.3.jar - avalon-framework-4.1.2.jar - avalon-excalibur-4.1.jar The test client is coco.ejb.test.CustomerServiceTest.java -- Comment By: Dain Sundstrom (dsundstrom) Date: 2002-07-04 13:26 Message: Logged In: YES user_id=251431 This is a duplicate of [ 577508 ] JBossCMP - Wrong table mapping. -- You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=577512group_id=22866 --- This sf.net email is sponsored by:ThinkGeek Caffeinated soap. No kidding. http://thinkgeek.com/sf ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
[JBoss-dev] [ jboss-Bugs-577512 ] JBossCMP - Wrong table mapping
Bugs item #577512, was opened at 2002-07-04 13:07 You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=577512group_id=22866 Category: JBossCMP Group: v3.0 Rabbit Hole Status: Open Resolution: Accepted Priority: 5 Submitted By: Udo Klinkmüller (ukkm) Assigned to: Dain Sundstrom (dsundstrom) Summary: JBossCMP - Wrong table mapping Initial Comment: My environment: - Linux (SuSe 7.3) - JDK 1.4 - JBoss 3.0 (CMP) I'm working with JBoss 3.0. My small project is based on CMP and I could successfully deploy it. Now in the test I get an error in the findByPrimaryKey method which looks a little strange for me. 2002-07-03 20:33:05,275 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKey Query.UserEJB.findByPrimaryKey] Executing SQL: SELECT userId FROM userejb WHERE userId=? 2002-07-03 20:33:05,430 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKey Query.UserEJB.findByPrimaryKey] Find failed java.sql.SQLException: ERROR: Relation 'userejb' does not exist at org.postgresql.Connection.ExecSQL (Connection.java:533) at org.postgresql.jdbc2.Statement.execute (Statement.java:294) at org.postgresql.jdbc2.Statement.executeQuery (Statement.java:59) at org.postgresql.jdbc2.PreparedStatement.executeQuery (PreparedStatement.java:108) at org.jboss.resource.adapter.jdbc.local.LocalPreparedStat ement.executeQuery(LocalPreparedStatement.java:289) The problem what I can recognize is that the generated SELECT statement uses the wrong table name 'userejb'. In the jbosscmp-jdbc.xml file I have specified the right table name: entity ejb-nameUserEJB/ejb-name table-namet_users/table-name . . . /entity Here are the two lines from the server log saying something about the jbosscmp-jdbc.xml file 2002-07-03 20:32:37,776 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.Cus tomerEJB] Loading standardjbosscmp-jdbc.xml : file:/opt/jboss-3.0.0_tomcat- 4.0.3/server/default/conf/standardjbosscmp-jdbc.xml 2002-07-03 20:32:38,227 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.Cus tomerEJB] jar:njar:file:/opt/jboss-3.0.0_tomcat- 4.0.3/server/default/tmp/deploy/server/default/deploy/CoC oEJB.ear/79.CoCoEJB.ear^/CoCoEJB.jar!/META- INF/jbosscmp-jdbc.xml found. Overriding defaults And here a snip of the content from my jar file. META-INF/ META-INF/MANIFEST.MF META-INF/ejb-jar.xml META-INF/jboss.xml META-INF/jbosscmp-jdbc.xml coco/ coco/base/ coco/base/CocoAppException.class coco/base/CocoSysException.class ... Because the projecte has more an educational character I attach the complete project sources. The attached jar file does not contain following necessary libraries: - xercesImpl.jar - log4j-1.2.3.jar - avalon-framework-4.1.2.jar - avalon-excalibur-4.1.jar The test client is coco.ejb.test.CustomerServiceTest.java -- Comment By: Dain Sundstrom (dsundstrom) Date: 2002-07-04 13:27 Message: Logged In: YES user_id=251431 This is the one with the example code. I'll delete the other one. -- Comment By: Dain Sundstrom (dsundstrom) Date: 2002-07-04 13:26 Message: Logged In: YES user_id=251431 This is a duplicate of [ 577508 ] JBossCMP - Wrong table mapping. -- You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=577512group_id=22866 --- This sf.net email is sponsored by:ThinkGeek Caffeinated soap. No kidding. http://thinkgeek.com/sf ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development