Tried.
13:22:58.892 [main] INFO OpenEJB.startup.config - Configuring
PersistenceUnit(name=a_foo)
13:22:58.893 [main] INFO OpenEJB.startup.config - Auto-creating a Resource
with id 'jdbc/acme_fooNonJta' of type 'DataSource for 'a_foo'.
13:22:58.893 [main] INFO OpenEJB.startup.config - Configuring
Service(id=jdbc/acme_fooNonJta, type=Resource, provider-id=jdbc/acme_foo)
13:22:58.893 [main] INFO OpenEJB.startup.config - Adjusting
PersistenceUnit a_foo <non-jta-data-source> to Resource ID
'jdbc/acme_fooNonJta' from 'null'
13:22:58.893 [main] INFO OpenEJB.startup.config - Configuring
PersistenceUnit(name=a_bar)
13:22:58.894 [main] INFO OpenEJB.startup.config - Auto-creating a Resource
with id 'jdbc/acme_barNonJta' of type 'DataSource for 'a_bar'.
13:22:58.894 [main] INFO OpenEJB.startup.config - Configuring
Service(id=jdbc/acme_barNonJta, type=Resource, provider-id=jdbc/acme_bar)
13:22:58.894 [main] INFO OpenEJB.startup.config - Adjusting
PersistenceUnit a_bar <non-jta-data-source> to Resource ID
'jdbc/acme_barNonJta' from 'null'
It seems to have cleaned up wiring persistence unit to data source but
tests still fail with same infamous "user lacks privileges..." error. As if
connection/database is not actually there when schema is about to be
created.
Persistence unit references only jta data source. I wonder why are only
unmanaged non-jta data sources mentioned in openejb logs. And if I
understand logs well, only unmanaged sources are created and "wired" to
persistence units.
It didn't help adding
"<non-jta-data-source>jdbc/acme_fooNonJta</non-jta-data-source>" and
"<non-jta-data-source>jdbc/acme_barNonJta</non-jta-data-source>" to
persistence.xml
Logs after adding non-jta-data-source look like
13:58:32.299 [main] INFO OpenEJB.startup.config - Configuring
Service(id=jdbc/acme_bar, type=Resource, provider-id=Default JDBC Database)
13:58:32.300 [main] INFO OpenEJB.startup.config - Configuring
Service(id=jdbc/acme_foo, type=Resource, provider-id=Default JDBC Database)
...
13:58:33.408 [main] INFO OpenEJB.startup.config - Configuring
PersistenceUnit(name=a_foo)
13:58:33.409 [main] INFO OpenEJB.startup.config - Auto-creating a Resource
with id 'jdbc/acme_fooNonJta' of type 'DataSource for 'a_foo'.
13:58:33.409 [main] INFO OpenEJB.startup.config - Configuring
Service(id=jdbc/acme_fooNonJta, type=Resource, provider-id=jdbc/acme_foo)
13:58:33.409 [main] INFO OpenEJB.startup.config - Configuring
PersistenceUnit(name=a_bar)
13:58:33.410 [main] INFO OpenEJB.startup.config - Auto-creating a Resource
with id 'jdbc/acme_barNonJta' of type 'DataSource for 'a_bar'.
13:58:33.410 [main] INFO OpenEJB.startup.config - Configuring
Service(id=jdbc/acme_barNonJta, type=Resource, provider-id=jdbc/acme_bar)
...
I don't understand there "provider-id=Default JDBC Database". I guess it's
some sort of shared parent template datasource/metadata.
Kind regards,
Stevo Slavić.
On Wed, Jun 27, 2012 at 1:20 PM, Romain Manni-Bucau
<rmannibu...@gmail.com>wrote:
> Hi,
>
> can you try removing java: in persistence.xml?
>
>
> - Romain
>
>
> 2012/6/27 Stevo Slavić <ssla...@gmail.com>
>
> > Hello OpenEJB community,
> >
> > I'm migrating a legacy system to Java EE 6 and JBoss AS 7.1.1
> > With the upgrade came "updated" JBoss AS 7.1.1 provided CXF version
> > (2.4.6). This broke and revealed all yet rare openejb tests. Then I
> > upgraded openejb too, from 3.1.4 to 4.0.0 but not all tests are passing.
> > To be more specific there is 1 passing, and 2 failing tests, all in same
> > module using shared jndi.properties, persistence.xml, and ejb-jar.xml
> > In jndi.properties (see [1]) two data sources are configured for openejb
> to
> > create.
> > In persistence.xml there are two persistence units. Each PU references a
> > single data source.
> >
> > Test that passes, has EntityManager instance injected
> > (@PersistenceContext(name="a_bar", unitName="a_bar" )) and successfully
> > executes queries, like select on Entity2.
> > Tests that fail, fail late, when createQuery is issued on other injected
> > EntityManager instance (@PersistenceContext(name="a_foo",
> > unitName="a_foo")) - HSLQDB reports "user lacks privilege or object not
> > found: PUBLIC.ENTITY2 {stmnt 1836093446 ALTER TABLE ENTITY2 ADD COLUMN ID
> > NUMERIC} [code=-5501, state=42501]"
> >
> > There seems to be an issue with schema creation. To fail earlier, I
> > uncomment configuring openjpa.InitializeEagerly to true.
> >
> > Then in openejb log output I noticed openejb is doing some unwanted stuff
> > with data sources (see [3]), associating wrong data sources with
> > persistence units, and creating non-jta data sources which aren't
> > needed/referenced.
> >
> > It smells to me that some openejb convention is not followed well. Maybe
> > it's just HSQLDB configuration (2.2.4 is referenced by openejb, but I
> also
> > tried with 2.2.8).
> >
> > I did my "homework", found lots of entries online about "user lacks
> > privilege or object not found" and configuring openejb, but neither of
> them
> > helped.
> >
> > Does anyone see what could be wrong here?
> >
> > I'd like to preserve persistence.xml as-is, while jndi.properties can be
> > changed or even replaced entirely with openejb.xml if needed.
> >
> > Kind regards,
> > Stevo Slavić.
> >
> >
> > [1] jndi.properties
> >
> >
> >
> java.naming.factory.initial=org.apache.openejb.client.LocalInitialContextFactory
> > openejb.embedded.remotable=true
> > openejb.altdd.prefix=test.
> >
> > jdbc/acme_foo=new://Resource?type=DataSource
> > jdbc/acme_foo.JdbcUrl=jdbc:hsqldb:mem:acme_foo
> > jdbc/acme_foo.JdbcDriver=org.hsqldb.jdbcDriver
> > jdbc/acme_foo.Username=sa
> > jdbc/acme_foo.Password=
> > jdbc/acme_foo.JtaManaged=true
> >
> > jdbc/acme_bar=new://Resource?type=DataSource
> > jdbc/acme_bar.JdbcUrl=jdbc:hsqldb:mem:acme_bar
> > jdbc/acme_bar.JdbcDriver=org.hsqldb.jdbcDriver
> > jdbc/acme_bar.Username=sa
> > jdbc/acme_bar.Password=
> > jdbc/acme_bar.JtaManaged=true
> >
> >
> > [2] persistence.xml
> >
> > <?xml version="1.0" encoding="UTF-8"?>
> > <persistence version="2.0"
> > xmlns="http://java.sun.com/xml/ns/persistence"; xmlns:xsi="
> > http://www.w3.org/2001/XMLSchema-instance";
> > xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
> > http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd";>
> >
> > <persistence-unit name="a_foo" transaction-type="JTA">
> > <jta-data-source>java:jdbc/acme_foo</jta-data-source>
> >
> > <class>a.foo.model.Entity1</class>
> > <exclude-unlisted-classes>true</exclude-unlisted-classes>
> >
> > <properties>
> > <property name="hibernate.dialect"
> > value="org.hibernate.dialect.Oracle10gDialect"/>
> > <property name="hibernate.show_sql" value="true"/>
> > <property name="hibernate.transaction.manager_lookup_class"
> >
> > value="org.hibernate.transaction.JBossTransactionManagerLookup"/>
> >
> > <property name="openjpa.jdbc.SynchronizeMappings"
> > value="buildSchema(ForeignKeys=true)"/>
> > <!--
> > <property name="openjpa.InitializeEagerly" value="true"/>
> > -->
> > </properties>
> > </persistence-unit>
> >
> > <persistence-unit name="a_bar" transaction-type="JTA">
> > <jta-data-source>java:jdbc/acme_bar</jta-data-source>
> >
> > <class>a.bar.model.Entity2</class>
> > <exclude-unlisted-classes>true</exclude-unlisted-classes>
> >
> > <properties>
> > <property name="hibernate.dialect"
> > value="org.hibernate.dialect.Oracle10gDialect"/>
> > <property name="hibernate.show_sql" value="true"/>
> > <property name="hibernate.transaction.manager_lookup_class"
> >
> > value="org.hibernate.transaction.JBossTransactionManagerLookup"/>
> >
> > <property name="openjpa.jdbc.SynchronizeMappings"
> > value="buildSchema(ForeignKeys=true)"/>
> > <!--
> > <property name="openjpa.InitializeEagerly" value="true"/>
> > -->
> > </properties>
> > </persistence-unit>
> > </persistence>
> >
> >
> > [3] openejb container startup log fragment
> >
> > 11:50:07.459 [main] INFO OpenEJB.startup.config - Configuring
> > PersistenceUnit(name=a_foo)
> > 11:50:07.462 [main] INFO OpenEJB.startup.config - Auto-creating a
> Resource
> > with id 'jdbc/acme_barNonJta' of type 'DataSource for 'a_foo'.
> > 11:50:07.462 [main] INFO OpenEJB.startup.config - Configuring
> > Service(id=jdbc/acme_barNonJta, type=Resource, provider-id=jdbc/acme_bar)
> > 11:50:07.462 [main] INFO OpenEJB.startup.config - Adjusting
> > PersistenceUnit a_foo <jta-data-source> to Resource ID 'jdbc/acme_bar'
> from
> > 'java:jdbc/acme_foo'
> > 11:50:07.462 [main] INFO OpenEJB.startup.config - Adjusting
> > PersistenceUnit a_foo <non-jta-data-source> to Resource ID
> > 'jdbc/acme_barNonJta' from 'null'
> > 11:50:07.462 [main] INFO OpenEJB.startup.config - Configuring
> > PersistenceUnit(name=a_bar)
> > 11:50:07.463 [main] INFO OpenEJB.startup.config - Adjusting
> > PersistenceUnit a_bar <jta-data-source> to Resource ID 'jdbc/acme_bar'
> from
> > 'java:jdbc/acme_bar'
> > 11:50:07.463 [main] INFO OpenEJB.startup.config - Adjusting
> > PersistenceUnit a_bar <non-jta-data-source> to Resource ID
> > 'jdbc/acme_barNonJta' from 'null'
> >
>
