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 table transactions is a very big table
2. I have set all index for columns transaction_id, refenence_tran_id and
original_transaction_id.
3. The query usually return 2-3 result rows
4. Seems the java.lang.OutOfMemoryError happened in high load
My concern is why there is memory error for this query with just quite a few
result sets. Any wrong with my query syntax above? Thank you for your help
in advance.
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 table transactions is a very big table
2. I have set all index for columns transaction_id, refenence_tran_id and
original_transaction_id.
3. The query usually return 2-3 result rows
4. Seems the java.lang.OutOfMemoryError happened in high load
My concern is why there is memory error for this query with just quite a few
result sets. Any wrong with my query syntax above? Thank you for your help
in advance.