Thanks sven..Just thought of confirming this.Thanks very much
Rahesh
On 6/30/06, Sven.Boden <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]]
>Verzonden: vrijdag, juni 30, 2006 07:30 AM
>Aan: [email protected]
>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
>;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
>
