5 Replies Latest reply on Aug 28, 2007 9:48 PM by Clebert Suconic

    ORA-014161 - Help with Bug on Oracle Driver

    Clebert Suconic Master

      I'm testing JBossMessaging for the release process, and I found what seems to be a bug on Oracle driver:


      "java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column"


      I have a simple statement, insterting values into JBM_MSG:


      INSERT INTO JBM_MSG (MESSAGE_ID, RELIABLE, EXPIRATION, TIMESTAMP, PRIORITY, HEADERS, PAYLOAD, TYPE) SELECT ?, ?, ?, ?, ?, ?, ?, ? FROM JBM_DUAL WHERE NOT EXISTS (SELECT MESSAGE_ID FROM JBM_MSG WHERE MESSAGE_ID = ?)


      And this can't work when using LONGs on queries.


      This is clearly a bug on the driver :-( Anyone know how to fix that?


      I have googled for this of course, and the only conclusion I found was.. "this is a bug on the driver" and nothing more besides that.

      It seems that everybody fixed it by just avoiding it the long.. replacing the long usage by store procedures or something else.