Re: JDBC4 Support?

From: Dov Rosenberg (DRosenber..nquira.Com)
Date: Tue Apr 13 2010 - 14:41:44 EDT

  • Next message: John Huss (JIRA): "[OS-JIRA] Created: (WOL-1158) Patternset behaviour different with ant and incremental builder (again)"

    Apache-commons DBCP seems to work for non EOF type of calls. We haven't
    tried using a connection pool with EOF yet

    Dov

    On 4/13/10 2:03 PM, "David Brusowankin" <skidance..mail.com> wrote:

    > We use jtds in production for some critical systems. I wish it had better
    > connection pooling support though. The windows authentication works fine so
    > we're pretty OK.
    >
    > I just haven't had enough experience with the MSFT driver to make a good
    > comparison. I remember trying some tests with it and it seemed OK but they
    > were far from exhaustive.
    >
    > Do you have a good solution for pooling with JTDS?
    > Good Luck,
    >
    > David
    >
    >
    > On Apr 13, 2010, at 1:47 PM, Dov Rosenberg wrote:
    >
    >> We were looking to move to the Microsoft driver, thinking that MSFT will be
    >> more motivated to keeping it current. We have been using the JTDS driver but
    >> up until a couple of months ago it had rarely been updated.
    >>
    >> Any thoughts regarding JTDS versus MSFT driver?
    >>
    >> Thanks
    >>
    >> Dov
    >>
    >>
    >> On 4/13/10 1:43 PM, "David Brusowankin" <skidance..mail.com> wrote:
    >>
    >>> Can't you use the jtds driver rather than the microsoft driver? Jtds works
    >>> fine with Java 6.
    >>>
    >>> Good Luck,
    >>> David
    >>>
    >>> On Apr 13, 2010, at 11:14 AM, Dov Rosenberg wrote:
    >>>
    >>>> Has anyone run into any issues with using the latest Microsoft JDBC 2.0
    >>>> driver for SQL Server? We are running under Java 6 which requires the
    >>>> sqljdbc4.jar driver which incorporates JDBC4 spec. We are running into
    >>>> strange behavior where the EOF framework is using NSData types for nvarchar
    >>>> or nchar because it seems that the JDBCInfo is returning ­9 and ­16 instead
    >>>> of the expected data types.
    >>>>
    >>>> Any help or ideas would be appreciated
    >>>>
    >>>> Thanks in advance
    >>>>
    >>>> Dov
    >>>
    >>
    >



    This archive was generated by hypermail 2.0.0 : Tue Apr 13 2010 - 14:42:31 EDT