You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@tomee.apache.org by kuba44 <ja...@gmail.com> on 2013/09/18 12:21:19 UTC

org.apache.openjpa.lib.jdbc.ReportingSQLException - type not found or user lacks privilege

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.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - type not found or user lacks privilege

Posted by Romain Manni-Bucau <rm...@gmail.com>.

If your user is not sa your config is still wrong i fear. Maybe try adding
DataSourceCreator = dbcp
Le 18 sept. 2013 19:35, "kuba44" <ja...@gmail.com> a écrit :

> When i add UserName and Password from my database error still is
>
>
>
> --
> View this message in context:
> http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-type-not-found-or-user-lacks-privilege-tp4665124p4665151.html
> Sent from the OpenEJB User mailing list archive at Nabble.com.
>

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - type not found or user lacks privilege

Posted by kuba44 <ja...@gmail.com>.

When i add UserName and Password from my database error still is



--
View this message in context: http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-type-not-found-or-user-lacks-privilege-tp4665124p4665151.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - type not found or user lacks privilege

Posted by Romain Manni-Bucau <rm...@gmail.com>.

You should set your UserName and Password otherwise SA and empty will be used
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 <ja...@gmail.com>:
> this is my tomee.xml:
>
> <tomee>
>     <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>
> </tomee>
>
> is syntax form is ok?
>
>
>
> --
> View this message in context: http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-type-not-found-or-user-lacks-privilege-tp4665124p4665145.html
> Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - type not found or user lacks privilege

Posted by kuba44 <ja...@gmail.com>.

this is my tomee.xml:

<tomee>
    <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>
</tomee>

is syntax form is ok? 



--
View this message in context: http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-type-not-found-or-user-lacks-privilege-tp4665124p4665145.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - type not found or user lacks privilege

Posted by Romain Manni-Bucau <rm...@gmail.com>.

the error means the datasource used is not the configured one so
either a weird (maybe invisible) character in tomee.xml or a
misconfiguration.
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 <ja...@gmail.com>:
> after a few restarts server error come back to first 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 1457512226 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 1457512226 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-tp4665124p4665140.html
> Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - type not found or user lacks privilege

Posted by kuba44 <ja...@gmail.com>.

after a few restarts server error come back to first 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 1457512226 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 1457512226 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-tp4665124p4665140.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - type not found or user lacks privilege

Posted by kuba44 <ja...@gmail.com>.

when i open tomee.xml file in my browser to read it i see it's in one line



--
View this message in context: http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-type-not-found-or-user-lacks-privilege-tp4665124p4665138.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - type not found or user lacks privilege

Posted by Romain Manni-Bucau <rm...@gmail.com>.

Aren't JdbcUrl and jdbc:mysql... on 2 lines? ensure it is on a single line
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 <ja...@gmail.com>:
> i'm sorry. i want to say directory :p
>
> when I add
> <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>
>
> to tomee.xml and restart server and run application again I get other 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: There were errors
> initializing your configuration: <openjpa-2.2.0-r422266:1244990 fatal user
> error> org.apache.openjpa.util.UserException: A connection could not be
> obtained for driver class "com.mysql.jdbc.Driver" and URL
> "jdbc:mysql://localhost:11080/jkitaj?zeroDateTimeBehavior=convertToNull".
> You may have specified an invalid URL. at
> org.apache.openjpa.jdbc.schema.DataSourceFactory.newConnectException(DataSourceFactory.java:255)
> at
> org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSourceFactory.java:241)
> at
> org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getConnectionFactory(JDBCConfigurationImpl.java:733)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606) at
> org.apache.openjpa.lib.conf.ConfigurationImpl.instantiateAll(ConfigurationImpl.java:295)
> at
> org.apache.openjpa.conf.OpenJPAConfigurationImpl.instantiateAll(OpenJPAConfigurationImpl.java:1671)
> at
> org.apache.openjpa.kernel.AbstractBrokerFactory.makeReadOnly(AbstractBrokerFactory.java:646)
> at
> org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:203)
> at
> org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156)
> at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227)
> at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60)
> at
> org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createEntityManager(ReloadableEntityManagerFactory.java:160)
> at
> org.apache.openejb.persistence.JtaEntityManagerRegistry.getEntityManager(JtaEntityManagerRegistry.java:115)
> at
> org.apache.openejb.persistence.JtaEntityManager.getEntityManager(JtaEntityManager.java:80)
> at
> org.apache.openejb.persistence.JtaEntityManager.createNamedQuery(JtaEntityManager.java:273)
> at model.beans.UserFacade.findByLogin(UserFacade.java:48) at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606) at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
> at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
> at org.apache.openejb.cdi.CdiInterceptor.invoke(CdiInterceptor.java:126) at
> org.apache.openejb.cdi.CdiInterceptor.access$000(CdiInterceptor.java:42) at
> org.apache.openejb.cdi.CdiInterceptor$1.call(CdiInterceptor.java:63) at
> org.apache.openejb.cdi.CdiInterceptor.aroundInvoke(CdiInterceptor.java:69)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606) at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
> at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
> at
> org.apache.openejb.monitoring.StatsInterceptor.record(StatsInterceptor.java:176)
> at
> org.apache.openejb.monitoring.StatsInterceptor.invoke(StatsInterceptor.java:95)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606) at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
> at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
> at
> org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:138)
> at
> org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:239)
> at
> org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:191)
> at
> org.apache.openejb.core.ivm.EjbObjectProxyHandler.synchronizedBusinessMethod(EjbObjectProxyHandler.java:246)
> at
> org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:241)
> at
> org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:83)
> at
> org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:279)
> at
> model.beans.UserFacade$LocalBeanProxy.findByLogin(model/beans/UserFacade.java)
> at controller.RegisterController.isUserInDB(RegisterController.java:101) at
> controller.RegisterController.register(RegisterController.java:81) at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606) at
> org.apache.el.parser.AstValue.invoke(AstValue.java:278) at
> org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274) at
> org.apache.myfaces.view.facelets.el.ContextAwareTagMethodExpression.invoke(ContextAwareTagMethodExpression.java:96)
> at
> org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:68)
> at javax.faces.component.UICommand.broadcast(UICommand.java:120) at
> javax.faces.component.UIViewRoot._broadcastAll(UIViewRoot.java:1028) at
> javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:286) at
> javax.faces.component.UIViewRoot._process(UIViewRoot.java:1375) at
> javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:752) at
> org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:38)
> at
> org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:170)
> at
> org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
> at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> at
> org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
> at org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:45) at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
> at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
> at
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
> at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
> at
> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:724) Caused by: java.sql.SQLException:
> Access denied for user 'sa'@'localhost' (using password: NO) at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) at
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:925) at
> com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4615) at
> com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1302) at
> com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465) at
> com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2498) at
> com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283) at
> com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822) at
> com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at
> com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at
> com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404) at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
> at
> org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
> at
> org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
> at
> org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:702)
> at
> org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:634)
> at
> org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:188)
> at
> org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:128)
> at
> org.apache.tomee.jdbc.TomEEDataSourceCreator$TomEEDataSource.getConnection(TomEEDataSourceCreator.java:264)
> at
> org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:86)
> at
> org.apache.tomee.jdbc.TomEEDataSourceCreator$TomEEDataSource.getConnection(TomEEDataSourceCreator.java:271)
> at
> org.apache.openejb.resource.jdbc.managed.local.ManagedDataSource.getConnection(ManagedDataSource.java:49)
> at
> org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:118)
> at
> org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:93)
> at
> org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSourceFactory.java:233)
> ... 88 more <openjpa-2.2.0-r422266:1244990 fatal user error>
> org.apache.openjpa.util.UserException: A connection could not be obtained
> for driver class "null" and URL "null". You may have specified an invalid
> URL. at
> org.apache.openjpa.jdbc.schema.DataSourceFactory.newConnectException(DataSourceFactory.java:255)
> at
> org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSourceFactory.java:241)
> at
> org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getConnectionFactory2(JDBCConfigurationImpl.java:807)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606) at
> org.apache.openjpa.lib.conf.ConfigurationImpl.instantiateAll(ConfigurationImpl.java:295)
> at
> org.apache.openjpa.conf.OpenJPAConfigurationImpl.instantiateAll(OpenJPAConfigurationImpl.java:1671)
> at
> org.apache.openjpa.kernel.AbstractBrokerFactory.makeReadOnly(AbstractBrokerFactory.java:646)
> at
> org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:203)
> at
> org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156)
> at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227)
> at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60)
> at
> org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createEntityManager(ReloadableEntityManagerFactory.java:160)
> at
> org.apache.openejb.persistence.JtaEntityManagerRegistry.getEntityManager(JtaEntityManagerRegistry.java:115)
> at
> org.apache.openejb.persistence.JtaEntityManager.getEntityManager(JtaEntityManager.java:80)
> at
> org.apache.openejb.persistence.JtaEntityManager.createNamedQuery(JtaEntityManager.java:273)
> at model.beans.UserFacade.findByLogin(UserFacade.java:48) at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606) at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
> at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
> at org.apache.openejb.cdi.CdiInterceptor.invoke(CdiInterceptor.java:126) at
> org.apache.openejb.cdi.CdiInterceptor.access$000(CdiInterceptor.java:42) at
> org.apache.openejb.cdi.CdiInterceptor$1.call(CdiInterceptor.java:63) at
> org.apache.openejb.cdi.CdiInterceptor.aroundInvoke(CdiInterceptor.java:69)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606) at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
> at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
> at
> org.apache.openejb.monitoring.StatsInterceptor.record(StatsInterceptor.java:176)
> at
> org.apache.openejb.monitoring.StatsInterceptor.invoke(StatsInterceptor.java:95)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606) at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
> at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
> at
> org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:138)
> at
> org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:239)
> at
> org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:191)
> at
> org.apache.openejb.core.ivm.EjbObjectProxyHandler.synchronizedBusinessMethod(EjbObjectProxyHandler.java:246)
> at
> org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:241)
> at
> org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:83)
> at
> org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:279)
> at
> model.beans.UserFacade$LocalBeanProxy.findByLogin(model/beans/UserFacade.java)
> at controller.RegisterController.isUserInDB(RegisterController.java:101) at
> controller.RegisterController.register(RegisterController.java:81) at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606) at
> org.apache.el.parser.AstValue.invoke(AstValue.java:278) at
> org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274) at
> org.apache.myfaces.view.facelets.el.ContextAwareTagMethodExpression.invoke(ContextAwareTagMethodExpression.java:96)
> at
> org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:68)
> at javax.faces.component.UICommand.broadcast(UICommand.java:120) at
> javax.faces.component.UIViewRoot._broadcastAll(UIViewRoot.java:1028) at
> javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:286) at
> javax.faces.component.UIViewRoot._process(UIViewRoot.java:1375) at
> javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:752) at
> org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:38)
> at
> org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:170)
> at
> org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
> at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> at
> org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
> at org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:45) at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
> at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
> at
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
> at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
> at
> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:724) Caused by: java.sql.SQLException:
> Access denied for user 'sa'@'localhost' (using password: NO) at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) at
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:925) at
> com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4615) at
> com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1302) at
> com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465) at
> com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2498) at
> com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283) at
> com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822) at
> com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at
> com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at
> com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404) at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
> at
> org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
> at
> org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
> at
> org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:702)
> at
> org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:634)
> at
> org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:188)
> at
> org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:128)
> at
> org.apache.tomee.jdbc.TomEEDataSourceCreator$TomEEDataSource.getConnection(TomEEDataSourceCreator.java:264)
> at
> org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:116)
> at
> org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:93)
> at
> org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSourceFactory.java:236)
> ... 88 more
>
> viewId=/pages/register.xhtml
> location=/home/jakub/Projekty/Collv2/build/web/pages/register.xhtml
> phaseId=INVOKE_APPLICATION(5)
>
> Caused by:
> java.lang.RuntimeException - There were errors initializing your
> configuration: <openjpa-2.2.0-r422266:1244990 fatal user error>
> org.apache.openjpa.util.UserException: A connection could not be obtained
> for driver class "com.mysql.jdbc.Driver" and URL
> "jdbc:mysql://localhost:11080/jkitaj?zeroDateTimeBehavior=convertToNull".
> You may have specified an invalid URL. at
> org.apache.openjpa.jdbc.schema.DataSourceFactory.newConnectException(DataSourceFactory.java:255)
> at
> org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSourceFactory.java:241)
> at
> org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getConnectionFactory(JDBCConfigurationImpl.java:733)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606) at
> org.apache.openjpa.lib.conf.ConfigurationImpl.instantiateAll(ConfigurationImpl.java:295)
> at
> org.apache.openjpa.conf.OpenJPAConfigurationImpl.instantiateAll(OpenJPAConfigurationImpl.java:1671)
> at
> org.apache.openjpa.kernel.AbstractBrokerFactory.makeReadOnly(AbstractBrokerFactory.java:646)
> at
> org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:203)
> at
> org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156)
> at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227)
> at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60)
> at
> org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createEntityManager(ReloadableEntityManagerFactory.java:160)
> at
> org.apache.openejb.persistence.JtaEntityManagerRegistry.getEntityManager(JtaEntityManagerRegistry.java:115)
> at
> org.apache.openejb.persistence.JtaEntityManager.getEntityManager(JtaEntityManager.java:80)
> at
> org.apache.openejb.persistence.JtaEntityManager.createNamedQuery(JtaEntityManager.java:273)
> at model.beans.UserFacade.findByLogin(UserFacade.java:48) at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606) at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
> at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
> at org.apache.openejb.cdi.CdiInterceptor.invoke(CdiInterceptor.java:126) at
> org.apache.openejb.cdi.CdiInterceptor.access$000(CdiInterceptor.java:42) at
> org.apache.openejb.cdi.CdiInterceptor$1.call(CdiInterceptor.java:63) at
> org.apache.openejb.cdi.CdiInterceptor.aroundInvoke(CdiInterceptor.java:69)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606) at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
> at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
> at
> org.apache.openejb.monitoring.StatsInterceptor.record(StatsInterceptor.java:176)
> at
> org.apache.openejb.monitoring.StatsInterceptor.invoke(StatsInterceptor.java:95)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606) at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
> at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
> at
> org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:138)
> at
> org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:239)
> at
> org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:191)
> at
> org.apache.openejb.core.ivm.EjbObjectProxyHandler.synchronizedBusinessMethod(EjbObjectProxyHandler.java:246)
> at
> org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:241)
> at
> org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:83)
> at
> org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:279)
> at
> model.beans.UserFacade$LocalBeanProxy.findByLogin(model/beans/UserFacade.java)
> at controller.RegisterController.isUserInDB(RegisterController.java:101) at
> controller.RegisterController.register(RegisterController.java:81) at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606) at
> org.apache.el.parser.AstValue.invoke(AstValue.java:278) at
> org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274) at
> org.apache.myfaces.view.facelets.el.ContextAwareTagMethodExpression.invoke(ContextAwareTagMethodExpression.java:96)
> at
> org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:68)
> at javax.faces.component.UICommand.broadcast(UICommand.java:120) at
> javax.faces.component.UIViewRoot._broadcastAll(UIViewRoot.java:1028) at
> javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:286) at
> javax.faces.component.UIViewRoot._process(UIViewRoot.java:1375) at
> javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:752) at
> org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:38)
> at
> org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:170)
> at
> org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
> at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> at
> org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
> at org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:45) at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
> at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
> at
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
> at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
> at
> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:724) Caused by: java.sql.SQLException:
> Access denied for user 'sa'@'localhost' (using password: NO) at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) at
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:925) at
> com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4615) at
> com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1302) at
> com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465) at
> com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2498) at
> com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283) at
> com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822) at
> com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at
> com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at
> com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404) at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
> at
> org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
> at
> org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
> at
> org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:702)
> at
> org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:634)
> at
> org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:188)
> at
> org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:128)
> at
> org.apache.tomee.jdbc.TomEEDataSourceCreator$TomEEDataSource.getConnection(TomEEDataSourceCreator.java:264)
> at
> org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:86)
> at
> org.apache.tomee.jdbc.TomEEDataSourceCreator$TomEEDataSource.getConnection(TomEEDataSourceCreator.java:271)
> at
> org.apache.openejb.resource.jdbc.managed.local.ManagedDataSource.getConnection(ManagedDataSource.java:49)
> at
> org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:118)
> at
> org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:93)
> at
> org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSourceFactory.java:233)
> ... 88 more <openjpa-2.2.0-r422266:1244990 fatal user error>
> org.apache.openjpa.util.UserException: A connection could not be obtained
> for driver class "null" and URL "null". You may have specified an invalid
> URL. at
> org.apache.openjpa.jdbc.schema.DataSourceFactory.newConnectException(DataSourceFactory.java:255)
> at
> org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSourceFactory.java:241)
> at
> org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getConnectionFactory2(JDBCConfigurationImpl.java:807)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606) at
> org.apache.openjpa.lib.conf.ConfigurationImpl.instantiateAll(ConfigurationImpl.java:295)
> at
> org.apache.openjpa.conf.OpenJPAConfigurationImpl.instantiateAll(OpenJPAConfigurationImpl.java:1671)
> at
> org.apache.openjpa.kernel.AbstractBrokerFactory.makeReadOnly(AbstractBrokerFactory.java:646)
> at
> org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:203)
> at
> org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156)
> at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227)
> at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60)
> at
> org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createEntityManager(ReloadableEntityManagerFactory.java:160)
> at
> org.apache.openejb.persistence.JtaEntityManagerRegistry.getEntityManager(JtaEntityManagerRegistry.java:115)
> at
> org.apache.openejb.persistence.JtaEntityManager.getEntityManager(JtaEntityManager.java:80)
> at
> org.apache.openejb.persistence.JtaEntityManager.createNamedQuery(JtaEntityManager.java:273)
> at model.beans.UserFacade.findByLogin(UserFacade.java:48) at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606) at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
> at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
> at org.apache.openejb.cdi.CdiInterceptor.invoke(CdiInterceptor.java:126) at
> org.apache.openejb.cdi.CdiInterceptor.access$000(CdiInterceptor.java:42) at
> org.apache.openejb.cdi.CdiInterceptor$1.call(CdiInterceptor.java:63) at
> org.apache.openejb.cdi.CdiInterceptor.aroundInvoke(CdiInterceptor.java:69)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606) at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
> at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
> at
> org.apache.openejb.monitoring.StatsInterceptor.record(StatsInterceptor.java:176)
> at
> org.apache.openejb.monitoring.StatsInterceptor.invoke(StatsInterceptor.java:95)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606) at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
> at
> org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
> at
> org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:138)
> at
> org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:239)
> at
> org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:191)
> at
> org.apache.openejb.core.ivm.EjbObjectProxyHandler.synchronizedBusinessMethod(EjbObjectProxyHandler.java:246)
> at
> org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:241)
> at
> org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:83)
> at
> org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:279)
> at
> model.beans.UserFacade$LocalBeanProxy.findByLogin(model/beans/UserFacade.java)
> at controller.RegisterController.isUserInDB(RegisterController.java:101) at
> controller.RegisterController.register(RegisterController.java:81) at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606) at
> org.apache.el.parser.AstValue.invoke(AstValue.java:278) at
> org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274) at
> org.apache.myfaces.view.facelets.el.ContextAwareTagMethodExpression.invoke(ContextAwareTagMethodExpression.java:96)
> at
> org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:68)
> at javax.faces.component.UICommand.broadcast(UICommand.java:120) at
> javax.faces.component.UIViewRoot._broadcastAll(UIViewRoot.java:1028) at
> javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:286) at
> javax.faces.component.UIViewRoot._process(UIViewRoot.java:1375) at
> javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:752) at
> org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:38)
> at
> org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:170)
> at
> org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
> at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> at
> org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
> at org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:45) at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
> at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
> at
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
> at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
> at
> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:724) Caused by: java.sql.SQLException:
> Access denied for user 'sa'@'localhost' (using password: NO) at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) at
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:925) at
> com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4615) at
> com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1302) at
> com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465) at
> com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2498) at
> com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283) at
> com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822) at
> com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at
> com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at
> com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404) at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
> at
> org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
> at
> org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
> at
> org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:702)
> at
> org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:634)
> at
> org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:188)
> at
> org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:128)
> at
> org.apache.tomee.jdbc.TomEEDataSourceCreator$TomEEDataSource.getConnection(TomEEDataSourceCreator.java:264)
> at
> org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:116)
> at
> org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:93)
> at
> org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSourceFactory.java:236)
> ... 88 more
> at
> org.apache.openjpa.lib.conf.ConfigurationImpl.instantiateAll(ConfigurationImpl.java:309)
>
> /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-tp4665124p4665134.html
> Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - type not found or user lacks privilege

Posted by kuba44 <ja...@gmail.com>.

i'm sorry. i want to say directory :p

when I add 
<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>

to tomee.xml and restart server and run application again I get other 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: There were errors
initializing your configuration: <openjpa-2.2.0-r422266:1244990 fatal user
error> org.apache.openjpa.util.UserException: A connection could not be
obtained for driver class "com.mysql.jdbc.Driver" and URL
"jdbc:mysql://localhost:11080/jkitaj?zeroDateTimeBehavior=convertToNull".
You may have specified an invalid URL. at
org.apache.openjpa.jdbc.schema.DataSourceFactory.newConnectException(DataSourceFactory.java:255)
at
org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSourceFactory.java:241)
at
org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getConnectionFactory(JDBCConfigurationImpl.java:733)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606) at
org.apache.openjpa.lib.conf.ConfigurationImpl.instantiateAll(ConfigurationImpl.java:295)
at
org.apache.openjpa.conf.OpenJPAConfigurationImpl.instantiateAll(OpenJPAConfigurationImpl.java:1671)
at
org.apache.openjpa.kernel.AbstractBrokerFactory.makeReadOnly(AbstractBrokerFactory.java:646)
at
org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:203)
at
org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156)
at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227)
at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60)
at
org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createEntityManager(ReloadableEntityManagerFactory.java:160)
at
org.apache.openejb.persistence.JtaEntityManagerRegistry.getEntityManager(JtaEntityManagerRegistry.java:115)
at
org.apache.openejb.persistence.JtaEntityManager.getEntityManager(JtaEntityManager.java:80)
at
org.apache.openejb.persistence.JtaEntityManager.createNamedQuery(JtaEntityManager.java:273)
at model.beans.UserFacade.findByLogin(UserFacade.java:48) at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606) at
org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
at
org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
at org.apache.openejb.cdi.CdiInterceptor.invoke(CdiInterceptor.java:126) at
org.apache.openejb.cdi.CdiInterceptor.access$000(CdiInterceptor.java:42) at
org.apache.openejb.cdi.CdiInterceptor$1.call(CdiInterceptor.java:63) at
org.apache.openejb.cdi.CdiInterceptor.aroundInvoke(CdiInterceptor.java:69)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606) at
org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
at
org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
at
org.apache.openejb.monitoring.StatsInterceptor.record(StatsInterceptor.java:176)
at
org.apache.openejb.monitoring.StatsInterceptor.invoke(StatsInterceptor.java:95)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606) at
org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
at
org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
at
org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:138)
at
org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:239)
at
org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:191)
at
org.apache.openejb.core.ivm.EjbObjectProxyHandler.synchronizedBusinessMethod(EjbObjectProxyHandler.java:246)
at
org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:241)
at
org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:83)
at
org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:279)
at
model.beans.UserFacade$LocalBeanProxy.findByLogin(model/beans/UserFacade.java)
at controller.RegisterController.isUserInDB(RegisterController.java:101) at
controller.RegisterController.register(RegisterController.java:81) at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606) at
org.apache.el.parser.AstValue.invoke(AstValue.java:278) at
org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274) at
org.apache.myfaces.view.facelets.el.ContextAwareTagMethodExpression.invoke(ContextAwareTagMethodExpression.java:96)
at
org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:68)
at javax.faces.component.UICommand.broadcast(UICommand.java:120) at
javax.faces.component.UIViewRoot._broadcastAll(UIViewRoot.java:1028) at
javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:286) at
javax.faces.component.UIViewRoot._process(UIViewRoot.java:1375) at
javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:752) at
org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:38)
at
org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:170)
at
org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:45) at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724) Caused by: java.sql.SQLException:
Access denied for user 'sa'@'localhost' (using password: NO) at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:925) at
com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4615) at
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1302) at
com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465) at
com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2498) at
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283) at
com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822) at
com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at
com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404) at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
at
org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
at
org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
at
org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:702)
at
org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:634)
at
org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:188)
at
org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:128)
at
org.apache.tomee.jdbc.TomEEDataSourceCreator$TomEEDataSource.getConnection(TomEEDataSourceCreator.java:264)
at
org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:86)
at
org.apache.tomee.jdbc.TomEEDataSourceCreator$TomEEDataSource.getConnection(TomEEDataSourceCreator.java:271)
at
org.apache.openejb.resource.jdbc.managed.local.ManagedDataSource.getConnection(ManagedDataSource.java:49)
at
org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:118)
at
org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:93)
at
org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSourceFactory.java:233)
... 88 more <openjpa-2.2.0-r422266:1244990 fatal user error>
org.apache.openjpa.util.UserException: A connection could not be obtained
for driver class "null" and URL "null". You may have specified an invalid
URL. at
org.apache.openjpa.jdbc.schema.DataSourceFactory.newConnectException(DataSourceFactory.java:255)
at
org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSourceFactory.java:241)
at
org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getConnectionFactory2(JDBCConfigurationImpl.java:807)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606) at
org.apache.openjpa.lib.conf.ConfigurationImpl.instantiateAll(ConfigurationImpl.java:295)
at
org.apache.openjpa.conf.OpenJPAConfigurationImpl.instantiateAll(OpenJPAConfigurationImpl.java:1671)
at
org.apache.openjpa.kernel.AbstractBrokerFactory.makeReadOnly(AbstractBrokerFactory.java:646)
at
org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:203)
at
org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156)
at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227)
at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60)
at
org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createEntityManager(ReloadableEntityManagerFactory.java:160)
at
org.apache.openejb.persistence.JtaEntityManagerRegistry.getEntityManager(JtaEntityManagerRegistry.java:115)
at
org.apache.openejb.persistence.JtaEntityManager.getEntityManager(JtaEntityManager.java:80)
at
org.apache.openejb.persistence.JtaEntityManager.createNamedQuery(JtaEntityManager.java:273)
at model.beans.UserFacade.findByLogin(UserFacade.java:48) at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606) at
org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
at
org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
at org.apache.openejb.cdi.CdiInterceptor.invoke(CdiInterceptor.java:126) at
org.apache.openejb.cdi.CdiInterceptor.access$000(CdiInterceptor.java:42) at
org.apache.openejb.cdi.CdiInterceptor$1.call(CdiInterceptor.java:63) at
org.apache.openejb.cdi.CdiInterceptor.aroundInvoke(CdiInterceptor.java:69)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606) at
org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
at
org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
at
org.apache.openejb.monitoring.StatsInterceptor.record(StatsInterceptor.java:176)
at
org.apache.openejb.monitoring.StatsInterceptor.invoke(StatsInterceptor.java:95)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606) at
org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
at
org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
at
org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:138)
at
org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:239)
at
org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:191)
at
org.apache.openejb.core.ivm.EjbObjectProxyHandler.synchronizedBusinessMethod(EjbObjectProxyHandler.java:246)
at
org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:241)
at
org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:83)
at
org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:279)
at
model.beans.UserFacade$LocalBeanProxy.findByLogin(model/beans/UserFacade.java)
at controller.RegisterController.isUserInDB(RegisterController.java:101) at
controller.RegisterController.register(RegisterController.java:81) at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606) at
org.apache.el.parser.AstValue.invoke(AstValue.java:278) at
org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274) at
org.apache.myfaces.view.facelets.el.ContextAwareTagMethodExpression.invoke(ContextAwareTagMethodExpression.java:96)
at
org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:68)
at javax.faces.component.UICommand.broadcast(UICommand.java:120) at
javax.faces.component.UIViewRoot._broadcastAll(UIViewRoot.java:1028) at
javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:286) at
javax.faces.component.UIViewRoot._process(UIViewRoot.java:1375) at
javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:752) at
org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:38)
at
org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:170)
at
org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:45) at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724) Caused by: java.sql.SQLException:
Access denied for user 'sa'@'localhost' (using password: NO) at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:925) at
com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4615) at
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1302) at
com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465) at
com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2498) at
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283) at
com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822) at
com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at
com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404) at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
at
org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
at
org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
at
org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:702)
at
org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:634)
at
org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:188)
at
org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:128)
at
org.apache.tomee.jdbc.TomEEDataSourceCreator$TomEEDataSource.getConnection(TomEEDataSourceCreator.java:264)
at
org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:116)
at
org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:93)
at
org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSourceFactory.java:236)
... 88 more 

viewId=/pages/register.xhtml
location=/home/jakub/Projekty/Collv2/build/web/pages/register.xhtml
phaseId=INVOKE_APPLICATION(5)

Caused by:
java.lang.RuntimeException - There were errors initializing your
configuration: <openjpa-2.2.0-r422266:1244990 fatal user error>
org.apache.openjpa.util.UserException: A connection could not be obtained
for driver class "com.mysql.jdbc.Driver" and URL
"jdbc:mysql://localhost:11080/jkitaj?zeroDateTimeBehavior=convertToNull".
You may have specified an invalid URL. at
org.apache.openjpa.jdbc.schema.DataSourceFactory.newConnectException(DataSourceFactory.java:255)
at
org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSourceFactory.java:241)
at
org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getConnectionFactory(JDBCConfigurationImpl.java:733)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606) at
org.apache.openjpa.lib.conf.ConfigurationImpl.instantiateAll(ConfigurationImpl.java:295)
at
org.apache.openjpa.conf.OpenJPAConfigurationImpl.instantiateAll(OpenJPAConfigurationImpl.java:1671)
at
org.apache.openjpa.kernel.AbstractBrokerFactory.makeReadOnly(AbstractBrokerFactory.java:646)
at
org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:203)
at
org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156)
at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227)
at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60)
at
org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createEntityManager(ReloadableEntityManagerFactory.java:160)
at
org.apache.openejb.persistence.JtaEntityManagerRegistry.getEntityManager(JtaEntityManagerRegistry.java:115)
at
org.apache.openejb.persistence.JtaEntityManager.getEntityManager(JtaEntityManager.java:80)
at
org.apache.openejb.persistence.JtaEntityManager.createNamedQuery(JtaEntityManager.java:273)
at model.beans.UserFacade.findByLogin(UserFacade.java:48) at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606) at
org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
at
org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
at org.apache.openejb.cdi.CdiInterceptor.invoke(CdiInterceptor.java:126) at
org.apache.openejb.cdi.CdiInterceptor.access$000(CdiInterceptor.java:42) at
org.apache.openejb.cdi.CdiInterceptor$1.call(CdiInterceptor.java:63) at
org.apache.openejb.cdi.CdiInterceptor.aroundInvoke(CdiInterceptor.java:69)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606) at
org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
at
org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
at
org.apache.openejb.monitoring.StatsInterceptor.record(StatsInterceptor.java:176)
at
org.apache.openejb.monitoring.StatsInterceptor.invoke(StatsInterceptor.java:95)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606) at
org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
at
org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
at
org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:138)
at
org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:239)
at
org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:191)
at
org.apache.openejb.core.ivm.EjbObjectProxyHandler.synchronizedBusinessMethod(EjbObjectProxyHandler.java:246)
at
org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:241)
at
org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:83)
at
org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:279)
at
model.beans.UserFacade$LocalBeanProxy.findByLogin(model/beans/UserFacade.java)
at controller.RegisterController.isUserInDB(RegisterController.java:101) at
controller.RegisterController.register(RegisterController.java:81) at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606) at
org.apache.el.parser.AstValue.invoke(AstValue.java:278) at
org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274) at
org.apache.myfaces.view.facelets.el.ContextAwareTagMethodExpression.invoke(ContextAwareTagMethodExpression.java:96)
at
org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:68)
at javax.faces.component.UICommand.broadcast(UICommand.java:120) at
javax.faces.component.UIViewRoot._broadcastAll(UIViewRoot.java:1028) at
javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:286) at
javax.faces.component.UIViewRoot._process(UIViewRoot.java:1375) at
javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:752) at
org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:38)
at
org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:170)
at
org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:45) at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724) Caused by: java.sql.SQLException:
Access denied for user 'sa'@'localhost' (using password: NO) at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:925) at
com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4615) at
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1302) at
com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465) at
com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2498) at
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283) at
com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822) at
com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at
com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404) at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
at
org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
at
org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
at
org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:702)
at
org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:634)
at
org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:188)
at
org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:128)
at
org.apache.tomee.jdbc.TomEEDataSourceCreator$TomEEDataSource.getConnection(TomEEDataSourceCreator.java:264)
at
org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:86)
at
org.apache.tomee.jdbc.TomEEDataSourceCreator$TomEEDataSource.getConnection(TomEEDataSourceCreator.java:271)
at
org.apache.openejb.resource.jdbc.managed.local.ManagedDataSource.getConnection(ManagedDataSource.java:49)
at
org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:118)
at
org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:93)
at
org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSourceFactory.java:233)
... 88 more <openjpa-2.2.0-r422266:1244990 fatal user error>
org.apache.openjpa.util.UserException: A connection could not be obtained
for driver class "null" and URL "null". You may have specified an invalid
URL. at
org.apache.openjpa.jdbc.schema.DataSourceFactory.newConnectException(DataSourceFactory.java:255)
at
org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSourceFactory.java:241)
at
org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getConnectionFactory2(JDBCConfigurationImpl.java:807)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606) at
org.apache.openjpa.lib.conf.ConfigurationImpl.instantiateAll(ConfigurationImpl.java:295)
at
org.apache.openjpa.conf.OpenJPAConfigurationImpl.instantiateAll(OpenJPAConfigurationImpl.java:1671)
at
org.apache.openjpa.kernel.AbstractBrokerFactory.makeReadOnly(AbstractBrokerFactory.java:646)
at
org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:203)
at
org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156)
at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227)
at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60)
at
org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createEntityManager(ReloadableEntityManagerFactory.java:160)
at
org.apache.openejb.persistence.JtaEntityManagerRegistry.getEntityManager(JtaEntityManagerRegistry.java:115)
at
org.apache.openejb.persistence.JtaEntityManager.getEntityManager(JtaEntityManager.java:80)
at
org.apache.openejb.persistence.JtaEntityManager.createNamedQuery(JtaEntityManager.java:273)
at model.beans.UserFacade.findByLogin(UserFacade.java:48) at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606) at
org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
at
org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
at org.apache.openejb.cdi.CdiInterceptor.invoke(CdiInterceptor.java:126) at
org.apache.openejb.cdi.CdiInterceptor.access$000(CdiInterceptor.java:42) at
org.apache.openejb.cdi.CdiInterceptor$1.call(CdiInterceptor.java:63) at
org.apache.openejb.cdi.CdiInterceptor.aroundInvoke(CdiInterceptor.java:69)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606) at
org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
at
org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
at
org.apache.openejb.monitoring.StatsInterceptor.record(StatsInterceptor.java:176)
at
org.apache.openejb.monitoring.StatsInterceptor.invoke(StatsInterceptor.java:95)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606) at
org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181)
at
org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163)
at
org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:138)
at
org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:239)
at
org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:191)
at
org.apache.openejb.core.ivm.EjbObjectProxyHandler.synchronizedBusinessMethod(EjbObjectProxyHandler.java:246)
at
org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:241)
at
org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:83)
at
org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:279)
at
model.beans.UserFacade$LocalBeanProxy.findByLogin(model/beans/UserFacade.java)
at controller.RegisterController.isUserInDB(RegisterController.java:101) at
controller.RegisterController.register(RegisterController.java:81) at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606) at
org.apache.el.parser.AstValue.invoke(AstValue.java:278) at
org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274) at
org.apache.myfaces.view.facelets.el.ContextAwareTagMethodExpression.invoke(ContextAwareTagMethodExpression.java:96)
at
org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:68)
at javax.faces.component.UICommand.broadcast(UICommand.java:120) at
javax.faces.component.UIViewRoot._broadcastAll(UIViewRoot.java:1028) at
javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:286) at
javax.faces.component.UIViewRoot._process(UIViewRoot.java:1375) at
javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:752) at
org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:38)
at
org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:170)
at
org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:45) at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724) Caused by: java.sql.SQLException:
Access denied for user 'sa'@'localhost' (using password: NO) at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:925) at
com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4615) at
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1302) at
com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465) at
com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2498) at
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283) at
com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822) at
com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at
com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404) at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
at
org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
at
org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
at
org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:702)
at
org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:634)
at
org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:188)
at
org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:128)
at
org.apache.tomee.jdbc.TomEEDataSourceCreator$TomEEDataSource.getConnection(TomEEDataSourceCreator.java:264)
at
org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:116)
at
org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:93)
at
org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSourceFactory.java:236)
... 88 more 
at
org.apache.openjpa.lib.conf.ConfigurationImpl.instantiateAll(ConfigurationImpl.java:309)

/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-tp4665124p4665134.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - type not found or user lacks privilege

Posted by Romain Manni-Bucau <rm...@gmail.com>.

I don't know what is your app dictionnary but keep tomee.xml and put
your resources inside seems the "default" procedure
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 <ja...@gmail.com>:
> so when I want to use
>
> transaction-type="JTA" and
> <jta-data-source>myDatabase</jta-data-source>
> <non-jta-data-source>myDatabaseUnmanaged</non-jta-data-source>
>
>  in my persistence.xml file I have to make openejb.xml in <tomee
> installation>/conf and delete tomee.xml ?
>
> or put it in my application dictionary ?
>
>
>
> --
> View this message in context: http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-type-not-found-or-user-lacks-privilege-tp4665124p4665132.html
> Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - type not found or user lacks privilege

Posted by kuba44 <ja...@gmail.com>.

so when I want to use 

transaction-type="JTA" and 
<jta-data-source>myDatabase</jta-data-source>
<non-jta-data-source>myDatabaseUnmanaged</non-jta-data-source>

 in my persistence.xml file I have to make openejb.xml in <tomee
installation>/conf and delete tomee.xml ?

or put it in my application dictionary ?



--
View this message in context: http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-type-not-found-or-user-lacks-privilege-tp4665124p4665132.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - type not found or user lacks privilege

Posted by Romain Manni-Bucau <rm...@gmail.com>.

openejb.xml is replaced by tomee.xml in tomee (just the root tag
should be tomee instead of openejb) and the file is located in <tomee
installation>/conf
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 <ja...@gmail.com>:
> find in log:
>
> wrz 18, 2013 3:06:31 PM org.apache.openejb.config.AutoConfig
> setJtaDataSource
> INFO: Adjusting PersistenceUnit CollDocPU <jta-data-source> to Resource ID
> 'Default JDBC Database' from 'myDatabase'
> wrz 18, 2013 3:06:31 PM org.apache.openejb.config.AutoConfig
> setNonJtaDataSource
> INFO: Adjusting PersistenceUnit CollDocPU <non-jta-data-source> to Resource
> ID 'Default Unmanaged JDBC Database' from 'myDatabaseUnmanaged'
>
> wrz 18, 2013 3:06:35 PM org.apache.openejb.config.AutoConfig
> setJtaDataSource
> INFO: Adjusting PersistenceUnit CollDocPU <jta-data-source> to Resource ID
> 'Default JDBC Database' from 'null'
> wrz 18, 2013 3:06:35 PM org.apache.openejb.config.AutoConfig
> setNonJtaDataSource
> INFO: Adjusting PersistenceUnit CollDocPU <non-jta-data-source> to Resource
> ID 'Default Unmanaged JDBC Database' from 'null'
>
>
>
>
>
> At http://tomee.apache.org/openjpa.html I find information about openejb.xml
> but i don't know where it should be.
>
>
>
> --
> View this message in context: http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-type-not-found-or-user-lacks-privilege-tp4665124p4665130.html
> Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - type not found or user lacks privilege

Posted by kuba44 <ja...@gmail.com>.

find in log:

wrz 18, 2013 3:06:31 PM org.apache.openejb.config.AutoConfig
setJtaDataSource
INFO: Adjusting PersistenceUnit CollDocPU <jta-data-source> to Resource ID
'Default JDBC Database' from 'myDatabase'
wrz 18, 2013 3:06:31 PM org.apache.openejb.config.AutoConfig
setNonJtaDataSource
INFO: Adjusting PersistenceUnit CollDocPU <non-jta-data-source> to Resource
ID 'Default Unmanaged JDBC Database' from 'myDatabaseUnmanaged'

wrz 18, 2013 3:06:35 PM org.apache.openejb.config.AutoConfig
setJtaDataSource
INFO: Adjusting PersistenceUnit CollDocPU <jta-data-source> to Resource ID
'Default JDBC Database' from 'null'
wrz 18, 2013 3:06:35 PM org.apache.openejb.config.AutoConfig
setNonJtaDataSource
INFO: Adjusting PersistenceUnit CollDocPU <non-jta-data-source> to Resource
ID 'Default Unmanaged JDBC Database' from 'null'





At http://tomee.apache.org/openjpa.html I find information about openejb.xml
but i don't know where it should be.



--
View this message in context: http://openejb.979440.n4.nabble.com/org-apache-openjpa-lib-jdbc-ReportingSQLException-type-not-found-or-user-lacks-privilege-tp4665124p4665130.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - type not found or user lacks privilege

Posted by Romain Manni-Bucau <rm...@gmail.com>.

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 <ja...@gmail.com>:
> 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.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - type not found or user lacks privilege

Posted by kuba44 <ja...@gmail.com>.

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.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - type not found or user lacks privilege

Posted by Romain Manni-Bucau <rm...@gmail.com>.

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 <ja...@gmail.com>:
> "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 &lt;
>
>> jakub.k8@
>
>> &gt;:
>>> 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.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - type not found or user lacks privilege

Posted by kuba44 <ja...@gmail.com>.

"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 &lt;

> jakub.k8@

> &gt;:
>> 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.

Re: org.apache.openjpa.lib.jdbc.ReportingSQLException - type not found or user lacks privilege

Posted by Romain Manni-Bucau <rm...@gmail.com>.

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 <ja...@gmail.com>:
> 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.