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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...