March 4, 2009 at 9:12 am
Hi All
I am planning to use File stream date type on SQL 2008, when i read about the JDBC side, it seems that MS has not yet realised a new driver version for SQL 2008, has any one got this problem , does the latest JDBC 2.0 supports file stream 🙂
March 4, 2009 at 9:44 am
I tried several times to get Microsoft's JDBC driver to work, with no chance. It's buggy and slow, I would never recommend it. Try jtds instead (http://jtds.sourceforge.net).
Unfortunaltely there's no sql 2008 specific release, but I think the community is working on it.
Hope this helps you
Regards
Gianluca
-- Gianluca Sartori
March 4, 2009 at 10:19 am
We are using JDBC1.2 it works fine( According to developers) but it doesn't support Filestreaming, jTDS seems that it doesn't support BLOB, correct me here if i am wrong.
March 5, 2009 at 1:34 am
I don't use BLOBs in my databases, so I can't say anything about it. I took a look at the FAQ page on JTDS site and it looks like there's no problem with BLOBs. The only thing I can tell you is that jtds never let me down, something I can't honestly say of Microsoft's driver.
For sure FileStream isn't supported yet, but I wouldn't be surprised to see it implemented by jtds much before Microsoft. This is probably because Microsoft doesn't have big interests in keeping the java world going...
Time will tell
-- Gianluca Sartori
July 20, 2010 at 4:03 pm
We are successfully using BLOB and jTDS driver w/ SQL Server 2008
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply