Hi All I have just noticed that my last e-mail contained some typos which provided to give the wrong information.
What I am trying to say is that openjpa seems to ignore the specified schem when openjpa.jdbc.Schema property in my persistence.xml file. This works fine with the H2 database but not the HSQLDB database. It would be nice to know if there is a way of getting openjpa to use the Schema set in HSQLDB. Thanks David On Thu, 2009-10-22 at 20:08 +0100, David Beer wrote: > Hi Kevin > > I use the property openjpa.jdbc.Schema set in my persistence.xml file. > It would appear that the schema name is being recognised properly. I am > using openjpa 1.2.1. It seems similar to this Jira issue > https://issues.apache.org/jira/browse/OPENJPA-842. I am not sure though, > it would be good to be able to use a separate schema. > > Thanks > > David > > On Thu, 2009-10-22 at 08:27 -0500, Kevin Sutter wrote: > > Hi David, > > There are several JPA-defined mechanisms to override a schema name. > > You can specify a schema name on the @Table or @SecondaryTable > > annotation. You can specify a default schema name in an orm.xml file. > > Or, you can use the OpenJPA-specific property openjpa.jdbc.Schema [1] > > in your persistence.xml. > > > > Are you indicating that these approaches are not sufficient for your > > scenario? Or, are these not working with HSQLDB? > > > > Hope this helps, > > Kevin > > > > [1] > > http://openjpa.apache.org/builds/latest/docs/manual/manual.html#openjpa.jdbc.Schema > > > > On Thu, Oct 22, 2009 at 6:23 AM, David Beer > > <[email protected]> wrote: > > Hi All > > > > Is there anyway to get openjpa and HSQLDB to use a different > > schema to > > the default one. > > > > > > -- > > Thanks > > > > David > > > > >
