Sunday, August 4, 2002 10:06 PM
I answered this question here:The Answer
Basically, the jdbc odbc bridge driver is lame, it doesn't
support a ton of usefull features that any basic
application developer would maybe want support for in
a generic dbase. In my case, this was support of blob
and clob type data fields, the driver didn't know
how to handle transforming these data types to java.
The solution, was to simply download better drivers! I was
testing my app. with a MS SqlServer2000 dbase to start
so I went to MS looking for a jdbc driver and sure
enough they had posted one some time in may, I
downloaded it hoping it would support extraction of
clob and blob type fields (ntext is one of these datatypes)..so anyway I downloaded it, installed the
package in my classpath and switched my apps. dbase xml file (xml rocks for application configuration files..)
and tried the test...well it didn't work ..but the reason why is specified more fully in the link I provided
earlier, needless to say after that tweak was performed on the dbase
box it worked fine. If you are having similar issues, and are getting "unsupported feature" errors, most
likely you have to get a better driver from the dbase vendor itself or there are some thirdparty guys that will
give you an all in one driver ...for a fee of course!
Here's a link to Sun's website driver finder tool, FIND DRIVERS
That is all..