Java heap space

Hello,

  A problem I submitted shortly ago, which I though
related with the underscore, keeps reappearing in a
different fashion. It is somewhat related with LIKE
statements and the use of underscore. 

To reproduce the problem:

1)Create a test table 

create table TEST (
 TESTKEY CHAR(32),
 TESTCODE INT,
 TESTSTRING VARCHAR(50), 
 TESTSTRING2 VARCHAR(50), 
 TESTSTRING3 VARCHAR(50)
)

2) perform the following query, which works.

select 
 TESTKEY
from 
 TEST T
where 
 TESTSTRING like '%E\\_%'
order by
  TESTCODE


3) now replace '%E\\_%' with 'E\\_%' (without the
initial percent sign). This new query, which is
supposed to be less demanding,  fails.

It can't be executed from Java, nor from my AquaStudio
editor. Here's the stack trace

Exception in thread "Timer-3"
org.springframework.jdbc.UncategorizedSQLException:
executing PreparedStatementCallback: encountered
SQLException [Java heap space]; nested exception is
com.mckoi.database.jdbc.MSQLException: Java heap space
com.mckoi.database.jdbc.MSQLException: Java heap space
	at
com.mckoi.database.jdbc.RemoteDatabaseInterface.execQuery(RemoteDatabaseInterface.java:280)
	at
com.mckoi.database.jdbc.MConnection.executeQuery(MConnection.java:442)
	at
com.mckoi.database.jdbc.MConnection.executeQueries(MConnection.java:425)
	at
com.mckoi.database.jdbc.MStatement.executeQueries(MStatement.java:190)
	at
com.mckoi.database.jdbc.MStatement.executeQuery(MStatement.java:164)
	at
com.mckoi.database.jdbc.MPreparedStatement.executeQuery(MPreparedStatement.java:221)

Any idea how can I circumvent this?
Thanks in advance.

   Gonzalo

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]