<!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><BR>@GeneratedValue(strategy = GenerationType.IDENTITY) $B$@$H(B insert
$B$GNc30!#(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$HDj5A$5$l$F$$$k%(%s%F%#%F%#$G(B</DIV>
<DIV> </DIV>
<DIV> jdbcManager.insert( kokyaku ).execute();</DIV>
<DIV> </DIV>
<DIV>$B$r<B9T$9$k$H!"(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>...<BR>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)</DIV>
<DIV> </DIV>
<DIV>$B$NNc30$,H/@8!#(BID$BNs$,;XDj$5$l$F$$$^$9!#(B</DIV>
<DIV> </DIV>
<DIV>DDL$B$O!"(B</DIV>
<DIV> </DIV>
<DIV>CREATE TABLE KOKYAKUS<BR>(<BR> ID SERIAL NOT
NULL,<BR>...<BR></FONT></DIV></BODY></HTML>