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

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

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

Nicolas Malin (Jira)
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 | Threaded
Open this post in threaded view
|

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

Nicolas Malin (Jira)

    [ 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.

Reply | Threaded
Open this post in threaded view
|

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

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

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

Derryck Welas commented on OFBIZ-1012:
--------------------------------------

Hi Jacopo,
   
  I dont see anyone reacting, seems i'm the only one using FB with ofbiz (-:
   
  If possible please commit  , it makes life easier.
   
  Regards,
  Derryck
   
 

"Jacopo Cappellato (JIRA)" <[hidden email]> a écrit :
 
[ 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?



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



       
---------------------------------
 Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail


> 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.

Reply | Threaded
Open this post in threaded view
|

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

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

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

Jacopo Cappellato reassigned OFBIZ-1012:
----------------------------------------

    Assignee: Jacopo Cappellato

> 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
>            Assignee: Jacopo Cappellato
>
> 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 | Threaded
Open this post in threaded view
|

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

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

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

Jacques Le Roux closed OFBIZ-1012.
----------------------------------

       Resolution: Fixed
    Fix Version/s: SVN trunk
         Assignee: Jacques Le Roux  (was: Jacopo Cappellato)

I kept as comment old jdbc and login/pwd configuration (seems to be not platform independent)

Commited in trunk revision: 594077 (I was not able to automatically merge in release4.0)


> 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
>            Assignee: Jacques Le Roux
>             Fix For: SVN trunk
>
>
> 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.