"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.
