You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@activemq.apache.org by "Gary Tully (JIRA)" <ji...@apache.org> on 2011/04/20 13:37:05 UTC
[jira] [Created] (AMQ-3289) ActiveMQ has problems storing >4K
messages in Oracle
ActiveMQ has problems storing >4K messages in Oracle
----------------------------------------------------
Key: AMQ-3289
URL: https://issues.apache.org/jira/browse/AMQ-3289
Project: ActiveMQ
Issue Type: Bug
Components: Message Store
Affects Versions: 5.5.0, 5.4.0
Reporter: Gary Tully
Assignee: Gary Tully
Fix For: 5.6.0
The oracle persistence adapter extends the blob jdbc adapter but it has gotten out of sync with the method overrides. @Override to the rescue for the future.
The blob adapter uses native blob streaming to insert data (which can accommodate > 4k) but it has been out of step for some time.
The implementations need to be brought into line w.r.t to the api, schema and locking.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (AMQ-3289) ActiveMQ has problems storing >4K
messages in Oracle
Posted by "Gary Tully (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/AMQ-3289?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13022089#comment-13022089 ]
Gary Tully commented on AMQ-3289:
---------------------------------
It looks like the ojdbc6 drivers avoid this problem as they use the default adapter.
> ActiveMQ has problems storing >4K messages in Oracle
> ----------------------------------------------------
>
> Key: AMQ-3289
> URL: https://issues.apache.org/jira/browse/AMQ-3289
> Project: ActiveMQ
> Issue Type: Bug
> Components: Message Store
> Affects Versions: 5.4.0, 5.5.0
> Reporter: Gary Tully
> Assignee: Gary Tully
> Labels: BLOB, JDBC, oracle
> Fix For: 5.6.0
>
>
> The oracle persistence adapter extends the blob jdbc adapter but it has gotten out of sync with the method overrides. @Override to the rescue for the future.
> The blob adapter uses native blob streaming to insert data (which can accommodate > 4k) but it has been out of step for some time.
> The implementations need to be brought into line w.r.t to the api, schema and locking.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (AMQ-3289) ActiveMQ has problems storing >4K
messages in Oracle
Posted by "William McDonald (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/AMQ-3289?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
William McDonald updated AMQ-3289:
----------------------------------
Attachment: OracleJDBCAdapter.java
BlobJDBCAdapter.java
Updates to make blob work with Oracle 10g.
> ActiveMQ has problems storing >4K messages in Oracle
> ----------------------------------------------------
>
> Key: AMQ-3289
> URL: https://issues.apache.org/jira/browse/AMQ-3289
> Project: ActiveMQ
> Issue Type: Bug
> Components: Message Store
> Affects Versions: 5.4.0, 5.5.0
> Reporter: Gary Tully
> Assignee: Gary Tully
> Labels: BLOB, JDBC, oracle
> Fix For: 5.6.0
>
> Attachments: BlobJDBCAdapter.java, OracleJDBCAdapter.java
>
>
> The oracle persistence adapter extends the blob jdbc adapter but it has gotten out of sync with the method overrides. @Override to the rescue for the future.
> The blob adapter uses native blob streaming to insert data (which can accommodate > 4k) but it has been out of step for some time.
> The implementations need to be brought into line w.r.t to the api, schema and locking.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Reopened] (AMQ-3289) ActiveMQ has problems storing >4K
messages in Oracle
Posted by "Gary Tully (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/AMQ-3289?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gary Tully reopened AMQ-3289:
-----------------------------
reopening to take in Williams patch
> ActiveMQ has problems storing >4K messages in Oracle
> ----------------------------------------------------
>
> Key: AMQ-3289
> URL: https://issues.apache.org/jira/browse/AMQ-3289
> Project: ActiveMQ
> Issue Type: Bug
> Components: Message Store
> Affects Versions: 5.4.0, 5.5.0
> Reporter: Gary Tully
> Assignee: Gary Tully
> Labels: BLOB, JDBC, oracle
> Fix For: 5.6.0
>
> Attachments: BlobJDBCAdapter.java, OracleJDBCAdapter.java
>
>
> The oracle persistence adapter extends the blob jdbc adapter but it has gotten out of sync with the method overrides. @Override to the rescue for the future.
> The blob adapter uses native blob streaming to insert data (which can accommodate > 4k) but it has been out of step for some time.
> The implementations need to be brought into line w.r.t to the api, schema and locking.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (AMQ-3289) ActiveMQ has problems storing >4K
messages in Oracle
Posted by "Gary Tully (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/AMQ-3289?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gary Tully resolved AMQ-3289.
-----------------------------
Resolution: Fixed
updated the blob adapter in revision: http://svn.apache.org/viewvc?rev=1095376&view=rev
Need someone with a handy Oracle install to validate the fix. Verify send received persistent messages > 4k
Kicked off a snapshot that will be done in an hour or so.
> ActiveMQ has problems storing >4K messages in Oracle
> ----------------------------------------------------
>
> Key: AMQ-3289
> URL: https://issues.apache.org/jira/browse/AMQ-3289
> Project: ActiveMQ
> Issue Type: Bug
> Components: Message Store
> Affects Versions: 5.4.0, 5.5.0
> Reporter: Gary Tully
> Assignee: Gary Tully
> Labels: BLOB, JDBC, oracle
> Fix For: 5.6.0
>
>
> The oracle persistence adapter extends the blob jdbc adapter but it has gotten out of sync with the method overrides. @Override to the rescue for the future.
> The blob adapter uses native blob streaming to insert data (which can accommodate > 4k) but it has been out of step for some time.
> The implementations need to be brought into line w.r.t to the api, schema and locking.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (AMQ-3289) ActiveMQ has problems storing >4K
messages in Oracle
Posted by "Gary Tully (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/AMQ-3289?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gary Tully resolved AMQ-3289.
-----------------------------
Resolution: Fixed
patch applied with thanks in http://svn.apache.org/viewvc?rev=1173605&view=rev
@William, if you get a chance, can you validate tonight's 5.6-SNAPSHOT against Oracle.
> ActiveMQ has problems storing >4K messages in Oracle
> ----------------------------------------------------
>
> Key: AMQ-3289
> URL: https://issues.apache.org/jira/browse/AMQ-3289
> Project: ActiveMQ
> Issue Type: Bug
> Components: Message Store
> Affects Versions: 5.4.0, 5.5.0
> Reporter: Gary Tully
> Assignee: Gary Tully
> Labels: BLOB, JDBC, oracle
> Fix For: 5.6.0
>
> Attachments: BlobJDBCAdapter.java, OracleJDBCAdapter.java
>
>
> The oracle persistence adapter extends the blob jdbc adapter but it has gotten out of sync with the method overrides. @Override to the rescue for the future.
> The blob adapter uses native blob streaming to insert data (which can accommodate > 4k) but it has been out of step for some time.
> The implementations need to be brought into line w.r.t to the api, schema and locking.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira