You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openjpa.apache.org by apph <k....@gmail.com> on 2014/04/16 22:43:50 UTC
openjpa.jdbc.Schemas configuration property
According to the documentation:
This property accepts a comma-separated list of schemas and tables
However, when I'm trying to specify two schemas in the form like <property
name="openjpa.jdbc.Schema" value="SCHEMA1,SCHEMA2"/> i do not get any
results. When I specify only one I'm getting the generated entities.
I'm using Oracle database and
org.apache.openjpa.jdbc.meta.ReverseMappingTool.
I was checking the source code and I don't know how it can work as it goes
down to this class:
oracle.jdbc.driver.OracleDatabaseMetaData and there is this comparison:
WHERE t.owner LIKE :1 where :1 is the passed schema value, so
"SCHEMA1,SCHEMA2". The values in the owner column are particular schema
values: SYSTEM, SCHEMA1, SYSTEM, SCHEMA2, SCHEMA3, etc....
--
View this message in context: http://openjpa.208410.n2.nabble.com/openjpa-jdbc-Schemas-configuration-property-tp7586236.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
Re: openjpa.jdbc.Schemas configuration property
Posted by Kevin Sutter <kw...@gmail.com>.
There are two properties with very similar names...
openjpa.jdbc.Schema
openjpa.jdbc.Schemas
The plural version allows for the list of schemas to be used schema
reflection.
On Wed, Apr 16, 2014 at 3:43 PM, apph <k....@gmail.com> wrote:
> According to the documentation:
> This property accepts a comma-separated list of schemas and tables
>
> However, when I'm trying to specify two schemas in the form like <property
> name="openjpa.jdbc.Schema" value="SCHEMA1,SCHEMA2"/> i do not get any
> results. When I specify only one I'm getting the generated entities.
> I'm using Oracle database and
> org.apache.openjpa.jdbc.meta.ReverseMappingTool.
>
> I was checking the source code and I don't know how it can work as it goes
> down to this class:
> oracle.jdbc.driver.OracleDatabaseMetaData and there is this comparison:
> WHERE t.owner LIKE :1 where :1 is the passed schema value, so
> "SCHEMA1,SCHEMA2". The values in the owner column are particular schema
> values: SYSTEM, SCHEMA1, SYSTEM, SCHEMA2, SCHEMA3, etc....
>
>
>
> --
> View this message in context:
> http://openjpa.208410.n2.nabble.com/openjpa-jdbc-Schemas-configuration-property-tp7586236.html
> Sent from the OpenJPA Users mailing list archive at Nabble.com.
>