#1 MicrosoftSQL-server support

closed
nobody
None
5
2010-03-26
2010-03-24
Dennis
No

Isn't is possible to also support Microsoft SQL server?

Discussion

  • Jef Van Den Ouweland

    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>]

     
  • Dennis

    Dennis - 2010-03-26

    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.

    Example-error:
    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 dbedit.actions.RunAction.performThreaded(RunAction.java:65)
    at dbedit.actions.CustomAction$1.execute(CustomAction.java:64)
    at dbedit.ThreadedAction.run(ThreadedAction.java:52)
    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...

     
  • Jef Van Den Ouweland

    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.

     
  • Dennis

    Dennis - 2010-03-26

    The fix works flawless!
    I tested some select-queries and update-queries, no problemsn found...

    Thanks for the quick fix!

     
  • Jef Van Den Ouweland

    • status: open --> closed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks