Discussion :

[jmturc]

bonjour,

dans un contexte j2ee (tomcat + sybase), j'effectue au démarage de l'application une instruction sql qui fonctionne.

Or j'ai besoin de pouvoir executer ce code dans un contexte J2SE (junit entre autre).
Le probleme est que le meme code dans un context j2SE (sans conteneur web) ne fonctionne pas, alors que les logs crée par jpa (eclipseLink) sont exactement les memesn, et que le code s'execute sans exception.

Voici ce code :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
 
	EntityManager em = factory.createEntityManager();// jndi loading, see com.bankofny.bru.fatf.server.JpaEclipseLinkSessionCustomizer
		EntityTransaction tx = em.getTransaction();
		tx.begin();
		em.createNativeQuery("delete from t_fat_sequence").executeUpdate();
		//em.createNativeQuery("delete from t_fat_user").executeUpdate();
		//em.createNativeQuery("insert into t_fat_sequence (sequence_name,valeur) values ('profiles',101)").executeUpdate();
		tx.commit();
		em.close();

voici persistence.xml

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlnssi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
<persistence-unit name="fatfServer" transaction-type="RESOURCE_LOCAL">
<description>Fatf jpa config</description>
<provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
<non-jta-data-source>fatfDev</non-jta-data-source>
<class>com.bankofny.bru.fatf.common.domain.User</class>
<class>com.bankofny.bru.fatf.common.domain.Details</class>
<class>com.bankofny.bru.fatf.common.domain.Profile</class>
<properties>
<property name="eclipselink.session.customizer" value="com.bankofny.bru.fatf.server.JpaEclipseLinkSessionCustomizer" />
<property name="eclipselink.target-server" value="None" />
<property name="eclipselink.target-database" value="Sybase" />
<!-- <property name="eclipselink.ddl-generation" value="drop-and-create-tables" />
<property name="eclipselink.ddl-generation.output-mode" value="both" />
<property name="eclipselink.application-location" value="D:\my projects\fatfServer\SybaseScripts" /> -->
<property name="eclipselink.logging.level" value="FINEST" />
</properties>
</persistence-unit>
</persistence>

et voici les logs

[EL Info]: 2009-06-22 15:46:43.109--ServerSession(33136362)--Thread(Thread[main,5,main])--EclipseLink, version: Eclipse Persistence Services - 1.1.1.v20090430-r4097
[EL Config]: 2009-06-22 15:46:43.171--ServerSession(33136362)--Connection(10709843)--Thread(Thread[main,5,main])--connecting(DatabaseLogin(
platform=>SybasePlatform
user name=> ""
connector=>JNDIConnector datasource name=>fatfDev
))
[EL Config]: 2009-06-22 15:46:43.203--ServerSession(33136362)--Connection(14365489)--Thread(Thread[main,5,main])--Connected: jdbc:sybase:Tds:....
User: dbo
Database: Adaptive Server Enterprise Version: Adaptive Server Enterprise/15.0.2/EBF 15651 ESD#4/P/Sun_svr4/OS 5.8/ase1502/2528/64-bit/FBO/Sat Apr 5 09:36:08 2008
Driver: jConnect (TM) for JDBC (TM) Version: jConnect (TM) for JDBC(TM)/6.0(Build 25308)/P/EBF11817/JDK14/Fri Feb 27 20:57:29 2004
[EL Config]: 2009-06-22 15:46:43.234--ServerSession(33136362)--Connection(16650201)--Thread(Thread[main,5,main])--connecting(DatabaseLogin(
platform=>SybasePlatform
user name=> ""
connector=>JNDIConnector datasource name=>fatfDev
))
[EL Config]: 2009-06-22 15:46:43.265--ServerSession(33136362)--Connection(29529080)--Thread(Thread[main,5,main])--Connected: jdbc:......
User: dbo
Database: Adaptive Server Enterprise Version: Adaptive Server Enterprise/15.0.2/EBF 15651 ESD#4/P/Sun_svr4/OS 5.8/ase1502/2528/64-bit/FBO/Sat Apr 5 09:36:08 2008
Driver: jConnect (TM) for JDBC (TM) Version: jConnect (TM) for JDBC(TM)/6.0(Build 25308)/P/EBF11817/JDK14/Fri Feb 27 20:57:29 2004
[EL Info]: 2009-06-22 15:46:43.765--ServerSession(33136362)--Thread(Thread[main,5,main])--file:/D:/my%20projects/fatfServer/WebContent/WEB-INF/classes/-fatfServer login successful
[EL Finest]: 2009-06-22 15:46:43.781--ServerSession(33136362)--Thread(Thread[main,5,main])--End deploying Persistence Unit fatfServer; state Deployed; factoryCount 1
[EL Finer]: 2009-06-22 15:46:45.64--ServerSession(33136362)--Thread(Thread[main,5,main])--client acquired
[EL Finest]: 2009-06-22 15:46:46.171--UnitOfWork(21335499)--Thread(Thread[main,5,main])--Execute query DataModifyQuery(sql="delete from t_fat_sequence")
[EL Finer]: 2009-06-22 15:46:46.187--ClientSession(4341071)--Connection(13046738)--Thread(Thread[main,5,main])--begin transaction
[EL Finest]: 2009-06-22 15:46:46.187--ClientSession(4341071)--Thread(Thread[main,5,main])--reconnecting to external connection pool
[EL Fine]: 2009-06-22 15:46:46.203--ClientSession(4341071)--Connection(31877484)--Thread(Thread[main,5,main])--delete from t_fat_sequence
[EL Finer]: 2009-06-22 15:46:46.656--UnitOfWork(21335499)--Thread(Thread[main,5,main])--begin unit of work commit
[EL Finer]: 2009-06-22 15:46:46.703--ClientSession(4341071)--Connection(31877484)--Thread(Thread[main,5,main])--commit transaction
[EL Finer]: 2009-06-22 15:46:46.765--UnitOfWork(21335499)--Thread(Thread[main,5,main])--end unit of work commit
[EL Finer]: 2009-06-22 15:46:46.765--UnitOfWork(21335499)--Thread(Thread[main,5,main])--resume unit of work
[EL Finer]: 2009-06-22 15:46:47.281--UnitOfWork(21335499)--Thread(Thread[main,5,main])--release unit of work
[EL Finer]: 2009-06-22 15:46:47.281--ClientSession(4341071)--Thread(Thread[main,5,main])--client released

Une idée ?
Merci

[jmturc]

désolé,
c'est de ma faute , je me suis trompé dans un paramétré (nom de la base).