Firebird 2.0 config improvement
-------------------------------

                 Key: OFBIZ-1012
                 URL: https://issues.apache.org/jira/browse/OFBIZ-1012
             Project: OFBiz (The Open for Business Project)
          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.

Reply via email to