Hi everyone

I am woundering if someone know that H2 database support the following
DELETE statement

DELETE FROM mytable WHERE mycolumn LIKE 'match_this';

I am trying this and getting the following error.




org.h2.jdbc.JdbcSQLException: General error:
java.lang.NoClassDefFoundError: java.lang.CharSequence [HY000-63]
        at org.h2.message.Message.getSQLException(Unknown Source)
        at org.h2.message.Message.convert(Unknown Source)
        at org.h2.message.TraceObject.logAndConvert(Unknown Source)
        at org.h2.jdbc.JdbcConnection.prepareStatement(Unknown Source)
        at pmc.test.H2Test1.deleteCachedData(Unknown Source)
        at pmc.test.TestMain.test1(Unknown Source)
        at IBIClient.main(Unknown Source) java.lang.NoClassDefFoundError:
java.lang.CharSequence
        at java.lang.Class.verifyImpl(Native Method)
        at java.lang.Class.verify(Unknown Source)
        at java.lang.Class.initialize(Unknown Source)
        at org.h2.command.Parser.readCondition(Unknown Source)
        at org.h2.command.Parser.readAnd(Unknown Source)
        at org.h2.command.Parser.readExpression(Unknown Source)
        at org.h2.command.Parser.parseDelete(Unknown Source)
        at org.h2.command.Parser.parsePrepared(Unknown Source)
        at org.h2.command.Parser.parse(Unknown Source)
        at org.h2.command.Parser.parse(Unknown Source)
        at org.h2.command.Parser.prepareCommand(Unknown Source)
        at org.h2.engine.Session.prepareLocal(Unknown Source)
        at org.h2.engine.Session.prepareCommand(Unknown Source)
        at org.h2.jdbc.JdbcConnection.prepareCommand(Unknown Source)
        at org.h2.jdbc.JdbcPreparedStatement.<init>(Unknown Source)
        at org.h2.jdbc.JdbcConnection.prepareStatement(Unknown Source)
        at pmc.test.H2Test1.deleteCachedData(Unknown Source)
        at pmc.test.TestMain.test1(Unknown Source)
        at IBIClient.main(Unknown Source) java.lang.NoClassDefFoundError:
java.lang.CharSequence
        at java.lang.Class.verifyImpl(Native Method)
        at java.lang.Class.verify(Unknown Source)
        at java.lang.Class.initialize(Unknown Source)
        at org.h2.command.Parser.readCondition(Unknown Source)
        at org.h2.command.Parser.readAnd(Unknown Source)
        at org.h2.command.Parser.readExpression(Unknown Source)
        at org.h2.command.Parser.parseDelete(Unknown Source)
        at org.h2.command.Parser.parsePrepared(Unknown Source)
        at org.h2.command.Parser.parse(Unknown Source)
        at org.h2.command.Parser.parse(Unknown Source)
        at org.h2.command.Parser.prepareCommand(Unknown Source)
        at org.h2.engine.Session.prepareLocal(Unknown Source)
        at org.h2.engine.Session.prepareCommand(Unknown Source)
        at org.h2.jdbc.JdbcConnection.prepareCommand(Unknown Source)
        at org.h2.jdbc.JdbcPreparedStatement.<init>(Unknown Source)
        at org.h2.jdbc.JdbcConnection.prepareStatement(Unknown Source)
        at pmc.test.H2Test1.deleteCachedData(Unknown Source)
        at pmc.test.TestMain.test1(Unknown Source)
        at IBIClient.main(Unknown Source) Exception: General error:
java.lang.NoClassDefFoundError: java.lang.CharSequence [HY000-63]







--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to