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

kubo [E-MAIL ADDRESS DELETED]
2010年 6月 15日 (火) 17:08:51 JST


Hello, thomas

Please try DBFlute-0.9.7.2-00-SNAPSHOT.
http://dbflute.sandbox.seasar.org/ja/environment/newest.html

And specify a property in littleAdjustmentMap.dfprop
For example:
-> isSuppressNonCompilableConnectorLimiter = true

However several functions may not work
if you use the objects that have the connectors.
Only tests for basic patterns exist.
(Tests for various patterns don't exist)
(And a procedure's test about it does not exist)

// Basic Pattern Tests
// (Spring Framework + DBFlute + PostgreSQL)
https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-postgresql-example/src/test/java/com/example/dbflute/postgresql/dbflute/vendor/VendorNameTest.java
https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-postgresql-example/src/main/resources/com/example/dbflute/postgresql/dbflute/exbhv/various/vendorcheck/VendorCheckBhv_selectVendorUnsupportedAlias.sql

It's a restriction of non-compilable connectors.
So you should change the names if you can.

Basically DBFlute does not support
non-compilable connectors in table/column name.
So the property's default is false.
The exception occurs without setting it.


Thanks
Kubo (jflute)

2010/6/14 thomas <[E-MAIL ADDRESS DELETED]>:
> Hello Kubo さん、
>
> First i would like to say thanks for your new release.
> Now i am able to create java classes.
>
>
> One problem in my created java file is
>
> BsPmsPrUpdateProductionResultsSearchSpNotParamResult1.java
>
>
> in sqlserver procedure the variable with ' '(space) is accepted.When i run
> Sql2Entity,the
> created customize entity class i have the variable as
>
>  protected Integer _good Qty;
>
>     /** Hold Qty: {numeric(6)} */
>     protected Integer _hold Qty;
>
>     /** Total Qty: {numeric(6)} */
>     protected Integer _total Qty;
>
>
> ALTER PROCEDURE [dbo].[PMS_PR_Update_Production_Results_Search_SP]
> (
>  ----------
> ----------
> ---------
>
>
>
>     SELECT  PR_SNO             'pr_sno'
> ----
> -------
> -------
>
>         ,    PR_Good_Qty         'Good Qty'
>         ,    PR_Hold_Qty         'Hold Qty'
>         ,    PR_Total_Qty     'Total Qty'
>
>         ,   CONVERT(CHAR(10),PR_Prod_Date ,111)     'Proddate'
>     FROM    PMS_PR_Production_Result (NOLOCK)
>
>
>     ORDER BY PR_Prod_Date
>
>           ----------------
> ------------------
> -----------------
>
>
>     SET NOCOUNT OFF
>
> END
>
>
> I can remove the space in procedures.But i have already created lots of
> procedures like this.
> Is there any way i can configure this?
>
> Thanks,
> Thomas.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 2010/6/14 kubo <[E-MAIL ADDRESS DELETED]>
>>
>> Hello, thomas
>>
>> DBFlute-0.9.7.1 and DBFlute.NET-0.8.9.17 were released.
>> Thank you for your feedback. It helped me a lot!
>>
>> Please try the new version.
>> If other problems occur, I will fix them to the next version.
>>
>> 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
>
>


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