From: Nathan H. <twi...@sp...> - 2003-06-03 19:58:26
|
We're having an odd intermittent issue with our CMP beans on JBoss 3.2.0.=20 Every once in a while, we'll get an error like so: Load failed; CausedByException is: *** ERROR[15001] Syntax error at or before: SELECT PARTITION, ACCOUNT_QID, CHECK_NUMBER,PAYEE, AMOUNT, ISSUE_DATE,= HAS_MEMO , ENTERED_DATE, ENTERED_BY_WS_ID, ENTRY_METHOD, STATUS, CLEAR_DATE, FILE_ID,= EX TERNAL_UNIQUE_ID, TYPE FROM PPCHECKS WHERE (PARTITION=3D? AND ACCOUNT_QID=3D= ? AND C HECK_NUMBER=3D?) OR (PARTITION=3D? AND ACCOUNT_QID=3D? AND CHECK_NUMBER=3D?)= OR (PARTIT ION=3D? AND ACCOUNT_QID=3D? AND CHECK_NUMBER=3D?) OR (PARTITION=3D? AND= ACCOUNT_QID=3D? A ND CHECK_NUMBER=3D?) OR (PARTITION=3D? AND ACCOUNT_QID=3D? AND= CHECK_NUMBER=3D?) FOR SE RIALIZABLE ACCESS =01=80=07=80; The binary junk at the end seems to be appearing from nowhere! Not to=20 mention, Axis assumes that the exception message will contain only=20 printable ASCII, so then ASP.NET vomits because the error comes back=20 containing lots of low binary values that aren't valid in XML. I'm ready to blame our JDBC vendor (HP, for NonStop SQL/MX), but I wanted=20 to check and see if anyone else has experienced this issue. Thanks Nathan |