[jira] Commented: (OFBIZ-1012) Firebird 2.0 config improvement

["Jacopo Cappellato (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OFBIZ-1012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12527422 ] 

Jacopo Cappellato commented on OFBIZ-1012:
------------------------------------------

Can we commit this change?
Are there other users that have tested these settings in Firebird?


> Firebird 2.0 config improvement
> -------------------------------
>
>                 Key: OFBIZ-1012
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1012
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: SVN trunk
>         Environment: Windows / Linux
>            Reporter: Derryck Welas
>
> Hi,
> I have ofbiz/trunk  running with Firebird 2.0 
> but there are some small changes needed in the config files .
> can someone commit this into the trunk.
> 1)   in file "fieldtypefirebird.xml", change sql-type for blob and very-long
>  
> <field-type-def type="blob" sql-type="BLOB SUB_TYPE 2" java-type="java.lang.Object"></field-type-def>
> <field-type-def type="very-long" sql-type="BLOB SUB_TYPE 1" java-type="String"></field-type-def>
> 2)  in file "entityengine.xml",  change:
>     <datasource name="localfirebird"
>             helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
>             field-type-name="firebird"
>             check-on-start="true"
>             use-foreign-key-indices="false"
>             add-missing-on-start="true"
>             alias-view-columns="false"
>             join-style="ansi">
>         <read-data reader-name="seed"/>
>         <read-data reader-name="demo"/>
>         <read-data reader-name="ext"/>
>         <inline-jdbc
>                 jdbc-driver="org.firebirdsql.jdbc.FBDriver"
>                 jdbc-uri="jdbc:firebirdsql:127.0.0.1:C:\\data\\ofbiz.gdb"
>                 jdbc-username="SYSDBA"
>                 jdbc-password="masterkey"
>                 isolation-level="ReadCommitted"
>                 pool-minsize="2"
>                 pool-maxsize="250"
>                  />
>         <!-- <jndi-jdbc jndi-server-name="default" jndi-name="comp/env/jdbc/xa/localfirebird" isolation-level="ReadCommitted"/> --> <!-- Orion Style JNDI name -->
>         <!-- <tyrex-dataSource dataSource-name="firebird" isolation-level="ReadCommitted"/>  -->
>     </datasource>
> after these changes you should be able to run  ant "run-install" without a problem.
> Regards,
> Derryck

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.