$B5WJ]$5$s!#(B $B$*@$OC$K$J$C$F$*$j$^$9!#@6?e$H?=$7$^$9!#(B $B@hF|2sEz$7$F$$$?$@$-$^$7$?7o$G$9$,!"L$BP1~$N2DG=@-$,9b$$$H$$$&$3$H$G!"?=$7Lu$"$j$^$;$s$,(B $B:#2s$O(BOUT$B%Q%i%a!<%?$K$FBP1~2DG=$@$C$?$?$a!"$3$A$i$GBP1~$9$k$3$H$KCW$7$^$7$?!#(B $B$4LBOG$*3]$1$7$^$7$FBgJQ?=$7Lu$"$j$^$;$s!#(B $B:#8e$H$b59$7$/$*4j$$CW$7$^$9!#(B kubo <dbflute@gmail.com>: > $B5WJ](B(jflute)$B$G$9!#(B > > > > > > $B@6?e$5$s!"$3$s$P$s$O(B > > > > > > DBFlute.NET$B$K$O!"(BPostgreSQL$B$N%9%H%"%I%U%!%s%/%7%g%s(B > > > $B$KBP$9$k%F%9%H$,B8:_$7$F$$$J$$$?$a!"C1=c$KL$BP1~$G$"$k(B > > > $B$H$$$&2DG=@-$O9b$$$G$9!#(B > > > (Java$BHG$G$O$7$C$+$j%F%9%H$5$l$F$$$FF0:n$9$k$N$G$9$,!"(B > > > DBFlute.NET$B$G$O$=$b$=$b(BPostgreSQL$B$N(BExample$B$,$"$j$^$;$s(B) > > > > > > $B$J$N$G!"?=$7Lu$"$j$^$;$s$,!"$"$kDxEY$A$g$C$H%=!<%9$r(B > > > $B=$@5$7$F$b$i$C$F!"$I$&D>$9$Y$-$+$r;n$7$FC5$C$F$b$i$&(B > > > $B$3$H$K$J$C$F$7$^$$$^$9!#(B > > > > > > $B$^$:$O!"(BProcedurePmb(ParameterBean)$B$N(B > > > $B!V(BProcedure Parameter$B!W$NDj5A$O$I$N$h$&$K(B > > > $B$J$C$F$$$^$9$G$7$g$&$+!)(B > > > (return $B$N$b$N$,$"$j$^$9$G$7$g$&$+!)(B) > > > > > > $B$=$7$F!"%9%?%C%/%H%l!<%9$r8+$k$K!"(B > > > AllCommon.S2Dao.Internal.SqlHandler.InternalProcedureHandler > > > $B$N(B HandleOutParameters() $B$N=hM}$,%]%$%s%H$K$J$j$=$&$G$9!#(B > > > $B$=$N8e!"(BSetValue() $B$,8F$S=P$5$l$F$$$^$9$,!"(B > > > $BFs$D$"$j$^$9$,!"(Breturn$B$KBP$7$F$I$A$i$NJ,4t$N(BSetValue()$B$,(B > > > $B8F$S=P$5$l$F$$$k$G$7$g$&$+!)(B > > > ($B62$i$/!"(Bppt.IsReturnType$B$@$H;W$$$^$9$,3NG'$N$?$a(B) > > > > > > $B$b$7!"(Bppt.IsReturnType$B$NJ}$N(BSetValue()$B$G$"$l$P!"(B > > > $B$=$N(B returnValue $B$,$I$3$+$i$d$C$F$-$F$$$k$N$+3NG'$7$F(B > > > $B$_$F2<$5$$!#$=$NCM$,(B System.DBNull $B$H$$$&$3$H$G$"$l$P!"(B > > > $B%U%!%s%/%7%g%s$NLa$jCM$r$A$c$s$H<hF@$G$-$F$$$J$$$H$$$&(B > > > $B$3$H$K$J$k$N$G!"(B(PostgreSQL$B$N(B)ADO.NET$B$H$7$F!"(B > > > $BK\Mh$I$N$h$&$K<hF@$9$k$Y$-$J$N$+$rC5$kI,MW$,$"$j$^$9!#(B > > > $B$b$7!"$=$N<hF@J}K!$,$o$+$l$P!V$b$7!"(BPostgreSQL$B$@$C$?$i!W(B > > > $B$H$$$&J,4t$rF~$l$F=$@5$7$F$$$/$3$H$K$J$k$+$H;W$$$^$9!#(B > > > > > > 2011/3/29 samurai_bouzu s.bracing.field@gmail.com>: > > > > $B$*@$OC$K$J$j$^$9!#@6?e$H?=$7$^$9!#(B > > > > > > > > PostgreSQL$B!J(B.8.4.4$B!K$N%9%H%"%I%U%!%s%/%7%g%s$N%*%V%8%'%/%H$r(BDBFlute.NET$B$+$i8F$S=P$7$FMxMQ$7$h$&$H$7$F$*$j$^$9$,!"<B9T;~$K%(%i!<$,H/@8$7<B9T$G$-$^$;$s!#(B > > > > > > > > $B%9%H%"%I%U%!%s%/%7%g%s$O(B > > > > CREATE OR REPLACE FUNCTION usp_createwk_correspondence_history(IN > > > > "MailFlg" boolean, IN "PhoneFlg" boolean, IN "OfferFlg" boolean, IN > > > > "FanMailFlg" boolean, IN "ReceiveDtFr" timestamp with time zone, IN > > > > "ReceiveDtTo" timestamp with time zone, IN "InquiryCategoryCd" text, > > > > IN "CustomerCd" text, IN "CustomerNm" text, IN "Phone" text, IN > > > > "ProductCategoryACd" text, IN "ProductCategoryBCd" text, IN > > > > "ProductCd" text, IN "PersonCd" text, IN "OfferCategoryACd" text, IN > > > > "OfferCategoryBCd" text, IN "KeyWord1" text, IN "KeyWord2" text, IN > > > > "KeyWord3" text, IN "KeyWord4" text, IN "KeyWord5" text, IN "KeyWord6" > > > > text, IN "KeyWord7" text, IN "KeyWord8" text, IN "KeyWord9" text, IN > > > > "KeyWord10" text, IN "KeyWord11" text, IN "KeyWord12" text, IN > > > > "KeyWord13" text, IN "KeyWord14" text, IN "KeyWord15" text, IN > > > > "KeyWord16" text, IN "KeyWord17" text, IN "KeyWord18" text, IN > > > > "KeyWord19" text, IN "KeyWord20" text, IN "Address" text, IN > > > > "HabitatCd" text) > > > > RETURNS integer > > > >  AS$B!!(B.... > > > > > > > > return 1; > > > > > > > > $B$H$$$&$b$N$G$9!#(B > > > > > > > > C#$BB&$N8F$S=P$7$O0J2<$G$9!#(B > > > > UspCreatewkCorrespondenceHistoryPmb pmb = new > > > > UspCreatewkCorrespondenceHistoryPmb(); > > > > ... > > > > > > > > // Timeout$B$rL5@)8B$K@_Dj(B > > > > StatementConfig config = new StatementConfig(); > > > > config.QueryTimeout(0); > > > > > > > > inquiryInfoBhv.OutsideSql().Configure(config).Call(pmb); > > > > > > > > > > > > $B<B9T$7$?:]$NNc30$O(B > > > > XXX.DBFlute.AllCommon.Exp.SQLFailureException $B$,%-%c%C%A$5$l$^$7$?(B > > > >  Message="Look! Read the message below.\n/* * * * * * * * * * * * * * > > > > * * * * * * * * * * * * * * * * * * * *\nThe SQL failed to > > > > execute!\n\n[Advice]\nPlease confirm the Exception > > > > message.\n\n[Exception]\nSystem.ArgumentException\n$B7?(B 'System.DBNull' > > > > $B$N%*%V%8%'%/%H$r7?(B 'System.Nullable`1[System.Int32]' > > > > $B$KJQ49$G$-$^$;$s!#(B\n\n[OutsideSqlPath]\nusp_createwk_correspondence_history\n\n[ParameterBean]\nXXX.DBFlute.ExDao.PmBean.UspCreatewkCorrespondenceHistoryPmb\nUspCreatewkCorrespondenceHistoryPmb:{, > > > > True, True, False, False, 2010/03/30 0:00:00, 2011/03/29 0:00:00, , , > > > > , , 00, , , , , , , , , , , , , , , , , , , , , , , , , , , , > > > > }\n\n[Statement]\nNpgsql.NpgsqlCommand\n* * * * * * * * * */" > > > >  Source="XXX.DBFlute" > > > >  StackTrace: > > > >       $B>l=j(B XXX.DBFlute.AllCommon.S2Dao.Internal.SqlHandler.DbExceptionHandler.ThrowSQLFailureException(Exception > > > > e, IDbCommand cmd, String displaySql) > > > >       $B>l=j(B XXX.DBFlute.AllCommon.S2Dao.Internal.SqlHandler.DbExceptionHandler.HandleDbException(Exception > > > > e, IDbCommand cmd, Boolean uniqueConstraintValid, String displaySql) > > > >       $B>l=j(B XXX.DBFlute.AllCommon.S2Dao.Internal.SqlHandler.InternalBasicHandler.HandleDbException(Exception > > > > e, IDbCommand cmd, Boolean uniqueConstraintValid) > > > >       $B>l=j(B XXX.DBFlute.AllCommon.S2Dao.Internal.SqlHandler.InternalProcedureHandler.Execute(IDbConnection > > > > conn, Object[] args, Type[] argTypes) > > > >       $B>l=j(B XXX.DBFlute.AllCommon.S2Dao.Internal.SqlHandler.InternalBasicSelectHandler.Execute(Object[] > > > > args, Type[] argTypes) > > > >       $B>l=j(B XXX.DBFlute.AllCommon.S2Dao.Internal.SqlHandler.InternalBasicSelectHandler.Execute(Object[] > > > > args) > > > >       $B>l=j(B XXX.DBFlute.AllCommon.S2Dao.Internal.SqlCommand.InternalProcedureCommand.Execute(Object[] > > > > args) > > > >       $B>l=j(B XXX.DBFlute.AllCommon.S2Dao.S2DaoInterceptor.DispatchInvoking(IMethodInvocation > > > > invocation) > > > >       $B>l=j(B XXX.DBFlute.AllCommon.S2Dao.S2DaoInterceptor.Invoke(IMethodInvocation > > > > invocation) > > > >       $B>l=j(B Seasar.Framework.Aop.Proxy.DynamicAopProxy.Intercept(IInvocation > > > > invocation, Object[] args) > > > >       $B>l=j(B ProxyInterfaceSystemSystemObject_XXX_DBFlute_AllCommon_CBean_OutsideSqlOutsideSqlDao_System_Runtime_SerializationISerializable.Call(String > > > > path, Object pmb, OutsideSqlOption option) > > > >       $B>l=j(B XXX.DBFlute.AllCommon.CBean.OutsideSql.Executor.OutsideSqlBasicExecutor.Call(ProcedurePmb > > > > pmb) > > > >       $B>l=j(B MsiApp.CustomerCenter.XXX.Appli.DHM1010.Service.DHM1010Service.GetHistoryInfoListDataTable() > > > > $B>l=j(B D:\XXX\PROG\CustomerCenter\XXX\Appli\Source\DH0101001_$BBP1~MzNr8!:w(B\DHM1010\Service\DHM1010Service.cs:$B9T(B > > > > 452 > > > >  InnerException: System.ArgumentException > > > >       Message="$B7?(B 'System.DBNull' $B$N%*%V%8%'%/%H$r7?(B > > > > 'System.Nullable`1[System.Int32]' $B$KJQ49$G$-$^$;$s!#(B" > > > >       Source="mscorlib" > > > >       StackTrace: > > > >            $B>l=j(B System.RuntimeType.CheckValue(Object value, Binder > > > > binder, CultureInfo culture, BindingFlags invokeAttr) > > > >            $B>l=j(B System.Reflection.MethodBase.CheckArguments(Object[] > > > > parameters, Binder binder, BindingFlags invokeAttr, CultureInfo > > > > culture, Signature sig) > > > >            $B>l=j(B System.Reflection.RuntimeMethodInfo.Invoke(Object obj, > > > > BindingFlags invokeAttr, Binder binder, Object[] parameters, > > > > CultureInfo culture, Boolean skipVisibilityChecks) > > > >            $B>l=j(B System.Reflection.RuntimeMethodInfo.Invoke(Object obj, > > > > BindingFlags invokeAttr, Binder binder, Object[] parameters, > > > > CultureInfo culture) > > > >            $B>l=j(B System.Reflection.RuntimePropertyInfo.SetValue(Object > > > > obj, Object value, BindingFlags invokeAttr, Binder binder, Object[] > > > > index, CultureInfo culture) > > > >            $B>l=j(B System.Reflection.RuntimePropertyInfo.SetValue(Object > > > > obj, Object value, Object[] index) > > > >            $B>l=j(B XXX.DBFlute.AllCommon.S2Dao.InternalProcedureParameterType.SetValue(Object > > > > dto, Object value) > > > >            $B>l=j(B XXX.DBFlute.AllCommon.S2Dao.Internal.SqlHandler.InternalProcedureHandler.HandleOutParameters(IDbCommand > > > > dbCommand, Object dto, Object returnValue) > > > >            $B>l=j(B XXX.DBFlute.AllCommon.S2Dao.Internal.SqlHandler.InternalProcedureHandler.Execute(IDbConnection > > > > conn, Object[] args, Type[] argTypes) > > > >       InnerException: > > > > > > > > $B$J$K$+!"%U%!%s%/%7%g%s$N:n@.J}K!!"$^$?$O!"(BDBFlute$B$G$N8F$S=P$7J}K!$K8m$j$,$"$k$N$G$7$g$&$+!#(B > > > > $B$h$m$7$/$*4j$$$$$?$7$^$9!#(B > > > > _______________________________________________ > > > > seasar-dotnet mailing list > > > > seasar-dotnet@ml.seasar.org > > > > https://ml.seasar.org/mailman/listinfo/seasar-dotnet > > > > > > > _______________________________________________ > > > seasar-dotnet mailing list > > > seasar-dotnet@ml.seasar.org > > > https://ml.seasar.org/mailman/listinfo/seasar-dotnet > > >