ODBC Connection

[KentP]

I have used ODBCConfig to create a mysql odbc connector. I then changed entityengine.zml to use the mysql odbc connection. When I execute ant run-install I am seeing error messages stating that ofbiz can't connect to the database. Obviously I am doing something wrong either in ofbiz or in my setup of the odbc connection using ODBCConfig or it's enabling. Are there any tutorials on setting up an odbc connection on opensuse and using it to access an ofbiz database on another server. Here is the entityengine.xml:

</datasource>
    <datasource name="odbcmysql"
            helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
            field-type-name="mysql"
            check-on-start="true"
            add-missing-on-start="false"
            check-pks-on-start="false"
            use-foreign-keys="true"
            join-style="ansi-no-parenthesis"
            alias-view-columns="false"
            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/ofbiz_odbc?autoReconnect=true"
                jdbc-username="ofbiz"
                jdbc-password="forest14"
                isolation-level="ReadCommitted"
                pool-minsize="2"
                pool-maxsize="20"/>
       
    </datasource>

Here is unizODBC output:

rwxr-xr-x 2 root root 4096 Jun  6  2008 ODBCDataSources
-rw-r--r-- 1 root root  214 Aug 15 13:21 odbc.ini
-rw-r--r-- 1 root root  221 Aug 14 23:38 odbcinst.ini
root@linux-o2bm:/etc/unixODBC
> cd ODBC*
root@linux-o2bm:/etc/unixODBC/ODBCDataSources
> ls -l
total 0
root@linux-o2bm:/etc/unixODBC/ODBCDataSources
> cd ..
root@linux-o2bm:/etc/unixODBC
> isql -v ofbiz_odbc ofbiz forest14
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> quit
root@linux-o2bm:/etc/unixODBC
> ls -aF
./  ../  ODBCDataSources/  odbc.ini  odbcinst.ini


The isql portion of unixODBC seems to show that the ofbiz odbc connection is active but ofbiz can not seen to connect to this odbc connection. Please Help!!!!!!!

[BJ Freeman]

your
dbc-uri="jdbc:mysql://127.0.0.1/ofbiz_odbc?autoReconnect=true"
is pointing to your local server
it has to have the ip of the remote sever
and they should be on the same network.
the database
the
jdbc-driver="com.mysql.jdbc.Driver"
does not use outside odbc protocols.



KentP sent the following on 8/16/2008 12:09 AM:

> I have used ODBCConfig to create a mysql odbc connector. I then changed
> entityengine.zml to use the mysql odbc connection. When I execute ant
> run-install I am seeing error messages stating that ofbiz can't connect to
> the database. Obviously I am doing something wrong either in ofbiz or in my
> setup of the odbc connection using ODBCConfig or it's enabling. Are there
> any tutorials on setting up an odbc connection on opensuse and using it to
> access an ofbiz database on another server. Here is the entityengine.xml:
>
> </datasource>
>     <datasource name="odbcmysql"
>             helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
>             field-type-name="mysql"
>             check-on-start="true"
>             add-missing-on-start="false"
>             check-pks-on-start="false"
>             use-foreign-keys="true"
>             join-style="ansi-no-parenthesis"
>             alias-view-columns="false"
>             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/ofbiz_odbc?autoReconnect=true"
>                 jdbc-username="ofbiz"
>                 jdbc-password="forest14"
>                 isolation-level="ReadCommitted"
>                 pool-minsize="2"
>                 pool-maxsize="20"/>
>         <!-- <jndi-jdbc jndi-server-name="localjndi"
> jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> -->
>     </datasource>
>
> Here is unizODBC output:
>
> rwxr-xr-x 2 root root 4096 Jun  6  2008 ODBCDataSources
> -rw-r--r-- 1 root root  214 Aug 15 13:21 odbc.ini
> -rw-r--r-- 1 root root  221 Aug 14 23:38 odbcinst.ini
> root@linux-o2bm:/etc/unixODBC
>> cd ODBC*
> root@linux-o2bm:/etc/unixODBC/ODBCDataSources
>> ls -l
> total 0
> root@linux-o2bm:/etc/unixODBC/ODBCDataSources
>> cd ..
> root@linux-o2bm:/etc/unixODBC
>> isql -v ofbiz_odbc ofbiz forest14
> +---------------------------------------+
> | Connected!                            |
> |                                       |
> | sql-statement                         |
> | help [tablename]                      |
> | quit                                  |
> |                                       |
> +---------------------------------------+
> SQL> quit
> root@linux-o2bm:/etc/unixODBC
>> ls -aF
> ./  ../  ODBCDataSources/  odbc.ini  odbcinst.ini
>
>
> The isql portion of unixODBC seems to show that the ofbiz odbc connection is
> active but ofbiz can not seen to connect to this odbc connection. Please
> Help!!!!!!!
>