[seasar-dotnet:1712] Re: [dbflute Procedure Generation Error]

[thomas]

Hai,

I understand the problem,my stored procedure is returning result set.
If my procedure returns result set i cant call through dbflute,am i correct?

Is there any other way to call my stored procedures?

Regards,
Thomas.

2010/6/9 kubo <[E-MAIL ADDRESS DELETED]>

> Hello,
>
> (I changed the subject of this mail)
>
> > i wnat to genrate procedure parameter bean,so i changed the
> >
> > isGenerateProcedureParameterBean = true
> > isGenerateProcedureCustomizeEntity = true
>
> For starters, DBFlute.NET does not support a procedure
> that returns result set (result of select statement).
> (Java version only supports it)
> so you should set:
> isGenerateProcedureCustomizeEntity = false
>
> Then please use DBFlute.NET-0.8.9.17-03-SNAPSHOT
> and you can get more detail messages.
> http://dbflute.net.sandbox.seasar.org/ja/environment/newest.html
>
> And the Exception is thrown by SQLServer JDBC driver.
> (An example except SQLException is thrown from the driver)
> Tell me what kind of JDBC driver you use,
> for example: sqljdbc.jar or sqljdbc4.jar
>
> and tell me what kind of procedure parameter you define,
> for example:
>
> create procedure dbo.SP_RETURN_RESULT_SET_WITH
>    @v_in_varchar varchar(10)
>    , @v_out_varchar varchar(10) output
>    , @v_inout_varchar varchar(10) output
> as
>  ...
>  return 1
>
> Because in my environment, this exception is not occurred.
> There is an example for DBFlute(Java) + SQLServer
> "dbflute-sqlserver-example" which also uses procedure
> parameter-bean generation without an exception.
> (Though this is for Java, the process of procedures
> is common between Java and C# versions)
>
> // Procedure statements for replace-schema task
> // of dbflute-sqlserver-example
>
> https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-sqlserver-example/dbflute_exampledb/playsql/replace-schema-50-procedure.sql
>
> But patterns of parameters in these examples is not many,
> so I want to know your parameter definitions.
> _______________________________________________
> seasar-dotnet mailing list
> [E-MAIL ADDRESS DELETED]
> https://ml.seasar.org/mailman/listinfo/seasar-dotnet
>
-------------- next part --------------
HTML$B$NE:IU%U%!%$%k$rJ]4I$7$^$7$?(B...
URL: <http://ml.seasar.org/archives/seasar-dotnet/attachments/20100610/1802866b/attachment.html>