Home > database >  Consult a Ibatis background error problem, for the oracle database
Consult a Ibatis background error problem, for the oracle database

Time:09-22

The background error, I walk a breakpoint follow found is I when executing a SQL query to fault:

The query results and more than twenty thousand, my computer myeclipse. Ini, myeclipse JDK, tomcat memory setting has been changed,
I tomcat, JDK has been set up - Xms256m - Xmx512m - XX: XX: CompileThreshold=8000 - PermSize=48 m - XX: MaxPermSize=256 m - Doracle JDBC. V8Compatible=true
There is no effect, but also great god please help see why, error content is as follows:
07-07 14:56:59 ERROR sitech. JCF. Proxy. Impl. AllBeanProxy: 71 - Java. Lang. OutOfMemoryError: Java heap space
At oracle, the JDBC driver. CharCommonAccessor. Get string (404) CharCommonAccessor. Java:
At oracle, the JDBC driver. T4CVarcharAccessor. Get string (436) T4CVarcharAccessor. Java:
At oracle, the JDBC driver. OracleResultSetImpl. Get string (971) OracleResultSetImpl. Java:
At oracle, the JDBC driver. OracleResultSet. Get string (494) OracleResultSet. Java:
At org.apache.com mons. DBCP. DelegatingResultSet. Get string (DelegatingResultSet. Java: 224)
At com, ibatis sqlmap. Engine. The StringTypeHandler. GetResult (StringTypeHandler. Java: 35)
At com, ibatis sqlmap. Engine. Mapping. The result. The ResultMap. GetPrimitiveResultMappingValue (ResultMap. Java: 619)
At com, ibatis sqlmap. Engine. Mapping. The result. The ResultMap. The assembled (ResultMap. Java: 345)
At com, ibatis sqlmap. Engine. Execution. SqlExecutor. HandleResults (SqlExecutor. Java: 419)
At com, ibatis sqlmap. Engine. Execution. SqlExecutor. HandleMultipleResults (SqlExecutor. Java: 336)
At com, ibatis sqlmap. Engine. Execution. SqlExecutor. IBatisExecuteQuery (SqlExecutor. Java: 224)
At com, ibatis sqlmap. Engine. Execution. SqlExecutor. ExecuteQuery (SqlExecutor. Java: 186)
At com, ibatis sqlmap. Engine. Mapping. The statement. MappedStatement. SqlExecuteQuery (MappedStatement. Java: 222)
At com, ibatis sqlmap. Engine. Mapping. The statement. MappedStatement. ExecuteQueryWithCallback (MappedStatement. Java: 190)
At com, ibatis sqlmap. Engine. Mapping. The statement. MappedStatement. ExecuteQueryForList (MappedStatement. Java: 139)
At com, ibatis sqlmap. Engine. Impl. SqlMapExecutorDelegate. QueryForList (SqlMapExecutorDelegate. Java: 567)
At com, ibatis sqlmap. Engine. Impl. SqlMapExecutorDelegate. QueryForList (SqlMapExecutorDelegate. Java: 541)
At com, ibatis sqlmap. Engine. Impl. SqlMapSessionImpl. QueryForList (SqlMapSessionImpl. Java: 118)
The at org. Springframework. Orm. Ibatis. SqlMapClientTemplate $3. DoInSqlMapClient (SqlMapClientTemplate. Java: 295)
The at org. Springframework. Orm. Ibatis. SqlMapClientTemplate $3. DoInSqlMapClient (SqlMapClientTemplate. Java: 1)
The at org. Springframework. Orm. Ibatis. SqlMapClientTemplate. Execute (SqlMapClientTemplate. Java: 200)
The at org. Springframework. Orm. Ibatis. SqlMapClientTemplate. QueryForList (SqlMapClientTemplate. Java: 293)
At com. Sitech. JCF. Core. Dao. BaseDao. QueryForList (BaseDao. Java: 295)
At com.sitech.groupcust.com, mon. Dao. TdSSeqctrlDao. QueryList (TdSSeqctrlDao. Java: 24)
At com. Sitech. Groupcust. Busi. Other. SeqctrlServiceImpl. SelectCrmSeq (SeqctrlServiceImpl. Java: 99)
At sun. Reflect. NativeMethodAccessorImpl. Invoke0 (Native Method)
At sun. Reflect. NativeMethodAccessorImpl. Invoke (NativeMethodAccessorImpl. Java: 39)
At sun. Reflect. DelegatingMethodAccessorImpl. Invoke (DelegatingMethodAccessorImpl. Java: 25)
The at Java. Lang. Reflect. Method. Invoke (597) Method. The Java:
The at org. Springframework. Aop. Support. AopUtils. InvokeJoinpointUsingReflection (AopUtils. Java: 309)
The at org. Springframework. Aop. Framework. ReflectiveMethodInvocation. InvokeJoinpoint (ReflectiveMethodInvocation. Java: 183)
The at org. Springframework. Aop. Framework. ReflectiveMethodInvocation. Proceed (ReflectiveMethodInvocation. Java: 150)

CodePudding user response:

My code and colleagues, colleagues can run no problem, and I have a question, all should be code problems,
Is the query time is too long, lead to? Now I just changed the sqlMapConfig. XML setup defaultStatementTimeout="900" timeout of 900 s, have a try, later see can be successful,

CodePudding user response:

After setting defaultStatementTimeout="900" also doesn't work,
Add an error content
The Exception in the thread "ContainerBackgroundProcessor [StandardEngine [Catalina]]" Java. Lang. OutOfMemoryError: Java heap space
The at org. Apache. Juli. Logging. DirectJDKLog. Log (DirectJDKLog. Java: 154)
At org. Apache. Juli. Logging. DirectJDKLog. Error (135) DirectJDKLog. Java:
The at org. Apache. Catalina. Core. ContainerBase $ContainerBackgroundProcessor. ProcessChildren (ContainerBase. Java: 1655)
The at org. Apache. Catalina. Core. ContainerBase $ContainerBackgroundProcessor. Run (ContainerBase. Java: 1642)
The at Java. Lang. Thread. The run (Thread. Java: 619)

My local modified catalina. Bat increased
JAVA_OPTS="- Djava. Awt. Headless=true - Dfile. Encoding=utf-8
- server - Xms1536m - Xmx1536m
- XX: XX: NewSize=256 m - MaxNewSize=256 m - XX: PermSize=256 m
- XX: MaxPermSize=256 m - XX: + DisableExplicitGC
"
Catalina. Sh increased JAVA_OPTS="- server - XX: PermSize=64 m - XX: MaxPermSize=128 m" after an error,
Waiting for reply!

CodePudding user response:

At the time of startup project found a in the process of execution
nullnullnullnullnullnullnullnullnullnullnull
  • Related