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;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
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
- Error occured when executing a query Rahesh Kumar
- Re: Error occured when executing a query Sven.Boden
- Re: Error occured when executing a query Rahesh Kumar
