You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@activemq.apache.org by SuoNayi <su...@163.com> on 2012/01/13 04:48:36 UTC

Fusesource message brokers misbehave with oracle jdbc storage

Hi all,
     I have tested fusesource message broker from apache-activemq-5.5.0-fuse-00-27-bin.tar.gz to apache-activemq-5.5.1-fuse-01-20-bin.tar.gz.
Some exception is thrown when sending messages by client to broker.
------------------------------------------------------------------------------------------------
apache-activemq-5.5.0-fuse-00-27-bin.tar.gz
Caused by: java.sql.SQLException: Missing IN or OUT parameter at index:: 7
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1729)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3365)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
        at org.apache.activemq.store.jdbc.adapter.BlobJDBCAdapter.doAddMessage(BlobJDBCAdapter.java:71)
        at org.apache.activemq.store.jdbc.JDBCMessageStore.addMessage(JDBCMessageStore.java:104)
        ... 17 more
------------------------------------------------------------------------------------------------
apache-activemq-5.5.0-fuse-00-43-bin.tar.gz
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
    at org.apache.activemq.store.jdbc.adapter.BlobJDBCAdapter.doAddMessage(BlobJDBCAdapter.java:72)
    at org.apache.activemq.store.jdbc.JDBCMessageStore.addMessage(JDBCMessageStore.java:104)
    ... 17 more
------------------------------------------------------------------------------------------------
apache-activemq-5.5.0-fuse-00-53-bin.tar.gz

    Caused by: java.sql.SQLException: ORA-01465: invalid hex number

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
    at org.apache.activemq.store.jdbc.adapter.BlobJDBCAdapter.doAddMessage(BlobJDBCAdapter.java:72)
    at org.apache.activemq.store.jdbc.JDBCMessageStore.addMessage(JDBCMessageStore.java:104)
    ... 17 more
------------------------------------------------------------------------------------------------
While other version brokers miss the value of the priority of messages  according to inspecting records in activemq_msgs table in oracle database.
Hope fusesource experts pay attention to these problem.

Re: Fusesource message brokers misbehave with oracle jdbc storage

Posted by Claus Ibsen <cl...@gmail.com>.
Hi

Thanks for reporting.

I have logged a ticket to enhance the migration guide, as we slipped
this change.
http://fusesource.com/issues/browse/MB-1057
http://fusesource.com/docs/broker/5.5/migration/Summary.html


2012/1/13 SuoNayi <su...@163.com>:
> Hi all,
>     I have tested fusesource message broker from apache-activemq-5.5.0-fuse-00-27-bin.tar.gz to apache-activemq-5.5.1-fuse-01-20-bin.tar.gz.
> Some exception is thrown when sending messages by client to broker.
> ------------------------------------------------------------------------------------------------
> apache-activemq-5.5.0-fuse-00-27-bin.tar.gz
> Caused by: java.sql.SQLException: Missing IN or OUT parameter at index:: 7
>        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>        at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1729)
>        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3365)
>        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)
>        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
>        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
>        at org.apache.activemq.store.jdbc.adapter.BlobJDBCAdapter.doAddMessage(BlobJDBCAdapter.java:71)
>        at org.apache.activemq.store.jdbc.JDBCMessageStore.addMessage(JDBCMessageStore.java:104)
>        ... 17 more
> ------------------------------------------------------------------------------------------------
> apache-activemq-5.5.0-fuse-00-43-bin.tar.gz
>    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
>    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
>    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
>    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
>    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
>    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
>    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
>    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)
>    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
>    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
>    at org.apache.activemq.store.jdbc.adapter.BlobJDBCAdapter.doAddMessage(BlobJDBCAdapter.java:72)
>    at org.apache.activemq.store.jdbc.JDBCMessageStore.addMessage(JDBCMessageStore.java:104)
>    ... 17 more
> ------------------------------------------------------------------------------------------------
> apache-activemq-5.5.0-fuse-00-53-bin.tar.gz
>
>    Caused by: java.sql.SQLException: ORA-01465: invalid hex number
>
>    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
>    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
>    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
>    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
>    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
>    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
>    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
>    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)
>    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
>    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
>    at org.apache.activemq.store.jdbc.adapter.BlobJDBCAdapter.doAddMessage(BlobJDBCAdapter.java:72)
>    at org.apache.activemq.store.jdbc.JDBCMessageStore.addMessage(JDBCMessageStore.java:104)
>    ... 17 more
> ------------------------------------------------------------------------------------------------
> While other version brokers miss the value of the priority of messages  according to inspecting records in activemq_msgs table in oracle database.
> Hope fusesource experts pay attention to these problem.



-- 
Claus Ibsen
-----------------
FuseSource
Email: cibsen@fusesource.com
Web: http://fusesource.com
Twitter: davsclaus, fusenews
Blog: http://davsclaus.blogspot.com/
Author of Camel in Action: http://www.manning.com/ibsen/