[JBoss-user] [Persistence,JBoss/CMP, Hibernate, Database] - Re: sql performance difference
hi connection url is: jdbc:oracle:thin:@(DESCRIPTION = (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP) (HOST = kopsdb1_vip.yurticikargo.com.tr) (PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = kopsdb2_vip.yurticikargo.com.tr)(PORT = 1521)) (CONNECT_DATA= (SERVER = DEDICATED) (SERVICE_NAME = KOPS))) we use oracle10g rack system and try to do load balancing. so i think its application server problem. because lots of sql statement execute in system and some of then slower in application server. same sql statement execute in pl/sql and jdeveloper faster than application server. these sql staments contains more than joins and hints (for index) View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3895991#3895991 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3895991 --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence,JBoss/CMP, Hibernate, Database] - sql performance difference
hi our problem is differnence execution time between pl/sql developer and jboss application server. same select statments executed in 5 seconds at pl/sql devoleper or oracle j-developer , but selfsame excecuted in 30 seconds at jboss application server. i checked the index , strings etc. but i dont see any problems. sample select statments is bottom of the page. but we have lots of same problems on different statements. have you got any idea , can we change any jboss or java parameter , configuration settings , etc ? thanks -- select /*+ INDEX (atd, acc_tran_detail_ind1) */ TO_CHAR(atd.field1) as CUST_ID, c.cust_name as CUST_NAME, decode(atd.debit_credit_flag, 'A', (sum(amount)*(-1)), sum(amount)) as DOCUMENT_DEBIT, TO_CHAR(atd.segment2) as ACCOUNT_TYPE from acc_transaction atn join acc_tran_detail atd on atd.tran_id = atn.tran_id join gen_customer c on c.cust_id = TO_NUMBER(atd.field1) -- ACC_TRAN_DETAIL_IND3 (SEGMENT4, ACC_TYPE, DEBIT_CREDIT_FLAG, SEGMENT2) and atd.segment4 = '1043' and atd.acc_type = 'D' and atd.debit_credit_flag in ('B','A') and atd.segment2 in ('1','3') -- ACC_TRANSACTION_INDX1 (TRAN_DATE, UNIT_ID, TRAN_CODE) and atn.tran_date = '20050916' and atn.unit_id = '1043' and atn.tran_code in (select temp.tran_code from acc_transaction_template temp ) --and nvl(atn.cancel_flag, 0) = 0 --and nvl(atn.cancelled_tran_id, 0) = 0 and atn.status = '1' where --atd.segment1 = 1 atd.segment1 in(1,4) --and atd.field1 = '2011906' --and c.cust_name like 'I%' group by atd.field1, atd.debit_credit_flag, atd.segment2, c.cust_name View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3895638#3895638 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3895638 --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence,JBoss/CMP, Hibernate, Database] - Re: restart and java.lang.NoClassDefFoundError
thanks joachim it works fine best regards View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3893169#3893169 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3893169 --- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [EJB/JBoss] - restart and java.lang.NoClassDefFoundError
our problem occurs after restart report server.. Report server works normally. But when i restart the server (without any variety) , our server is giving java.lang errors. first --Can't connect to X11 window server using 'localhost:1.0' as the value of the DISPLAY variable.-- error is on report log , then --java.lang.NoClassDefFoundError-- errors is on report log. when restart the report server one more times , it works normally again. what is the why and solution. any idea ? 2005-09-05 17:22:41,682 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : Can't conn ect to X11 window server using 'localhost:1.0' as the value of the DISPLAY varia ble. 2005-09-05 17:22:43,555 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:43,767 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:47,085 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:47,300 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:47,889 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:48,233 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:49,473 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:49,960 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:50,423 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:52,315 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:54,089 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:54,826 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:55,156 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError . . . . . View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3893148#3893148 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3893148 --- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence,JBoss/CMP, Hibernate, Database] - restart and java.lang.NoClassDefFoundError
hi our problem occurs after restart report server.. Report server works normally. But when i restart the server (without any variety) , our server is giving java.lang errors. first --Can't connect to X11 window server using 'localhost:1.0' as the value of the DISPLAY variable.-- error is on report log , then --java.lang.NoClassDefFoundError-- errors is on report log. when restart the report server one more times , it works normally again. what is the why and solution. any idea ? 2005-09-05 17:22:41,682 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : Can't conn ect to X11 window server using 'localhost:1.0' as the value of the DISPLAY varia ble. 2005-09-05 17:22:43,555 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:43,767 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:47,085 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:47,300 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:47,889 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:48,233 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:49,473 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:49,960 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:50,423 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:52,315 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:54,089 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:54,826 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError 2005-09-05 17:22:55,156 INFO [STDOUT] [SEVERE] [ID : ReportServlet] : : tr.co m.cs.aurora.report.server.engine.operations.ReportFiller.fillReport : java.lang. NoClassDefFoundError . . . . . View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3893146#3893146 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3893146 --- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user