[
https://issues.apache.org/jira/browse/QPID-8257?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16676506#comment-16676506
]
Alex Rudyy commented on QPID-8257:
----------------------------------
Hi Olivier,
Could you please provide Sybase exception stack trace for adding a message with
an empty body?
I am a bit confused here as JDBC message store is not setting explicitly
content column to null for an empty message content. A binary stream is always
written for a message content (see
{{org.apache.qpid.server.store.jdbc.AbstractJDBCMessageStore#addContent}}).
It seems your patch cannot be applied as JDBC store tests are failing with
Derby on attempt to declare nullable blob field (content blob null). We need to
look for a bit different solution.
> Sybase message store not supporting empty messages
> --------------------------------------------------
>
> Key: QPID-8257
> URL: https://issues.apache.org/jira/browse/QPID-8257
> Project: Qpid
> Issue Type: Bug
> Components: Broker-J
> Affects Versions: qpid-java-broker-7.0.3
> Reporter: Olivier VERMEULEN
> Priority: Major
>
> Unlike other databases Sybase default nullability for a column is "NOT NULL".
> And since we don't specify anything when creating the QPID_MESSAGE_CONTENT
> table, the "content" column defaults to "NOT NULL".
> So when we send an empty message, this constraint is broken and we receive a
> SybSQLException...
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]