[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 メーリングリストの案内