[JBoss-user] [Persistence CMP/JBoss] - Re: jboss-4.0.1 startup slow (Entitybean SQL generation prob
Concerning this issue, a bug report has just been posted, please see: http://jira.jboss.com/jira/browse/JBAS-1941 Nicolas View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3882448#3882448 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3882448 --- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477alloc_id=16492op=click ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence CMP/JBoss] - Re: jboss-4.0.1 startup slow (Entitybean SQL generation prob
Have you tried increasing the amount of memory which is available for your jboss instance (see startup files). Joachim View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3870540#3870540 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3870540 --- SF email is sponsored by - The IT Product Guide Read honest candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595alloc_id=14396op=click ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence CMP/JBoss] - Re: jboss-4.0.1 startup slow (Entitybean SQL generation prob
Hi Joachim, thank you for your suggestion, I have set the JVM memory allocation pool parameters to -Xms128m and -Xmx768m ( was -Xmx512m before), bit it did not help: startup time 12m:18s | 15:16:19,470 INFO [Server] JBoss (MX MicroKernel) [4.0.1sp1 (build: CVSTag=JBoss_4_0_1_SP1 date=200502160314)] Started in 12m:18s:662ms Best regards, Peter View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3870561#3870561 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3870561 --- SF email is sponsored by - The IT Product Guide Read honest candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595alloc_id=14396op=click ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence CMP/JBoss] - Re: jboss-4.0.1 startup slow (Entitybean SQL generation prob
Grab a profiler and create a bug report in jira(http://jira.jboss.com) with the results. Two good profilers: http://www.ej-technologies.com/products/jprofiler/overview.html http://www.yourkit.com/home/index.jsp View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3870582#3870582 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3870582 --- SF email is sponsored by - The IT Product Guide Read honest candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595alloc_id=14396op=click ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence CMP/JBoss] - Re: jboss-4.0.1 startup slow (Entitybean SQL generation prob
Any suggestions? Alexey maybe? Thanks, Peter View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3870355#3870355 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3870355 --- SF email is sponsored by - The IT Product Guide Read honest candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595alloc_id=14396op=click ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence CMP/JBoss] - Re: jboss-4.0.1 startup slow (Entitybean SQL generation prob
Hi,
and here I post the corresponding log statements generated by
JBoss-3.2.1 when generating the SQL statements for the entitybeans.
It takes only 2.5 sec to generate the statements!
Any help would be very much appreciated,
best regards,
peter
| 2005-03-15 10:09:47,259 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.InternetOfferteEntity]
Initializing CMP plugin for InternetOfferteEntity
| 2005-03-15 10:09:48,681 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.SequenceEntity] Insert
Entity SQL: INSERT INTO TDVB_KEY_INDEX (OBJECT_TYPE, COUNTER) VALUES (?, ?)
| 2005-03-15 10:09:48,681 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.SequenceEntity] Entity
Exists SQL: SELECT COUNT(*) FROM TDVB_KEY_INDEX WHERE OBJECT_TYPE=?
| 2005-03-15 10:09:48,681 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.SequenceEntity]
entity-command: [commandName=default,commandClass=class
org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
| 2005-03-15 10:09:48,691 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.SequenceEntity] Remove
SQL: DELETE FROM TDVB_KEY_INDEX WHERE OBJECT_TYPE=?
| 2005-03-15 10:09:48,741 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.SequenceEntity] Table not
create as requested: TDVB_KEY_INDEX
| 2005-03-15 10:09:48,751 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.SequenceEntity.findByPrimaryKey]
SQL: SELECT OBJECT_TYPE FROM TDVB_KEY_INDEX WHERE OBJECT_TYPE=?
| 2005-03-15 10:09:48,761 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.SequenceEntity] Added
findByPrimaryKey query command for local home interface
| 2005-03-15 10:09:48,772 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.JurPartnerEntity]
Insert Entity SQL: INSERT INTO TDVB_JUR_PARTNER (Partner_Nr, FIRMA_ZUSATZ)
VALUES (?, ?)
| 2005-03-15 10:09:48,772 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.JurPartnerEntity]
Entity Exists SQL: SELECT COUNT(*) FROM TDVB_JUR_PARTNER WHERE Partner_Nr=?
| 2005-03-15 10:09:48,772 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.JurPartnerEntity]
entity-command: [commandName=default,commandClass=class
org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
| 2005-03-15 10:09:48,772 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.JurPartnerEntity]
Remove SQL: DELETE FROM TDVB_JUR_PARTNER WHERE Partner_Nr=?
| 2005-03-15 10:09:48,772 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.JurPartnerEntity] Table not
create as requested: TDVB_JUR_PARTNER
| 2005-03-15 10:09:48,772 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.JurPartnerEntity.findByPrimaryKey]
SQL: SELECT Partner_Nr FROM TDVB_JUR_PARTNER WHERE Partner_Nr=?
| 2005-03-15 10:09:48,772 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.JurPartnerEntity] Added
findByPrimaryKey query command for local home interface
| 2005-03-15 10:09:48,782 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RisikoZusatzEntity]
Insert Entity SQL: INSERT INTO TDVB_RISIKO_Z_ATTR (RISIKO_ID, ZUSATZ_NR,
ZUSATZ_CODE, ZUSATZ_ATTR_CODE, ZUSATZ_ATTR_WERT, ERSTELLUNGSDATUM,
ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
| 2005-03-15 10:09:48,782 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RisikoZusatzEntity]
Entity Exists SQL: SELECT COUNT(*) FROM TDVB_RISIKO_Z_ATTR WHERE RISIKO_ID=?
AND ZUSATZ_NR=? AND ZUSATZ_CODE=? AND ZUSATZ_ATTR_CODE=?
| 2005-03-15 10:09:48,782 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.RisikoZusatzEntity]
entity-command: [commandName=default,commandClass=class
org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
| 2005-03-15 10:09:48,792 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.RisikoZusatzEntity]
Remove SQL: DELETE FROM TDVB_RISIKO_Z_ATTR WHERE RISIKO_ID=? AND ZUSATZ_NR=?
AND ZUSATZ_CODE=? AND ZUSATZ_ATTR_CODE=?
| 2005-03-15 10:09:48,792 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.RisikoZusatzEntity] Table not
create as requested: TDVB_RISIKO_Z_ATTR
| 2005-03-15 10:09:48,792 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.RisikoZusatzEntity.findByPrimaryKey]
SQL: SELECT RISIKO_ID, ZUSATZ_NR, ZUSATZ_CODE, ZUSATZ_ATTR_CODE,
ZUSATZ_ATTR_WERT, ERSTELLUNGSDATUM, ERSTELLUNG_ID, AENDERUNGSDATUM,
AENDERUNG_ID FROM TDVB_RISIKO_Z_ATTR WHERE RISIKO_ID=? AND ZUSATZ_NR=? AND
ZUSATZ_CODE=? AND ZUSATZ_ATTR_CODE=?
| 2005-03-15 10:09:48,792 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.RisikoZusatzEntity] Added
findByPrimaryKey query command for local home interface
| 2005-03-15 10:09:48,812 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.FremdvertragEntity]
Insert Entity SQL: INSERT INTO TDVB_FREMDVERTRAG (Fremdvertrag_Nr,
Beziehung_Art, Vers_Gesellschaft, Risiko_Art, AblaufDatum, RisikoBeschreibung,
[JBoss-user] [Persistence CMP/JBoss] - Re: jboss-4.0.1 startup slow (Entitybean SQL generation prob
Hello again,
I exaggerated a little in my post: the generation of 1 sql
statement does take less than 15sec.
But the whole of the sql-generation takes over 8min, that's
a large part of the total startup time. I will post the log
statements of the sql-generation below.
greetings,
Peter
| 2005-03-14 17:40:19,347 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.InternetOfferteEntity]
Initializing CMP plugin for InternetOfferteEntity
| 2005-03-14 17:40:21,020 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.SequenceEntity] Insert
Entity SQL: INSERT INTO TDVB_KEY_INDEX (OBJECT_TYPE, COUNTER) VALUES (?, ?)
| 2005-03-14 17:40:21,020 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.SequenceEntity] Entity
Exists SQL: SELECT COUNT(*) FROM TDVB_KEY_INDEX WHERE OBJECT_TYPE=?
| 2005-03-14 17:40:21,020 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.SequenceEntity]
entity-command: [commandName=default,commandClass=class
org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
| 2005-03-14 17:40:21,030 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.SequenceEntity] Remove
SQL: DELETE FROM TDVB_KEY_INDEX WHERE OBJECT_TYPE=?
| 2005-03-14 17:40:38,896 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.SequenceEntity] Table not
create as requested: TDVB_KEY_INDEX
| 2005-03-14 17:40:38,956 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.SequenceEntity#findByPrimaryKey]
SQL: SELECT t0_SequenceEntity.OBJECT_TYPE FROM TDVB_KEY_INDEX
t0_SequenceEntity WHERE t0_SequenceEntity.OBJECT_TYPE=?
| 2005-03-14 17:40:38,966 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.SequenceEntity] Added
findByPrimaryKey query command for local home interface
| 2005-03-14 17:40:38,976 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.JurPartnerEntity]
Insert Entity SQL: INSERT INTO TDVB_JUR_PARTNER (Partner_Nr, FIRMA_ZUSATZ)
VALUES (?, ?)
| 2005-03-14 17:40:38,976 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.JurPartnerEntity]
Entity Exists SQL: SELECT COUNT(*) FROM TDVB_JUR_PARTNER WHERE Partner_Nr=?
| 2005-03-14 17:40:38,976 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.JurPartnerEntity]
entity-command: [commandName=default,commandClass=class
org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
| 2005-03-14 17:40:38,976 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.JurPartnerEntity]
Remove SQL: DELETE FROM TDVB_JUR_PARTNER WHERE Partner_Nr=?
| 2005-03-14 17:40:56,811 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.JurPartnerEntity] Table not
create as requested: TDVB_JUR_PARTNER
| 2005-03-14 17:40:56,811 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.JurPartnerEntity#findByPrimaryKey]
SQL: SELECT t0_JurPartnerEntit.Partner_Nr FROM TDVB_JUR_PARTNER
t0_JurPartnerEntit WHERE t0_JurPartnerEntit.Partner_Nr=?
| 2005-03-14 17:40:56,811 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.JurPartnerEntity] Added
findByPrimaryKey query command for local home interface
| 2005-03-14 17:40:56,851 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RisikoZusatzEntity]
Insert Entity SQL: INSERT INTO TDVB_RISIKO_Z_ATTR (RISIKO_ID, ZUSATZ_NR,
ZUSATZ_CODE, ZUSATZ_ATTR_CODE, ZUSATZ_ATTR_WERT, ERSTELLUNGSDATUM,
ERSTELLUNG_ID, AENDERUNGSDATUM, AENDERUNG_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
| 2005-03-14 17:40:56,851 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.RisikoZusatzEntity]
Entity Exists SQL: SELECT COUNT(*) FROM TDVB_RISIKO_Z_ATTR WHERE RISIKO_ID=?
AND ZUSATZ_NR=? AND ZUSATZ_CODE=? AND ZUSATZ_ATTR_CODE=?
| 2005-03-14 17:40:56,851 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.RisikoZusatzEntity]
entity-command: [commandName=default,commandClass=class
org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
| 2005-03-14 17:40:56,851 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.RisikoZusatzEntity]
Remove SQL: DELETE FROM TDVB_RISIKO_Z_ATTR WHERE RISIKO_ID=? AND ZUSATZ_NR=?
AND ZUSATZ_CODE=? AND ZUSATZ_ATTR_CODE=?
| 2005-03-14 17:41:14,497 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.RisikoZusatzEntity] Table not
create as requested: TDVB_RISIKO_Z_ATTR
| 2005-03-14 17:41:14,497 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.RisikoZusatzEntity#findByPrimaryKey]
SQL: SELECT t0_RisikoZusatzEnt.RISIKO_ID, t0_RisikoZusatzEnt.ZUSATZ_NR,
t0_RisikoZusatzEnt.ZUSATZ_CODE, t0_RisikoZusatzEnt.ZUSATZ_ATTR_CODE,
t0_RisikoZusatzEnt.ZUSATZ_ATTR_WERT, t0_RisikoZusatzEnt.ERSTELLUNGSDATUM,
t0_RisikoZusatzEnt.ERSTELLUNG_ID, t0_RisikoZusatzEnt.AENDERUNGSDATUM,
t0_RisikoZusatzEnt.AENDERUNG_ID FROM TDVB_RISIKO_Z_ATTR t0_RisikoZusatzEnt
WHERE t0_RisikoZusatzEnt.RISIKO_ID=? AND t0_RisikoZusatzEnt.ZUSATZ_NR=? AND
t0_RisikoZusatzEnt.ZUSATZ_CODE=? AND t0_RisikoZusatzEnt.ZUSATZ_ATTR_CODE=?
|
