<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=text/html;charset=iso-2022-jp http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16722"></HEAD>
<BODY style="PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: 15px"
id=MailContainerBody leftMargin=0 topMargin=0 CanvasTabStop="true"
name="Compose message area">
<DIV><FONT face=Calibri>$B4D6-(B<BR>DB: PostgreSQL 9.0.3<BR>S2JDBC-Gen
2.4.43<BR>s2-framework/tiger/extension-2.4.43</FONT></DIV>
<DIV> </DIV><FONT face=Calibri>
<DIV>PostgreSQL $B$G(B </DIV>
<DIV> </DIV>
<DIV> /** id$B%W%m%Q%F%#(B */<BR>
@Id<BR> @GeneratedValue(strategy =
GenerationType.IDENTITY)<BR> @Column(precision = 10, unique =
true)<BR> public Integer id;</DIV>
<DIV> </DIV>
<DIV>$B$N<g%-!<$,$"$k%(%s%F%#%F%#$G!!(Binsert</DIV>
<DIV> </DIV>
<DIV> int kazu = jdbcManager.insert( kokyaku
).execute();</DIV>
<DIV> </DIV>
<DIV>$B;XDj$5$l$J$$$O$:$N(BID$BNs$,;XDj$5$l$F!"Nc30$,H/@8$9$k!#$J$<!)(B</DIV>
<DIV> </DIV>
<DIV>DDL$B$O!"(B</DIV>
<DIV> </DIV>
<DIV>CREATE TABLE KOKYAKUS<BR>(<BR> ID SERIAL NOT NULL,<BR>...</DIV>
<DIV> </DIV>
<DIV>$B$465<x$r$*4j$$$7$^$9!#(B</DIV>
<DIV><BR>javax.servlet.ServletException:
org.seasar.framework.exception.SQLRuntimeException: [ESSR0072]SQL$B$GNc30(B(SQL=[insert
into KOKYAKUS (ID, CODE, LASTNAME1_KANJI, FIRSTNAME1_KANJI, LASTNAME1_KANA,
FIRSTNAME1_KANA, TANTOU1, BUSHOYAKU1, postalcode1_1, postalcode1_2, PREFECTURE1,
CITY1, TOWN1, BUIL1, tel1_1, tel1_2, tel1_3, fax1_1, fax1_2, fax1_3, TANTOU2,
BUSHOYAKU2, postalcode2_1, postalcode2_2, PREFECTURE2, CITY2, TOWN2, BUIL2,
tel2_1, tel2_2, tel2_3, fax2_1, fax2_2, fax2_3, OFFICENAME_KANJI,
OFFICENAME_KANA, OFFICEPOST, postalcode0_1, postalcode0_2, PREFECTURE0, CITY0,
TOWN0, BUIL0, tel0_1, tel0_2, tel0_3, fax0_1, fax0_2, fax0_3, mbtel_1, mbtel_2,
mbtel_3, URL, MAIL, MBMAIL, BIRTHDAY) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)],
Message=[[ESSR0072]SQL$B$GNc30(B(SQL=[insert into KOKYAKUS (ID, CODE, LASTNAME1_KANJI,
FIRSTNAME1_KANJI, LASTNAME1_KANA, FIRSTNAME1_KANA, TANTOU1, BUSHOYAKU1,
postalcode1_1, postalcode1_2, PREFECTURE1, CITY1, TOWN1, BUIL1, tel1_1, tel1_2,
tel1_3, fax1_1, fax1_2, fax1_3, TANTOU2, BUSHOYAKU2, postalcode2_1,
postalcode2_2, PREFECTURE2, CITY2, TOWN2, BUIL2, tel2_1, tel2_2, tel2_3, fax2_1,
fax2_2, fax2_3, OFFICENAME_KANJI, OFFICENAME_KANA, OFFICEPOST, postalcode0_1,
postalcode0_2, PREFECTURE0, CITY0, TOWN0, BUIL0, tel0_1, tel0_2, tel0_3, fax0_1,
fax0_2, fax0_3, mbtel_1, mbtel_2, mbtel_3, URL, MAIL, MBMAIL, BIRTHDAY) values
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?)], Message=[0], ErrorCode=23502, SQLState={3})$B$,H/@8$7$^$7$?(B :
[SQL$B$GNc30(B(Message=[ERROR: $BNs(B"id"$BFb$N(BNULL$BCM$O(BNOT NULL$B@)Ls0cH?$G$9(B], ErrorCode=0,
SQLState=23502)$B$,H/@8$7$^$7$?!#(B], [ERROR: $BNs(B"id"$BFb$N(BNULL$BCM$O(BNOT NULL$B@)Ls0cH?$G$9(B], ErrorCode=0,
SQLState=23502)$B$,H/@8$7$^$7$?(B<BR> org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)<BR> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)<BR> org.seasar.struts.action.S2RequestProcessor.process(S2RequestProcessor.java:132)<BR> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)<BR> org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)<BR>...</DIV>
<DIV> </DIV>
<DIV>$B860x(B </DIV>
<DIV> </DIV>
<DIV>org.seasar.framework.exception.SQLRuntimeException:
[ESSR0072]SQL$B$GNc30(B(SQL=[insert into KOKYAKUS (ID, CODE, LASTNAME1_KANJI,
FIRSTNAME1_KANJI, LASTNAME1_KANA, FIRSTNAME1_KANA, TANTOU1, BUSHOYAKU1,
postalcode1_1, postalcode1_2, PREFECTURE1, CITY1, TOWN1, BUIL1, tel1_1, tel1_2,
tel1_3, fax1_1, fax1_2, fax1_3, TANTOU2, BUSHOYAKU2, postalcode2_1,
postalcode2_2, PREFECTURE2, CITY2, TOWN2, BUIL2, tel2_1, tel2_2, tel2_3, fax2_1,
fax2_2, fax2_3, OFFICENAME_KANJI, OFFICENAME_KANA, OFFICEPOST, postalcode0_1,
postalcode0_2, PREFECTURE0, CITY0, TOWN0, BUIL0, tel0_1, tel0_2, tel0_3, fax0_1,
fax0_2, fax0_3, mbtel_1, mbtel_2, mbtel_3, URL, MAIL, MBMAIL, BIRTHDAY) values
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?)], Message=[[ESSR0072]SQL$B$GNc30(B(SQL=[insert into KOKYAKUS (ID, CODE,
LASTNAME1_KANJI, FIRSTNAME1_KANJI, LASTNAME1_KANA, FIRSTNAME1_KANA, TANTOU1,
BUSHOYAKU1, postalcode1_1, postalcode1_2, PREFECTURE1, CITY1, TOWN1, BUIL1,
tel1_1, tel1_2, tel1_3, fax1_1, fax1_2, fax1_3, TANTOU2, BUSHOYAKU2,
postalcode2_1, postalcode2_2, PREFECTURE2, CITY2, TOWN2, BUIL2, tel2_1, tel2_2,
tel2_3, fax2_1, fax2_2, fax2_3, OFFICENAME_KANJI, OFFICENAME_KANA, OFFICEPOST,
postalcode0_1, postalcode0_2, PREFECTURE0, CITY0, TOWN0, BUIL0, tel0_1, tel0_2,
tel0_3, fax0_1, fax0_2, fax0_3, mbtel_1, mbtel_2, mbtel_3, URL, MAIL, MBMAIL,
BIRTHDAY) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?)], Message=[0], ErrorCode=23502, SQLState={3})$B$,H/@8$7$^$7$?(B :
[SQL$B$GNc30(B(Message=[ERROR: $BNs(B"id"$BFb$N(BNULL$BCM$O(BNOT NULL$B@)Ls0cH?$G$9(B], ErrorCode=0,
SQLState=23502)$B$,H/@8$7$^$7$?!#(B], [ERROR: $BNs(B"id"$BFb$N(BNULL$BCM$O(BNOT NULL$B@)Ls0cH?$G$9(B], ErrorCode=0,
SQLState=23502)$B$,H/@8$7$^$7$?(B<BR> org.seasar.framework.util.PreparedStatementUtil.executeUpdate(PreparedStatementUtil.java:68)<BR> org.seasar.extension.jdbc.query.AbstractAutoUpdate.executeInternal(AbstractAutoUpdate.java:125)<BR> org.seasar.extension.jdbc.query.AbstractAutoUpdate.execute(AbstractAutoUpdate.java:90)<BR> jp.kaitorishahan.action.KokyakuAction.index(KokyakuAction.java:51)<BR>...</DIV>
<DIV> </DIV>
<DIV>$B860x(B </DIV>
<DIV> </DIV>
<DIV>org.seasar.framework.exception.SSQLException: [ESSR0072]SQL$B$GNc30(B(SQL=[insert
into KOKYAKUS (ID, CODE, LASTNAME1_KANJI, FIRSTNAME1_KANJI, LASTNAME1_KANA,
FIRSTNAME1_KANA, TANTOU1, BUSHOYAKU1, postalcode1_1, postalcode1_2, PREFECTURE1,
CITY1, TOWN1, BUIL1, tel1_1, tel1_2, tel1_3, fax1_1, fax1_2, fax1_3, TANTOU2,
BUSHOYAKU2, postalcode2_1, postalcode2_2, PREFECTURE2, CITY2, TOWN2, BUIL2,
tel2_1, tel2_2, tel2_3, fax2_1, fax2_2, fax2_3, OFFICENAME_KANJI,
OFFICENAME_KANA, OFFICEPOST, postalcode0_1, postalcode0_2, PREFECTURE0, CITY0,
TOWN0, BUIL0, tel0_1, tel0_2, tel0_3, fax0_1, fax0_2, fax0_3, mbtel_1, mbtel_2,
mbtel_3, URL, MAIL, MBMAIL, BIRTHDAY) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)], Message=[0],
ErrorCode=23502,
SQLState={3})$B$,H/@8$7$^$7$?(B<BR> org.seasar.extension.jdbc.impl.PreparedStatementWrapper.wrapException(PreparedStatementWrapper.java:72)<BR> org.seasar.extension.jdbc.impl.PreparedStatementWrapper.wrapException(PreparedStatementWrapper.java:67)<BR> org.seasar.extension.jdbc.impl.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:91)<BR> org.seasar.framework.util.PreparedStatementUtil.executeUpdate(PreparedStatementUtil.java:66)<BR> org.seasar.extension.jdbc.query.AbstractAutoUpdate.executeInternal(AbstractAutoUpdate.java:125)<BR> org.seasar.extension.jdbc.query.AbstractAutoUpdate.execute(AbstractAutoUpdate.java:90)<BR> jp.kaitorishahan.action.KokyakuAction.index(KokyakuAction.java:51)<BR>...</DIV>
<DIV> </DIV>
<DIV>$B860x(B </DIV>
<DIV> </DIV>
<DIV>org.postgresql.util.PSQLException: ERROR: $BNs(B"id"$BFb$N(BNULL$BCM$O(BNOT
NULL$B@)Ls0cH?$G$9(B<BR> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)<BR> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)<BR> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)<BR> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)<BR> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)<BR> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)<BR> org.seasar.extension.jdbc.impl.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:89)<BR> org.seasar.framework.util.PreparedStatementUtil.executeUpdate(PreparedStatementUtil.java:66)<BR> org.seasar.extension.jdbc.query.AbstractAutoUpdate.executeInternal(AbstractAutoUpdate.java:125)<BR> org.seasar.extension.jdbc.query.AbstractAutoUpdate.execute(AbstractAutoUpdate.java:90)<BR> jp.kaitorishahan.action.KokyakuAction.index(KokyakuAction.java:51)<BR>...</DIV>
<DIV> </DIV>
<DIV><BR></FONT> </DIV></BODY></HTML>