Check in the log "Auto-adjusting" or "Adjusting" lines.
That said openejb.xml is not read in WEB-INF. Maybe you thought to resources.xml? Romain Manni-Bucau Twitter: @rmannibucau Blog: http://rmannibucau.wordpress.com/ LinkedIn: http://fr.linkedin.com/in/rmannibucau Github: https://github.com/rmannibucau 2013/9/18 kuba44 <[email protected]>: > I add to web/WEB-INF dictionary openejb.xml file: > > <?xml version="1.0" encoding="UTF-8"?> > <openejb> > <Resource id="myDatabase" type="DataSource"> > JdbcDriver = com.mysql.jdbc.Driver > JdbcUrl = > jdbc:mysql://localhost:11080/jkitaj?zeroDateTimeBehavior=convertToNull > </Resource> > > <Resource id="myDatabaseUnmanaged" type="DataSource"> > JdbcDriver = com.mysql.jdbc.Driver > JdbcUrl = > jdbc:mysql://localhost:11080/jkitaj?zeroDateTimeBehavior=convertToNull > JtaManaged = false > </Resource> > </openejb> > > > and this is my 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="CollDocPU" transaction-type="JTA"> > <jta-data-source>myDatabase</jta-data-source> > <non-jta-data-source>myDatabaseUnmanaged</non-jta-data-source> > > <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider> > <class>model.entity.Course</class> > <class>model.entity.CourseHasLecturer</class> > <class>model.entity.File</class> > <class>model.entity.Task</class> > <class>model.entity.User</class> > <exclude-unlisted-classes>false</exclude-unlisted-classes> > <properties> > <property name="javax.persistence.jdbc.url" > value="jdbc:mysql://localhost:11080/jkitaj?zeroDateTimeBehavior=convertToNull"/> > <property name="javax.persistence.jdbc.password" value="pass"/> > <property name="javax.persistence.jdbc.driver" > value="com.mysql.jdbc.Driver"/> > <property name="javax.persistence.jdbc.user" value="jkitaj"/> > <property name="openjpa.jdbc.SynchronizeMappings" > value="buildSchema(ForeignKeys=true)"/> > </properties> > </persistence-unit> > > > what mean "database was not adjusted" ? > > > > > > -- > View this message in context: > http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-type-not-found-or-user-lacks-privilege-tp4665124p4665128.html > Sent from the OpenEJB User mailing list archive at Nabble.com.
