1 Reply Latest reply on Sep 8, 2015 10:26 AM by albatrozdv

    JBossResourceException-Connection is broken

    albatrozdv
    albatrozdv Sep 7, 2015 8:03 PM

      Hi , it's the first time I am using Jboss and I have some issues that drives me crazy . I am using an old jdk 1.4 (don´t ask why, I just have to) , also  I am using eclipse 3.1.2 and Jboss ide 3.2.2. I am trying to run only the Jboss server (not the java project) but it throws some exceptions : 

       

      [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection:

      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Connection is broken: Connection refused: connect)

      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:153)

      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:372)

      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:185)

      at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:459)

      at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:417)

      at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:317)

      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:469)

      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:800)

      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)

      at org.jboss.mq.pm.jdbc2.PersistenceManager.getConnection(PersistenceManager.java:1225)

      ...

      Caused by: java.sql.SQLException: Connection is broken: Connection refused: connect

      at org.hsqldb.Trace.getError(Unknown Source)

      at org.hsqldb.Trace.error(Unknown Source)

      at org.hsqldb.jdbcConnection.reconnectHSQL(Unknown Source)

      at org.hsqldb.jdbcConnection.openHSQL(Unknown Source)

      at org.hsqldb.jdbcConnection.<init>(Unknown Source)

      at org.hsqldb.jdbcDriver.connect(Unknown Source)

      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:143)

      ... 78 more

       

      Also Throws :

       

      java.lang.NoClassDefFoundError: javax/sql/rowset/CachedRowSet

      at java.lang.Class.getDeclaredMethods0(Native Method)

      at java.lang.Class.privateGetDeclaredMethods(Class.java:1647)

      at java.lang.Class.privateGetPublicMethods(Class.java:1770)

      at java.lang.Class.getMethods(Class.java:824)

      at org.jboss.verifier.strategy.AbstractVerifier.hasEJBCreateMethod(AbstractVerifier.java:688)

      at org.jboss.verifier.strategy.EJBVerifier20.verifySessionBean(EJBVerifier20.java:1037)

      at org.jboss.verifier.strategy.EJBVerifier20.checkSession(EJBVerifier20.java:92)

      at org.jboss.verifier.BeanVerifier.verify(BeanVerifier.java:159)

      at org.jboss.ejb.EJBDeployer.create(EJBDeployer.java:475)

      ...

       

      My sybase-ds.xml contains:

       

      <no-tx-datasource>

      <jndi-name>jdbc/DATABD</jndi-name>

      <connection-url>jdbc:jtds:sqlserver:Tds:x.x.x.x:5000/DATABD1?JCONNECT_VERSION=6</connection-url>

        <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>

        <user-name>user</user-name>

        <password>pass</password>

        <min-pool-size>3</min-pool-size>

        <max-pool-size>10</max-pool-size>

        <connection-property name="HOSTNAME">xxxx-user</connection-property>

        <connection-property name="DYNAMIC_PREPARE">true</connection-property>

        <connection-property name="PACKETSIZE">512</connection-property>

        <connection-property name="CONNECTION_FAILOVER">false</connection-property>

        <connection-property name="SELECT_OPENS_CURSOR">false</connection-property>

        <connection-property name="SERIALIZE_REQUESTS">true</connection-property>

        <connection-property name="USE_METADATA">false</connection-property>

        <connection-property name="GET_BY_NAME_USES_COLUMN_LABEL">true</connection-property>

        </no-tx-datasource>

       

      I don't know what is wrong, can someone help please?