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
>