Jboss talking to MySQL over the network

[frankstolte]

I’m using Windows 2000 professional, JDK 1.3.1, JBoss-2.4/Jetty-3.1 and MySQL 3.23 plus mm.mysql-2.0.6 JDBC driver.

I want to connect to my MySQL database on another machine on the network. By using the MySQLGUI tool I can access the database.

Using the following settings in jboss. jcml


mySQLDS
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
mySQLDS
jdbc:mysql://192.168.181.253:3306/betting
admin
admin
0



I get the following error when starting JBoss

[mySQLDS] XA Connection pool mySQLDS bound to java:/mySQLDS
[XADataSourceLoader] Stopped
[Configuration] java.lang.NullPointerException
[Configuration] at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection
(XAPoolDataSource.java:165)
[Configuration] at org.jboss.jdbc.XADataSourceLoader.startService(XAData
SourceLoader.java:330)
[Configuration] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBean
Support.java:106)
[Configuration] at java.lang.reflect.Method.invoke(Native Method)
[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
rverImpl.java:1628)
[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
rverImpl.java:1523)
[Configuration] at org.jboss.configuration.ConfigurationService$ServiceP
roxy.invoke(ConfigurationService.java:831)
[Configuration] at $Proxy0.start(Unknown Source)
[Configuration] at org.jboss.util.ServiceControl.start(ServiceControl.ja
va:81)
[Configuration] at java.lang.reflect.Method.invoke(Native Method)
[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
rverImpl.java:1628)
[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
rverImpl.java:1523)
[Configuration] at org.jboss.Main.(Main.java:209)
[Configuration] at org.jboss.Main$1.run(Main.java:115)
[Configuration] at java.security.AccessController.doPrivileged(Native Me
thod)
[Configuration] at org.jboss.Main.main(Main.java:111)
[ServerDataCollector] Starting
[ServerDataCollector] JBoss Management Service 'servercollector' bound to server
collector
[ServerDataCollector] Started

I think I might have to set some access rights.

Thanks for the help.

Frank

[fbiaggi]

Try to change the line to:

org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl

[juanje]

This class is only under JBoss 2.2.2, i've the same problem with the same db. Anyway i've changed this line and the problem persists

[juanje]

Sorry, after reply i've seen the same problem and the solution. see http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=forums/

[frankstolte]

It is me again.

My setup works if I'm using localhost, but if I use an IP address the problem starts this is the crucial line

jdbc:mysql://192.168.181.253:3306/betting

in the jboss.jcml file.

I now believe te problem lies in access rights of the JBoss main class. Here again the error message

[Configuration] at org.jboss.Main.(Main.java:209)
[Configuration] at org.jboss.Main$1.run(Main.java:115)
[Configuration] at java.security.AccessController.doPrivileged(Native Me
thod)

I already put in my java.policy file the following

grant codeBase "file:D:/JBoss-2.4_Jetty-3.1/jboss/bin/*" {
permission java.security.AllPermission;
};

but it made no difference.

Frank