cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tore Halset (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CAY-2024) check for AUTO_PK_TABLE should respect current schema
Date Sat, 26 Sep 2015 21:39:04 GMT

    [ https://issues.apache.org/jira/browse/CAY-2024?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14909491#comment-14909491
] 

Tore Halset commented on CAY-2024:
----------------------------------

I had to upgrade jdbc drivers for Derby and PostgreSQL in my project to use Connection#getSchema.
I do not know the state of all the jdbc drivers out there and if people can upgrade their
drivers.

> check for AUTO_PK_TABLE should respect current schema
> -----------------------------------------------------
>
>                 Key: CAY-2024
>                 URL: https://issues.apache.org/jira/browse/CAY-2024
>             Project: Cayenne
>          Issue Type: Bug
>            Reporter: Tore Halset
>            Assignee: Andrus Adamchik
>            Priority: Minor
>             Fix For: Undefined future
>
>
> The create/delete/insert/update of AUTO_PK_TABLE should respect the schema in the model.
There are other older issues covering this.
> When a schema is not defined in the model, the create/delete/insert/update of AUTO_PK_TABLE
in the default schema works fine. However, the check for AUTO_PK_TABLE in JdbcPkGenerator#autoPkTableExists
are currently looking in all schemas. But it should only check in the current schema.
> I discovered this when trying to run several instances of one cayenne application on
different schemas in the same database.
> In java 7, they added java.sql.Connection#getSchema that should return the current schema.
However, cayenne 4 seem to be at java 6. To make getSchema work also jdbc drivers and connection
pools must be updated. Do we need to create our own getSchema(Connection), or do we already
have it, or are cayenne 4 going to be java 7+?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message