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.
