Mailing-List: contact open-jpa-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: open-jpa-dev@incubator.apache.org
Received-SPF: pass (herse.apache.org: domain of plinskey@bea.com designates
 66.248.192.22 as permitted sender)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Schema and Table Name sometimes being ignored when supplied onl
 in orm.xml
Date: Mon, 15 Jan 2007 17:07:20 -0800
Message-ID: <7D856CDFE035FF45A0420ACBD71BDD6302DB0EDA@repbex02.amer.bea.com>
In-Reply-To: <45ABC9F1.7060105@pobox.com>
Thread-Topic: Schema and Table Name sometimes being ignored when supplied onl
 in orm.xml
Thread-Index: Acc41Gq/sE5p19ioTVeu/MZapGfAvgANjomQ
From: "Patrick Linskey" <plinskey@bea.com>
To: <open-jpa-dev@incubator.apache.org>

What do you get when you set the MetaData log channel to TRACE?

-Patrick

--=20
Patrick Linskey
BEA Systems, Inc.=20

_______________________________________________________________________
Notice:  This email message, together with any attachments, may contain
information  of  BEA Systems,  Inc.,  its subsidiaries  and  affiliated
entities,  that may be confidential,  proprietary,  copyrighted  and/or
legally privileged, and is intended solely for the use of the individual
or entity named in this message. If you are not the intended recipient,
and have received this message in error, please immediately return this
by email and then delete it.=20

> -----Original Message-----
> From: Don Brady [mailto:dbrady@pobox.com]=20
> Sent: Monday, January 15, 2007 10:38 AM
> To: open-jpa-dev@incubator.apache.org
> Subject: Schema and Table Name sometimes being ignored when=20
> supplied onl in orm.xml
>=20
> I have entities like this which intentionally omit the schema and
> table names:
>=20
> @Entity
> // @Table(name =3D "V_MBK_KEY") specified in orm.xml
> public class FeMbkKey implements Serializable {
> ........
>=20
> and in orm.xml I add the name and schema:
>=20
>          ......
> 	<persistence-unit-metadata>
> 	 <persistence-unit-defaults>
> 	   <schema>CLMR</schema>
>           </persistence-unit-defaults>
> 	</persistence-unit-metadata>
> 	<package>com.ncfbins.services.mship.entity.entities</package>
> 	<schema>CLMR</schema>
> =09
> 	<entity class=3D"FeMbkKey">
> 		<table name=3D"V_MBK_KEY" schema=3D"CLMR" />
> 	</entity>
>=20
>           ......
>=20
>=20
>   This works fine a lot of the time, resulting in correct queries like
>=20
> SELECT MAX(f.mbkMemberIdNbr) FROM CLMR.V_MBK_KEY f .....
>=20
> that work fine.
>=20
> However, sometimes it gets into a permanent manner of=20
> behavior where it
> omits the table and schema additions that are in orm.xml; all queries
> fail in the database because schema and table never got=20
> inserted before
> the query is issued.
>=20
> The final query sent to the database in such cases is=20
> omitting the real
> schema and table name from orm.xml:
>=20
> SELECT MAX(f.mbkMemberIdNbr) FROM FeMbkKey f
>=20
> Of course these fail because there is no FeMbkKey table in=20
> the database,
> just a CLMR.V_MBK_KEY table.
>=20
> The strange thing is that nothing helps now to get it to go back to
> honoring orm.xml.  Yet, I have made essentially no changes=20
> from when it
> worked to when it stopped working.
>=20
> I have stepped through the openjpa source code and it is accessing and
> parsing orm.xml successfully.  Perhaps someone can tell me where would
> be a couple of places in the source code to set breakpoints to see why
> it is not translating the entity name into the Query.  I have tried
> using fully-package-qualified class names in orm.xml and that does not
> help.  I have traced through PersistenceMetaDataFactory and other
> classes and cannot see where it goes wrong.
>=20
> This is all on 0.9.6 final under WebSphere.  It occurs on straight
> openjpa 0.9.6 and also on IBM's packaged alpha update, and on multiple
> fixpack levels of WebSphere.  I think I tried 0.9.7 too.
>=20
>   For now, I will have to go back to putting the class and=20
> table in the
> entities but eventually I want to be able to not bind those right into
> the entities as we have multiple environments to run in...
>=20
>   Thanks!
>=20
>   Don
>=20
>=20
>=20
>=20
>=20