You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by chitrakala ramanujam <ne...@rediffmail.com> on 2007/02/21 06:13:18 UTC
Quick Shipment Order
Hi,
Thanks Jacques to your reply and to vamsi also. But DB connection is correct i think. I have given my DB connection, still im getting the same error.
<datasource name="localmysql"
helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
field-type-name="mysql"
check-on-start="true"
add-missing-on-start="true"
check-pks-on-start="false"
use-foreign-keys="true"
join-style="ansi-no-parenthesis"
alias-view-columns="true"
drop-fk-use-foreign-key-keyword="true"
table-type="InnoDB"
character-set="latin1"
collate="latin1_general_cs">
<read-data reader-name="seed"/>
<read-data reader-name="demo"/>
<read-data reader-name="ext"/>
<inline-jdbc
jdbc-driver="com.mysql.jdbc.Driver"
jdbc-uri="jdbc:mysql://127.0.0.1/lcptt?autoReconnect=true"
jdbc-username="ofbiz_lc_user"
jdbc-password="LC1!"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="20"/>
<!-- <jndi-jdbc jndi-server-name="localjndi" jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> -->
</datasource>
<datasource name="odbcmysql"
helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
field-type-name="mysql"
check-on-start="true"
add-missing-on-start="true"
check-pks-on-start="false"
use-foreign-keys="true"
join-style="ansi-no-parenthesis"
alias-view-columns="true"
drop-fk-use-foreign-key-keyword="true"
table-type="InnoDB"
character-set="latin1"
collate="latin1_general_cs">
<read-data reader-name="seed"/>
<inline-jdbc
jdbc-driver="com.mysql.jdbc.Driver"
jdbc-uri="jdbc:mysql://127.0.0.1/lcptt?autoReconnect=true"
jdbc-username="ofbiz_lc_user"
jdbc-password="LC1!"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="20"/>
<!-- <jndi-jdbc jndi-server-name="localjndi" jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> -->
</datasource>
Thanks.
chitrakala. R
Re: Quick Shipment Order
Posted by Vamsi Gmail! <va...@gmail.com>.
hi,
Please verify this one also
<delegator name="default" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="localmysql"/>
look at this one==> <group-map group-name="org.ofbiz.odbc"
datasource-name="odbcmysql"/>
</delegator>
regards
vamsi
look at the second one may be that one is commented
On 21 Feb 2007 05:13:18 -0000, chitrakala ramanujam <
netizenck@rediffmail.com> wrote:
>
> Hi,
>
> Thanks Jacques to your reply and to vamsi also. But DB connection is
> correct i think. I have given my DB connection, still im getting the same
> error.
>
>
>
> <datasource name="localmysql"
> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> field-type-name="mysql"
> check-on-start="true"
> add-missing-on-start="true"
> check-pks-on-start="false"
> use-foreign-keys="true"
> join-style="ansi-no-parenthesis"
> alias-view-columns="true"
> drop-fk-use-foreign-key-keyword="true"
> table-type="InnoDB"
> character-set="latin1"
> collate="latin1_general_cs">
> <read-data reader-name="seed"/>
> <read-data reader-name="demo"/>
> <read-data reader-name="ext"/>
> <inline-jdbc
> jdbc-driver="com.mysql.jdbc.Driver"
> jdbc-uri="jdbc:mysql://127.0.0.1/lcptt?autoReconnect=true"
> jdbc-username="ofbiz_lc_user"
> jdbc-password="LC1!"
> isolation-level="ReadCommitted"
> pool-minsize="2"
> pool-maxsize="20"/>
> <!-- <jndi-jdbc jndi-server-name="localjndi"
> jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> -->
> </datasource>
>
> <datasource name="odbcmysql"
> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> field-type-name="mysql"
> check-on-start="true"
> add-missing-on-start="true"
> check-pks-on-start="false"
> use-foreign-keys="true"
> join-style="ansi-no-parenthesis"
> alias-view-columns="true"
> drop-fk-use-foreign-key-keyword="true"
> table-type="InnoDB"
> character-set="latin1"
> collate="latin1_general_cs">
> <read-data reader-name="seed"/>
> <inline-jdbc
> jdbc-driver="com.mysql.jdbc.Driver"
> jdbc-uri="jdbc:mysql://127.0.0.1/lcptt?autoReconnect=true"
> jdbc-username="ofbiz_lc_user"
> jdbc-password="LC1!"
> isolation-level="ReadCommitted"
> pool-minsize="2"
> pool-maxsize="20"/>
> <!-- <jndi-jdbc jndi-server-name="localjndi"
> jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> -->
> </datasource>
>
>
> Thanks.
> chitrakala. R
>