Hello Matthew,

you defined two primary keys for each entity: one is unknown and the
other one is "known". You can't do it. Get rid of one of them.
To let the "known" key be generated just mark it as auto-increment.
Note, entity-command declaration is needed in both cases.

alex

Monday, August 11, 2003, 9:14:39 PM, Matthew Hanson wrote:

> Hi,

> jboss 3.2.1 CMP2.0 with integrated hsqldb and code generation by xdoclet
> 1.2b3-dev

> I am having some trouble writing a many side entity bean within CMR to my
> datasource (hsqldb).  I use xdoclet to generate much of the source and
> deployment descriptors.  I am able to create the one side, which has a
> single column, auto increment type primary key, using the following
> deployment tags (jbosscmp-jdbc.xml):

>       <entity>
>          <ejb-name>accountHolderBean</ejb-name>
>                  <datasource>java:/DefaultDS</datasource>
>                  <datasource-mapping>Hypersonic SQL</datasource-mapping>
>          <table-name>account</table-name>

>          <cmp-field>
>             <field-name>accountId</field-name>
>             <column-name>account_id</column-name>

>         </cmp-field>
>          <cmp-field>
>             <field-name>accountRoleId</field-name>
>             <column-name>account_role_id</column-name>
> .
> .
> .

>         <unknown-pk>
>                 <unknown-pk-class>java.lang.Integer</unknown-pk-class>
>                 <column-name>account_id</column-name>
>                 <jdbc-type>INTEGER</jdbc-type>
>                 <sql-type>INTEGER</sql-type>
>                 <auto-increment/>
>         </unknown-pk>
>         <entity-command name="account_id_pk"
> class="org.jboss.ejb.plugins.cmp.jdbc.hsqldb.JDBCHsqldbCreateCommand">
>         </entity-command>
> <!-- jboss 3.2 features -->
> <!-- optimistic locking does not express the exclusions needed -->
>       </entity>

> However, the following entries for the many side, using the same basic tags,
> fails to write successfully:

>       <entity>
>          <ejb-name>AccountRecipeBean</ejb-name>
>                  <datasource>java:/DefaultDS</datasource>
>                  <datasource-mapping>Hypersonic SQL</datasource-mapping>
>          <table-name>recipe</table-name>

>          <cmp-field>
>             <field-name>recipeId</field-name>
>             <column-name>recipe_id</column-name>

>         </cmp-field>
>          <cmp-field>
>             <field-name>accountId</field-name>
>             <column-name>account_id</column-name>

>         </cmp-field>
>          <cmp-field>
>             <field-name>recipeName</field-name>
>             <column-name>recipe_name</column-name>

>         </cmp-field>

>         <unknown-pk>
>                 <unknown-pk-class>java.lang.Integer</unknown-pk-class>
>                 <column-name>recipe_id</column-name>
>                 <jdbc-type>INTEGER</jdbc-type>
>                 <sql-type>INTEGER</sql-type>
>                 <auto-increment/>
>         </unknown-pk>
>         <entity-command name="recipe_id_pk"
> class="org.jboss.ejb.plugins.cmp.jdbc.hsqldb.JDBCHsqldbCreateCommand">
>         </entity-command>
> <!-- jboss 3.2 features -->
> <!-- optimistic locking does not express the exclusions needed -->
>       </entity>

> Here is the relationship definition:

>     <ejb-relation>
>       <ejb-relation-name>Account-Recipe</ejb-relation-name>

>       <ejb-relationship-role>
 
> <ejb-relationship-role-name>Account-Has-Recipes</ejb-relationship-role-name>
>           <key-fields>
>              <key-field>
>                <field-name>accountId</field-name>
>                <column-name>account_id</column-name>
>              </key-field>
>           </key-fields>

>       </ejb-relationship-role>
>       <ejb-relationship-role>
 
> <ejb-relationship-role-name>Recipe-Belongs-To-Account</ejb-relationship-role
-name>>
>                   <key-fields/>

>       </ejb-relationship-role>
>     </ejb-relation>

> The client uses an xdoclet value object for the many side, with a two-column
> primary key that includes the one-side key and a similar, auto-increment
> primary key of its own.  I have tried several combinations of the primary
> key passed into the facade to create the many side (null pk instance, actual
> pk object w/only the one-side value populated, actual pk object w/one-side
> and dummy many side key value, such as 10, populated).  In all cases, the
> following stack trace is generated (in this case, the many-side key is just
> a null Integer):

> 13:03:07,888 INFO  [STDOUT] add recipe:  {recipeId=null accountId=9
> recipeName=Pale Ale}
> 13:03:07,898 INFO  [STDOUT] in recipe bean ejbCreate for value object...
> 13:03:07,898 ERROR [AccountRecipeBean] Could not create entity
> java.sql.SQLException: Try to insert null into a non-nullable column in
> statement [INSERT INTO RECIP
> E (recipe_name) VALUES ('Pale Ale')]
>         at org.hsqldb.Trace.getError(Unknown Source)
>         at org.hsqldb.Result.<init>(Unknown Source)
>         at org.hsqldb.jdbcConnection.executeHSQL(Unknown Source)
>         at org.hsqldb.jdbcConnection.execute(Unknown Source)
>         at org.hsqldb.jdbcStatement.fetchResult(Unknown Source)
>         at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source)
>         at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source)
>         at
> org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(Wrapp
> edPreparedSta
> tement.java:308)
>         at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractVendorCreateCommand.insertEntity(
> JDBCAbstractV
> endorCreateCommand.java:118)
>         at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractVendorCreateCommand.execute(JDBCA
> bstractVendor
> CreateCommand.java:76)
>         at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManage
> r.java:569)
>         at
> org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManag
> er.java:225)
>         at
> org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntit
> y(CachedConne
> ctionInterceptor.java:270)
>         at
> org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:571)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
> )
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
> .java:25)
>         at java.lang.reflect.Method.invoke(Method.java:324)
>         at
> org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContaine
> r.java:998)
>         at
> org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.jav
> a:88)
>         at
> org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySync
> hronizationIn
> terceptor.java:188)
>         at
> org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(
> CachedConnect
> ionInterceptor.java:215)
>         at
> org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.jav
> a:88)
>         at
> org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInt
> erceptor.java
> :91)
>         at
> org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor
> .java:61)
>         at
> org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInt
> erceptor.java
> :28)
>         at
> org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor
> .java:88)
>         at
> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
> java:243)
>         at
> org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:74)
>         at
> org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.jav
> a:92)
>         at
> org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
>         at
> org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryF
> inderIntercep
> tor.java:93)
>         at
> org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:477)
>         at org.jboss.ejb.Container.invoke(Container.java:694)
>         at
> org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyF
> actory.java:2
> 72)
>         at
> org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
>         at $Proxy90.create(Unknown Source)
>         at
> homebrew.ejb.session.accountFacadeBean.addRecipes(accountFacadeBean.java:342
> )
>         at
> homebrew.ejb.session.accountFacadeBean.setAccountHolder(accountFacadeBean.ja
> va:186)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
> )
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
> .java:25)
>         at java.lang.reflect.Method.invoke(Method.java:324)
>         at
> org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.invoke(StatefulS
> essionContain
> er.java:878)
>         at
> org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:11
> 7)
>         at
> org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(Cach
> edConnectionI
> nterceptor.java:186)

> The client fills an array of many side value object, and the one side facade
> basically does this:

>         protected void addRecipes(Collection addedRecipes)
>         throws NamingException, CreateException
>         {
>                 Iterator addrIt = addedRecipes.iterator();
>                 AccountRecipeBeanLocal loc = null;
>                 System.out.println("trying to add recipe(s)...");
>                 while(addrIt.hasNext())
>                 {
>                         AccountRecipeBeanValue val =
> (AccountRecipeBeanValue) addrIt.next();
>                         System.out.println("add recipe:  " +
> val.toString());
>                         loc =
> AccountRecipeBeanUtil.getLocalHome().create(val);
>                 }
>         }

> I have looked at some of the code from jboss source, but I thought I would
> see if anyone sees any big problems with the deployment descriptor info or
> the client many-side primary key vals.

> If anyone can help me solve this problem, I would appreciate it very much.

> Regards,
> Matt Hanson


> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
> http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user



-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to