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
[EMAIL PROTECTED]:/etc/unixODBC
> cd ODBC*
[EMAIL PROTECTED]:/etc/unixODBC/ODBCDataSources
> ls -l
total 0
[EMAIL PROTECTED]:/etc/unixODBC/ODBCDataSources
> cd ..
[EMAIL PROTECTED]:/etc/unixODBC
> isql -v ofbiz_odbc ofbiz forest14
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> quit
[EMAIL PROTECTED]:/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.
