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

kubo [E-MAIL ADDRESS DELETED]
2010年 6月 9日 (水) 18:15:24 JST


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 メーリングリストの案内