6 Replies Latest reply on Dec 5, 2001 9:24 PM by schaefera

    jdbc odbc driver

    serifu

      Hi i use tomcat 3.2.3 and java servlet.I have a merand odbc driver...i think my driver doesn't work very well because i have a strange problem.Please give me some links with jdbc/odbc drivers which works well.I'm on win2000 & tomcat 3.2.3 system

        • 1. Re: jdbc odbc driver
          schaefera

          Please don't use JDBC-ODBC bridge. The problem is that this JDBC driver is only for testing / evaluation purposes and should not be used for development and/or production.

          Andy

          • 2. Re: jdbc odbc driver
            serifu

            Can you give me an idea where i can find a good driver(free if it can) on the internet.I downloaded from microsoft a new driver.Is this good?Thanks in advance...

            • 3. Re: jdbc odbc driver

              you can find the driver at:
              http://www.microsoft.com/sql/downloads/2000/jdbc.asp

              it looks like this driver is from merant BUT if you plan to use the sqlServer2000 bigint data type the driver has some bugs:

              java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]
              Unhandled data type: TDS_INT8

              statement form Sarah Parra Microsoft Developer Support:
              Right now the only workaround is to allow the column to be Nullable
              (from the microsoft newsgroup: microsoft.public.sqlserver.jdbcdriver)

              joe

              • 4. Re: jdbc odbc driver

                you can take a look at this free driver:

                http://www.thinweb.com/tw_products_twfreetds.html

                • 5. Re: jdbc odbc driver
                  katarzyna.hedlund

                  > Please don't use JDBC-ODBC bridge. The problem is
                  > that this JDBC driver is only for testing /
                  > evaluation purposes and should not be used for
                  > development and/or production.
                  >
                  > Andy

                  Why? Is this because it doesn´t work properly in all situations, or is it because of licencing issues?
                  Just like to know - Katarzyna

                  • 6. Re: jdbc odbc driver
                    schaefera

                    No, the JDBC-ODBC bridge is not thread-safe and will create problems when load increases. Also the guys from Sun did indent to write a good JDBC driver but just an example which works on Windows to show JDBC in action.
                    Somewhere on Javasoft side you will find a note explaining it a little bit more in details.

                    Motto: Whenever you are going to create a bigger or a reliable project don't use it.