Hello all
I use JbOss 4.0.2 & PostgreSQL 8
I have create simple entity bean and I want use key generator (simple
autoincrement)
this is ejb-jar.xml
<ejb-name>PersonEJB</ejb-name>
amc.ejb.cmp.PersonHome
amc.ejb.cmp.Person
<local-home>amc.ejb.cmp.LocalPersonHome</local-home>
amc.ejb.cmp.LocalPerson
<ejb-class>amc.ejb.cmp.PersonBean</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>java.lang.Long</prim-key-class>
False
<cmp-version>2.x</cmp-version>
<abstract-schema-name>PersonEJB</abstract-schema-name>
<cmp-field>
<field-name>personid</field-name>
</cmp-field> - KEY FIELD
<cmp-field>
<field-name>status</field-name>
</cmp-field>
<cmp-field>
<field-name>docid</field-name>
</cmp-field>
<primkey-field>personid</primkey-field>
I have tried different ways for fix this problem in jboss-jdbc.xml
first try
<ejb-name>PersonEJB</ejb-name>
<table-name>tbl_persons</table-name>
<cmp-field>
<field-name>docid</field-name>
<column-name>DOCID</column-name>
</cmp-field>
<cmp-field>
<field-name>status</field-name>
<column-name>STATUS</column-name>
</cmp-field>
<cmp-field>
<field-name>personid</field-name>
<column-name>PERSON_ID</column-name>
<auto-increment/>
</cmp-field>
<entity-command name="postgresql-fetch-seq"/>
second
<ejb-name>PersonEJB</ejb-name>
<table-name>tbl_persons</table-name>
<cmp-field>
<field-name>docid</field-name>
<column-name>DOCID</column-name>
</cmp-field>
<cmp-field>
<field-name>status</field-name>
<column-name>STATUS</column-name>
</cmp-field>
<unknown-pk>
<unknown-pk-class>java.lang.Long</unknown-pk-class>
<field-name>personid</field-name>
<column-name>PERSON_ID</column-name>
<jdbc-type>LONG</jdbc-type>
<sql-type>BIGSERIAL</sql-type>
<auto-increment/>
</unknown-pk>
<entity-command name="postgresql-fetch-seq"/>
| public abstract class PersonBean implements EntityBean {
|
| public Long ejbCreate() throws javax.ejb.CreateException{
|
| return null;
| }
|
But that I get, when call create() method
Could not create entity:java.sql.SQLException: ERROR: null value in column
"person_id" violates not-null constraint
What I do wrong?
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3889080#3889080
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3889080
-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
