Problem

[Anjana Rao]

Hi i am facing problem with weblogic. Often it thros this exception. Can anyone help me in understanding as to why does it do so? Reply Awaited
SEssion is weblogic.servlet.internal.session.MemorySession@5d616e
Start time is 1.02392339E12End time is..1023923361950 elapsed time is 0.0
SEssion is weblogic.servlet.internal.session.MemorySession@4683c0
Thu Jun 13 09:11:56 GMT-05:00 2002:<E> <Posix Performance Pack> Connection reset on socket: 'weblogic.socket.MuxableSocketHTTP@73bc22 - idle timeout: '60', socket timeout: '5000'', fd: '18'
Thu Jun 13 09:11:56 GMT-05:00 2002:<E> <Posix Performance Pack> Connection reset on socket: 'weblogic.socket.MuxableSocketHTTP@449afc - idle timeout: '60', socket timeout: '5000'', fd: '22'
12
query is SELECT A.ACCESS_ID,ACCESS_RES, A.ACCESS_NAME, A.ACCESS_DESC_ID FROM MEMS_ACCESS A, MEMS_ROLE B, MEMS_ACCESS_DESC C WHERE B.ROLENAME='admin' AND A.ACCESS_ID= B.ACCESS_ID AND A.ACCESS_DESC_ID=C.ACCESS_DESC_ID ORDER BY A.ACCESS_DESC_ID,A.ACCESS_ID
sessioid is ..54280108705509991089477
SEssion is weblogic.servlet.internal.session.MemorySession@55d4be
userid is..admin id 54280108705509991089477
referer is..http://10.16.1.105:9001/mems/admin/MEMSLogin.jsp
18
SEssion is weblogic.servlet.internal.session.MemorySession@55d4be
userid is..admin id 54280108705509991089477
referer is..http://10.16.1.105:9001/Admin_AuthServlet?val=12
50
resource is../FinancialReportsServlet?act=12&id=54280108705509991089477
Thu Jun 13 09:29:02 GMT-05:00 2002:<I> <ServletContext-General> FinancialReportsServlet: init
action:12
unique id is54280108705509991089477
SEssion is weblogic.servlet.internal.session.MemorySession@55d4be
userid is..admin id 54280108705509991089477
referer is..http://10.16.1.105:9001/mems/admin/MEMSAdminReports.jsp?id=54280108705509991089477
action:13
unique id is54280108705509991089477
unique id is54280108705509991089477
bill no for this case
group by a.billdate desc, a.mecode
Connection created
after forming queryselect a.billno, a.mecode, a.billamount, to_char(a.billdate,'DD-MM-YYYY') billdate, d.city, d.megname,nvl(d.mesname,' ') mesname, d.pin, c.area from mems_billtransmaster a, mems_area c, mems_meprofile d where a.mecode = d.mecode and d.areacode = c.area and d.pin = c.pincode and a.billdate between (to_date('13/06/2002','DD-MM-YYYY')) and (sysdate) AND sysdate >='01-jan-1900' order by a.billdate desc, a.mecode
intEnd is 10
inservlet intsize=289intEnd is10intstartis0
jsp intSize 289 intEnd20intStart 10
size of report1 is 289
after dispatch..
action:13
unique id isnull
unique id isnull
bill no for this case
group by a.billdate desc, a.mecode
Connection created
after forming queryselect a.billno, a.mecode, a.billamount, to_char(a.billdate,'DD-MM-YYYY') billdate, d.city, d.megname,nvl(d.mesname,' ') mesname, d.pin, c.area from mems_billtransmaster a, mems_area c, mems_meprofile d where a.mecode = d.mecode and d.areacode = c.area and d.pin = c.pincode and a.billdate between (to_date('13/06/2002','DD-MM-YYYY')) and (sysdate) AND sysdate >='01-jan-1900' order by a.billdate desc, a.mecode
intEnd is 20
inservlet intsize=289intEnd is20intstartis10
jsp intSize 289 intEnd30intStart 20
size of report1 is 289
after dispatch..
action:13
unique id isnull
unique id isnull
bill no for this case
group by a.billdate desc, a.mecode
Connection created
after forming queryselect a.billno, a.mecode, a.billamount, to_char(a.billdate,'DD-MM-YYYY') billdate, d.city, d.megname,nvl(d.mesname,' ') mesname, d.pin, c.area from mems_billtransmaster a, mems_area c, mems_meprofile d where a.mecode = d.mecode and d.areacode = c.area and d.pin = c.pincode and a.billdate between (to_date('13/06/2002','DD-MM-YYYY')) and (sysdate) AND sysdate >='01-jan-1900' order by a.billdate desc, a.mecode
intEnd is 20
inservlet intsize=289intEnd is20intstartis10
jsp intSize 289 intEnd30intStart 20
size of report1 is 289
after dispatch..
action:13
unique id isnull
unique id isnull
bill no for this case
group by a.billdate desc, a.mecode
Connection created
after forming queryselect a.billno, a.mecode, a.billamount, to_char(a.billdate,'DD-MM-YYYY') billdate, d.city, d.megname,nvl(d.mesname,' ') mesname, d.pin, c.area from mems_billtransmaster a, mems_area c, mems_meprofile d where a.mecode = d.mecode and d.areacode = c.area and d.pin = c.pincode and a.billdate between (to_date('13/06/2002','DD-MM-YYYY')) and (sysdate) AND sysdate >='01-jan-1900' order by a.billdate desc, a.mecode
intEnd is 30
inservlet intsize=289intEnd is30intstartis20
jsp intSize 289 intEnd40intStart 30
size of report1 is 289
after dispatch..
action:13
unique id isnull
unique id isnull
bill no for this case
group by a.billdate desc, a.mecode
Connection created
after forming queryselect a.billno, a.mecode, a.billamount, to_char(a.billdate,'DD-MM-YYYY') billdate, d.city, d.megname,nvl(d.mesname,' ') mesname, d.pin, c.area from mems_billtransmaster a, mems_area c, mems_meprofile d where a.mecode = d.mecode and d.areacode = c.area and d.pin = c.pincode and a.billdate between (to_date('13/06/2002','DD-MM-YYYY')) and (sysdate) AND sysdate >='01-jan-1900' order by a.billdate desc, a.mecode
intEnd is 40
inservlet intsize=289intEnd is40intstartis30
jsp intSize 289 intEnd50intStart 40
size of report1 is 289
after dispatch..
action:13
unique id isnull
unique id isnull
bill no for this case
group by a.billdate desc, a.mecode
Connection created
after forming queryselect a.billno, a.mecode, a.billamount, to_char(a.billdate,'DD-MM-YYYY') billdate, d.city, d.megname,nvl(d.mesname,' ') mesname, d.pin, c.area from mems_billtransmaster a, mems_area c, mems_meprofile d where a.mecode = d.mecode and d.areacode = c.area and d.pin = c.pincode and a.billdate between (to_date('13/06/2002','DD-MM-YYYY')) and (sysdate) AND sysdate >='01-jan-1900' order by a.billdate desc, a.mecode
intEnd is 50
inservlet intsize=289intEnd is50intstartis40
jsp intSize 289 intEnd60intStart 50
size of report1 is 289
after dispatch..
12
12
query is SELECT A.ACCESS_ID,ACCESS_RES, A.ACCESS_NAME, A.ACCESS_DESC_ID FROM MEMS_ACCESS A, MEMS_ROLE B, MEMS_ACCESS_DESC C WHERE B.ROLENAME='MANAGER' AND A.ACCESS_ID= B.ACCESS_ID AND A.ACCESS_DESC_ID=C.ACCESS_DESC_ID ORDER BY A.ACCESS_DESC_ID,A.ACCESS_ID
query is SELECT A.ACCESS_ID,ACCESS_RES, A.ACCESS_NAME, A.ACCESS_DESC_ID FROM MEMS_ACCESS A, MEMS_ROLE B, MEMS_ACCESS_DESC C WHERE B.ROLENAME='MANAGER' AND A.ACCESS_ID= B.ACCESS_ID AND A.ACCESS_DESC_ID=C.ACCESS_DESC_ID ORDER BY A.ACCESS_DESC_ID,A.ACCESS_ID
Admin_AuthBean.authenticateUser raised Exception..when getting datajava.sql.SQLException: Closed Statement: next
sessioid is ..5129015248735251583615
SEssion is weblogic.servlet.internal.session.MemorySession@6b2473
userid is..danbys id 5129015248735251583615
referer is..http://10.16.1.105:9001/mems/admin/MEMSLogin.jsp
Thu Jun 13 09:29:51 GMT-05:00 2002:<E> <ServletContext-General> Servlet failed with Exception
java.lang.Error: 8 Was already released:weblogic.jdbc.common.internal.ConnectionEnv@66361e
at weblogic.common.internal.ResourceAllocator.release(ResourceAllocator.java:861)
at weblogic.common.internal.ResourceAllocator.release(ResourceAllocator.java:873)
at weblogic.jdbc.common.internal.ConnectionPool.release(ConnectionPool.java:191)
at weblogic.jdbcbase.pool.Connection.close(Connection.java:131)
at weblogic.jdbc20.rmi.internal.ConnectionImpl.close(ConnectionImpl.java:138)
at weblogic.jdbc20.rmi.SerialConnection.close(SerialConnection.java:161)
at mems.admin.Admin_AuthServlet.authenticateUser(Admin_AuthServlet.java:844)
at mems.admin.Admin_AuthServlet.doGet(Admin_AuthServlet.java:460)
at mems.admin.Admin_AuthServlet.doPost(Admin_AuthServlet.java:741)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:772)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:105)
at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImpl.java:742)
at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImpl.java:686)
at weblogic.servlet.internal.ServletContextManager.invokeServlet(ServletContextManager.java:247)
at weblogic.socket.MuxableSocketHTTP.invokeServlet(MuxableSocketHTTP.java:361)
at weblogic.socket.MuxableSocketHTTP.execute(MuxableSocketHTTP.java:261)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)

[Steve Chernyak]

Im just guessing, but is it possible that you are closing a DB connection twice?

[Pradeep bhatt]

I don't think that closing a connection object twice causes any exception.
To quote from java doc on close method of Connection interface:
public void close()
throws SQLException
Releases this Connection object's database and JDBC resources immediately instead of waiting for them to be automatically released.
Calling the method close on a Connection object that is already closed is a no-op.
Note: A Connection object is automatically closed when it is garbage collected. Certain fatal errors also close a Connection object.

Throws:
SQLException - if a database access error occurs

Originally posted by Steve Chernyak:
Im just guessing, but is it possible that you are closing a DB connection twice?