OFBiz › OFBiz - Dev

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

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

5 messages Options

Nicolas Malin (Jira)

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

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"
/>
 

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

Nicolas Malin (Jira)

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

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

Nicolas Malin (Jira)

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

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

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

Nicolas Malin (Jira)

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

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

Nicolas Malin (Jira)

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

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