[jira] Commented: (OPENJPA-973) Allow DB2 JCC driver to work with Informix database

["Fay Wang (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OPENJPA-973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12706954#action_12706954 ] 

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: https://issues.apache.org/jira/browse/OPENJPA-973
>             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.