[Seasar-user:13089] Re: [S2JDBC]@idのシーケンス発番で制約違反

[AGATA Toshitaka]

$BeQ$G$9!#$3$s$K$A$O!#(B

$B0JA0;d$bF1MM$N8=>]$G:$$C$?$3$H$,$"$j$^$7$?!#(B
$B$*$=$i$/(BCREATE SEQUENCE$B$G%$%s%/%j%a%s%HCM$r(B50$B$K(B
$B$7$F$$$J$$$+$i$@$H;W$$$^$9!#(B

@javax.persistence.SequenceGenerator$B$N(BallocationSize$B$r(B
1$B$K$9$k$3$H$G!"%$%s%/%j%a%s%HCM(B1$B$N%7!<%1%s%9$rMxMQ$9$k$3$H$b$G$-$^$9!#(B

@javax.persistence.SequenceGenerator(name="project_seq",
sequenceName="project_id", allocationSize=1)

$B$3$N$"$?$j$N7P0^$O0J2<$K%a%b$7$F$$$^$9!#;29M$^$G$K!#(B

http://d.hatena.ne.jp/agt/20080208#p1

$B0J>e$G$9!#(B

Tomato Kagome $B$5$s$O=q$-$^$7$?(B:
> $B$3$s$K$A$O!#(B
> 
> S2JDBC$B$N([E-MAIL ADDRESS DELETED]$B$N%7!<%1%s%9H/HV$G(B
> $B-!$7$P$i$/$OA[DjDL$j$NF0:n$r$7$F$$$k$N$G$9$,!"(B
> $B-"2?$+$N%?%$%_%s%0$+$i%7!<%1%s%9$NH/HV$G$J$/$J$j!"(B
> $B-#FMA3%7!<%1%s%9$G$NH/HV$KLa$C$[E-MAIL ADDRESS DELETED]@)Ls0cH?$H$J$C$F$7$^$C$F$$$^$9!#(B
> 
> $B0J2<$O!"F0:n;~$N%m%0$rH4$-=P$7$?$b$N$G$9!#(B
> $B-!(B
> org.seasar.extension.jta.TransactionImpl [TP-Processor2]
> $B%H%i%s%6%/%7%g%s$r3+;O$7$^$7$?!#(Btx=[FormatId=4360, GlobalId=1203923088134/10,
> BranchId=]
> org.seasar.framework.aop.interceptors.TraceInterceptor [TP-Processor2]
> BEGIN hoge.logic.ItemLogic#regist([E-MAIL ADDRESS DELETED])
> org.seasar.extension.jdbc.query.AutoInsertImpl [TP-Processor2] select
> nextval('item_id_seq')
> org.seasar.extension.jdbc.query.AutoInsertImpl [TP-Processor2] insert
> into ITEM (ID, NAME) values (2, 'hoge')
> org.seasar.framework.aop.interceptors.TraceInterceptor [TP-Processor2]
> END hoge.logic.ItemLogic#regist([E-MAIL ADDRESS DELETED]) : null
> org.seasar.extension.jta.TransactionImpl [TP-Processor2]
> $B%H%i%s%6%/%7%g%s$r%3%_%C%H$7$^$7$?!#(Btx=[FormatId=4360, GlobalId=1203923088134/10,
> BranchId=]
> 
> $B-"(B
> org.seasar.extension.jta.TransactionImpl [TP-Processor3]
> $B%H%i%s%6%/%7%g%s$r3+;O$7$^$7$?!#(Btx=[FormatId=4360, GlobalId=1203923088134/167,
> BranchId=]
> org.seasar.framework.aop.interceptors.TraceInterceptor [TP-Processor3]
> BEGIN jp.worksdc.knowledge.logic.ItemLogic#regist([E-MAIL ADDRESS DELETED])
> org.seasar.extension.jdbc.query.AutoInsertImpl [TP-Processor3] insert
> into ITEM (ID, NAME) values (49, 'hoge')
> org.seasar.framework.aop.interceptors.TraceInterceptor [TP-Processor3]
> END jp.worksdc.knowledge.logic.ItemLogic#regist([E-MAIL ADDRESS DELETED])
> : null
> org.seasar.extension.jta.TransactionImpl [TP-Processor3]
> $B%H%i%s%6%/%7%g%s$r%3%_%C%H$7$^$7$?!#(Btx=[FormatId=4360, GlobalId=1203923088134/167,
> BranchId=]
> 
> $B-#(B
> org.seasar.extension.jta.TransactionImpl [TP-Processor2]
> $B%H%i%s%6%/%7%g%s$r3+;O$7$^$7$?!#(Btx=[FormatId=4360, GlobalId=1204031054603/24,
> BranchId=]
> org.seasar.framework.aop.interceptors.TraceInterceptor [TP-Processor2]
> BEGIN hoge.logic.ItemLogic#regist([E-MAIL ADDRESS DELETED])
> org.seasar.extension.jdbc.query.AutoInsertImpl [TP-Processor2] select
> nextval('item_id_seq')
> org.seasar.extension.jdbc.query.AutoInsertImpl [TP-Processor2] insert
> into ITEM (ID, NAME) values (3, 'hoge')
> org.seasar.framework.aop.interceptors.TraceInterceptor [TP-Processor2]
> END hoge.logic.ItemLogic#regist([E-MAIL ADDRESS DELETED])
> Throwable:org.seasar.extension.jdbc.exception.SEntityExistsException:
> [ESSR0745]$B%(%s%F%#%F%#(B([E-MAIL ADDRESS DELETED])$B$O$9$G$KB8:_$7$^$9(B ($B@)Ls0cH?(B)$B!#(BSQL(insert
> into ITEM (ID, NAME) values (?, ?))
> org.seasar.extension.jta.TransactionImpl [TP-Processor2]
> $B%H%i%s%6%/%7%g%s$r%m!<%k%P%C%/$7$^$7$?!#(Btx=[FormatId=4360, GlobalId=1204031054603/24,
> BranchId=]
> org.seasar.framework.aop.interceptors.TraceInterceptor [TP-Processor2]
> END hoge.action.IndexAction#regist()
> Throwable:org.seasar.extension.jdbc.exception.SEntityExistsException:
> [ESSR0745]$B%(%s%F%#%F%#(B([E-MAIL ADDRESS DELETED])$B$O$9$G$KB8:_$7$^$9(B ($B@)Ls0cH?(B)$B!#(BSQL(insert
> into ITEM (ID, NAME) values (?, ?))
> org.apache.struts.action.RequestProcessor [TP-Processor2]
> $B=hM}$G$-$J$$Nc30$,%9%m!<$5$l$^$7$?(B: class
> org.seasar.extension.jdbc.exception.SEntityExistsException
> org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/knowledge].[action]
> [TP-Processor2] $B%5!<%V%l%C%H(B action $B$N(BServlet.service()$B$,Nc30$rEj$2$^$7$?(B
> org.seasar.extension.jdbc.exception.SEntityExistsException:
> [ESSR0745]$B%(%s%F%#%F%#(B([E-MAIL ADDRESS DELETED])$B$O$9$G$KB8:_$7$^$9(B ($B@)Ls0cH?(B)$B!#(BSQL(insert
> into ITEM (ID, NAME) values (?, ?))
> 	at org.seasar.extension.jdbc.query.AbstractAutoUpdate.execute(AbstractAutoUpdate.java:93)
> 	at hoge.logic.ItemLogic.regist(ItemLogic.java:41)
> 
> 
> $B-"$N(Bselect nextval('item_id_seq')$B$,H/9T$5$l$J$/$J$C$?$b$N$,$7$P$i$/B3$$$F!"(B
> $BFMA3%7!<%1%s%9$NH/HV$KLa$j!"0JA0$N%7!<%1%s%9$NB3$-$J$N$G@)Ls0cH?$H$J$j$^$9!#(B
> $B%7!<%1%s%9H/HV$5$l$J$/$J$C$F$$$k:GCf$O!"(Bid$B$O>!<j$K%$%s%/%j%a%s%H$5$l$?CM$G(B
> insert$B$5$l$F$$$k$h$&$G$9!#(B
> 
> $B4D6-$O0J2<$NDL$j$G$9!#(B
> S2Framework 2.2.22
> S2Struts 1.0.1-rc3
> PostgreSQL 8.1
> 
> $B%(%s%F%#%F%#$N(Bid$B$O2<5-$NDL$j$K$J$C$F$$$^$9!#(B
> @Id
> @GeneratedValue(strategy = GenerationType.SEQUENCE, generator =
> "item_id_seq_gen")
> @SequenceGenerator(name = "item_id_seq_gen", sequenceName = "item_id_seq")
> public Long id;
> 
> $B2?$+J,$+$k$3$H$O$"$j$^$9$G$7$g$&$+!#(B
> 
> $B0J>e!"$h$m$7$/$*4j$$$$$?$7$^$9!#(B
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Seasar-user mailing list
> [E-MAIL ADDRESS DELETED]
> https://ml.seasar.org/mailman/listinfo/seasar-user


-- 
-------------------------------
$B3t<02q<R%L!<%i%\!!eQ!!=S5.(B
Mail : [E-MAIL ADDRESS DELETED]
HP   : http://www.nulab.co.jp/
TEL  : 03-5766-6256($BEl5~(B)
       092-724-0020($BJ!2,(B)
-------------------------------