Hello Kubo さん、 In the following link its mentioned that the test values for date type is passed as '2010-03-31 12:34:56' <a href="http://dbflute.sandbox.seasar.org/ja/manual/function/generator/task/sql2entity/procedurepmb.html#resultsethandling">http://dbflute.sandbox.seasar.org/ja/manual/function/generator/task/sql2entity/procedurepmb.html#resultsethandling</a> when i run Sql2Entity its trying to assign 0 for date parameter.so i got "converting data type nvarchar to date" Error. Is this my procedure problem?Or i have to do some other settings? Thanks, Thomas 2010-06-11 14:56:41,578 [main] INFO (DfProcedureExecutionMetaExtractor#doExtractExecutionMetaData():100) - ...Calling: {? = call PMS_COM_MONTH_CLOSE_CHECK_FN(?, ?, ?)} 2010-06-11 14:56:41,578 [main] INFO (DfProcedureExecutionMetaExtractor#doExtractExecutionMetaData():123) - (x) retry: ? = call PMS_COM_MONTH_CLOSE_CHECK_FN(?, ?, ?) 2010-06-11 14:56:41,578 [main] INFO (DfProcedureExecutionMetaExtractor#doExtractExecutionMetaData():177) - *Failed to execute the procedure for getting meta data: {? = call PMS_COM_MONTH_CLOSE_CHECK_FN(?, ?, ?)} @RETURN_VALUE: int(10) as Return @Date: date(10) as In @Fiscal_year: int(10) as In @Fiscal_month: int(10) as In test values = [0, 0, 0] Error converting data type nvarchar to date. <div class="gmail_quote"> On Fri, Jun 11, 2010 at 2:40 PM, kubo <<a href="mailto:dbflute@gmail.com">dbflute@gmail.com</a>> wrote: <blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"> Good afternoon, thomas Success: <div class="im"> DBFLUTE_CLIENT: {dfclient} database = mssql (Microsoft SQL Server 10.00.1600) </div>Failure: DBFLUTE_CLIENT: {dfclient} database = h2 (Microsoft SQL Server 10.00.1600) Change the database type "h2 to mssql" at "dfprop/basicInfoMap.dfprop". And when you upgrade DBFlute, you don't need to remake DBFlute client directory. {Pattern 1} /= = = = = = = = = = = = = = = = = = = = = = = = = = dbflute_dfclient |-dfprop // no change |-_project.bat // *change the path to new version |-_project.sh // *change the path to new version |-...others // no change mydbflute |-dbflute-0.9.7.1-06-SNAPSHOT |-dbflute-0.9.7.1-07-SNAPSHOT // *put new module here ex) _project.sh export DBFLUTE_HOME=../mydbflute/dbflute-0.9.7.1-06-SNAPSHOT to export DBFLUTE_HOME=../mydbflute/dbflute-0.9.7.1-07-SNAPSHOT = = = = = = = = = =/ {Pattern 2} = = = = = = = = = = = = = = = = = = = = = = = = = = = = dbflute_dfclient |-dfprop // no change |-_project.bat // no change (to 0.9.7.1) |-_project.sh // no change (to 0.9.7.1) |-...others // no change mydbflute |-dbflute-0.9.7.1 // *override all files = = = = = = = = = =/ 2010/6/11 thomas <<a href="mailto:jp.mcy.10@gmail.com">jp.mcy.10@gmail.com</a>>: <div><div></div><div class="h5">> 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 <<a href="mailto:dbflute@gmail.com">dbflute@gmail.com</a>> >> >> 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) >> _______________________________________________ >> 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> > > > _______________________________________________ > 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> > > _______________________________________________ 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>