Hi Richard thanks for your response,
I added this configuration in tomee.xml...(seems that using a other file
doesn't work), but that continue not working....now I have a new error
message:
*[EL Info]: 2024-06-03
17:48:42.683--ServerSession(1020643364)--EclipseLink, version: Eclipse
Persistence Services - 2.7.13.v20230724-7ffb888abf[EL Severe]: 2024-06-03
17:48:42.683--ServerSession(1020643364)--java.lang.NoClassDefFoundError:
org/postgresql/jdbc/PgDatabaseMetaData at
org.postgresql.jdbc.PgConnection.getMetaData(PgConnection.java:1427) at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498) at
org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:131)
at
org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at
org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:74)
at
org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
at
org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
at com.sun.proxy.$Proxy125.getMetaData(Unknown Source) at
org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.setOrDetectDatasource(DatabaseSessionImpl.java:227)
at
org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:810)
at
org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:261)
at
org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:771)
at
org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:222)
at
org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:330)
at
org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:350)
at
org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:331)
at
org.apache.openejb.assembler.classic.ReloadableEntityManagerFactory.createEntityManager(ReloadableEntityManagerFactory.java:208)
at
org.apache.openejb.persistence.JtaEntityManagerRegistry.getEntityManager(JtaEntityManagerRegistry.java:125)
at
org.apache.openejb.persistence.JtaEntityManager.getEntityManager(JtaEntityManager.java:145)03-Jun-2024
17:48:42.945 GRAVE [http-nio-8080-exec-12]
org.apache.openejb.core.transaction.EjbTransactionUtil.handleSystemException
EjbTransactionUtil.handleSystemException: java.lang.NoClassDefFoundError:
org/postgresql/jdbc/PgDatabaseMetaData
javax.persistence.PersistenceException: java.lang.NoClassDefFoundError:
org/postgresql/jdbc/PgDatabaseMetaData at
org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:854)
at
org.apache.openejb.persistence.JtaEntityManager.proxyIfNoTx(JtaEntityManager.java:375)
at
org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:222)
at
org.apache.openejb.persistence.JtaEntityManager.createQuery(JtaEntityManager.java:329)
at
org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:330)*
In my pom.xml I have this driver version,
<dependency>
<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
<version>42.7.3</version>
</dependency>
And obviously I have the same version of driver in lib folder of apache
tomee.
Anything else that may be missing to configure?
El lun, 3 jun 2024 a la(s) 5:51 a.m., Richard Zowalla (r...@apache.org)
escribió:
> Hi,
>
> This kind of exception mostly happens, if the related datasource could not
> be found.
> TomEE auto-creates default resources baed on in memory databases (and if
> no schema is present, this is the typical exception which happens).
>
> You can try to use the following JNDI schema:
>
> java:openejb/Resource/<id-of-datasource>
>
> With a declaration like
>
> <Resource id="myds" type="javax.sql.DataSource">
> JtaManaged = true
>
> //properties here
> </Resource>
> Gruß
> Richard
>
> > Am 02.06.2024 um 00:13 schrieb Fernando <fernandoagu...@gmail.com>:
> >
> > Hi,
> > I am trying to migrate an small application from payara community 5 to
> > Apache Tomee Plume 8.
> > I am working with Java 8 and postgresql 14 on windows and I am getting
> this
> > error message when I try to launch the application:
> >
> >
> >
> > *javax.ejb.EJBException: The bean encountered a non-application
> exception;
> > nested exception is: javax.persistence.PersistenceException: Exception
> > [EclipseLink-4002] (Eclipse Persistence Services -
> > 2.7.13.v20230724-7ffb888abf):
> > org.eclipse.persistence.exceptions.DatabaseExceptionInternal Exception:
> > java.sql.SQLSyntaxErrorException: usuario no tiene privilegios
> suficientes
> > o objeto no encontrado: CUENTAS in statement [SELECT ID, NOMBRE, TIPO
> FROM
> > cuentas ORDER BY NOMBRE]*
> >
> > I am understand that said that the user have not enough privilege, but
> I the
> > user and password are correct!
> > In file context.xml under the META-INF of my project I set this:
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > *<Context path="/GastosJSP"> <Resource auth="Container"
> > driverClassName="org.postgresql.Driver" maxIdle="10"
> > maxTotal="20" maxWaitMillis="-1" name="jdbc/gastos"
> > password="unacontrasena" type="javax.sql.DataSource"
> > url="jdbc:postgresql://localhost:5432/GastosJ"
> > username="operador"/></Context>*
> >
> > and in persistence.xml I have this configuration:
> >
> >
> >
> >
> >
> >
> > *<persistence version="2.1" xmlns="
> http://xmlns.jcp.org/xml/ns/persistence
> > <http://xmlns.jcp.org/xml/ns/persistence>"
> > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance
> > <http://www.w3.org/2001/XMLSchema-instance>"
> > xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence
> > <http://xmlns.jcp.org/xml/ns/persistence>
> > http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd
> > <http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd>">
> > <persistence-unit name="GastosPU" transaction-type="JTA">
> > <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
> > <jta-data-source>jdbc/gastos</jta-data-source>
> > </persistence-unit></persistence>*
> >
> > Finally in Dao Class, where I have the error showed up, I have:
> >
> >
> >
> >
> >
> >
> > *@Statelesspublic class CuentaDaoImp implements CuentaDao {
> > @PersistenceContext(unitName = "GastosPU") private EntityManager em;*
> >
> > Maybe I am not understanding something.... i am a little lost.....someone
> > could give me a hand?
> > Thanks in advance!
> >
> > Fernando
>
>
