Check in the log the database was not adjusted. Also check you configure the non jta datasource in the persistence unit (same as jta one but with JtaManaged to false) 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]>: > "is your database well configured?" - i think so > > I generate tables manually > > > > > Romain Manni-Bucau wrote >> Hi >> >> is your database well configured? did you generate tables (either >> manually or from openjpa)? >> 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 < > >> jakub.k8@ > >> >: >>> In my web application run on TomEE 1.5.2 server at @ManagedBean I get EJB >>> by >>> @EJB annotation. >>> In EJB I get EntityManager by >>> >>> @PersistenceContext(unitName = "CollDocPU") >>> private EntityManager em; >>> >>> After that i use EM to create Query: >>> Query q = em.createNamedQuery("User.findByLogin").setParameter("login", >>> login); >>> >>> At this moment I get error: >>> >>> javax.el.ELException: javax.ejb.EJBException: The bean encountered a >>> non-application exception; nested exception is: >>> >> <openjpa-2.2.0-r422266:1244990 nonfatal general error> >>> org.apache.openjpa.persistence.PersistenceException: type not found or >>> user >>> lacks privilege: TEXT {stmnt 2102470495 CREATE TABLE COURSE (id_course >>> SMALLINT NOT NULL, code VARCHAR(255), description TEXT, name >>> VARCHAR(255), >>> realization INTEGER, version SMALLINT, PRIMARY KEY (id_course)) ENGINE = >>> innodb} [code=-5509, state=42509] >>> >>> viewId=/pages/register.xhtml >>> location=/home/jakub/Projekty/Collv2/build/web/pages/register.xhtml >>> phaseId=INVOKE_APPLICATION(5) >>> >>> Caused by: >>> org.apache.openjpa.lib.jdbc.ReportingSQLException - type not found or >>> user >>> lacks privilege: TEXT {stmnt 2102470495 CREATE TABLE COURSE (id_course >>> SMALLINT NOT NULL, code VARCHAR(255), description TEXT, name >>> VARCHAR(255), >>> realization INTEGER, version SMALLINT, PRIMARY KEY (id_course)) ENGINE = >>> innodb} [code=-5509, state=42509] >>> at >>> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:247) >>> >>> /pages/register.xhtml at line 26 and column 104 >>> action="#{registerController.register}" >>> >>> >> <HtmlCommandButton action="#{registerController.register}" >>> >> actionExpression="#{registerController.register}" class="class >>> javax.faces.component.html.HtmlCommandButton" clientId="j_id_f:j_id_m" >>> disabled="false" id="j_id_m" immediate="false" inView="true" >>> readonly="false" rendered="true" transient="false" type="submit" >>> value="#{msg.login}" location="/pages/register.xhtml at line 26 and >>> column >>> 104"/> - State size:0 bytes >>> >>> >>> >>> -- >>> View this message in context: >>> http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-type-not-found-or-user-lacks-privilege-tp4665124.html >>> Sent from the OpenEJB User mailing list archive at Nabble.com. > > > > > > -- > View this message in context: > http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-type-not-found-or-user-lacks-privilege-tp4665124p4665126.html > Sent from the OpenEJB User mailing list archive at Nabble.com.
