[jboss-dev-forums] [Design of Messaging on JBoss (Messaging/JBoss)] - ORA-014161 - Help with Bug on Oracle Driver

Mon Aug 27 18:34:55 EDT 2007

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" site:oracle.com

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.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4078524#4078524

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4078524