java.sql.SQLException: Invalid escape character: Invalid escape character: hexadecimal string contains non hex character in statement [INSERT INTO EVENT_STORE VALUES('SEEBEYOND_EVENT_200711141531602_3826855916454061546','aced000573720032636f6d2e7374632e6576656e746d616e6167656d656e742e696d706c2e4e6f74696669636174696f6e4576656e74496d706c49881a421ac8a80302000c4a00036d49645a00126d4c697374656e6572734e6f7469666965644900136d4f62736572766174696f6e616c53746174654900116d4f7065726174696f6e616c53746174654900096d53657665726974794c000c6d4d657373616765436f64657400124c6a6176612f6c616e672f537472696e673b5b00106d4d657373616765436f6465417267737400135b4c6a6176612f6c616e672f537472696e673b4c000f6d4d65737361676544657461696c7371007e00014c00056d5479706571007e00015b000e6f625374617465537472696e677371007e00025b000e6f705374617465537472696e677371007e00025b000f7365766572697479537472696e677371007e000278720026636f6d2e7374632e6576656e746d616e6167656d656e742e696d706c2e4576656e74496d706c4248c88b25e4d24c02000b4a00036d49644a000a6d54696d655374616d704c000e6d436f6d706f6e656e744e616d6571007e00014c00196d436f6d706f6e656e7450726f6a656374506174684e616d6571007e00014c000e6d436f6d706f6e656e745479706571007e00014c000f6d4465706c6f796d656e744e616d6571007e00014c00106d456e7669726f6e6d656e744e616d6571007e00014c00106d4c6f676963616c486f73744e616d6571007e00014c00116d506879736963616c486f73744e616d6571007e00014c000b6d5365727665724e616d6571007e00014c000b6d5365727665725479706571007e000178700000000000000000000001163e9273e274000c65614854545053657276657274000c436f6e6e65637469766974797400044557415974001864704950535061796d656e745f69734465765f3139343030740006656e764465767400056c684465767074000b69734465765f313934303074000b494e544547524154494f4e00000000000000000000000000000000070000000474002348545450534552564552455741592d524551554553542d4641494c45443030303030317074007f4572726f7220696e2068616e646c6552657175657374207768696c652070726f63657373696e6720504f5354206f722047455420726571756573743b204661756c742072657475726e65647b687474703a2f2f7365656265796f6e642f636f6d2f787364646566696e65642f4661756c744d657373616765737d4661INSERT INTO EVENT_STORE VALUES('SEEBEYOND_EVENT_200711141531602_3826855916454061546','aced000573720032636f6d2e7374632e6576656e746d616e6167656d656e742e696d706c2e4e6f74696669636174696f6e4576656e74496d706c49881a421ac8a80302000c4a00036d49645a00126d4c697374656e6572734e6f7469666965644900136d4f62736572766174696f6e616c53746174654900116d4f7065726174696f6e616c53746174654900096d53657665726974794c000c6d4d657373616765436f64657400124c6a6176612f6c616e672f537472696e673b5b00106d4d657373616765436f6465417267737400135b4c6a6176612f6c616e672f537472696e673b4c000f6d4d65737361676544657461696c7371007e00014c00056d5479706571007e00015b000e6f625374617465537472696e677371007e00025b000e6f705374617465537472696e677371007e00025b000f7365766572697479537472696e677371007e000278720026636f6d2e7374632e6576656e746d616e6167656d656e742e696d706c2e4576656e74496d706c4248c88b25e4d24c02000b4a00036d49644a000a6d54696d655374616d704c000e6d436f6d706f6e656e744e616d6571007e00014c00196d436f6d706f6e656e7450726f6a656374506174684e616d6571007e00014c000e6d436f6d706f6e656e745479706571007e00014c000f6d4465706c6f796d656e744e616d6571007e00014c00106d456e7669726f6e6d656e744e616d6571007e00014c00106d4c6f676963616c486f73744e616d6571007e00014c00116d506879736963616c486f73744e616d6571007e00014c000b6d5365727665724e616d6571007e00014c000b6d5365727665725479706571007e000178700000000000000000000001163e9273e274000c65614854545053657276657274000c436f6e6e65637469766974797400044557415974001864704950535061796d656e745f69734465765f3139343030740006656e764465767400056c684465767074000b69734465765f313934303074000b494e544547524154494f4e00000000000000000000000000000000070000000474002348545450534552564552455741592d524551554553542d4641494c45443030303030317074007f4572726f7220696e2068616e646c6552657175657374207768696c652070726f63657373696e6720504f5354206f722047455420726571756573743b204661756c742072657475726e65647b687474703a2f2f7365656265796f6e642f636f6d2f787364646566696e65642f4661756c744d657373616765737d4661756c74740005416c657274757200135b4c6a6176612e6c616e672e537472696e673badd256e7e91d7b4702000078700000000374000a554e4f425345525645447400084f425345525645447400085245534f4c5645447571007e001000000007740007554e4b4e4f574e7400085354415254494e4774000a53555350454e44494e4774000953555350454e44454474000853544f5050494e4774000753544f5050454474000752554e4e494e477571007e001000000006740005464154414c740008435249544943414c7400054d414a4f527400054d494e4f527400075741524e494e47740004494e464f'+)]

Oracle Community | 807574 | 9 years ago
  1. 0

    Seebeyond eventstore database problems

    Oracle Community | 9 years ago | 807574
    java.sql.SQLException: Invalid escape character: Invalid escape character: hexadecimal string contains non hex character in statement [INSERT INTO EVENT_STORE VALUES('SEEBEYOND_EVENT_200711141531602_3826855916454061546','aced000573720032636f6d2e7374632e6576656e746d616e6167656d656e742e696d706c2e4e6f74696669636174696f6e4576656e74496d706c49881a421ac8a80302000c4a00036d49645a00126d4c697374656e6572734e6f7469666965644900136d4f62736572766174696f6e616c53746174654900116d4f7065726174696f6e616c53746174654900096d53657665726974794c000c6d4d657373616765436f64657400124c6a6176612f6c616e672f537472696e673b5b00106d4d657373616765436f6465417267737400135b4c6a6176612f6c616e672f537472696e673b4c000f6d4d65737361676544657461696c7371007e00014c00056d5479706571007e00015b000e6f625374617465537472696e677371007e00025b000e6f705374617465537472696e677371007e00025b000f7365766572697479537472696e677371007e000278720026636f6d2e7374632e6576656e746d616e6167656d656e742e696d706c2e4576656e74496d706c4248c88b25e4d24c02000b4a00036d49644a000a6d54696d655374616d704c000e6d436f6d706f6e656e744e616d6571007e00014c00196d436f6d706f6e656e7450726f6a656374506174684e616d6571007e00014c000e6d436f6d706f6e656e745479706571007e00014c000f6d4465706c6f796d656e744e616d6571007e00014c00106d456e7669726f6e6d656e744e616d6571007e00014c00106d4c6f676963616c486f73744e616d6571007e00014c00116d506879736963616c486f73744e616d6571007e00014c000b6d5365727665724e616d6571007e00014c000b6d5365727665725479706571007e000178700000000000000000000001163e9273e274000c65614854545053657276657274000c436f6e6e65637469766974797400044557415974001864704950535061796d656e745f69734465765f3139343030740006656e764465767400056c684465767074000b69734465765f313934303074000b494e544547524154494f4e00000000000000000000000000000000070000000474002348545450534552564552455741592d524551554553542d4641494c45443030303030317074007f4572726f7220696e2068616e646c6552657175657374207768696c652070726f63657373696e6720504f5354206f722047455420726571756573743b204661756c742072657475726e65647b687474703a2f2f7365656265796f6e642f636f6d2f787364646566696e65642f4661756c744d657373616765737d4661INSERT INTO EVENT_STORE VALUES('SEEBEYOND_EVENT_200711141531602_3826855916454061546','aced000573720032636f6d2e7374632e6576656e746d616e6167656d656e742e696d706c2e4e6f74696669636174696f6e4576656e74496d706c49881a421ac8a80302000c4a00036d49645a00126d4c697374656e6572734e6f7469666965644900136d4f62736572766174696f6e616c53746174654900116d4f7065726174696f6e616c53746174654900096d53657665726974794c000c6d4d657373616765436f64657400124c6a6176612f6c616e672f537472696e673b5b00106d4d657373616765436f6465417267737400135b4c6a6176612f6c616e672f537472696e673b4c000f6d4d65737361676544657461696c7371007e00014c00056d5479706571007e00015b000e6f625374617465537472696e677371007e00025b000e6f705374617465537472696e677371007e00025b000f7365766572697479537472696e677371007e000278720026636f6d2e7374632e6576656e746d616e6167656d656e742e696d706c2e4576656e74496d706c4248c88b25e4d24c02000b4a00036d49644a000a6d54696d655374616d704c000e6d436f6d706f6e656e744e616d6571007e00014c00196d436f6d706f6e656e7450726f6a656374506174684e616d6571007e00014c000e6d436f6d706f6e656e745479706571007e00014c000f6d4465706c6f796d656e744e616d6571007e00014c00106d456e7669726f6e6d656e744e616d6571007e00014c00106d4c6f676963616c486f73744e616d6571007e00014c00116d506879736963616c486f73744e616d6571007e00014c000b6d5365727665724e616d6571007e00014c000b6d5365727665725479706571007e000178700000000000000000000001163e9273e274000c65614854545053657276657274000c436f6e6e65637469766974797400044557415974001864704950535061796d656e745f69734465765f3139343030740006656e764465767400056c684465767074000b69734465765f313934303074000b494e544547524154494f4e00000000000000000000000000000000070000000474002348545450534552564552455741592d524551554553542d4641494c45443030303030317074007f4572726f7220696e2068616e646c6552657175657374207768696c652070726f63657373696e6720504f5354206f722047455420726571756573743b204661756c742072657475726e65647b687474703a2f2f7365656265796f6e642f636f6d2f787364646566696e65642f4661756c744d657373616765737d4661756c74740005416c657274757200135b4c6a6176612e6c616e672e537472696e673badd256e7e91d7b4702000078700000000374000a554e4f425345525645447400084f425345525645447400085245534f4c5645447571007e001000000007740007554e4b4e4f574e7400085354415254494e4774000a53555350454e44494e4774000953555350454e44454474000853544f5050494e4774000753544f5050454474000752554e4e494e477571007e001000000006740005464154414c740008435249544943414c7400054d414a4f527400054d494e4f527400075741524e494e47740004494e464f'+)]
  2. 0

    How to Store OBJECT in database

    hsqldb | 1 decade ago | kalyanbitra
    java.sql.SQLException: Invalid escape character: hexadecimal string contains non hex chara cter
  3. 0

    Handling spaces in the nvarchar field.

    jtds | 1 decade ago | archanabharathi
    java.sql.SQLException: Invalid SQL statement or JDBC escape, terminating ''' character not found.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Incorrect comments processing inside callable statement

    jtds | 6 years ago | niagarafaults
    java.sql.SQLException: Invalid JDBC escape syntax at line position 19 '}' character expected.
  6. 0

    CallableStatement Invalid JDBC escape synatax

    jtds | 1 decade ago | dijimon
    java.sql.SQLException: Invalid JDBC escape synatax at line position 44 '}' character expected.

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Invalid escape character: Invalid escape character: hexadecimal string contains non hex character in statement [INSERT INTO EVENT_STORE VALUES('SEEBEYOND_EVENT_200711141531602_3826855916454061546','aced000573720032636f6d2e7374632e6576656e746d616e6167656d656e742e696d706c2e4e6f74696669636174696f6e4576656e74496d706c49881a421ac8a80302000c4a00036d49645a00126d4c697374656e6572734e6f7469666965644900136d4f62736572766174696f6e616c53746174654900116d4f7065726174696f6e616c53746174654900096d53657665726974794c000c6d4d657373616765436f64657400124c6a6176612f6c616e672f537472696e673b5b00106d4d657373616765436f6465417267737400135b4c6a6176612f6c616e672f537472696e673b4c000f6d4d65737361676544657461696c7371007e00014c00056d5479706571007e00015b000e6f625374617465537472696e677371007e00025b000e6f705374617465537472696e677371007e00025b000f7365766572697479537472696e677371007e000278720026636f6d2e7374632e6576656e746d616e6167656d656e742e696d706c2e4576656e74496d706c4248c88b25e4d24c02000b4a00036d49644a000a6d54696d655374616d704c000e6d436f6d706f6e656e744e616d6571007e00014c00196d436f6d706f6e656e7450726f6a656374506174684e616d6571007e00014c000e6d436f6d706f6e656e745479706571007e00014c000f6d4465706c6f796d656e744e616d6571007e00014c00106d456e7669726f6e6d656e744e616d6571007e00014c00106d4c6f676963616c486f73744e616d6571007e00014c00116d506879736963616c486f73744e616d6571007e00014c000b6d5365727665724e616d6571007e00014c000b6d5365727665725479706571007e000178700000000000000000000001163e9273e274000c65614854545053657276657274000c436f6e6e65637469766974797400044557415974001864704950535061796d656e745f69734465765f3139343030740006656e764465767400056c684465767074000b69734465765f313934303074000b494e544547524154494f4e00000000000000000000000000000000070000000474002348545450534552564552455741592d524551554553542d4641494c45443030303030317074007f4572726f7220696e2068616e646c6552657175657374207768696c652070726f63657373696e6720504f5354206f722047455420726571756573743b204661756c742072657475726e65647b687474703a2f2f7365656265796f6e642f636f6d2f787364646566696e65642f4661756c744d657373616765737d4661INSERT INTO EVENT_STORE VALUES('SEEBEYOND_EVENT_200711141531602_3826855916454061546','aced000573720032636f6d2e7374632e6576656e746d616e6167656d656e742e696d706c2e4e6f74696669636174696f6e4576656e74496d706c49881a421ac8a80302000c4a00036d49645a00126d4c697374656e6572734e6f7469666965644900136d4f62736572766174696f6e616c53746174654900116d4f7065726174696f6e616c53746174654900096d53657665726974794c000c6d4d657373616765436f64657400124c6a6176612f6c616e672f537472696e673b5b00106d4d657373616765436f6465417267737400135b4c6a6176612f6c616e672f537472696e673b4c000f6d4d65737361676544657461696c7371007e00014c00056d5479706571007e00015b000e6f625374617465537472696e677371007e00025b000e6f705374617465537472696e677371007e00025b000f7365766572697479537472696e677371007e000278720026636f6d2e7374632e6576656e746d616e6167656d656e742e696d706c2e4576656e74496d706c4248c88b25e4d24c02000b4a00036d49644a000a6d54696d655374616d704c000e6d436f6d706f6e656e744e616d6571007e00014c00196d436f6d706f6e656e7450726f6a656374506174684e616d6571007e00014c000e6d436f6d706f6e656e745479706571007e00014c000f6d4465706c6f796d656e744e616d6571007e00014c00106d456e7669726f6e6d656e744e616d6571007e00014c00106d4c6f676963616c486f73744e616d6571007e00014c00116d506879736963616c486f73744e616d6571007e00014c000b6d5365727665724e616d6571007e00014c000b6d5365727665725479706571007e000178700000000000000000000001163e9273e274000c65614854545053657276657274000c436f6e6e65637469766974797400044557415974001864704950535061796d656e745f69734465765f3139343030740006656e764465767400056c684465767074000b69734465765f313934303074000b494e544547524154494f4e00000000000000000000000000000000070000000474002348545450534552564552455741592d524551554553542d4641494c45443030303030317074007f4572726f7220696e2068616e646c6552657175657374207768696c652070726f63657373696e6720504f5354206f722047455420726571756573743b204661756c742072657475726e65647b687474703a2f2f7365656265796f6e642f636f6d2f787364646566696e65642f4661756c744d657373616765737d4661756c74740005416c657274757200135b4c6a6176612e6c616e672e537472696e673badd256e7e91d7b4702000078700000000374000a554e4f425345525645447400084f425345525645447400085245534f4c5645447571007e001000000007740007554e4b4e4f574e7400085354415254494e4774000a53555350454e44494e4774000953555350454e44454474000853544f5050494e4774000753544f5050454474000752554e4e494e477571007e001000000006740005464154414c740008435249544943414c7400054d414a4f527400054d494e4f527400075741524e494e47740004494e464f'+)]

      at org.hsqldb.Trace.getError()
    2. HSQLDB
      jdbcConnection.<init>
      1. org.hsqldb.Trace.getError(Unknown Source)
      2. org.hsqldb.Log.runScript(Unknown Source)
      3. org.hsqldb.Log.open(Unknown Source)
      4. org.hsqldb.Database$Logger.openLog(Unknown Source)
      5. org.hsqldb.Database.open(Unknown Source)
      6. org.hsqldb.Database.<init>(Unknown Source)
      7. org.hsqldb.jdbcConnection.openStandalone(Unknown Source)
      8. org.hsqldb.jdbcConnection.<init>(Unknown Source)
      8 frames