[ 
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: dev-unsubscr...@qpid.apache.org
For additional commands, e-mail: dev-h...@qpid.apache.org

Reply via email to