[JBoss-user] [Persistence CMP/JBoss] - Poor performance with JBoss MS SQL Server
Hi, My application deployed in JBoss 3.2.6 uses a CMP with fields(similar to): entitynamePK String In DB varchar(255) PK entitytime Timestamp In DB datatime entitystate Integer In DB int entitysize Integer In DB int entitystr String In DB varchar(50) DB used is MS SQL Server. The field 'entitynamePK' is indexed in the DB. My problem is, In one of my session bean methods..say x(), I use findByPrimaryKey(String entitynamePK) for finding the entity by PK. Now, based on certain business logic, all other fields would be updated. I tried pre-filling the DB with 100 records, and ran a performance test on method x() to know the processing time reqd for this method. For 100 pre-filled records, the processing time was say 't1'. Then I filled the DB with a count of 20,000 records, and ran the same performance test, now the processing time raised to some where near..(10*t1). Later I found that the additional processing time is entirely because of the findByPrimaryKey() - finder. I'am little worried about the multiple by which the processing time is varying between the 100 pre-filled records the 20,000 pre-filled records. I'am not sure - where to attack the problem:: In DB or in JBoss?? Any pointers regarding the same would be much appreciated. Thanks in advance.. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3884056#3884056 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3884056 --- 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] [EJB/JBoss] - Re: Transaction - time out
Hi !! Can you please provide some more inputs on - determining the suitability of the 'default combination of pessimistic EJB locking commit option A' for the use-case. An example for analysing would be very helpful for me. Few comments: 1. the default commit option is 'B' not 'A' - right ?? 2. Read-only methods cannot be used in my case - since, timeout is happening only when i try to reads a modifiable field.[which cannot be made read-only, as concurrent writes are also possible] Thanks in advance !! View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3877297#3877297 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3877297 --- This SF.Net email is sponsored by Oracle Space Sweepstakes Want to be the first software developer in space? Enter now for the Oracle Space Sweepstakes! http://ads.osdn.com/?ad_id=7393alloc_id=16281op=click ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [EJB/JBoss] - Re: Transaction - time out
Hi !! I'am using JBoss 3.2.3 ... Regards.. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3876973#3876973 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3876973 --- This SF.Net email is sponsored by: NEC IT Guy Games. Get your fingers limbered up and give it your best shot. 4 great events, 4 opportunities to win big! Highest score wins.NEC IT Guy Games. Play to win an NEC 61 plasma display. Visit http://www.necitguy.com/?r=20 ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [EJB/JBoss] - Transaction - time out
Hi, I need some help from experienced programmers - who have faced this specific problem of 'transaction - timeout'. My GUI application accesses my app server - deployed with some of my session entity beans. There is a certain case - when the processing task for the app server becomes heavy because of the inputs from the GUI, I receive the below exception: [The cause for this exception was shown as the method call to a method in entity bean - which gets accessed by multiple session beans] --- java.lang.RuntimeException: Transaction marked for rollback, possibly a timeout at org.jboss.ejb.plugins.lock.QueuedPessimisticEJBLock.waitForTx(QueuedPessimisticEJBLock.java:366) at org.jboss.ejb.plugins.lock.QueuedPessimisticEJBLock.doSchedule(QueuedPessimisticEJBLock.java:236) at org.jboss.ejb.plugins.lock.QueuedPessimisticEJBLock.schedule(QueuedPessimisticEJBLock.java:183) These two warnings were also seen just before timing out. 2005-04-21 17:58:38,593 WARN [org.jboss.tm.TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=baskarbj//995, BranchQual=] timed out. status=STATUS_ACTIVE 2005-04-21 17:58:38,609 WARN [org.jboss.tm.TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=baskarbj//999, BranchQual=] timed out. status=STATUS_ACTIVE I mainly wanted to know - if the cause could be a 'dead lock' - that is causing the timing out. If transaction dead locks - can happen, but still not be notified through - an 'ApplicationDeadLockException' ?. Please comment Thanks in advance... View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3876490#3876490 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3876490 --- This SF.Net email is sponsored by: NEC IT Guy Games. Get your fingers limbered up and give it your best shot. 4 great events, 4 opportunities to win big! Highest score wins.NEC IT Guy Games. Play to win an NEC 61 plasma display. Visit http://www.necitguy.com/?r=20 ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [EJB/JBoss] - ApplicationDeadlockException
Hi, I'am running my EJBs on JBoss 3.2.3. I have an entity bean, which may be accessed by multiple other session beans. When I was testing my app - after deploying, I found an exception(as below): - org.jboss.util.deadlock.ApplicationDeadlockException: Application deadlock detected, [EMAIL PROTECTED], bean=, id=283, refs=2, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=//1995, BranchQual=], synched=Thread[Thread Pool Worker-16,5,ASF Session Pool Threads], timeout=5000, queue=[], holder=TransactionImpl:XidImpl [FormatId=257, GlobalId=//1993, BranchQual=], [EMAIL PROTECTED], bean=, id=292, refs=2, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=//1993, BranchQual=], synched=null, timeout=5000, queue=[TXLOCK waitingTx=TransactionImpl:XidImpl [FormatId=257, GlobalId=//1995, BranchQual=] id=0 thread=Thread[Thread Pool Worker-13,5,ASF Session Pool Threads] queued=true], waitingResourceHolder=TransactionImpl:XidImpl [FormatId=257, GlobalId=//1993, BranchQual=] --- This is the first time I'am seeing such an exception. Its a hard nut to crack. If someone can help me out in solving the exception, it'd be really helpful. Thanks in advance, Baskar View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3869192#3869192 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3869192 --- 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] [EJB/JBoss] - General query - usage of stateless session bean
Hi all, I have some doubts regarding the proper usage of stateless session beans. My application has a 'session facade' for receiving all external requests. After receiving requests, the facade interacts with 3 other state less session beans(individual components - each having a distinct functionality) to service the requests. And, each of the individual session bean components can interact with one or more entity bean for DB access/updates. That was my application design - untill I got this doubt: Why should I use stateless session beans for the individual components ? why can't they be plain java classes that access the entity beans(just like the session beans where accessing before) By this I can avoid a JNDI lookup - each time I want to access the component. I'am not sure of the negative effects this may have - related to transactions/scalability..,,. So, I would be happy - if some one can contribute their opinion in this regard. Thanks in advance, Baskar View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3867726#3867726 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3867726 --- 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] [EJB/JBoss] - Re: General query - usage of stateless session bean
Thanks for the analysis. Even I feel that the session beans are not required, except for a single point that: When the individual components are designed as session beans - independantly thay can be tested - (when deployed) - through the remote interface(using db Unit, probably). But when they are modelled as plain Java classes(which access the DB using other entity beans), component level testing cannot be performed. So all unit test cases may have to be done through the facade.(which may not be that much successful) I'am still not that much clear on taking the decision.(because of the above concern) Am I thinking in the wrong way / is there any way to test components - independantly, when deployed ? View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3867782#3867782 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3867782 --- 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] [EJB/JBoss] - Re: General query - usage of stateless session bean
Thanks a lot. Information - was very good for me to proceed. Its a bit difficult to turn the mindset towards Hibernate, after thinking a lot about Entity beans. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3867856#3867856 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3867856 --- 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] - Regarding CMP
Hi all, I've recently started working with CMPs on JBoss. I created an entity bean with some finder methods (using EJB QL : LOCATE method...,) In the jbosscmp-jdbc.xml, I configured the data source for this entity bean as 'mySQL' was working with MySQL server - in my system. This was running without a problem. Then I created another entity bean with finder methods(having simple EJB QL queries, without LOCATE method) For the second CMP bean, I configured the data source as - 'MS SQlServer'. Both the beans were properly deployed were working. (of course with MySQL server). Just for testing - I modified the datasource of my 1st entity bean also to 'MS SQlServer'. Now, both the CMP beans get deployed properly, but while running - I get SQL Exception : stating that - javax.ejb.FinderException: Find failed: java.sql.SQLException: Syntax error or access violation, message from server: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near some sql stateent Can anyone throw some light on this behavior. Thanks in advance. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3853649#3853649 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3853649 --- This SF.Net email is sponsored by: Sybase ASE Linux Express Edition - download now for FREE LinuxWorld Reader's Choice Award Winner for best database on Linux. http://ads.osdn.com/?ad_id=5588alloc_id=12065op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user