Would someone enlighten me as to what I'm doing wrong.
I'm currently accessing a MS Access db in Weblogic through Sun's jdbc-odbc driver.
Works great for Weblogic, just want to do it now through JBoss.
I've tried to configure JBoss to do the same, but when it starts up, it hangs
at the point it's doing "it's thing" with that db connection. No errors, just
hangs right after the "[Hypersonic] Press [CTRL] + [C] to abort" message.
I'm using Jboss 2.2.1 and Jetty that matched (3.1-RC4??).
From the jboss.jcml file:
<mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider">
<attribute name="Drivers">sun.jdbc.odbc.JdbcOdbcDriver</attribute>
</mbean>
<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=ipac_admin">
<attribute name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="PoolName">ipac_admin</attribute>
<attribute name="URL">jdbc:odbc:jboss_odbc</attribute>
<attribute name="JDBCUser"></attribute>
<attribute name="Password"></attribute>
</mbean>
ipac_admin is the db I'm trying to hit and is setup under the same name as the DSN to hit it through ODBC.
For Weblogic, the URL is "jdbc:odbc:ipac_admin", instead of "jdbc:odbc:jboss_odbc" as shown above - found that in some JBoss
docs somewhere. And for Weblogic, the user and password are both set to "none" - I left them blank as shown above because they aren't
set to anything. I've even tried putting "none" in for both, but it still hangs.
Granted, I know that's Sun's driver isn't the best, but I'm just doing this for quick development work and I haven't found anything
that says it doesn't work.
Robert Price
epixtech, inc.
- Re: [JBoss-user] JDBC-ODBC to Access DB not working R . Price
- Re: [JBoss-user] JDBC-ODBC to Access DB not working Dexter Legaspi
