My Experience using ms sql is :
1. ms sql more secure
2. if foreign key doesn't match it will error
3. This is my error last week with my client : Error cannot start a clone connection
Solution is fix driver for jdbc from select method = direct into select method = cursor
On 6/3/05, Tony Spencer <[EMAIL PROTECTED]> wrote:
If anyone here has experience using Java with Microsoft SQL Server can you
comment on your preferred JDBC driver?
Currently I've tried the following. I've ranked them in order of speed
based on some crude benchmarks I performed:
1. jtds
2. i-net OPTA (my version is 3 years old so a new one may be better)
3. microsoft (this thing threw exceptions ocassionally. didn't feel like
investigating when others worked fine)
Opinions?
Tony
_______________________________________________ Juglist mailing list [email protected] http://trijug.org/mailman/listinfo/juglist_trijug.org
