Isn't is possible to also support Microsoft SQL server?
Haven't tested it with SQL server but you can download the jTDS driver at http://jtds.sourceforge.net/.
Just extract the jar from the distribution, put it in the DBEdit 2 installation dir and connect with jdbc:jtds:sqlserver://<server>[:<port>][/<database>]
I haven't had the oppurtunity to test the jTDS-drivers... I tested with the official microsoft-drivers (com.microsoft.sqlserver.jdbc.SQLServerDriver, jdbc:sqlserver://<server>;DatabaseName=<database>)
The database-structure (tables and columns) are displayed, but I can't retrieve the data or perform a sql-query.
com.microsoft.sqlserver.jdbc.SQLServerException: The cursor type/concurrency combination is not supported.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.<init>(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.createStatement(Unknown Source)
at java.lang.Thread.run(Unknown Source)
It looks like a code-thing (haven't had time to realy check it, but it's right after a check for other database-types, my guess is thas mssql should also be checked here), but if you think it might work better with jTDS I will try them later...
I see, it's indeed a database type check in the code. I now made it more generic and created an intermediate test version. You can find it here: http://dbedit2.sourceforge.net/DBEdit2.2.2_DEV_setup.exe. Can you let me know if this works. If so, I'll include these changes in the next release.
The fix works flawless!
I tested some select-queries and update-queries, no problemsn found...
Thanks for the quick fix!
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.