4 Replies Latest reply on Sep 25, 2001 6:34 AM by Frank Stolte

    Jboss talking to MySQL over the network

    Frank Stolte Newbie

      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