M4 OracleJDBCAdapter BUG !!!

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

M4 OracleJDBCAdapter BUG !!!

haliq
I'm using ActiveMQ-4.0-M4, JDK 1.4.2_06

When I use Oracle for my persistence data source, I get a Exception:

DEBUG [org.apache.activemq.broker.AbstractConnection] - <Sync error occurred: java.io.IOException: Failed to recover container. Reason: java.sql.SQLException: Invalid column type: getBLOB not implemented for class oracle.jdbc.driver.T4CNumberAccessor>


I think there should be a BUG:

org/apache/activemq/store/jdbc/adapter/OracleJDBCAdapter.java line 62
    Blob aBlob = rs.getBlob(1);
should be changed to
    Blob aBlob = rs.getBlob(index);



org/apache/activemq/store/jdbc/TransactionContext.java line 91
    if ( rc[i]!= 1 ) {
should be changed to
    if ( !(rc[i] > 0 || rc[i] == Statement.SUCCESS_NO_INFO) ) {
Reply | Threaded
Open this post in threaded view
|

Re: M4 OracleJDBCAdapter BUG !!!

James Strachan-2
Great stuff! I raised an issue for this...
http://jira.activemq.org/jira/browse/AMQ-574

I've applied your patch to SVN HEAD now - many thanks.


On 16 Feb 2006, at 03:50, haliq wrote:

> I'm using ActiveMQ-4.0-M4, JDK 1.4.2_06
>
> When I use Oracle for my persistence data source, I get a Exception:
>
> DEBUG [org.apache.activemq.broker.AbstractConnection] - <Sync error  
> occurred: java.io.IOException: Failed to recover container. Reason:  
> java.sql.SQLException: Invalid column type: getBLOB not implemented  
> for class oracle.jdbc.driver.T4CNumberAccessor>
>
>
> I think there should be a BUG:
>
> org/apache/activemq/store/jdbc/adapter/OracleJDBCAdapter.java line 62
>     Blob aBlob = rs.getBlob(1);
> should be changed to
>     Blob aBlob = rs.getBlob(index);
>
>
>
> org/apache/activemq/store/jdbc/TransactionContext.java line 91
>     if ( rc[i]!= 1 ) {
> should be changed to
>     if ( !(rc[i] > 0 || rc[i] == Statement.SUCCESS_NO_INFO) ) {


James
-------
http://radio.weblogs.com/0112098/