java.lang.OutOfMemoryError: Java heap space in DB query - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Java - 爪哇娇娃

java.lang.OutOfMemoryError: Java heap space in DB query

java.lang.OutOfMemoryError: Java heap space in DB query# Java - 爪哇娇娃

l*b2009-06-15 07:06

1 楼

I use Spring JdbcTemplate to do the following query and use RowMapper to get
the ResultSet. However, the Jboss server generate java.lang.
OutOfMemoryError some time.
SELECT *
FROM transactions
WHERE transaction_id = (SELECT refenence_tran_id FROM transactions WHERE
transaction_id = '1234')
or transaction_id = (SELECT original_transaction_id FROM transactions WHERE
transaction_id = '1234')
or original_transaction_id = '1234' or refenence_tran_id = '1234' order by
transaction_id
Notes:
1. The tabl

l*b2009-06-15 07:06

2 楼

The whole error log is:
INFO [org.springframework.jdbc.support.SQLErrorCodesFactory] SQLErrorCodes
loaded: [DB2, HSQL, MS-SQL, MySQL, Oracle, Informix, PostgreSQL, Sybase]
ERROR [STDERR] com.active.dao.DAOException: An exception occurred during
database access: PreparedStatementCallback; uncategorized SQLException for
SQL [SELECT * FROM transactions WHERE transaction_id = (SELECT refenence_
tran_id FROM transactions WHERE transaction_id = ?) or transaction_id = (
SELECT original_transaction_id F

g*g2009-06-15 07:06

3 楼

try specify -Xms -Xmx when you start jboss.

get
WHERE

【在 l*****b 的大作中提到】

: I use Spring JdbcTemplate to do the following query and use RowMapper to get
: the ResultSet. However, the Jboss server generate java.lang.
: OutOfMemoryError some time.
: SELECT *
: FROM transactions
: WHERE transaction_id = (SELECT refenence_tran_id FROM transactions WHERE
: transaction_id = '1234')
: or transaction_id = (SELECT original_transaction_id FROM transactions WHERE
: transaction_id = '1234')
: or original_transaction_id = '1234' or refenence_tran_id = '1234' order by

l*b2009-06-15 07:06

4 楼

The config values are
-server -Xms128m -Xmx512m -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.
dgc.server.gcInterval=3600000
Thanks, goodbug

A*o2009-06-15 07:06

5 楼

time for a profiler

rmi.

【在 l*****b 的大作中提到】

: The config values are
: -server -Xms128m -Xmx512m -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.
: dgc.server.gcInterval=3600000
: Thanks, goodbug

b*y2009-06-15 07:06

6 楼

这个SQL好像有脱裤子放P之嫌啊？
难道不可以优化一下吗？
SELECT *
FROM transactions
WHERE transaction_id = (SELECT refenence_tran_id FROM transactions WHERE
transaction_id = '1234')
or transaction_id = (SELECT original_transaction_id FROM transactions WHERE
transaction_id = '1234')
or original_transaction_id = '1234' or refenence_tran_id = '1234' order by
transaction_id
==
SELECT *
FROM transactions
WHERE original_transaction_id = '1234' or refenence_tran_id = '1234' order
by
transaction_id

get
WHERE

【在 l*****b 的大作中提到】

m*t2009-06-15 07:06

7 楼

Your version wouldn't pick up the second row below:
reference_tran_id transaction_id
5555 1234
9898 5555

WHERE

【在 b******y 的大作中提到】

: 这个SQL好像有脱裤子放P之嫌啊？
: 难道不可以优化一下吗？
: SELECT *
: FROM transactions
: WHERE transaction_id = (SELECT refenence_tran_id FROM transactions WHERE
: transaction_id = '1234')
: or transaction_id = (SELECT original_transaction_id FROM transactions WHERE
: transaction_id = '1234')
: or original_transaction_id = '1234' or refenence_tran_id = '1234' order by
: transaction_id