ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahesh Kumar" <rah...@gmail.com>
Subject Re: Error occured when executing a query
Date Fri, 30 Jun 2006 06:09:43 GMT
Thanks sven..Just thought of confirming this.Thanks very much

Rahesh


On 6/30/06, Sven.Boden <list123@pandora.be> wrote:
>
>
> Nothing to do with iBATIS. Your DBA's assigned too little memory for
> certain oracle areas, they're the only ones who can solve it.
>
> Unless the query you execute is the only cause of the problem, but I would
> doubt that.
>
> Sven
>
>
> >----- Oorspronkelijk bericht -----
> >Van: Rahesh Kumar [mailto:rahesh@gmail.com]
> >Verzonden: vrijdag, juni 30, 2006 07:30 AM
> >Aan: user-java@ibatis.apache.org
> >Onderwerp: Error occured when executing a query
> >
> > jeff,
> >
> > while working on a query we suddenly experienced a problem as
> >
> > ORA-04031: unable to allocate 96 bytes of shared memory ("shared
> >pool","unknown object","sql area","optdef : apanlg")  . This is a problem
> >with the database. can this be solved by any means in IBatis . I am
> giving
> >the complete stack trace for your kind reference
> >
> >
> >com.ibatis.dao.client.DaoException: Failed to queryForList - id
> >[getTimesheets4AppStatus], parameterObject [{endSqlDate=07/02/2006,
> >startSqlDate=06/04/2006, isWeekEnd=TRUE, statusList=[TIMESHEET APPROVED,
> >TIMESHEET REJECTED, SUBMITTED FOR APPROVAL, SAVED AS DRAFT],
> >selectedContractors=[000303622], selectedProjects=[81, 0000000443,
> >0000000412, 0000000544, 82, 83, 84, 85, 86, 87, 88, 0000000019,
> 0000000596,
> >0000000533, 0000000008, 0000000017, 0000000016, 0000000060, 0000000044,
> >0000000042, 0000000043, 0000000039, 0000000045, 0000000040, 0000000038,
> 89,
> >90, 91, 0000000560, 92, 93, 94, 0000000036, 95, 96, 97, 98, 0000000014,
> >0000000365, 99, 0000000023, 101, 0000000361, 102, 0000000608, 0000000621,
> >0000000633, 0000000601, 0000000598, 0000000599, 0000000570, 0000000631,
> >0000000571, 0000000569, 0000000567, 0000000568, 103, 104, 105, 106,
> >0000000618, 107, 108, 109, 111, 112, 0000000513, 113, 114, 115, 116, 117,
> >118, 119, 121, 0000000575, 0000000444, 0000000002, 0000000499,
> 0000000047,
> >0000000037, 0000000503, 0000000414, 0000000061, 0000000564, 0000000565,
> >0000000026, 0000000626, 0000000478, 0000000518, 0000000430, 0000000539,
> >0000000510, 0000000368, 123, 124, 125, 126, 127, 128, 130, 129, 131,
> >0000000526, 0000000396, 132, 133, 134, 135, 136, 137, 138, 139,
> 0000000024,
> >0000000003, 0000000075, 0000000595, 0000000007, 0000000481, 0000000420,
> >0000000509, 0000000425, 0000000054, 145, 146, 147, 148, 149, 143, 144,
> >0000000519, 0000000456, 0000000493, 150, 151, 0000000613, 0000000614,
> 152,
> >153, 0000000537, 0000000615, 154, 0000000013, 155, 0000000021, 156, 157,
> >158, 0000000457, 0000000563, 0000000586, 0000000475, 0000000609,
> 0000000476,
> >0000000474, 0000000470, 0000000473, 0000000616, 0000000468, 0000000467,
> >0000000469, 0000000472, 0000000466, 0000000471, 0000000556, 159, 160,
> 161,
> >162, 0000000035, 0000000502, 0000000459, 0000000027, 0000000434,
> 0000000515,
> >0000000433, 164, 163, 165, 0000000056, 166, 0000000385, 167, 168, 169,
> 170,
> >171, 0000000455, 0000000523, 0000000410, 0000000419, 0000000500,
> 0000000413,
> >172, 173, 174, 0000000559, 0000000576, 175, 176, 0000000527, 177, 178,
> 180,
> >0000000531, 0000000463, 181, 182, 0000000384, 0000000555, 183,
> 0000000482,
> >0000000485, 0000000484, 0000000521, 0000000483, 0000000005, 184,
> 0000000065,
> >0000000079, 185, 0000000378, 0000000629, 0000000489, 0000000532,
> 0000000070,
> >186, 187, 0000000512, 0000000370, 0000000426, 0000000550, 0000000072,
> 188,
> >189, 0000000554, 0000000587, 0000000592, 0000000562, 0000000551,
> 0000000464,
> >0000000634, 190, 193, 0000000479, 191, 0000000552, 192, 0000000379,
> >0000000055, 0000000620, 194, 0000000549, 195, 0000000422, 0000000423,
> >0000000041, 0000000049, 0000000048, 0000000031, 0000000004, 196,
> 0000000397,
> >0000000622, 0000000623, 0000000619, 197, 198, 199, 200, 201, 203, 204,
> 205,
> >0000000454, 0000000488, 0000000487, 0000000577, 0000000486, 206, 207,
> 208,
> >0000000078, 0000000605, 0000000546, 0000000607, 0000000606, 209,
> 0000000580,
> >0000000579, 210, 211, 0000000074, 212, 213, 214, 215, 216, 217, 218, 219,
> >220, 221, 222, 223, 224, 225, 0000000520, 226, 0000000417, 227,
> 0000000033,
> >228, 229, 0000000432, 0000000492, 0000000358, 0000000446, 0000000498,
> >0000000447, 0000000491, 231, 0000000610, 0000000602, 0000000617,
> 0000000448,
> >0000000449, 0000000067, 0000000578, 338, 0000000632, 232, 0000000001,
> >0000000548, 0000000069, 0000000006, 235, 0000000418, 0000000528,
> 0000000465,
> >0000000581, 0000000356, 0000000372, 236, 237, 238, 0000000445, 239, 240,
> >241, 242, 0000000062, 0000000077, 243, 245, 246, 247, 0000000630, 248,
> >0000000494, 0000000362, 249, 250, 251, 0000000604, 0000000012,
> 0000000360,
> >0000000584, 0000000588, 279, 280, 281, 282, 0000000522, 0000000636, 284,
> >285, 286, 287, 0000000359, 288, 289, 0000000389, 0000000511, 0000000366,
> >0000000427, 0000000536, 0000000508, 0000000553, 0000000025, 0000000591,
> >0000000517, 0000000382, 0000000080, 0000000052, 290, 291, 0000000572,
> >0000000574, 292, 293, 0000000028, 0000000011, 0000000516, 0000000395,
> 294,
> >0000000480, 295, 296, 297, 0000000566, 0000000557, 298, 299, 300, 301,
> >0000000643, 0000000642, 0000000640, 0000000644, 0000000646, 0000000638,
> >0000000645, 0000000641, 0000000639, 0000000367, 0000000504, 302, 303,
> >0000000051, 0000000458, 0000000030, 304, 0000000415, 0000000363, 305,
> 306,
> >307, 308, 309, 310, 311, 0000000386, 0000000409, 0000000408, 0000000402,
> >0000000391, 0000000390, 0000000407, 0000000394, 0000000589, 0000000401,
> >0000000403, 0000000388, 0000000411, 0000000392, 0000000404, 0000000387,
> >0000000399, 0000000405, 0000000406, 0000000393, 0000000400, 312, 313,
> 314,
> >315, 316, 317, 318, 319, 320, 0000000059, 0000000058, 321, 322, 323,
> >0000000534, 0000000635, 0000000383, 0000000637, 0000000600, 0000000535,
> >0000000547, 0000000440, 0000000441, 0000000076, 0000000435, 0000000442,
> >0000000439, 0000000437, 0000000438, 0000000529, 0000000524, 326, 324,
> 325,
> >327, 328, 0000000015, 0000000376, 329, 330, 332, 333, 335, 336,
> 0000000477,
> >0000000009, 0000000593, 0000000050, 0000000625, 0000000624, 0000000357,
> 253,
> >254, 255, 257, 0000000429, 258, 259, 260, 261, 0000000431, 0000000612,
> 262,
> >263, 0000000542, 264, 266, 267, 268, 0000000505, 0000000506, 0000000543,
> >0000000421, 0000000416, 0000000501, 0000000369, 0000000540, 0000000573,
> >0000000497, 0000000377, 0000000071, 0000000018, 0000000538, 0000000022,
> >0000000545, 0000000380, 0000000046, 0000000066, 270, 271, 272, 273, 274,
> >275, 0000000453, 276, 0000000029, 277, 278, 339, 0000000611, 0000000064,
> >0000000057, 0000000541, 0000000585, 0000000558, 0000000053, 0000000020,
> >0000000594, 0000000582, 0000000583, 0000000507, 340, 341, 342, 343,
> >0000000603, 0000000375, 0000000063, 0000000461, 0000000462, 0000000460,
> >0000000073, 345, 0000000495, 346, 347, 348, 349, 0000000436, 350, 351,
> 354,
> >0000000428, 0000000371, 0000000530, 0000000034, 0000000514, 0000000398,
> >0000000628, 0000000561, 0000000590, 0000000424, 0000000381, 0000000373,
> >0000000452, 0000000451, 355, 0000000597, 0000000374, 0000000525,
> 0000000496,
> >0000000450, 142, 0000000627, 0000000364, 0000000068]}]. Cause:
> >com.ibatis.common.jdbc.exception.NestedSQLException: --- The error
> occurred
> >while applying a parameter map. --- Check the
> >getTimesheets4AppStatus-InlineParameterMap. --- Check the statement
> (query
> >failed). --- Cause: java.sql.SQLException: ORA-04031: unable to allocate
> 96
> >bytes of shared memory ("shared pool","unknown object","sql area","optdef
> :
> >apanlg") Caused by: java.sql.SQLException: ORA-04031: unable to allocate
> 96
> >bytes of shared memory ("shared pool","unknown object","sql area","optdef
> :
> >apanlg") Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
> ---
> >The error occurred while applying a parameter map. --- Check the
> >getTimesheets4AppStatus-InlineParameterMap. --- Check the statement
> (query
> >failed). --- Cause: java.sql.SQLException: ORA-04031: unable to allocate
> 96
> >bytes of shared memory ("shared pool","unknown object","sql area","optdef
> :
> >apanlg") Caused by: java.sql.SQLException: ORA-04031: unable to allocate
> 96
> >bytes of shared memory ("shared pool","unknown object","sql area","optdef
> :
> >apanlg") at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList
> (
> >SqlMapDaoTemplate.java:205) at
> >ctrs.persistence.dao.sqlmapdao.TimesheetSqlMapDao.getTimesheets4AppStatus
> (Unknown
> >Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> >sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java
> :39)
> >at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> >DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(
> >Method.java:324) at
> >com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:64)
> >at $Proxy1.getTimesheets4AppStatus(Unknown Source) at
> >ctrs.actions.TimesheetsStatusAction.timesheetsReports(Unknown Source) at
> >sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> >sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java
> :39)
> >at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> >DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(
> >Method.java:324) at
> org.apache.struts.actions.DispatchAction.dispatchMethod(
> >DispatchAction.java:270) at
> org.apache.struts.actions.DispatchAction.execute
> >(DispatchAction.java:187) at
> >org.apache.struts.action.RequestProcessor.processActionPerform(
> >RequestProcessor.java:431) at
> >org.apache.struts.action.RequestProcessor.process(RequestProcessor.java
> :236)
> >at org.apache.struts.action.ActionServlet.process(ActionServlet.java
> :1196)
> >at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
> at
> >javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at
> >javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
> >com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(
> >StrictServletInstance.java:110) at
> >com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(
> >StrictLifecycleServlet.java:174) at
> >com.ibm.ws.webcontainer.servlet.ServicingServletState.service(
> >StrictLifecycleServlet.java:333) at
> >com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(
> >StrictLifecycleServlet.java:116) at
> >com.ibm.ws.webcontainer.servlet.ServletInstance.service(
> ServletInstance.java:283)
> >at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(
> >ValidServletReferenceState.java:42) at
> >com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(
> >ServletInstanceReference.java:40) at
> >
> com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch
> (
> >WebAppRequestDispatcher.java:1171) at
> >com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(
> >WebAppRequestDispatcher.java:676) at
> >com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(
> >WebAppRequestDispatcher.java:203) at
> >com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java
> :125)
> >at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(
> >WebAppInvoker.java:294) at
> >
> com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation
> (
> >CachedInvocation.java:71) at
> >
> com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke
> (
> >CacheableInvocationContext.java:116) at
> >com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(
> >ServletRequestProcessor.java:186) at
> >com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(
> >OSEListener.java:334) at
> >com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(
> >HttpConnection.java:56) at
> >com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java
> :652)
> >at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:448) at
> >com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:912) Caused by:
> >com.ibatis.common.jdbc.exception.NestedSQLException: --- The error
> occurred
> >while applying a parameter map. --- Check the
> >getTimesheets4AppStatus-InlineParameterMap. --- Check the statement
> (query
> >failed). --- Cause: java.sql.SQLException: ORA-04031: unable to allocate
> 96
> >bytes of shared memory ("shared pool","unknown object","sql area","optdef
> :
> >apanlg") Caused by: java.sql.SQLException: ORA-04031: unable to allocate
> 96
> >bytes of shared memory ("shared pool","unknown object","sql area","optdef
> :
> >apanlg") at
> >
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback
> >(GeneralStatement.java:185) at
> >
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList
> >(GeneralStatement.java:123) at
> >com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(
> >SqlMapExecutorDelegate.java:610) at
> >com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(
> >SqlMapExecutorDelegate.java:584) at
> >com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(
> >SqlMapSessionImpl.java:101) at
> >com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(
> >SqlMapClientImpl.java:78) at
> >com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(
> >SqlMapDaoTemplate.java:203) ... 40 more Caused by: java.sql.SQLException:
> >ORA-04031: unable to allocate 96 bytes of shared memory ("shared
> >pool","unknown object","sql area","optdef : apanlg") at
> >oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at
> >oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at
> >oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573) at
> >oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891) at
> >oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
> at
> >oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java
> :2391)
> >at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
> >OracleStatement.java:2672) at
> >oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(
> >OraclePreparedStatement.java:589) at
> >oracle.jdbc.driver.OraclePreparedStatement.execute(
> >OraclePreparedStatement.java:656) at
> >com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(
> >WSJdbcPreparedStatement.java:400) at
> >com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(
> SqlExecutor.java:180)
> >at
> >
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery
> (
> >GeneralStatement.java:205) at
> >
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback
> >(GeneralStatement.java:173) ... 46 more Caused by:
> >com.ibatis.common.jdbc.exception.NestedSQLException: --- The error
> occurred
> >while applying a parameter map. --- Check the
> >getTimesheets4AppStatus-InlineParameterMap. --- Check the statement
> (query
> >failed). --- Cause: java.sql.SQLException: ORA-04031: unable to allocate
> 96
> >bytes of shared memory ("shared pool","unknown object","sql area","optdef
> :
> >apanlg") Caused by: java.sql.SQLException: ORA-04031: unable to allocate
> 96
> >bytes of shared memory ("shared pool","unknown object","sql area","optdef
> :
> >apanlg") at
> >
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback
> >(GeneralStatement.java:185) at com.ibatis.sqlmap.enginue255
>
> >;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
> >
>
>
>

Mime
View raw message