Hi, I tried to use the JAWS feature of auto generating the PRIMARY KEY constraint. In standardjaws.xml I put <pk-constraint>true</pk-constraint> in the <default-entity> tag.
In my special case the PK consists of 3 fields (dienstName, email, sendeDatum). On deploy the following apears in the log: [2001-10-23 16:01:43,037] (JAWS) Initializing JAWS plugin for SendeProtokoll [2001-10-23 16:01:43,200] (JAWS) Loading standardjaws.xml :file:/local/appserver/JBoss-2.4.3_Tomcat-3.2.3/jboss/conf/tomcat/standardjaws.xml [2001-10-23 16:01:43,288] (JAWS) Init SQL: CREATE TABLE SendeProtokoll (email TEXT,dokumentName TEXT,reply TEXT,dienstName TEXT,sendeDatum TIMESTAMP) [2001-10-23 16:01:43,312] (JAWS) Destroy SQL: DROP TABLE SendeProtokoll [2001-10-23 16:01:43,332] (JAWS) Exists SQL: SELECT COUNT(*) FROM SendeProtokoll WHERE dienstName=? AND email=? AND sendeDatum=? [2001-10-23 16:01:43,342] (JAWS) AutoGenerated finders - Home=interface de.dpa.ejb.entity.SendeProtokollHome -- LocalHome=null [2001-10-23 16:01:43,343] (JAWS) Save AutoGenerated findByDienstName public abstract java.util.Collection de.dpa.ejb.entity.SendeProtokollHome.findByDienstName(java.lang.String) throws java.rmi.Rem [2001-10-23 16:01:43,361] (Container factory) Finder:dienstname [2001-10-23 16:01:43,362] (JAWS) findByDienstName SQL: SELECT dienstName,email,sendeDatum FROM SendeProtokoll WHERE dienstName=? [2001-10-23 16:01:43,362] (JAWS) Save AutoGenerated findByEmail public abstract java.util.Collection de.dpa.ejb.entity.SendeProtokollHome.findByEmail(java.lang.String) throws java.rmi.RemoteExcepti [2001-10-23 16:01:43,362] (Container factory) Finder:email [2001-10-23 16:01:43,363] (JAWS) findByEmail SQL: SELECT dienstName,email,sendeDatum FROM SendeProtokoll WHERE email=? [2001-10-23 16:01:43,375] (JAWS) Create SQL: INSERT INTO SendeProtokoll (email,dokumentName,reply,dienstName,sendeDatum) VALUES (?,?,?,?,?) [2001-10-23 16:01:43,381] (JAWS) Remove SQL: DELETE FROM SendeProtokoll WHERE dienstName=? AND email=? AND sendeDatum=? [2001-10-23 16:01:43,391] (JAWS) Load SQL: SELECT SendeProtokoll.dienstName,SendeProtokoll.email,SendeProtokoll.sendeDatum,SendeProtokoll.dokumentName,SendeProtokoll.reply FROM SendeProtokoll WHERE [2001-10-23 16:01:43,399] (JAWS) Load SQL: SELECT SendeProtokoll.dienstName,SendeProtokoll.email,SendeProtokoll.sendeDatum,SendeProtokoll.dokumentName,SendeProtokoll.reply FROM SendeProtokoll WHERE [2001-10-23 16:01:43,408] (JAWS) Store SQL: UPDATE SendeProtokoll SET email=?,dokumentName=?,reply=?,dienstName=?,sendeDatum=? WHERE dienstName=? AND email=? AND sendeDatum=? [2001-10-23 16:01:43,417] (DefaultDS) No transaction right now. [2001-10-23 16:01:43,418] (DefaultDS) Pool DefaultDS [1/1/50] gave out pooled object: org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl@2d8659 [2001-10-23 16:01:43,470] (DefaultDS) Pool DefaultDS [0/1/50] returned object org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl@2d8659 to the pool. [2001-10-23 16:01:43,869] (DefaultDS) Resource 'org.jboss.pool.jdbc.xa.wrapper.XAResourceImpl@7124af' enlisted for 'org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl@2d8659'. [2001-10-23 16:01:43,870] (DefaultDS) Pool DefaultDS [1/1/50] gave out pooled object: org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl@2d8659 [2001-10-23 16:01:43,871] (JAWS) Init command executing: CREATE TABLE SendeProtokoll (email TEXT,dokumentName TEXT,reply TEXT,dienstName TEXT,sendeDatum TIMESTAMP) [2001-10-23 16:01:43,935] (JAWS) Rows affected = 1 [2001-10-23 16:01:43,936] (JAWS) Table SendeProtokoll created [2001-10-23 16:01:43,951] (DefaultDS) Pool DefaultDS [0/1/50] returned object org.jboss.pool.jdbc.xa.wrapper.XAConnectionImpl@2d8659 to the pool. [2001-10-23 16:01:43,952] (JAWS) Created table 'SendeProtokoll' successfully. [2001-10-23 16:01:43,953] (JAWS) Primary key of table 'SendeProtokoll' is 'null'. I read it as if the compound key is recognized (see the finder and the remove) but for some reason the pk is lost later. Any idea? Marco _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
