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 <[email protected]>: > 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.
