[seasar-dotnet:928] Re: S2Dao.Net+SSCE SQL自動生成を利用したInsert時の日付型データの書式

林 秀仁 [E-MAIL ADDRESS DELETED]
2008年 9月 4日 (木) 11:45:04 JST


$B$*@$OC$K$J$C$F$*$j$^$9!#(B
$BNS$G$9!#(B

$BD4::$NB3$-$rJs9p$7$^$9!#(B

Insert$B$K4X$7$F!"(B
>INSERT$B6g$N%+%i%`%j%9%H$H9TCM%3%s%9%H%i%/%?$NJB$S=g$,(B
>$B%F!<%V%kDj5A$H0lCW$7$F$$$kI,MW$,$"$j$=$&(B(SSCE$BB&@)Ls(B)
$B$HG'<1$7$F$$$^$7$?$,!"$3$l$O4V0c$$$@$C$?$h$&$G$9!#(B
$B%+%i%`$NJB$S$rJQ99$7$F!"(B
INSERT INTO BOO  (dt, s1, s2) VALUES(@0, @1, @2)$B9=J8$N(BSQL$B$r<B9T$7$?$H$3$m!"(B
$[E-MAIL ADDRESS DELETED]>o$KF0:nCW$7$^$7$?!#(B

$B0J2<$N%(%i!<%a%C%;!<%8$,!"(BInsert$BJ8$N%+%i%`%j%9%H$,%F!<%V%kDj5A$H0lCW$7$F$$$k>l9g$K$O(B
$B=PNO$5$l$J$+$C$?0Y!"8m$C$?2r<a$r$7$F$7$^$C$F$$$^$7$?!#(B
>>>>> Seasar.Framework.Exceptions.SQLRuntimeException: 
>>>>> [ESSR0071]SQLException
>>>>> occured, because System.FormatException: @2 : 10 - $BJ8;zNs$OM-8z$J(B 
>>>>> DateTime
>>>>> $B$G$O$"$j$^$;$s$G$7$?!#(B

$B860x$O$*$=$i$/!"(B
INSERT INTO BOO  (dt, s1, s2) VALUES(@0, @1, @2)
$B$r<B9T$7$?:]$K!"(B(dt, s1, s2)$B$HBP1~$9$Y$-(BVALUES$B$NCM$,%:%l$F$$$k$H$$$&;v$G$9!#(B
$B"($3$l$J$i30It(BSQL$B$G$N(BInsert$B$,<:GT$7$J$$@bL@$b$D$-$^$9!#(B

$B$3$l0J>eD4::$7$F$b:,K\E*$J2r7h$K$^$G;j$i$J$$$HH=CG(B($BD4::;~4V$b$"$^$jL5$$0Y(B)$B$7!"(B 

$B-!(BInsert$B$r30It(BSQL$B$H$9$k(B
$B-"(BSSCE$B$N;HMQ$rCGG0$9$k(B
$BEy$GLdBj$r2sHr$7$h$&$H;W$$$^$9!#(B

$B$"$j$,$H$&$4$6$$$^$7$?!#(B

----- Original Message ----- 
From: "$BNS!!=(?N(B" <[E-MAIL ADDRESS DELETED]>
To: <[E-MAIL ADDRESS DELETED]>
Sent: Wednesday, September 03, 2008 9:34 AM
Subject: [seasar-dotnet:927] Re:S2Dao.Net+SSCE SQL$B<[E-MAIL ADDRESS DELETED]@.$rMxMQ$7$?(BInsert$B;~$NF|IU7?%G!<%?$N=q<0(B


> $B$*@$OC$K$J$C$F$*$j$^$9!#(B
> $BNS$G$9!#(B
>
>> $B$7$+$7!"(B
>> GetProperties()$B%a%=%C%I$GJV$5$l$k%W%m%Q%F%#$O!"(B
>> $B%"%k%U%!%Y%C%H=g$[E-MAIL ADDRESS DELETED]@=g$J$I$NFCDj$N=g=x$GJV$5$l$k$o$1$G$O$"$j$^$;$s(B
>> $B$H(BMSDN$B$K$"$k$N$G%+%i%`$N=g=x$OFCDj$G$-$J$$$H;W$$$^$9!#(B
>
> $BLkJ,CY$/$^$GD4::!"<ALd$X$N2sEz$"$j$,$H$&$4$6$$$^$9!#(B
> $B%+%i%`$N=g=x$OFCDj$G$-$J$$$N$G$9$M!#(B
> $B$H$J$k$H!"(BSSCE$B$G(BInsert$B=hM}$r9T$&>l9g$O!"30It(BSQL$B$K$9$k$7$+(B
> $B<jN)$F$O$J$5$=$&$G$9$M!#$"$j$,$H$&$4$6$$$^$9!#(B
> $BK:$l$F$$$^$7$?$,!"(B(5)$B%H%i%s%6%/%7%g%s@)8f(B $B$K$D$$$F$O(B
> $BLdBj$"$j$^$;$s$G$7$?!#(B
>
> $B$^$?2?$+$"$j$^$7$?$iJs9p!"<ALd$5$;$F$$$?$@$-$^$9!#(B
> $B$h$m$7$/$*4j$$$7$^$9!#(B
>
> ----- Original Message ----- 
> From: "Ryo Miyagi" <[E-MAIL ADDRESS DELETED]>
> To: <[E-MAIL ADDRESS DELETED]>
> Sent: Wednesday, September 03, 2008 2:32 AM
> Subject: [seasar-dotnet:926] Re:S2Dao.Net+SSCE SQL$B<[E-MAIL ADDRESS DELETED]@.$rMxMQ$7$?(BInsert$B;~$NF|IU7?%G!<%?$N=q<0(B
>
>
>> $B5\>k$G$9!#(B
>>
>>> $B$H$"$j$^$7$?$,!"(BInsert$BJ8$[E-MAIL ADDRESS DELETED]@.$K4X$7$F!"%+%i%`$N=g=x$O!"(B
>>> $B2?$N>pJs$r85$K7hDj$5$l$F$$$k$+$4B8$8$G$7$g$&$+!)(B
>>> $B;d6&$,:[E-MAIL ADDRESS DELETED]$7$?$$$/$D$+$N(BEntity$B%/%i%9$G(BInsert$B=hM}$r<B9T$7$?$H$3$m!"%F!<%V%kDj5A=g$K(BInsert$BJ8$[E-MAIL ADDRESS DELETED]@.$5$l$k$b$N$b$"$l$P!"$=$&$G$J$$$b$N$b$"$k$H$$$C$?>u67$G$9!#(B
>>
>> $B<[E-MAIL ADDRESS DELETED]@.$N(BInsert$B$N>l9g!"(B
>> Entity$B%/%i%9$N(BGetType().GetProperties()$B%a%=%C%I$G(B
>> $B<hF@$7$?%W%m%Q%F%#$NG[Ns$N=gHV$[E-MAIL ADDRESS DELETED]@.$7$F$$$?$+$H;W$$$^$9!#(B
>> (ID$[E-MAIL ADDRESS DELETED]$,$D$$$?%W%m%Q%F%#$,$"$k$H<c43$:$l$k$+$b$7$l$^$;$s(B)
>>
>> $B$7$+$7!"(B
>> GetProperties()$B%a%=%C%I$GJV$5$l$k%W%m%Q%F%#$O!"(B
>> $B%"%k%U%!%Y%C%H=g$[E-MAIL ADDRESS DELETED]@=g$J$I$NFCDj$N=g=x$GJV$5$l$k$o$1$G$O$"$j$^$;$s(B
>> $B$H(BMSDN$B$K$"$k$N$G%+%i%`$N=g=x$OFCDj$G$-$J$$$H;W$$$^$9!#(B
>>
>>
>>
>> 2008/09/02 18:31 $BNS!!=(?N(B <[E-MAIL ADDRESS DELETED]>:
>>> $B$*@$OC$K$J$C$F$*$j$^$9!#(B
>>> $BNS$G$9!#(B
>>>
>>> $B>/$74V$,6u$-$^$7$?$,!"7P2a$rJs9p$7$^$9!#(B
>>>
>>> (4)$B30It(BSQL$B%U%!%$%k$N<B9T(B
>>> $B$K$D$$$F$OLdBj$J$/%Q%9$$$?$7$^$7$?!#(B
>>>
>>> $BLdBj$N(B(3)Insert$B$K4X$7$F$G$9$,!"(B
>>>>>
>>>>> $B!&(BINSERT$B6g$N%+%i%`%j%9%H$H9TCM%3%s%9%H%i%/%?$NJB$S=g$,(B
>>>>> $B!!%F!<%V%kDj5A$H0lCW$7$F$$$kI,MW$,$"$j$=$&(B(SSCE$BB&@)Ls(B)
>>>
>>> $B$H$"$j$^$7$?$,!"(BInsert$BJ8$[E-MAIL ADDRESS DELETED]@.$K4X$7$F!"%+%i%`$N=g=x$O!"(B
>>> $B2?$N>pJs$r85$K7hDj$5$l$F$$$k$+$4B8$8$G$7$g$&$+!)(B
>>> $B;d6&$,:[E-MAIL ADDRESS DELETED]$7$?$$$/$D$+$N(BEntity$B%/%i%9$G(BInsert$B=hM}$r<B9T$7$?$H$3$m!"%F!<%V%kDj5A=g$K(BInsert$BJ8$[E-MAIL ADDRESS DELETED]@.$5$l$k$b$N$b$"$l$P!"$=$&$G$J$$$b$N$b$"$k$H$$$C$?>u67$G$9!#(B
>>>
>>>
>>> ----- Original Message ----- From: "Ryo Miyagi" <[E-MAIL ADDRESS DELETED]>
>>> To: <[E-MAIL ADDRESS DELETED]>
>>> Sent: Friday, August 29, 2008 8:24 PM
>>> Subject: [seasar-dotnet:924] Re:S2Dao.Net+SSCE SQL$B<[E-MAIL ADDRESS DELETED]@.$rMxMQ$7$?(BInsert$B;~$NF|IU7?%G!<%?$N=q<0(B
>>>
>>>
>>>> $B5\>k$G$9!#(B
>>>>
>>>>> S2$B$[E-MAIL ADDRESS DELETED]$GF|IU7?%G!<%?$N=q<0JQ49;XDj$r$G$-$?$j$9$k$b$N$G$7$g$&$+!)(B
>>>>> $B$4B8CN$G$7$?$i$465<x$/$@$5$$!#(B
>>>>
>>>> S2Dao.NET$B$N%m%0%U%!%$%k$K=PNO$5$l$k(BSQL$BJ8$H(B
>>>> SSCE$B$KBP$7$FH/9T$7$F$$$k(BSQL$BJ8$O0[$J$j$^$9!#(B
>>>>
>>>> $B%m%0%U%!%$%k$N(BSQL$BJ8$O!"(B
>>>> $B%G%P%C%0;~Ey$K!"(BSQL$BJ8$r%3%s%=!<%k$+$iD>@\<B9T$G$-$k$h$&$K(B
>>>> $BF|;~=q<0$rJQ99$G$-$k$h$&$K$7$F$$$^$9!#(B
>>>> $BF|;~=q<0$NJQ99$O!"(BDicon$B%U%!%$%k$K2<5-$[E-MAIL ADDRESS DELETED]$r$9$k$3$H$G2DG=$G$9!#(B
>>>>  <component class="Seasar.Extension.ADO.Impl.BasicCommandFactory" >
>>>>   <property name="SqlLogDateFormat">"yyyy/MM/dd"</property>
>>>>   <property name="SqlLogDateTimeFormat">"yyyy/MM/dd
>>>> HH:mm:ss.fff"</property>
>>>>  </component>
>>>>
>>>> SSCE$B$KBP$7$FH/9T$7$F$$$k(BSQL$BJ8$G$O!"(B
>>>> System.Data.IDbDataParameter$B%Q%i%a!<%?$r;HMQ$7$FCM$[E-MAIL ADDRESS DELETED]$7$F$$$^$9!#(B
>>>> $B%Q%i%a!<%?$r4^$`(BSQL$BJ8$O!"(B
>>>> INSERT INTO BOO  (dt, s1, s2) VALUES(@0, @1, @2)
>>>> $B$N$h$&$K$J$j!"(B
>>>> Seasar.Extension.ADO.Types.BaseValueType.BindValue$B%a%=%C%I$G(B
>>>> @$B%Q%i%a!<%?$KCM$r%;%C%H$7$F$$$^$9!#(B
>>>>
>>>> $B=>$C$F!"(BSSCE$B$N(BADO.NET$B%G!<%?%W%m%P%$%@$,(B
>>>> SSCE$B$N(BDateTime$B7?$H(B.NET Framework$B$N(BSystem.DateTime$B7?$H$N(B
>>>> $[E-MAIL ADDRESS DELETED]$J%^%C%T%s%0$r<B9T$7$F$/$l$F$$$l$P!"LdBj$J$$$H;W$$$^$9!#(B
>>>> $B"((BMSDN$B$r8+$k8B$j$@$[E-MAIL ADDRESS DELETED]$K%^%C%T%s%0$7$F$$$k$_$?$$$G$9!#(B
>>>>
>>>>> Seasar.Framework.Exceptions.SQLRuntimeException: 
>>>>> [ESSR0071]SQLException
>>>>> occured, because System.FormatException: @2 : 10 - $BJ8;zNs$OM-8z$J(B 
>>>>> DateTime
>>>>> $B$G$O$"$j$^$;$s$G$7$?!#(B
>>>>> $B$J$*30It(BSQL$B$rMQ$$$?(BInsert$B$O2?8N$[E-MAIL ADDRESS DELETED]$7$^$7$?!#(B
>>>>
>>>> $B<[E-MAIL ADDRESS DELETED]@.$5$l$?(BSQL$B$H30It(BSQL$B$N%+%i%`=g$,0[$J$C$F$$$l$P(B
>>>> $[E-MAIL ADDRESS DELETED]$5$s$N%a!<%k$K$"$C$?(B
>>>>>
>>>>> $B!&(BINSERT$B6g$N%+%i%`%j%9%H$H9TCM%3%s%9%H%i%/%?$NJB$S=g$,(B
>>>>> $B!!%F!<%V%kDj5A$H0lCW$7$F$$$kI,MW$,$"$j$=$&(B(SSCE$BB&@)Ls(B)
>>>>
>>>> $B$N@)Ls$K0z$C$+$+$C$F$$$k$N$+$b$7$l$^$;$s!#(B
>>>>
>>>>
>>>>
>>>> 2008/08/29 16:26 $BNS!!=(?N(B <[E-MAIL ADDRESS DELETED]>:
>>>>>
>>>>> $B$*@$OC$K$J$C$F$*$j$^$9!#[E-MAIL ADDRESS DELETED]$G$9!#(B
>>>>> $BB3Js$G$9!#(B
>>>>>
>>>>> (2)Delete$B$O%Q%9$7$^$7$?$,(B
>>>>> (3)Insert$B$O%Q%9$7$^$;$s$G$7$?!#(B
>>>>> $BF|;~7?%G!<%?$N=q<0JQ49$KLdBj$,$"$k$h$&$G$9!#(B
>>>>>
>>>>>
>>>>> $B:#2sI>2A$7$F$$$k%G!<%?7?$O0J2<$NFs<oN`$G$9!#(B
>>>>> SSEE$B$G$O(B VARCHAR, DATETIME
>>>>> SSCE$B$G$O(B NVARCHAR,DATETIME$B$G$9!#(B
>>>>> (SSCE$B$G$O(BVARCHAR$B$O%5%]!<%H$5$l$J$$0Y!"(BNVARCHAR$B$GBeMQ$G$9!K(B
>>>>>
>>>>> S2dao(?)$B$,<[E-MAIL ADDRESS DELETED]@.$9$k(B INSERT$BJ8$O(BDebug.log$B$K$h$k$H(B
>>>>> INSERT INTO BOO  (dt, s1, s2) VALUES('2008-08-09 15.55.59', '10', 
>>>>> '10')
>>>>> $B$N$h$&$K5-O?$5$l$F$$$^$9!#(B
>>>>>
>>>>> SSCE$B$KBP$7$F<B9T$7$?7k2L$NNc30$O(B
>>>>> ----
>>>>> Seasar.Framework.Exceptions.SQLRuntimeException: 
>>>>> [ESSR0071]SQLException
>>>>> occured, because System.FormatException: @2 : 10 - $BJ8;zNs$OM-8z$J(B 
>>>>> DateTime
>>>>> $B$G$O$"$j$^$;$s$G$7$?!#(B
>>>>> ----
>>>>> $B$,H/@8$7$^$9!#(B
>>>>>
>>>>> $B"($A$J$_$K$3$N(BSQL$B$r(BSSEE$BAj<j$KD>@\Aw$k$H%G!<%?$,HO0O30$H$$$&Nc30$K$J$j$^$9$,!"(B
>>>>> $B<B83%W%m%0%i%`$K$F(BS2$B$r7PM3$7!"(BSSEE$B$KBP$9$k(BINSERT$B$[E-MAIL ADDRESS DELETED]$7$^$9!#(B
>>>>> $B62$i$/(BS2$B$NCf$G=q<0JQ49$7!"<B:]$KH/9T$7$F$$$k(BSQL$B$OJLJ*$J$N$+$J$H9M$($F$$$^$9!#(B
>>>>>
>>>>>
>>>>> DB$B8GM-$N<BAu$GF|IU7?%G!<%?$N=q<0I=8=$,$^$A$^$A$H$$$&$N$OM-$j$&$kOC$@$H;W$$$^$9!#(B
>>>>>
>>>>> S2$B$[E-MAIL ADDRESS DELETED]$GF|IU7?%G!<%?$N=q<0JQ49;XDj$r$G$-$?$j$9$k$b$N$G$7$g$&$+!)(B
>>>>> $B$4B8CN$G$7$?$i$465<x$/$@$5$$!#(B
>>>>>
>>>>>
>>>>> $B$h$m$7$/$*4j$$$7$^$9!#(B
>>>>>
>>>>> $B"((B
>>>>> $B$J$*30It(BSQL$B$rMQ$$$?(BInsert$B$O2?8N$[E-MAIL ADDRESS DELETED]$7$^$7$?!#(B
>>>>> $BF|IU7?%G!<%?$N=q<0JQ49=hM}$,!"<[E-MAIL ADDRESS DELETED]@.$H30It(BSQL$B$G0[$J$k7PO)$rDL$C$F$k$N$+$J!)(B
>>>>>
>>>>>
>>>>> ----- Original Message ----- From: "kubo" <[E-MAIL ADDRESS DELETED]>
>>>>> To: <[E-MAIL ADDRESS DELETED]>
>>>>> Sent: Friday, August 29, 2008 1:52 PM
>>>>> Subject: [seasar-dotnet:921] Re:S2Dao.Net+SSCE $B$NABDLCf4V7k2LJs9p(B
>>>>>
>>>>>
>>>>>> $B5WJ](B(jflute)$B$G$9!#(B
>>>>>>
>>>>>> $[E-MAIL ADDRESS DELETED]$5$s!"$3$s$K$A$O(B
>>>>>>
>>>>>> $BHs>o$KNI$$%U%#!<%I%P%C%/$"$j$,$H$&$4$6$$$^$9!#(B
>>>>>> $B5.=E$J%a!<%k$H$J$j$=$&$G$9!#(B
>>>>>> $B$^$?!"$H$j$"$($:$J$,$[E-MAIL ADDRESS DELETED]$7$FNI$+$C$?$G$9!#(B
>>>>>>
>>>>>> 2008/8/29 hayakawa jiro <[E-MAIL ADDRESS DELETED]>:
>>>>>>>
>>>>>>> $B$*@$OC$K$J$C$F$*$j$^$9!#[E-MAIL ADDRESS DELETED]$G$9!#(B
>>>>>>>
>>>>>>> S2Dao.Net + SQL Server Compact Editon $B$NAH$_9g$o$;$G$NESCf7k2LJs9p$G$9!#(B 
>>>>>>>  $BESCf7k2LJs9p$H$7$F$O![E-MAIL ADDRESS DELETED]!W$G$9!#(B
>>>>>>> S2Dao.Net$B$N5!G=$N$&$A(BSelect$B$K4X$7$F$NABDL3NG'$,<h$l$^$7$?!#(B
>>>>>>>
>>>>>>> $B!J;d$?$A$N!K(BS2Dao.Net$B$NMxMQM=Dj5!G=$H$7$F(B
>>>>>>> (1)Select
>>>>>>> (2)Delete
>>>>>>> (3)Insert
>>>>>>> (4)$B30It(BSQL$B%U%!%$%k$N<B9T(B
>>>>>>> (5)$B%H%i%s%6%/%7%g%s@)8f(B
>>>>>>> $B$rM=Dj$7$F$*$j!"$"$H(B(2)$B!A(B(5)$B$NF0:n3NG'$,<h$l$l$P!"8!F$$O40N;$G$9!#(B
>>>>>>>
>>>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> seasar-dotnet mailing list
>>>>> [E-MAIL ADDRESS DELETED]
>>>>> https://ml.seasar.org/mailman/listinfo/seasar-dotnet
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Ryo Miyagi
>>>> _______________________________________________
>>>> seasar-dotnet mailing list
>>>> [E-MAIL ADDRESS DELETED]
>>>> https://ml.seasar.org/mailman/listinfo/seasar-dotnet
>>>
>>> _______________________________________________
>>> seasar-dotnet mailing list
>>> [E-MAIL ADDRESS DELETED]
>>> https://ml.seasar.org/mailman/listinfo/seasar-dotnet
>>>
>>
>>
>>
>> -- 
>> Ryo Miyagi
>> _______________________________________________
>> seasar-dotnet mailing list
>> [E-MAIL ADDRESS DELETED]
>> https://ml.seasar.org/mailman/listinfo/seasar-dotnet
>
> _______________________________________________
> seasar-dotnet mailing list
> [E-MAIL ADDRESS DELETED]
> https://ml.seasar.org/mailman/listinfo/seasar-dotnet 



seasar-dotnet メーリングリストの案内