You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@activemq.apache.org by Jeroen Nikkels <je...@infor.com> on 2013/06/07 09:56:22 UTC

image datatype deprecated for future sqlserver versions

I'm using ActiveMQ (5.7) with sqlserver persistence, using the jtds jdbc
driver. I see that the JDBCAdapter being used is derived from
ImageBasedJDBCAdapter, which means that binary data is stored with datatype
'image'. On MSDN I read that the image datatype will be deprecated in the
future: see  MSDN <http://msdn.microsoft.com/en-us/library/ms187993.aspx>  .

Wouldn't it be better to start using varbinary(max) instead of image? I did
not find a way to customize that with the current ActiveMQ version. I tried
to change Statements, but ImageBasedJDBCAdapter seems to override my change
and always use 'image'. Should I write my own adapter?

Hope someone can help...

Regards,
Jeroen



--
View this message in context: http://activemq.2283324.n4.nabble.com/image-datatype-deprecated-for-future-sqlserver-versions-tp4667994.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.