Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Schema creation slow with informix
Schema creation slow with informix [message #1067777] Wed, 10 July 2013 14:25 Go to next message
Oliver Pfau is currently offline Oliver PfauFriend
Messages: 9
Registered: November 2011
Junior Member
Hi,

I migrated my JPA 2 mapping from hibernate 4.2.2 to eclipselink 2.5.0. Database is informix and app server JBoss 7.
On 1st access the DB schema is generated. I was wondering that it took a lot of time. Each 15s one table is created. Could something be done to speed it up?

Cheers
Oliver
Re: Schema creation slow with informix [message #1067812 is a reply to message #1067777] Wed, 10 July 2013 16:35 Go to previous messageGo to next message
Tom Eugelink is currently offline Tom EugelinkFriend
Messages: 807
Registered: July 2009
Senior Member
Have you tried to create the tables using exactly the same statements manually? Because 15s is a lot of time for either side to be busy with creating a table.

Tom
Re: Schema creation slow with informix [message #1067886 is a reply to message #1067812] Thu, 11 July 2013 06:28 Go to previous messageGo to next message
Oliver Pfau is currently offline Oliver PfauFriend
Messages: 9
Registered: November 2011
Junior Member
The execution of the eclipselink create table statement took 3 ms if executed manually. The table creation works (but very slow), the insertion works, but the select does not work:

Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.0.v20130507-3faac2b): org.eclipse.persistence.exceptions.DatabaseException

Call: SELECT ID, MIME_TYPE, TYPE FROM CONTENT_TYPE

08:18:12,301 INFO [stdout] (http--0.0.0.0-9090-6) Query: ReadAllQuery(referenceClass=ContentTypeEntity sql="SELECT ID, MIME_TYPE, TYPE FROM CONTENT_TYPE").

08:18:12,302 INFO [stdout] (http--0.0.0.0-9090-6) [EL Warning]: 2013-07-11 08:18:12.301--UnitOfWork(59195133)--Thread(Thread[http--0.0.0.0-9090-6,5,main])--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.0.v20130507-3faac2b): org.eclipse.persistence.exceptions.DatabaseException

...

08:18:12,303 INFO [stdout] (http--0.0.0.0-9090-6) Internal Exception: com.ibm.db2.jcc.am.SqlException: [jcc][t4][2093][11302][4.14.111] Die Abfrageverarbeitung wurde wegen eines Fehlers auf dem Server beendet. ERRORCODE=-4228, SQLSTATE=null

08:18:12,304 INFO [stdout] (http--0.0.0.0-9090-6) Error Code: -4228
Re: Schema creation slow with informix [message #1067943 is a reply to message #1067886] Thu, 11 July 2013 11:23 Go to previous message
Oliver Pfau is currently offline Oliver PfauFriend
Messages: 9
Registered: November 2011
Junior Member
Errors and lags are solved if I use the JDBC 3 driver (ifxjdbc.jar) for Informix it works. If I use JDBC 4 JCC Driver (db2jcc.jar) the exceptions and lags mentioned occur.

[Updated on: Thu, 11 July 2013 11:37]

Report message to a moderator

Previous Topic:How to prevent eclipse-link from loading lazy fetched attributes ?
Next Topic:AbstractMethodError: _persistence_shallow_clone()
Goto Forum:
  


Current Time: Fri Dec 19 20:23:43 GMT 2014

Powered by FUDForum. Page generated in 0.01735 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software