[jboss-jira] [JBoss JIRA] Resolved: (JBAS-919) Problem using oracle-sequence key generation

Problem using oracle-sequence key generation -------------------------------------------- Key: JBAS-919 URL: http://jira.jboss.com/jira/browse/JBAS-919 Project: JBoss Application Server Issue Type: Bug Security Level: Public(Everyone can see) Components: CMP service Affects Versions: JBossAS-3.2.6 Final Reporter: SourceForge User Assigned To: Alexey Loubyansky Fix For: No Release SourceForge Submitter: jeeads . OS client Window XP server Windows Server 2000 Database Oracle 8i JBoss 3.2.3 production release JDK Version 1.4.3 I have created some entity beans that have non nullable foreign keys and when I go to test them I find an interesting problem. To test these beans I must create or find an existing bean for the instatiation of the non nullable foreign key. No matter if I create or find the foreign key prior to creating the bean to test, when creating the bean to test the org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCOracleCreateC ommand doesn't get called? Here is the print out of the problem. All bean transactions are marked required. Error using lanehome.create to initialize the non nullable foreign key for the bases bean Initializing testBasesBean. 2004-03-26 13:04:13,281 DEBUG [org.jboss.ejb.plugins.LogInterceptor] InvokeHome: create(471582173,4]]J,32526,32526, [B@187b796,2222YYYDDD;;;NNNHHHH444tttGGG=== [[[[HHH>>>111WWW]]]]TTTppp666RRRIIII [[[QQQ===333P```222ssssUUUKKKggg]]]0000??? \\\RRR555uuuuaaaWWWtttiii<<<<222111rrr^^^TTTT [[[666===444RRRR555tttGGG===^^^^TTTAAA666IIITTT TAAA777SSSIII6666000CCC888UUULLLLMM? NkkkaaaMMMCCCpppf,-16268,- 1279147916,f999xxxKKKAAAwwwwmmm000VVVCCC8888U UULLLMMMCCCUUUULLL999222OOOEEEE111XXXOOOFFFb bbbXXXEEE;;;[[[Q4444ZZZGGGeee [[[bbbb===DDDTTTCCC::::ooofff999xxxJJJJZZZmmmcccO OOFFFFMMMrrryyy:::MMMMCCCyyyoooBBBRRRRYYY44411 1rrrYYYYOOO<<<111NNNHHHHWWWccc999EEELLLLjjjaaaL LLCCCV,-22018,1888135678,Sat Apr 17 10:33:03 CDT 2004,Sat Apr 17 11:56:25 CDT 2004,Sat Apr 17 11:56:25 CDT 2004,Sat Apr 17 11:56:25 CDT 2004,12186,12186,12186,7785,7785,7785,OOOEEEEvvvm mm666EEEbbbbXXXyyyooo [[[QQQQdddoooBBB888nnnnddd;;;111:::0000MMMCCC^^ ^UUU@@@@777JJJZZZFFF====YYYOOOWWWDDD::::LL LCCC000??? \\\\QQQ>>>555FFF====YYYOOO<<<KKKRRRR^^^QQQG GGdddooooBBBQQQnnnddd1111qqqDDDSSSppp1111NNND DDpppgggnnnn333PPP___2ssssGGGDDDPppp,222RRRIIII66 6uuu444 [[[FFFF===XXXOOO;;;KKKK^^^UUU@@@777RRRRIIIeee [[[>>>4444TTTaaa666]]] JJJJUUUhhh^^^JJJ@@@@```WWWttt999iiii```444PPP`` `3333sssIII???SSSbbbb555@@@]]]SSS???? 555222BBB___nnnnAAA7SSSS___\\\777>>>NNNN;;;111M MMCCCMMMMBBB^^^TTTAAA7777mmmcccaaa<<<C,1,- 1824321783,-1824321783,CaaaWWWttt999VVV,Fri Mar 05 02:24:17 CST 2004,Fri Mar 05 04:06:53 CST 2004,Fri Mar 05 04:06:53 CST 2004,McccoooEEE<<<<XXXccc666vvvYYYYOOOoooeee88 8HHHHddd [[[___UUUuuuu777>>>NNN;;;1111CCC:::UUUKKK8888ww wJJJ@@@===3333OOOFFF222:::1111NNNCCCVVV666SS SSIII555[[[HHH====vvv<<<XXXOOOooooeee888GGG [[[ffff888yyyddd[[[xxxxqqq;;;JJJggg]]]] DDD;;;XXXggg0000tttGGG===sssiiii<,<<ZZZPPP:::FFFFM MM]]]III@@@ [[[[RRR444ZZZGGG<<<<YYYOOOUUULLL^^^^TTTAAA66 6SSI5 [[[XXXXNNNkkk000MMMCCCC___UUU^^^TTTqqqqjjj===4 44iii````444GGG===sssjjjj<<<666SSSbbbuuuulllSSSIII666 vvvvHHHBBBUUULLL7777xxxKKUUU\\\888 [[[RRRRXXXNNNkkk000MMMMBBBUUUKKK777^^^^JJJZZZ a,null,null,null) 2004-03-26 13:04:13,281 DEBUG [com.genecodes.oracle8iseqcol.lane.LaneBean] setEntityContext 2004-03-26 13:04:13,359 DEBUG [com.genecodes.oracle8iseqcol.lane.LaneBean] ejbCreate 2004-03-26 13:04:13,375 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCOracleCreate Command.Oracle8iSeqCol_Lane] Executing SQL: {call INSERT INTO LANE (ID, LANE_TYPE, APPLICATION_CREATOR, AUTO_ANALYSIS, AUTO_PRINT, LAST_USED, NAME, LANE_NUMBER, STATUS, THUMBPRINT, PRIMER_POSITION, RAW_DATA_START_POINT, START_EP, END_EP, START_EP_ANALYSIS, END_EP_ANALYSIS, INITIAL_SCAN_START, INITIAL_SCAN_END, LAST_SCAN_START, LAST_SCAN_END, CUSTOM_SCAN_START, CUSTOM_SCAN_END, START_COMMENT, STOP_COMMENT, ADAPTIVE_WORKED, AVERAGE_SPACING, CALCULATED_SPACING, ANALYSIS_VERSION, DATE_UPLOADED, SAMPLE_CREATION, SAMPLE_MODIFICATION, COLLECTION_SIZE_STD_NAME, COLLECTION_ANALYSIS_PARMS_NAME, SAMPLE_ID, SIGNAL_PROCESS_ID, RUN_ID) VALUES (LaneSeq.NEXTVAL, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? , ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING ID INTO ? } 2004-03-26 13:04:13,515 DEBUG [com.genecodes.oracle8iseqcol.lane.LaneBean] ejbPostCreate 2004-03-26 13:04:18,671 DEBUG [org.jboss.ejb.plugins.LogInterceptor] InvokeHome: create(O? 88UUULLL777xxxx___UUUSSSxxx555,5AAA111XXXCCC:::: MMMXXX___UUUAAAA777===444GGG<<<<YYYOOOWWW DDD9999VVVMMMfff]]]0000??? \\\QQQmmmddddFFF<<<YYYiiippppKKKRRR^^^pppffff999 eeeuuuu222rrrTTT```ggggrrrEEETTTqqqggggZZZQQQ=== 333PPPP>>>444;;;FFFCCCCPPP@@@666RRRHHHH555@@ @===444OOOOFFFLLLBBB___TTTT888^^^III@@@ [[[[RRR??? NNNrrr4444TTTJJJ222rrrEEEETTTggg^^^444tttt```VVVs ssGGG>>>>QQQ```333wwwIIII@@@vvvlll555@@@@]]] lll???555UUUULLLUUUKKK777\\\\III@@@ [[[RRR5555EEEaaaWWWCCC::::UUULLL___TTTAAAAQQQ mmmdddOOOFFFFYYYaaaXXXCCC::::VVVfffmmmyyy==== 444OOOEEE222rrrrDDD;;;777^^^IIII@@@GGGQQQ>>>55 55GGG===]::::@@@LLLSSSIIIAAAA777SSSIII6660000LLL CCCKKKBBB````gggsssIIIUUU\\\\lll555DDDaaaWWWWsssiii <<<KKK^^^^nnnAAA777mmmcccc666uuu>>>NNNjjjjaaa MMMCCC000ooooIIITTTAAA777SSSSIII666000CCCNNNNU UUKKK999VVVMMMM888___EEE<<<XXXXNNN:::111bbbYY YY;;;111NNNHHHdddd [[[FFF===uuukkkk>>>MMMjjjaaaMMMMCCCooofff888www wJJJAAAvvvmmmOOOOFFF222rrrDDD;;;;CCC000ooo888yy yy555[[[222===DDDDOOOOOOFFF111XXXXEEE>>> [[[PPP4444ZZZ[[[RRRnnn4444QQQJJJ]]] TTT@@@@666SSS^^^000@@@@SSSIIIjjj```3333BB,- 391886304,Sun Mar 21 19:05:04 CST 2004,32181,32181,- 5753,1,1,Oracle8iSeqCol_Lane:Primary key: 52,null,null) 2004-03-26 13:04:18,671 DEBUG [com.genecodes.oracle8iseqcol.bases.BasesBean] setEntityContext 2004-03-26 13:04:18,687 DEBUG [com.genecodes.oracle8iseqcol.bases.BasesBean] ejbCreate 2004-03-26 13:04:18,703 INFO [org.jboss.ejb.plugins.LogInterceptor] Application Exception javax.ejb.CreateException: Primary key for created instance is null. at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createE ntity(JDBCStoreManager.java:556) Error using lanehome.findByPrimaryKey to initialize the non nullable foreign key for the bases bean Initializing testBasesBean. 2004-03-28 16:54:36,609 DEBUG [org.jboss.ejb.plugins.LogInterceptor] InvokeHome: findByPrimaryKey(Primary key: 54) 2004-03-28 16:54:36,625 DEBUG [com.genecodes.oracle8iseqcol.lane.LaneBean] setEntityContext 2004-03-28 16:54:36,640 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQue ry.Oracle8iSeqCol_Lane#findByPrimaryKey] Executing SQL: SELECT ID FROM LANE WHERE ID=? 2004-03-28 16:54:41,859 DEBUG [org.jboss.ejb.plugins.LogInterceptor] InvokeHome: create (BwnAAAPPPPWWW222FFF<<<WWWWNNN;;;,000MMM\\\ \ZZZ666<<<HHHOOOOZZZGGG<<<EEE<<<<\\\RRRooo444 QQQ\\\ooofffQQQHHHHOOO^^^111@@@TTTTJJJhhhooo eeeQQQQGGG333ttt===LLLLiii```111qqq]]]] SSSCCCSSY6<222333ZZZ===2222OOOEEE555 \\\HHHH>>>QQQ\\\III????[[[QQQAAA888KKKK@@@]]] TTTBBB^^^^TTTAAA777yyyppppCCCRRRooo000LLLLCCC oooeee8882222OOO^^^111qqqOOOOEEE222qqqDDD>>> > [[[QQQ333sssFFFFQQQXXX333:::FFFFSSSJJJfff\\\IIIIQQQ GGGdddYYY<<<<333iii___KKKAAAAHHHSSSfff]]]HHHH??? ___kkkrrrMMMMKKKAAArrriiiTTTTKKKhhhaaaQQQGGGG333s ss[[[QQQXXXX333000===]]]SSSS??? 555RRRZZZQQQQ444??? FFFVVVBBBB999UUUKKK^^^SSSS@@@555RRRHHHNNNNE EEDDDDJJJUUUrrriiiTTTTKKK^^^nnntttPPPPVVVMMM444u uu>>>>MMMjjjddd666wwwwcccYYYlll@@@7777lllccc666y yyLLLLBBBBBB8889990000777BBBIII??? <<<<222NNNDDD111<<<<CCC999KKKAAAHHHH>>> [[[PPP===3333EEE;;;WWWMMM::::JJJggg]]] PPP\\\ddd7777wwwcccYYYvvvpppp999^^^eee\\\CCCC9 99VVVeeeyyyrrrrEEE<<<qqqhhh::::EEEYYYhhh;;;1111QQ QHHH444ttt3333XXXEEE;;;WWWMMMM:::JJJ]]]RRR???? 666>>>ZZZQQQ====333___VVVsss8888UUUKKKfff]]]???? 555RRRbbbiiiuuuuKKKEEEE<<<XXXhhh:::1111QQQGGGtttjjj ====,-1037058010,Tue Mar 16 16:50:23 CST 2004,- 16346,-3142,-3142,1,1,Oracle8iSeqCol_Lane:Primary key: 54,null,null) 2004-03-28 16:54:41,859 DEBUG [com.genecodes.oracle8iseqcol.bases.BasesBean] setEntityContext 2004-03-28 16:54:41,890 DEBUG [com.genecodes.oracle8iseqcol.bases.BasesBean] ejbCreate 2004-03-28 16:54:41,906 INFO [org.jboss.ejb.plugins.LogInterceptor] Application Exception javax.ejb.CreateException: Primary key for created instance is null. at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createE ntity(JDBCStoreManager.java:556) jbosscmp-jdbc < entity> < ejb-name>Oracle8iSeqCol_Bases< /ejb-name> < pk-constraint>false< /pk-constraint> < table-name>BASES< /table-name> < cmp-field> < field-name>id< /field-name> < column-name>ID< /column-name> < auto-increment/> < /cmp-field> < cmp-field> < field-name>callerName< /field-name> < column-name>CALLER_NAME< /column-name> < /cmp-field> < cmp-field> < field-name>sequence< /field-name> < column-name>SEQUENCE< /column-name> < /cmp-field> < cmp-field> < field-name>length< /field-name> < column-name>LENGTH< /column-name> < /cmp-field> < cmp-field> < field-name>modDate< /field-name> < column-name>MOD_DATE< /column-name> < /cmp-field> < cmp-field> < field-name>clearRangeStart< /field-name> < column-name>CLEAR_RANGE_START< /column-name> < /cmp-field> < cmp-field> < field-name>clearRangeEnd< /field-name> < column-name>CLEAR_RANGE_END< /column-name> < /cmp-field> < cmp-field> < field-name>clearRangeLength< /field-name> < column-name>CLEAR_RANGE_LENGTH< /column-name> < /cmp-field> < cmp-field> < field-name>isComplemented< /field-name> < column-name>IS_COMPLEMENTED< /column-name> < /cmp-field> < cmp-field> < field-name>isCurrent< /field-name> < column-name>IS_CURRENT< /column-name> < /cmp-field> < entity-command name="oracle-sequence" class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCOracle CreateCommand"> < attribute name="sequence">BasesSeq< /attribute> < /entity-command> < /entity> < entity> < ejb-name>Oracle8iSeqCol_Lane< /ejb-name> < pk-constraint>false< /pk-constraint> < table-name>LANE< /table-name> < cmp-field> < field-name>id< /field-name> < column-name>ID< /column-name> < auto-increment/> < /cmp-field> < cmp-field> < field-name>laneType< /field-name> < column-name>LANE_TYPE< /column-name> < /cmp-field> < cmp-field> < field-name>applicationCreator< /field-name> < column-name>APPLICATION_CREATOR< /column- name> < /cmp-field> < cmp-field> < field-name>autoAnalysis< /field-name> < column-name>AUTO_ANALYSIS< /column-name> < /cmp-field> < cmp-field> < field-name>autoPrint< /field-name> < column-name>AUTO_PRINT< /column-name> < /cmp-field> < cmp-field> < field-name>lastUsed< /field-name> < column-name>LAST_USED< /column-name> < /cmp-field> < cmp-field> < field-name>name< /field-name> < column-name>NAME< /column-name> < /cmp-field> < cmp-field> < field-name>landNumber< /field-name> < column-name>LANE_NUMBER< /column-name> < /cmp-field> < cmp-field> < field-name>status< /field-name> < column-name>STATUS< /column-name> < /cmp-field> < cmp-field> < field-name>thumbprint< /field-name> < column-name>THUMBPRINT< /column-name> < /cmp-field> < cmp-field> < field-name>primerPosition< /field-name> < column-name>PRIMER_POSITION< /column-name> < /cmp-field> < cmp-field> < field-name>rawDataStartPoint< /field-name> < column-name>RAW_DATA_START_POINT< /column- name> < /cmp-field> < cmp-field> < field-name>startEp< /field-name> < column-name>START_EP< /column-name> < /cmp-field> < cmp-field> < field-name>endEp< /field-name> < column-name>END_EP< /column-name> < /cmp-field> < cmp-field> < field-name>startEpAnalysis< /field-name> < column-name>START_EP_ANALYSIS< /column-name> < /cmp-field> < cmp-field> < field-name>endEpAnalysis< /field-name> < column-name>END_EP_ANALYSIS< /column-name> < /cmp-field> < cmp-field> < field-name>initialScanStart< /field-name> < column-name>INITIAL_SCAN_START< /column-name> < /cmp-field> < cmp-field> < field-name>initialScanEnd< /field-name> < column-name>INITIAL_SCAN_END< /column-name> < /cmp-field> < cmp-field> < field-name>lastScanStart< /field-name> < column-name>LAST_SCAN_START< /column-name> < /cmp-field> < cmp-field> < field-name>lastScanEnd< /field-name> < column-name>LAST_SCAN_END< /column-name> < /cmp-field> < cmp-field> < field-name>customScanStart< /field-name> < column-name>CUSTOM_SCAN_START< /column- name> < /cmp-field> < cmp-field> < field-name>customScanEnd< /field-name> < column-name>CUSTOM_SCAN_END< /column-name> < /cmp-field> < cmp-field> < field-name>startComment< /field-name> < column-name>START_COMMENT< /column-name> < /cmp-field> < cmp-field> < field-name>stopComment< /field-name> < column-name>STOP_COMMENT< /column-name> < /cmp-field> < cmp-field> < field-name>adaptiveWorked< /field-name> < column-name>ADAPTIVE_WORKED< /column-name> < /cmp-field> < cmp-field> < field-name>averageSpacing< /field-name> < column-name>AVERAGE_SPACING< /column-name> < /cmp-field> < cmp-field> < field-name>calculatedSpacing< /field-name> < column-name>CALCULATED_SPACING< /column-name> < /cmp-field> < cmp-field> < field-name>analysisVersion< /field-name> < column-name>ANALYSIS_VERSION< /column-name> < /cmp-field> < cmp-field> < field-name>dateUploaded< /field-name> < column-name>DATE_UPLOADED< /column-name> < /cmp-field> < cmp-field> < field-name>sampleCreation< /field-name> < column-name>SAMPLE_CREATION< /column-name> < /cmp-field> < cmp-field> < field-name>sampleModification< /field-name> < column-name>SAMPLE_MODIFICATION< /column- name> < /cmp-field> < cmp-field> < field-name>collectionSizeStdName< /field-name> < column- name>COLLECTION_SIZE_STD_NAME< /column-name> < /cmp-field> < cmp-field> < field-name>collectionAnalysisParmsName< /field- name> < column- name>COLLECTION_ANALYSIS_PARMS_NAME< /column- name> < /cmp-field> < entity-command name="oracle-sequence" class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCOracle CreateCommand"> < attribute name="sequence">LaneSeq< /attribute> < /entity-command> < /entity> < ejb-relation> < ejb-relation-name>Bases_lane< /ejb-relation-name> < !-- Says that we're doing a foreign key map instead of an intersection table map (relation-table-mapping)--> < foreign-key-mapping/> < ejb-relationship-role> < ejb-relationship-role-name>Bases_has_Lane< /ejb- relationship-role-name> < !-- No key fields, since Lane has no foreign key --> < key-fields/> < /ejb-relationship-role> < ejb-relationship-role> < ejb-relationship-role-name>LaneRole< /ejb-relationship- role-name> < key-fields> < key-field> < !-- CMP field from the Lane object --> < field-name>id< /field-name> < !-- Foreign Key in the Bases table that maps to this ID --> < column-name>LANE_ID< /column-name> < /key-field> < /key-fields> < /ejb-relationship-role> < /ejb-relation> ejb-jar < entity> < display-name>Oracle8iSeqCol_Bases< /display-name> < ejb-name>Oracle8iSeqCol_Bases< /ejb-name> < local- home>com.genecodes.oracle8iseqcol.bases.BasesHome< /local-home> < local>com.genecodes.oracle8iseqcol.bases.Bases< /local> < ejb- class>com.genecodes.oracle8iseqcol.bases.BasesBean< / ejb-class> < persistence-type>Container< /persistence-type> < prim-key- class>com.genecodes.oracle8iseqcol.bases.BasesPK< /pri m-key-class> < reentrant>False< /reentrant> < cmp-version>2.x< /cmp-version> < abstract-schema- name>Oracle8iSeqCol_Bases< /abstract-schema-name> < cmp-field> < field-name>id< /field-name> < /cmp-field> < cmp-field> < field-name>callerName< /field-name> < /cmp-field> < cmp-field> < field-name>sequence< /field-name> < /cmp-field> < cmp-field> < field-name>length< /field-name> < /cmp-field> < cmp-field> < field-name>modDate< /field-name> < /cmp-field> < cmp-field> < field-name>clearRangeStart< /field-name> < /cmp-field> < cmp-field> < field-name>clearRangeEnd< /field-name> < /cmp-field> < cmp-field> < field-name>clearRangeLength< /field-name> < /cmp-field> < cmp-field> < field-name>isComplemented< /field-name> < /cmp-field> < cmp-field> < field-name>isCurrent< /field-name> < /cmp-field> < query> < query-method> < method-name>findAll< /method-name> < method-params/> < /query-method> < return-type-mapping>Local< /return-type-mapping> < ejb-ql>< ![CDATA[SELECT OBJECT(o)FROM Oracle8iSeqCol_Bases o]]>< /ejb-ql> < /query> < security-identity> < description/> < use-caller-identity/> < /security-identity> < /entity> < entity> < display-name>Oracle8iSeqCol_Lane< /display-name> < ejb-name>Oracle8iSeqCol_Lane< /ejb-name> < local- home>com.genecodes.oracle8iseqcol.lane.LaneHome< /lo cal-home> < local>com.genecodes.oracle8iseqcol.lane.Lane< /local> < ejb- class>com.genecodes.oracle8iseqcol.lane.LaneBean< /ejb -class> < persistence-type>Container< /persistence-type> < prim-key- class>com.genecodes.oracle8iseqcol.lane.LanePK< /prim- key-class> < reentrant>False< /reentrant> < cmp-version>2.x< /cmp-version> < abstract-schema- name>Oracle8iSeqCol_Lane< /abstract-schema-name> < cmp-field> < field-name>id< /field-name> < /cmp-field> < cmp-field> < field-name>laneType< /field-name> < /cmp-field> < cmp-field> < field-name>applicationCreator< /field-name> < /cmp-field> < cmp-field> < field-name>autoAnalysis< /field-name> < /cmp-field> < cmp-field> < field-name>autoPrint< /field-name> < /cmp-field> < cmp-field> < field-name>lastUsed< /field-name> < /cmp-field> < cmp-field> < field-name>name< /field-name> < /cmp-field> < cmp-field> < field-name>landNumber< /field-name> < /cmp-field> < cmp-field> < field-name>status< /field-name> < /cmp-field> < cmp-field> < field-name>thumbprint< /field-name> < /cmp-field> < cmp-field> < field-name>primerPosition< /field-name> < /cmp-field> < cmp-field> < field-name>rawDataStartPoint< /field-name> < /cmp-field> < cmp-field> < field-name>startEp< /field-name> < /cmp-field> < cmp-field> < field-name>endEp< /field-name> < /cmp-field> < cmp-field> < field-name>startEpAnalysis< /field-name> < /cmp-field> < cmp-field> < field-name>endEpAnalysis< /field-name> < /cmp-field> < cmp-field> < field-name>initialScanStart< /field-name> < /cmp-field> < cmp-field> < field-name>initialScanEnd< /field-name> < /cmp-field> < cmp-field> < field-name>lastScanStart< /field-name> < /cmp-field> < cmp-field> < field-name>lastScanEnd< /field-name> < /cmp-field> < cmp-field> < field-name>customScanStart< /field-name> < /cmp-field> < cmp-field> < field-name>customScanEnd< /field-name> < /cmp-field> < cmp-field> < field-name>startComment< /field-name> < /cmp-field> < cmp-field> < field-name>stopComment< /field-name> < /cmp-field> < cmp-field> < field-name>adaptiveWorked< /field-name> < /cmp-field> < cmp-field> < field-name>averageSpacing< /field-name> < /cmp-field> < cmp-field> < field-name>calculatedSpacing< /field-name> < /cmp-field> < cmp-field> < field-name>analysisVersion< /field-name> < /cmp-field> < cmp-field> < field-name>dateUploaded< /field-name> < /cmp-field> < cmp-field> < field-name>sampleCreation< /field-name> < /cmp-field> < cmp-field> < field-name>sampleModification< /field-name> < /cmp-field> < cmp-field> < field-name>collectionSizeStdName< /field-name> < /cmp-field> < cmp-field> < field-name>collectionAnalysisParmsName< /field- name> < /cmp-field> < query> < query-method> < method-name>findAll< /method-name> < method-params/> < /query-method> < return-type-mapping>Local< /return-type-mapping> < ejb-ql>< ![CDATA[SELECT OBJECT(o)FROM Oracle8iSeqCol_Lane o]]>< /ejb-ql> < /query> < security-identity> < description/> < use-caller-identity/> < /security-identity> < /entity> < !-- this is a One to Many Unidirectional relationship -- > < ejb-relation> < ejb-relation-name>Bases_lane< /ejb-relation-name> < ejb-relationship-role> < description>Bases has one Lane< /description> < ejb-relationship-role-name>Bases_has_Lane< /ejb- relationship-role-name> < multiplicity>Many< /multiplicity> < cascade-delete/> < relationship-role-source> < ejb-name>Oracle8iSeqCol_Bases< /ejb-name> < /relationship-role-source> < cmr-field> < cmr-field-name>lane< /cmr-field-name> < /cmr-field> < /ejb-relationship-role> < ejb-relationship-role> < description>one Lane exists for Bases< /description> < ejb-relationship-role-name>LaneRole< /ejb-relationship- role-name> < multiplicity>One< /multiplicity> < relationship-role-source> < description>Lane< /description> < ejb-name>Oracle8iSeqCol_Lane< /ejb-name> < /relationship-role-source> < /ejb-relationship-role> < /ejb-relation>