Hai,<br><br>I understand the problem,my stored procedure is returning result set.<br>If my procedure returns result set i cant call through dbflute,am i correct?<br><br>Is there any other way to call my stored procedures?<br>
<br>Regards,<br>Thomas.<br><br><div class="gmail_quote">2010/6/9 kubo <span dir="ltr">&lt;<a href="mailto:dbflute@gmail.com" target="_blank">dbflute@gmail.com</a>&gt;</span><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">


Hello,<br>
<br>
(I changed the subject of this mail)<br>
<br>
&gt; i wnat to genrate procedure parameter bean,so i changed the<br>
&gt;<br>
&gt; isGenerateProcedureParameterBean = true<br>
&gt; isGenerateProcedureCustomizeEntity = true<br>
<br>
For starters, DBFlute.NET does not support a procedure<br>
that returns result set (result of select statement).<br>
(Java version only supports it)<br>
so you should set:<br>
isGenerateProcedureCustomizeEntity = false<br>
<br>
Then please use DBFlute.NET-0.8.9.17-03-SNAPSHOT<br>
and you can get more detail messages.<br>
<a href="http://dbflute.net.sandbox.seasar.org/ja/environment/newest.html" target="_blank">http://dbflute.net.sandbox.seasar.org/ja/environment/newest.html</a><br>
<br>
And the Exception is thrown by SQLServer JDBC driver.<br>
(An example except SQLException is thrown from the driver)<br>
Tell me what kind of JDBC driver you use,<br>
for example: sqljdbc.jar or sqljdbc4.jar<br>
<br>
and tell me what kind of procedure parameter you define,<br>
for example:<br>
<br>
create procedure dbo.SP_RETURN_RESULT_SET_WITH<br>
    @v_in_varchar varchar(10)<br>
    , @v_out_varchar varchar(10) output<br>
    , @v_inout_varchar varchar(10) output<br>
as<br>
  ...<br>
  return 1<br>
<br>
Because in my environment, this exception is not occurred.<br>
There is an example for DBFlute(Java) + SQLServer<br>
&quot;dbflute-sqlserver-example&quot; which also uses procedure<br>
parameter-bean generation without an exception.<br>
(Though this is for Java, the process of procedures<br>
is common between Java and C# versions)<br>
<br>
// Procedure statements for replace-schema task<br>
// of dbflute-sqlserver-example<br>
<a href="https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-sqlserver-example/dbflute_exampledb/playsql/replace-schema-50-procedure.sql" target="_blank">https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-sqlserver-example/dbflute_exampledb/playsql/replace-schema-50-procedure.sql</a><br>



<br>
But patterns of parameters in these examples is not many,<br>
so I want to know your parameter definitions.<br>
_______________________________________________<br>
seasar-dotnet mailing list<br>
<a href="mailto:seasar-dotnet@ml.seasar.org" target="_blank">seasar-dotnet@ml.seasar.org</a><br>
<a href="https://ml.seasar.org/mailman/listinfo/seasar-dotnet" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-dotnet</a><br>
</blockquote></div><br>