how to get data fast on the report

2002-11-09 Thread Vaishali S. Pandya
HI Every body,

I am doing MIS Reporting. I have to fetch 6 rows at a time. In the  Qry
there is a join.
All index are there.

Right now the exewcution of the program takes 20 seconds I want to reduce
it by 10 seconds.

Thanks for the support,

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: signoff JSP-INTEREST.
For digest: mailto [EMAIL PROTECTED] with body: set JSP-INTEREST DIGEST.
Some relevant FAQs on JSP/Servlets can be found at:

 http://archives.java.sun.com/jsp-interest.html
 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.jsp
 http://www.jguru.com/faq/index.jsp
 http://www.jspinsider.com



jdbc driver for sql server

2002-11-09 Thread Bahram Sheibani
Hi,
have you ever used the jdbc driver for sql server? There is a project was
developed with servlet and dbAnywhere and sql server  ,but  we decided to
change dbanywhere to jdbc driver for sql server from Microsoft. The problem
that exist is, the stored procedure doesn't work properly in jdbc driver. I
get error such as [Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet
set was produced. .I  appreciate any help in advance.
regards

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: signoff JSP-INTEREST.
For digest: mailto [EMAIL PROTECTED] with body: set JSP-INTEREST DIGEST.
Some relevant FAQs on JSP/Servlets can be found at:

 http://archives.java.sun.com/jsp-interest.html
 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.jsp
 http://www.jguru.com/faq/index.jsp
 http://www.jspinsider.com



Re: how to get data fast on the report

2002-11-09 Thread Sreenath V Reddy
send me the query madam will tell u the easiet way and also send me the table 
description i mean table structure and which are indexed and all ok !

-Original Message- 
From: Vaishali S. Pandya [mailto:Vaishali_Shah;RIL.COM] 
Sent: Sat 11/9/2002 2:51 PM 
To: [EMAIL PROTECTED] 
Cc: 
Subject: how to get data fast on the report



HI Every body,

I am doing MIS Reporting. I have to fetch 6 rows at a time. In the  Qry
there is a join.
All index are there.

Right now the exewcution of the program takes 20 seconds I want to reduce
it by 10 seconds.

Thanks for the support,

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: signoff 
JSP-INTEREST.
For digest: mailto [EMAIL PROTECTED] with body: set JSP-INTEREST DIGEST.
Some relevant FAQs on JSP/Servlets can be found at:

 http://archives.java.sun.com/jsp-interest.html
 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.jsp
 http://www.jguru.com/faq/index.jsp
 http://www.jspinsider.com



**Disclaimer**

 Information contained in this E-MAIL being proprietary to Wipro Limited is 
'privileged'
and 'confidential' and intended for use only by the individual or entity to which it is
addressed. You are notified that any use, copying or dissemination of the information
contained in the E-MAIL in any manner whatsoever is strictly prohibited.





how to STOP TOMCAT LOGGING

2002-11-09 Thread randie ursal
hi list,

  how can i disable logging on TOMCAT?

  i have a tomcat on a Solaris 8.0 machine, and when i look at the
  logs folder the log files from previous months was not erased. so,
  if this is going on for so long there's a tendency that my disk
  space will be full.

  BTW, im using jakarta-tomcat-4.0.

thanks.

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: signoff JSP-INTEREST.
For digest: mailto [EMAIL PROTECTED] with body: set JSP-INTEREST DIGEST.
Some relevant FAQs on JSP/Servlets can be found at:

http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com



Re: how to STOP TOMCAT LOGGING

2002-11-09 Thread Jiri Chaloupka
Whz do not delete old logs?
Create new log file for each month (for example) and delete logs older than 1 
year ...

Jirka

Dne so 9. listopad 2002 16:07 jste napsal(a):
 hi list,

how can i disable logging on TOMCAT?

i have a tomcat on a Solaris 8.0 machine, and when i look at the
logs folder the log files from previous months was not erased. so,
if this is going on for so long there's a tendency that my disk
space will be full.

BTW, im using jakarta-tomcat-4.0.

 thanks.

==To 
unsubscribe: mailto [EMAIL PROTECTED] with body: signoff JSP-INTEREST.
For digest: mailto [EMAIL PROTECTED] with body: set JSP-INTEREST DIGEST.
Some relevant FAQs on JSP/Servlets can be found at:

 http://archives.java.sun.com/jsp-interest.html
 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.jsp
 http://www.jguru.com/faq/index.jsp
 http://www.jspinsider.com



Re: how to STOP TOMCAT LOGGING

2002-11-09 Thread randie ursal
i thought TOMCAT automatically delete this, i'm talking about the
log files generated by TOMCAT on logs folder.

Jiri Chaloupka wrote:

Whz do not delete old logs?
Create new log file for each month (for example) and delete logs older than 1
year ...

Jirka

Dne so 9. listopad 2002 16:07 jste napsal(a):


hi list,

  how can i disable logging on TOMCAT?

  i have a tomcat on a Solaris 8.0 machine, and when i look at the
  logs folder the log files from previous months was not erased. so,
  if this is going on for so long there's a tendency that my disk
  space will be full.

  BTW, im using jakarta-tomcat-4.0.

thanks.



To unsubscribe: mailto [EMAIL PROTECTED] with body: signoff JSP-INTEREST.
For digest: mailto [EMAIL PROTECTED] with body: set JSP-INTEREST DIGEST.
Some relevant FAQs on JSP/Servlets can be found at:

 http://archives.java.sun.com/jsp-interest.html
 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.jsp
 http://www.jguru.com/faq/index.jsp
 http://www.jspinsider.com




--

Randie V. Ursal
Design Engineering Department
NEC Telecom Software Philippines, Inc.
office : +63(032) 233-9142 (loc.3119)
mobile : +63(0917) 467-8244
email  : [EMAIL PROTECTED]

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: signoff JSP-INTEREST.
For digest: mailto [EMAIL PROTECTED] with body: set JSP-INTEREST DIGEST.
Some relevant FAQs on JSP/Servlets can be found at:

http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com



Re: jdbc driver for sql server

2002-11-09 Thread Martin Gainty

The JDBC Driver for SQLServer is located athttp://msdn.microsoft.com/downloads/default.asp?URL="/downloads/sample.asp?url=/MSDN-FILES/027/001/779/msdncompositedoc.xmlif the driver is flaky you can use a JDBC2ODBCBridge (which will cost you performance wise) but will give you a robustmappingof JDBC to ODBC calls..has anyone worked with JDeveloper?does anyone know what tweaking AddVMOption -Xheapbase1000in jdev.conf does?Thanks,







Martin Gainty



__

Disclaimer and confidentiality note

Everything in this e-mail and any attachments relating to the official business of Laconia Data Systems (LDS) is proprietary to the company. It is confidential, legally privileged and protected by law.LDS does not own and endorse any other content. Views and opinions are those of the sender unless clearly stated as being that of LDS. 

The person addressed in the e-mail is the sole authorised recipient. Please notify the sender immediately if it has unintentionally reached you and do not read, disclose or use the content in any way.



LDScan not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference.

_GMT-5___














From: Bahram Sheibani <[EMAIL PROTECTED]>
Reply-To: A mailing list about Java Server Pages specification and reference <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: jdbc driver for sql server
Date: Sat, 9 Nov 2002 13:00:00 +0330
MIME-Version: 1.0
Received: from mc7-f39.law1.hotmail.com ([65.54.253.46]) by mc7-s20.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Sat, 9 Nov 2002 01:43:18 -0800
Received: from swjscmail2.java.sun.com ([192.18.99.108]) by mc7-f39.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Sat, 9 Nov 2002 01:43:18 -0800
Received: from swjscmail1 (swjscmail1.Sun.COM [192.18.99.107])by swjscmail2.java.sun.com (Postfix) with ESMTPid F3EB721E6F; Sat, 9 Nov 2002 02:40:12 -0700 (MST)
Received: from JAVA.SUN.COM by JAVA.SUN.COM (LISTSERV-TCP/IP release 1.8d) with spool id 4072857 for [EMAIL PROTECTED]; Sat, 9 Nov 2002 02:38:03 -0700
Received: from negareh.com (unknown [66.48.76.208]) by swjscmail1.java.sun.com (Postfix) with ESMTP id D48E04830 for <[EMAIL PROTECTED]>; Sat, 9 Nov 2002 02:28:02 -0700 (MST)
Received: from bahram [213.217.51.173] by negareh.com with ESMTP (SMTPD32-7.07) id A5E56980098; Sat, 09 Nov 2002 04:31:17 -0500
Delivered-To: [EMAIL PROTECTED]
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
X-MIMEOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Importance: Normal
Message-ID: <[EMAIL PROTECTED]>
Sender: A mailing list about Java Server Pages specification and reference <[EMAIL PROTECTED]>
Comments: cc: [EMAIL PROTECTED]
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 09 Nov 2002 09:43:18.0716 (UTC) FILETIME=[6F22BFC0:01C287D4]

Hi,
have you ever used the jdbc driver for sql server? There is a project was
developed with servlet and dbAnywhere and sql server ,but we decided to
change dbanywhere to jdbc driver for sql server from Microsoft. The problem
that exist is, the stored procedure doesn't work properly in jdbc driver. I
get error such as "[Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet
set was produced." .I appreciate any help in advance.
regards

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://archives.java.sun.com/jsp-interest.html
 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.jsp
 http://www.jguru.com/faq/index.jsp
 http://www.jspinsider.com
Add photos to your e-mail with MSN 8. Get 2 months FREE*.

===
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://archives.java.sun.com/jsp-interest.html
 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.jsp
 http://www.jguru.com/faq/index.jsp
 http://www.jspinsider.com