I posted recently about an issue I was having with columns annotated with @Lob. As suggested on that thread, I decided to try using a different driver. The SQL 2005 driver appeared to be backward compatible with SQL 2000 so I tried using that. No good. On running my test app I get the following error:
Class [com.microsoft.jdbc.sqlserver.SQLServerDriver] not found
I did a bit of a search and discovered that the class has been renamed for the 2005 version to com.microsoft.sqlserver.jdbc
I tested the 2005 driver in a separate app. just to make sure I COULD connect to my SQL 2000 database and it worked fine. So - I'm assuming that the JPA is looking for the class com.microsoft.jdbc.sqlserver.SQLServerDriver and that there is nothing I can do to resolve this?
I'm using Build b58g-fcs (09/07/2007) of Oracle Toplink Essentials, which I believe is the latest stable release.
I'm SO frustrated with this now. I'm really liking the JPA but this could be a bit of a showstopper for me using it. I'm going to check out a workaround suggested on my previous thread - I posted this new message because the title better reflects the problem I have now.
[Message sent by forum member 'sprite64' (sprite64)]
http://forums.java.net/jive/thread.jspa?messageID=245388