hello,
I am using MYSql with
JBOSS, but while running starting JBOSS it
gives
Connection refused error:
MySqlDB] at java.net.PlainSocketImpl.socketCon
MySqlDB] at java.net.PlainSocketImpl.doConnect
MySqlDB] at java.net.PlainSocketImpl.connectTo
MySqlDB] at java.net.PlainSocketImpl.connect(U
MySqlDB] at java.net.Socket.<init>(Unknown Sou
MySqlDB] at java.net.Socket.<init>(Unknown Sou
MySqlDB] at org.gjt.mm.mysql.MysqlIO.<init>(My
MySqlDB] at org.gjt.mm.mysql.jdbc2.IO.<init>(I
MySqlDB] at org.gjt.mm.mysql.jdbc2.Connection.
159)
MySqlDB] at org.gjt.mm.mysql.Connection.connec
MySqlDB] at org.gjt.mm.mysql.jdbc2.Connection.
va:89)
MySqlDB] at org.gjt.mm.mysql.Driver.connect(Dr
MySqlDB] at java.sql.DriverManager.getConnecti
MySqlDB] at java.sql.DriverManager.getConnecti
MySqlDB] at org.opentools.minerva.jdbc.xa.wrap
nnection(XADataSourceImpl.java:118)
MySqlDB] at org.opentools.minerva.jdbc.xa.wrap
nnection(XADataSourceImpl.java:151)
MySqlDB] at org.opentools.minerva.jdbc.xa.XACo
(XAConnectionFactory.java:246)
MySqlDB] at org.opentools.minerva.pool.ObjectP
ol.java:819)
MySqlDB] at org.opentools.minerva.pool.ObjectP
a:569)
MySqlDB] at org.opentools.minerva.pool.ObjectP
a:521)
MySqlDB] at org.opentools.minerva.jdbc.xa.XAPo
APoolDataSource.java:165)
MySqlDB] at org.jboss.jdbc.XADataSourceLoader.
der.java:330)
MySqlDB] at org.jboss.util.ServiceMBeanSupport
ava:93)
MySqlDB] at java.lang.reflect.Method.invoke(Na
MySqlDB] at com.sun.management.jmx.MBeanServer
java:1628)
MySqlDB] at com.sun.management.jmx.MBeanServer
java:1523)
MySqlDB] at org.jboss.util.ServiceControl.star
MySqlDB] at java.lang.reflect.Method.invoke(Na
MySqlDB] at com.sun.management.jmx.MBeanServer
java:1628)
MySqlDB] at com.sun.management.jmx.MBeanServer
java:1523)
MySqlDB] at org.jboss.Main.<init>(Main.java:21
MySqlDB] at org.jboss.Main$1.run(Main.java:121
MySqlDB] at java.security.AccessController.doP
MySqlDB] at org.jboss.Main.main(Main.java:117)
I used the following tag in in JBOSS.jacml
< !-- MYSQL -->
<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=MySqlDB">
<attribute name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="PoolName">MySqlDB</attribute>
<attribute name="URL">
jdbc:mysql://192.168.0.6/AccountingDb:3333</attribute>
<attribute name="Properties">DatabaseName=AccountingDb</attribute>
<attribute name="JDBCUser"></attribute>
<attribute name="Password"></attribute>
<attribute name="MinSize">0</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
</mbean>
< !-- END MYSQL -->
and JDBC tag is
< !-- JDBC -->
<mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider">
<attribute name="Drivers">org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,com.pervasive.jdbc.v2.Driver,org.gjt.mm.mysql.Driver</attribute>
</mbean>
plz help me out
thanks
bhuwam