MS SQL using TSQL via JAVA jdbc

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • asufty888@gmail.com
    #1

    MS SQL using TSQL via JAVA jdbc

    Hello. I am having trouble finding a descent API for executing TSQL
    via JDBC. I have tried the Microsoft driver AND the JDTS driver's but
    get the same syntax errors. I am hoping there is a good solution also
    for executing scripts using the same. Any help is MUCH
    appreciated.Thx .

    Tags: None
    • Erland Sommarskog
      #2
      Re: MS SQL using TSQL via JAVA jdbc

      (asufty888@gmai l.com) writes:
      Hello. I am having trouble finding a descent API for executing TSQL
      via JDBC. I have tried the Microsoft driver AND the JDTS driver's but
      get the same syntax errors. I am hoping there is a good solution also
      for executing scripts using the same. Any help is MUCH
      appreciated.Thx .
      I believe that Datadirect's driver is good. Of course, the price is
      radically different than for Microsoft's driver or jTDS.

      Then again, if you gets the same syntax errors, maybe the problem is
      with your SQL code. Have you checked that it runs OK in Query Analyzer?


      --
      Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

      Books Online for SQL Server 2005 at
      http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

      Books Online for SQL Server 2000 at
      http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

        Comment

        • joeNOSPAM@BEA.com
          #3
          Re: MS SQL using TSQL via JAVA jdbc

          On Feb 5, 10:15 am, asufty...@gmail .com wrote:
          Hello. I am having trouble finding a descent API for executing TSQL
          via JDBC. I have tried the Microsoft driver AND the JDTS driver's but
          get the same syntax errors. I am hoping there is a good solution also
          for executing scripts using the same. Any help is MUCH
          appreciated.Thx .
          *No* JDBC driver will 'execute' T-SQL. They simply send it to the
          DBMS*.
          I suspect you are confusing the syntax of OSQL (eg: with 'GO' to send
          SQL)
          with actual T-SQL. Show the JDBC code and SQL and error you get.

          Joe Weinstein at BEA Systems

          * There is a small, well-defined area of JDBC SQL extensions which
          has the driver look for specific generic tags in the SQL for some
          functions, and replace them with correct DBMS-specific SQL.

            Comment

            Previous template Next
            Working...