1 Reply Latest reply on Jan 17, 2005 3:43 PM by Adrian Brock

    Serious Connection Problems....(MANAGED CONNECTION PROBLEMS.

    VANGELIS VANGELIS Newbie

      Hi Adrian,

      I am facinng some serious connectin problems.
      I have an j2ee appliction,

      a.jar
      b.war

      the first two files are administrative consoles.

      c.war
      The c.war is a web application for the users. it has static pages, with very few connection to the database.

      I have an oracle-ds.xml with two datasources, the adminitrative console is connection to the owner of the database, and the web-application to synomims. the idea here is the web not to have access directly to the tables but in synomims.


      FIRST PROBLEM:

      When the jboss is started up, i have a singleton class, caching ejbs, making initialization some properites, also making a connections to the database: It's executes some schedules task:

      The error i get is the follwoing:

      12037157 INFO 10 Jan 2005 23:04:28,401 connectionmanager.TxConnectionManager$TxConnectionEventListener - Unregistered handle that was not registered! null for managedConnection: org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1d1b44b
      12037158 INFO 10 Jan 2005 23:04:28,402 connectionmanager.TxConnectionManager$TxConnectionEventListener - Unregistered handle that was not registered! null for managedConnection: org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1d1b44b
      12037159 INFO 10 Jan 2005 23:04:28,403 connectionmanager.JBossManagedConnectionPool - Exception destroying ManagedConnection
      org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: Io exception: Broken pipe)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkException(BaseWrapperManagedConnection.java:445)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:229)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(InternalManagedConnectionPool.java:374)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.returnConnection(InternalManagedConnectionPool.java:250)
      at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool.returnConnection(JBossManagedConnectionPool.java:648)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.returnManagedConnection(BaseConnectionManager2.java:451)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$BaseConnectionEventListener.connectionErrorOccurred(BaseConnectionManager2.java:762)
      at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.connectionErrorOccurred(TxConnectionManager.java:629)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.broadcastConnectionError(BaseWrapperManagedConnection.java:309)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.connectionError(BaseWrapperManagedConnection.java:294)
      at org.jboss.resource.adapter.jdbc.WrappedConnection.checkException(WrappedConnection.java:819)
      at org.jboss.resource.adapter.jdbc.WrappedConnection.createStatement(WrappedConnection.java:156)
      at com.eurodyn.dimitra2.util.scheduling.XMLTask.getLastExecution(XMLTask.java:219)
      at com.eurodyn.dimitra2.util.scheduling.XMLTask.needExecution(XMLTask.java:307)
      at com.eurodyn.dimitra2.util.scheduling.XMLTask.execute(XMLTask.java:295)
      at com.eurodyn.dimitra2.util.scheduling.ScheduledTask.run(ScheduledTask.java:53)
      at java.util.TimerThread.mainLoop(Timer.java:432)
      at java.util.TimerThread.run(Timer.java:382)
      Caused by: java.sql.SQLException: Io exception: Broken pipe
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
      at oracle.jdbc.driver.OracleConnection.close(OracleConnection.java:1442)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:225)
      ... 16 more
      12037160 ERROR 10 Jan 2005 23:04:28,404 scheduling.XMLTask - Cannot setLastExecution. day : Wednesday time : 11 date : 2005-01-05 00:00:00.0 java.sql.SQLException: No more data to read from socket
      12037160 ERROR 10 Jan 2005 23:04:28,404 scheduling.XMLTask - java.sql.SQLException: No more data to read from socket
      java.sql.SQLException: No more data to read from socket
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
      at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)
      at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java:963)
      at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:893)
      at oracle.jdbc.ttc7.Oopen.receive(Oopen.java:105)
      at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:586)
      at oracle.jdbc.driver.OracleStatement.(OracleStatement.java:385)
      at oracle.jdbc.driver.OracleConnection.privateCreateStatement(OracleConnection.java:772)
      at oracle.jdbc.driver.OracleConnection.createStatement(OracleConnection.java:712)
      at org.jboss.resource.adapter.jdbc.WrappedConnection.createStatement(WrappedConnection.java:152)
      at com.eurodyn.dimitra2.util.scheduling.XMLTask.getLastExecution(XMLTask.java:219)
      at com.eurodyn.dimitra2.util.scheduling.XMLTask.needExecution(XMLTask.java:307)
      at com.eurodyn.dimitra2.util.scheduling.XMLTask.execute(XMLTask.java:295)
      at com.eurodyn.dimitra2.util.scheduling.ScheduledTask.run(ScheduledTask.java:53)
      at java.util.TimerThread.mainLoop(Timer.java:432)
      at java.util.TimerThread.run(Timer.java:382)
      12037161 INFO 10 Jan 2005 23:04:28,405 STDOUT - TASK SCHEDULE ID EXECUTED IS :490
      12037161 INFO 10 Jan 2005 23:04:28,405 STDOUT - MIN TIME IS : 18
      12037161 INFO 10 Jan 2005 23:04:28,405 STDOUT - MAN TIME IS : 24
      12037161 INFO 10 Jan 2005 23:04:28,405 STDOUT - CURRENT TIME IS :23


      I saw an previous topic of you saying that this is not an error , but a warning thrown ?????

      Althouhth of this error, u can work fine with the admistrative console..


      2. Problem with the webapplication.
      When the web-application is started up, alsoa servlet i runing , getting
      the connectin for the datasource...
      What is strange here, as i see from the logs, that the JBOSS creates 20 connection objects in the pool ? why is that ???

      <web-pool-size>
      <min-pool-size>5</min-pool-size>
      <max-pool-size>20</max-pool-size>

      20 is the maximum connection of the pool size ?
      __________________________________________
      <administrator pool-size>
      <min-pool-size>5</min-pool-size>
      <max-pool-size>100</max-pool-size>


      So the application server creates 20 connection for the web-pool-size ?
      why it doesnt creates also many connection for the administravice datasource. ???


      I can not understand this.



      PLEASE HELP.


      I am using JBOSS 3.2.1

      Is there a better connection pooling to 3.2.6 , can i move to 3.2.6 ??


      ALSO THE CONNECTION FROM THE ORACLE SIDE ALLOWED ARE 115.
      Thanx in advance...




      43521 DEBUG 11 Jan 2005 13:06:54,674 connectionmanager.IdleRemover - internalRegisterPool: registering pool with interval 900000 old interval: 450000
      43522 DEBUG 11 Jan 2005 13:06:54,675 local.LocalManagedConnectionFactory - Using properties: {user=dimitraweb, password=dimitraweb30}
      43522 DEBUG 11 Jan 2005 13:06:54,675 local.LocalManagedConnectionFactory - Checking driver for URL: jdbc:oracle:thin:@atlas2:1521:at25
      43522 DEBUG 11 Jan 2005 13:06:54,675 local.LocalManagedConnectionFactory - Driver already registered for url: jdbc:oracle:thin:@atlas2:1521:at25
      43738 DEBUG 11 Jan 2005 13:06:54,891 local.LocalManagedConnectionFactory - Using properties: {user=dimitraweb, password=dimitraweb30}
      43740 DEBUG 11 Jan 2005 13:06:54,893 local.LocalManagedConnectionFactory - Using properties: {user=dimitraweb, password=dimitraweb30}
      43931 DEBUG 11 Jan 2005 13:06:55,084 local.LocalManagedConnectionFactory - Using properties: {user=dimitraweb, password=dimitraweb30}
      44101 DEBUG 11 Jan 2005 13:06:55,254 local.LocalManagedConnectionFactory - Using properties: {user=dimitraweb, password=dimitraweb30}
      44437 DEBUG 11 Jan 2005 13:06:55,590 local.LocalManagedConnectionFactory - Using properties: {user=dimitraweb, password=dimitraweb30}
      44635 DEBUG 11 Jan 2005 13:06:55,788 local.LocalManagedConnectionFactory - Using properties: {user=dimitraweb, password=dimitraweb30}
      44805 DEBUG 11 Jan 2005 13:06:55,958 local.LocalManagedConnectionFactory - Using properties: {user=dimitraweb, password=dimitraweb30}
      44997 DEBUG 11 Jan 2005 13:06:56,150 local.LocalManagedConnectionFactory - Using properties: {user=dimitraweb, password=dimitraweb30}
      45179 DEBUG 11 Jan 2005 13:06:56,332 local.LocalManagedConnectionFactory - Using properties: {user=dimitraweb, password=dimitraweb30}
      45374 DEBUG 11 Jan 2005 13:06:56,527 local.LocalManagedConnectionFactory - Using properties: {user=dimitraweb, password=dimitraweb30}
      45585 DEBUG 11 Jan 2005 13:06:56,738 local.LocalManagedConnectionFactory - Using properties: {user=dimitraweb, password=dimitraweb30}
      45771 DEBUG 11 Jan 2005 13:06:56,924 local.LocalManagedConnectionFactory - Using properties: {user=dimitraweb, password=dimitraweb30}
      46001 DEBUG 11 Jan 2005 13:06:57,154 local.LocalManagedConnectionFactory - Using properties: {user=dimitraweb, password=dimitraweb30}
      46217 DEBUG 11 Jan 2005 13:06:57,370 local.LocalManagedConnectionFactory - Using properties: {user=dimitraweb, password=dimitraweb30}
      46902 DEBUG 11 Jan 2005 13:06:58,055 local.LocalManagedConnectionFactory - Using properties: {user=dimitraweb, password=dimitraweb30}
      47131 DEBUG 11 Jan 2005 13:06:58,284 local.LocalManagedConnectionFactory - Using properties: {user=dimitraweb, password=dimitraweb30}
      47350 DEBUG 11 Jan 2005 13:06:58,503 local.LocalManagedConnectionFactory - Using properties: {user=dimitraweb, password=dimitraweb30}
      47570 DEBUG 11 Jan 2005 13:06:58,723 local.LocalManagedConnectionFactory - Using properties: {user=dimitraweb, password=dimitraweb30}
      47841 DEBUG 11 Jan 2005 13:06:58,994 local.LocalManagedConnectionFactory - Using properties: {user=dimitraweb, password=dimitraweb30}
      53080 DEBUG 11 Jan 2005 13:07:04,233 util.NestedThrowable - org.jboss.util.NestedThrowable.parentTraceEnabled=true
      53082 DEBUG 11 Jan 2005 13:07:04,235 util.NestedThrowable - org.jboss.util.NestedThrowable.nestedTraceEnabled=false
      53082 DEBUG 11 Jan 2005 13:07:04,235 util.NestedThrowable - org.jboss.util.NestedThrowable.detectDuplicateNesting=true
      53085 FATAL 11 Jan 2005 13:07:04,238 DIMITRA-WEBSITE - ResourcesBean: Error at initStep=3
      org.jboss.util.NestedSQLException: No ManagedConnections Available!; - nested throwable: (javax.resource.ResourceException: No ManagedConnections Available!)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:106)
      at com.eurodyn.dimitra2.website.beans.ResourcesBean.(ResourcesBean.java:90)
      at com.eurodyn.dimitra2.website.beans.ResourcesBean.getInstance(ResourcesBean.java:182)