jdbc-odbc url is in the form
jdbc:odbc:<datasource_name>, so if you used
jdbc:odbc:jdbc_odbc then you should have a datasource
named jdbc_odbc
i think you should specify the username and password
in the attributes "JDBCUser" and "Password" attribute,
otherwise how will the container connect for CMP
beans? anyone care to verify?
hope this helps.
--- [EMAIL PROTECTED] wrote:
> 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.
>
>
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user