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

thomas [E-MAIL ADDRESS DELETED]
2010年 6月 11日 (金) 14:19:16 JST


Hello Kubo さん、

I downloaded the DBFlute-0.9.7.1-07-SNAPSHOT and i tried,its not connected
to the database itself.

while running jdbc.bat file the connection failed.

If i use DBFlute-0.9.7.1-06-SNAPSHOT it is connecting.I am using same
connection String

*jdbc:sqlserver://localhost;DatabaseName=MYTEST*

and i am using *sqljdbc4.jar.*

I have attached the log file for both versions.

What i am doing wrong here?

Thanks,
Tomas.

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

> Good morning, thomas
>
> I've got it! Thank you.
> I remembered SQLServer's function
> and it can return a table type.
>
> I could get the same exception in my environment.
> I'm surprised:
>
> The method, getString("DATA_TYPE")
> of DatabaseMetaData.getProcedureColumns(),
> throws NumberFormatException from JDBC driver
> (getInt("DATA_TYPE") throws NullPointerException)
> if it's SQLServer's function that returns a table type.
>
> Please use DBFlute-0.9.7.1-07-SNAPSHOT
> which is fixed about it.
> (if the Exception occurred, DBFlute ignores it)
> And also DBFlute.NET-0.8.9.17-07-SNAPSHOT
> is fixed about it.
>
> By the way, I remembered how to call procedures through outside-SQL.
> If a procedure has no OUT parameter, you can call like this:
>
>
> https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-sqlserver-example/src/main/resources/com/example/dbflute/sqlserver/dbflute/exbhv/various/vendorcheck/VendorCheckBhv_callProcReturnResultSetMore.sql
> /= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> -- #df:entity#
>
> -- !df:pmb!
> -- !!String memberStatusCode:cls(MemberStatus)!!
>
> SP_RETURN_RESULT_SET_MORE @statusCode=/*$pmb.memberStatusCode*/'WDL'
> = = = = = = = = = =/
>
>
> https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-sqlserver-example/src/main/resources/com/example/dbflute/sqlserver/dbflute/exbhv/various/vendorcheck/VendorCheckBhv_selectSimpleTableFunction.sql
> /= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> -- #df:entity#
>
> -- !df:pmb!
> -- !!String memberStatusCode:cls(MemberStatus)!!
>
> select * from FN_RETURN_TABLE(/*pmb.memberStatusCode*/'FML')
> = = = = = = = = = =/
>
>
> https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-sqlserver-example/src/test/java/com/example/dbflute/sqlserver/dbflute/topic/ProcedureTest.java
> /= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> String path =
> VendorCheckBhv.PATH_various_vendorcheck_callProcReturnResultSetMore;
> ProcReturnResultSetMorePmb pmb = new ProcReturnResultSetMorePmb();
> pmb.setMemberStatusCode_Formalized();
> Class<ProcReturnResultSetMore> entityType = ProcReturnResultSetMore.class;
>
> ListResultBean<ProcReturnResultSetMore> memberList
>    = vendorCheckBhv.outsideSql().selectList(path, pmb, entityType);
>
> // If you don't use OUT parameter, you can call procedures like this.
> // But you cannot get second result set. (first result set only)
> = = = = = = = = = =/
> /= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> String path =
> VendorCheckBhv.PATH_various_vendorcheck_callProcReturnResultSetMore;
> SimpleTableFunctionPmb pmb = new SimpleTableFunctionPmb();
> pmb.setMemberStatusCode_Formalized();
> Class<SimpleTableFunction> entityType = SimpleTableFunction.class;
>
> // ## Act ##
> ListResultBean<SimpleTableFunction> memberList =
> vendorCheckBhv.outsideSql().selectList(path, pmb, entityType);
> = = = = = = = = = =/
>
> However I didn't confirm it in DBFlute.NET environment.
> (It works in DBFlute(Java) environment)
>
>
> Thanks,
> Kubo (jflute)
> _______________________________________________
> 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/20100611/6d15332d/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: dbflute(dbflute-0.9.7.1-06-SNAPSHOT).log
Type: application/octet-stream
Size: 5985 bytes
Desc: $BL5$7(B
URL: <http://ml.seasar.org/archives/seasar-dotnet/attachments/20100611/6d15332d/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: dbflute(dbflute-0.9.7.1-07-SNAPSHOT).log
Type: application/octet-stream
Size: 6944 bytes
Desc: $BL5$7(B
URL: <http://ml.seasar.org/archives/seasar-dotnet/attachments/20100611/6d15332d/attachment-0001.obj>


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