You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Derryck Welas (JIRA)" <ji...@apache.org> on 2007/05/23 14:46:16 UTC
[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"
/>
<!-- <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.
[jira] Commented: (OFBIZ-1012) Firebird 2.0 config improvement
Posted by "Derryck Welas (JIRA)" <ji...@apache.org>.
[ 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)" <ji...@apache.org> 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.
[jira] Assigned: (OFBIZ-1012) Firebird 2.0 config improvement
Posted by "Jacopo Cappellato (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Closed: (OFBIZ-1012) Firebird 2.0 config improvement
Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Commented: (OFBIZ-1012) Firebird 2.0 config improvement
Posted by "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.