openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Fay Wang (JIRA)" <>
Subject [jira] Commented: (OPENJPA-973) Allow DB2 JCC driver to work with Informix database
Date Thu, 07 May 2009 16:03:30 GMT


Fay Wang commented on OPENJPA-973:

There is an open issue with db2 jcc driver when connecting to Informix.

A similar call to getColumns work with both jcc and native jdbc driver:

        ResultSet rs = dbMeta.getColumns("demodb", null, "jpataskbean", null); ==> jcc
return columns

	However, the getImportedKeys does not work with jcc driver:

	     rs = dbMeta.getImportedKeys("demodb", null, "jpataskbean"); ==> jcc returns empty
result set
There can be two possibilities here.

The database metadata methods in the driver are implemented by calling a stored procedure
on the server. So the problem could be in the in the stored procedure.

Or since the  IDS server supports two different protocols (i.e. sqli and drda). It is possible
that getImportedKeys is working in sqli protocol which is used with Informix legacy jdbc driver
and not working with drda protocol which is used by JCC driver.

Either way this does seems to be a JCC driver problem.

> Allow DB2 JCC driver to work with Informix database
> ---------------------------------------------------
>                 Key: OPENJPA-973
>                 URL:
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: jdbc
>            Reporter: Fay Wang
>             Fix For: 2.0.0
>         Attachments: OPENJPA-973.patch
> Openjpa parses the DatabaseMetaData retrieved from the jdbc connection to determine the
database type. For informix, if db2jcc driver is used, the product name in the DatabaseMetaData
does not start with "informix", but with "ids"

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message