ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sven.Boden" <list...@pandora.be>
Subject Re: Error occured when executing a query
Date Fri, 30 Jun 2006 06:01:11 GMT

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