jTDS JDBC driver not showing user tables
14 July, 2014
While testing on a Microsoft MSDE database i tried to check the functionality of different JDBC drivers. In this case i installed the jTDS drivers 1.3.1 which in first tested with DbVizualiser Pro. And that worked fine.
In YF 7.0 i changed my source to use thise driver with the same format (after i removed the 1.2.5 version which had come with the YF installation from my library) Testing this sources gives a Oke but... the userdefined tables i have to use are nog there. Even if i change my schema"filter" to None. Tables that i can see with this driver in DbVizualiser Pro.
Setting the driver back to the native Microsoft JDBC driver works (again) fine.
Are there any special URL-statements that i have tot use with jTDS? Or is this a known problem with this driver?
In YF 7.0 i changed my source to use thise driver with the same format (after i removed the 1.2.5 version which had come with the YF installation from my library) Testing this sources gives a Oke but... the userdefined tables i have to use are nog there. Even if i change my schema"filter" to None. Tables that i can see with this driver in DbVizualiser Pro.
Setting the driver back to the native Microsoft JDBC driver works (again) fine.
Are there any special URL-statements that i have tot use with jTDS? Or is this a known problem with this driver?
Hi Peter,
I don't know how you got the new driver to work, as I cannot.
Looks like the new JTDS driver uses a different class, so a tweak needs to be made to the web.xml file. Which I have not successfully been able to do as yet.
I cannot find any info on changes to the URL for the latest driver, but I would be very surprised if one was needed.
I have raised an enhancement request (TASK ID = 167763) for some testing and then the inclusion of this driver with future releases.
Until then, I'm happy to perform some more testing, just need to figure out why it's not working for me.
Out of curiosity, is there a reason why you want to use the latest driver?
Maybe there was a specific fix in the driver you wanted to use?
Thanks,
David
I don't know how you got the new driver to work, as I cannot.
Looks like the new JTDS driver uses a different class, so a tweak needs to be made to the web.xml file. Which I have not successfully been able to do as yet.
I cannot find any info on changes to the URL for the latest driver, but I would be very surprised if one was needed.
I have raised an enhancement request (TASK ID = 167763) for some testing and then the inclusion of this driver with future releases.
Until then, I'm happy to perform some more testing, just need to figure out why it's not working for me.
Out of curiosity, is there a reason why you want to use the latest driver?
Maybe there was a specific fix in the driver you wanted to use?
Thanks,
David
The main reason for trying the driver is that i'm testing all kind and drivers and functionality to find out how YF behaves and what might be the right driver use when developing solutions on MS SQL and XML databases. And while this driver worked fine with DBVizualiser i'd expected the same behavior in YF. But for now, i'll work with the previous release.
SOLVED!
The source of this failure appeared to be an error in the configuration string. Although jTDS accepts parameters like param=nnn, it doesn't support the parameter "database=mydatabase". Instead you'll have to use "...://Server:Port/mydatabase" That's how it's writen in the documentation, but while i used the Microsoft JDBC-driver before on this source (while quickly scanning the jTDS-documentation) i didn't catch that this parameters (database=) doesn't exist.
Normally i had expected an error-message in this situation or a result showing no tables or views at all. And that's where it went wrong. No error-message and just the systemtables in the list of this source. So just like a failure in the access-rights... In this case i like to state that this is, to my opinion, not a failure in YellowFin but just a mather of error-handling of this driver.
The source of this failure appeared to be an error in the configuration string. Although jTDS accepts parameters like param=nnn, it doesn't support the parameter "database=mydatabase". Instead you'll have to use "...://Server:Port/mydatabase" That's how it's writen in the documentation, but while i used the Microsoft JDBC-driver before on this source (while quickly scanning the jTDS-documentation) i didn't catch that this parameters (database=) doesn't exist.
Normally i had expected an error-message in this situation or a result showing no tables or views at all. And that's where it went wrong. No error-message and just the systemtables in the list of this source. So just like a failure in the access-rights... In this case i like to state that this is, to my opinion, not a failure in YellowFin but just a mather of error-handling of this driver.