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. <div class="gmail_quote">2010/6/11 kubo <<a href="mailto:dbflute@gmail.com">dbflute@gmail.com</a>> <blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"> 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: <a href="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" target="_blank">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</a> /= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = -- #df:entity# -- !df:pmb! -- !!String memberStatusCode:cls(MemberStatus)!! SP_RETURN_RESULT_SET_MORE @statusCode=/*$pmb.memberStatusCode*/'WDL' = = = = = = = = = =/ <a href="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" target="_blank">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</a> /= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = -- #df:entity# -- !df:pmb! -- !!String memberStatusCode:cls(MemberStatus)!! select * from FN_RETURN_TABLE(/*pmb.memberStatusCode*/'FML') = = = = = = = = = =/ <a href="https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-sqlserver-example/src/test/java/com/example/dbflute/sqlserver/dbflute/topic/ProcedureTest.java" target="_blank">https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-sqlserver-example/src/test/java/com/example/dbflute/sqlserver/dbflute/topic/ProcedureTest.java</a> /= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 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) <div><div></div><div class="h5">_______________________________________________ seasar-dotnet mailing list <a href="mailto:seasar-dotnet@ml.seasar.org">seasar-dotnet@ml.seasar.org</a> <a href="https://ml.seasar.org/mailman/listinfo/seasar-dotnet" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-dotnet</a> </div></div></blockquote></div>