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

[kubo]

Good afternoon, thomas

Success:

  DBFLUTE_CLIENT: {dfclient}
    database  = mssql (Microsoft SQL Server 10.00.1600)

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 <[E-MAIL ADDRESS DELETED]>:
> 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
>
>
> _______________________________________________
> seasar-dotnet mailing list
> [E-MAIL ADDRESS DELETED]
> https://ml.seasar.org/mailman/listinfo/seasar-dotnet
>
>