#327 Informix 3.0 JC3 is considered "not JDBC 2.1 compliant"

2.1rc2
closed-fixed
Core (462)
5
2014-08-29
2005-12-21
Peter F.
No

I'm using SquirrelSQL together with an Informix DB
(v.9.3) and switched from 2.0final to 2.1rc2 (and the
current CVS snapshot).

Since the switch, Squirrel always complains

The driver being used for alias 'xyz' is not JDBC 2.1
compliant.
You should consider getting a more recent version of
this driver

This occurs with Informix Driver version 3.0 JC2 and
JC3, while the latter ist the most recent version.

Squirrel reports the JDBC- and
Driver-Major/Minorversion as "3.0"

The driver docs say:
IBM Informix JDBC Driver 3.0, supported by IBM Informix
Dynamic Server 10.0 and later, is fully compliant with
the JDBC 3.0 API.

How does Squirrel determine if a driver is JDBC 2.1
compliant?
Is there an error in the detection routine, or is the
driver (together with Informix 9.30?) really not JDBC
2.1 compliant?

[This problem occurs in the CVS version of 2005-12-21, too]

Discussion

  • Rob Manning

    Rob Manning - 2005-12-21
    • assigned_to: colbell --> manningr
    • status: open --> pending-fixed
     
  • Rob Manning

    Rob Manning - 2005-12-21

    Logged In: YES
    user_id=1287991

    Hi Peter!

    You aren't the only one who has raised this issue. I recently
    added a FAQ item that explains the warning and what you can
    do about it. It's here:

    http://squirrel-sql.sourceforge.net/index.php?page=faq#faq8

    However, as I was reviewing the code, it appears that it is
    falsely identifying a driver as not JDBC 2.1 compliant.
    JDBC 2.1 added the method
    DatabaseMetaData.supportsSavepoints. If calling this method
    fails, the driver isn't compliant with the spec. However,
    it appears the code goes a little further than that. If
    the database reports that it doesn't support save points,
    then SQuirreL concludes that the driver doesn't meet the
    spec, which is erroneous. The fix is in CVS in
    Session.java. If you could rebuild from the trunk and test
    that would be perfect. If not, a new snapshot build
    should be available soon.

    Rob

     
  • Peter F.

    Peter F. - 2005-12-21

    Logged In: YES
    user_id=980055

    Hi Rob,

    thanks for this very quick fix!

    I updated the CVS, rebuild Squirrel and the complaint about
    the non-compliant driver doesn't appear anymore.

    cu
    Peter

     
  • Peter F.

    Peter F. - 2005-12-21
    • status: pending-fixed --> open-fixed
     
  • Peter F.

    Peter F. - 2005-12-21

    Logged In: YES
    user_id=980055

    I'd set the status of this issue to closed

     
  • Peter F.

    Peter F. - 2005-12-21
    • status: open-fixed --> closed-fixed
     
  • Rob Manning

    Rob Manning - 2005-12-21

    Logged In: YES
    user_id=1287991

    Peter,

    Thanks for verifying so quickly! I'm setting it to closed.

    Rob

     

Log in to post a comment.

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

Sign up for the SourceForge newsletter:





No, thanks