Serious Connection Problems....(MANAGED CONNECTION PROBLEMS.
georgewinner Jan 12, 2005 4:26 AMHi 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)