You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by KentP <kp...@yahoo.com> on 2008/08/16 09:09:34 UTC
ODBC Connection
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!!!!!!!
--
View this message in context: http://www.nabble.com/ODBC-Connection-tp19009308p19009308.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: ODBC Connection
Posted by BJ Freeman <bj...@free-man.net>.
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!!!!!!!
>