Help on JDBC:ODBC MS Access problem.

[shaun]

I have JBoss-2.4.4_Tomcat-3.2.3 on NT running jdk1.4.0 and try and access a MS Access database on seperate machine. The ODBC connection to the database is known as Shaun.

I have


sun.jdbc.odbc.JdbcOdbcDriver



org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
InterBaseDS
jdbc:odbc:ODBC Shaun
username
password



in jboss.jcml as reccommended by the documentation. When I run JBoss I get the following exceptions:

[16:53:36,515,InterBaseDS] Stopped
java.lang.NullPointerException
at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(Unknown Source)
at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:412)
at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:967)
at $Proxy0.start(Unknown Source)
at org.jboss.util.ServiceControl.start(ServiceControl.java:79)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.Main.(Main.java:208)
at org.jboss.Main$1.run(Main.java:110)
at java.security.AccessController.doPrivileged(Native Method)
at org.jboss.Main.main(Main.java:106)
[16:53:36,531,ConfigurationService] Unexpected error
java.lang.NullPointerException
at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(Unknown Source)
at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:412)
at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:967)
at $Proxy0.start(Unknown Source)
at org.jboss.util.ServiceControl.start(ServiceControl.java:79)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.Main.(Main.java:208)
at org.jboss.Main$1.run(Main.java:110)
at java.security.AccessController.doPrivileged(Native Method)
at org.jboss.Main.main(Main.java:106)


Any sugestions?
Many Thanks,

Shaun

[shaun]

The same thing occurs if I set:




in jboss.jcml :(

Somebody must have done this and got it working? :)

Shaun

[chrishoskins]

Hi Shaun

I'm getting exactly the same problem. Have you made any progress on this yet.

Regards, Chris.

[davidjencks]

This usually means your url is wrong. It looks like it has a space in it, something I've never seen before.

I have read repeatedly that jdbc:odbc is not suitable for production use, but never tried it. You may need to set maxSize=1.

If you don't have legacy data already in access, use a different db such as firebird, postgres, or mysql. If you do, consider moving it to an alternative db.

[chrishoskins]

Thanks for the message David.

I've tried a variety of URL's (with no spaces in them), and setting maxsize to 1.

Unfortunately I am still getting the same exception.

Whilst it is possible to convert the data to MySQL etc, this would also impact other systems so its not really an option - a connection to Access would be very useful.

I am intruiged as to why its failing when what I am doing seems to as prescibed in the manual.

Any other suggestions would be gratefully accepted!

Thanks, Chris.

[davidjencks]

Have you checked your exact URL with a standalone non jboss program to make certain that it is correct?

[shaun]

No progress made with MS Access. I decided to install MySQL instead and use that.

Shaun