[JBoss-user] [Persistence,JBoss/CMP, Hibernate, Database] - Re: sql performance difference
hi connection url is: connection-urljdbc: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)))/connection-url 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=bbop=viewtopicp=3895991#3895991 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=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=bbop=viewtopicp=3895638#3895638
Reply to the post :
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=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] - 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=bbop=viewtopicp=3893146#3893146 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=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
[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=bbop=viewtopicp=3893148#3893148 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=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] - Re: restart and java.lang.NoClassDefFoundError
thanks joachim it works fine best regards View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3893169#3893169 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=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
