Search results for query: *

Hi, I am using PreparedStatement and my query is like this: Select all_dest, city_type from TableA where city_type in (?) " ; In the PreparedStatement, I am using a String to provide value for city_type pstmt.setString(1, strCityType); Now this strCityType has value = 'I', 'T', 'A'; On...

Hi Mufasa, Thanks a lot for reply. In my case I have separate 30000 queries for deletion and after every query I have commit. So the issue of rollback segment is not there. Since I am deleting row having blob column, it is taking too much time. The overall size of these 30000 rows is...

Hi, I have a table which stores blob. There are 45,000 records in the table. I have to delete 30,000 records based on some criteria. I have written separate 30k queries, one for deleting one record. It is taking time more than 10 hours to delete all the 30k records. It will be of great help if...

Hi Venu when I searched on the http://jakarta.apache.org/tomcat/ I could not make out whether Apache Tomcat 4.3 supports Servlet 2.2 API or not. By default Apache Tomcat 4.3 implements Servlet 2.3 API. If anyone can confirm if Apache Tomcat 4.3 supports Servlet 2.2 API? Thanks Sikar

Hi Apache Tomcat 4.3 supports Servlet 2.3 API by default. It will be of great help if someone can confirm that it supports Servlet 2.2 API. Thanks Sikar

I iterated through the Threadgroups and got an array of active threads. Thread thread = threads[i]; if(thread.getName().equalsIgnoreCase("test")) { thread = null // This is not stopping the thread } Now how can I stop or destroy the 'test' thread. Thanks Sikar

In my program I create a thread and name it test and call its run method from a Java Class(file). Now on click of some button in a different Class I want to stop this 'test' thread. I list down all the active threads in my java class(in which I want to stop this 'test' thread) and if the name of...

In my report i need to round off a number to the next highest integer.How can i achieve this? Thanks Sikar

i have some condition on the basis of which i am suppressing details section.i need to know if the first record is suppressed(i.e. the condition on which i suppressed was true for first record).how can i achieve this.is there anything available in crystal reports which can directly tell me that...

i my details section i have a field which i have to show or suppress according to the previous detail record.If the previous details is suppressed then i have to show it else i have to suppress it.please help me out.

In my report i have a flag field which will have two values 'Y' or 'N'.On the value of this flag i have to sum a field separately for 'Y' and 'N'.After this i have to take difference of these two values.How to do this.Please help me out. thanks

In my report there is a group.In the group there is a field which will have only two values.Out of those two values i have to pick records for the maximum value only.i have put all the fields to be shown in the 'details Section'. Please help me to do this.I tried to use 'maximum' in the...

In my report i am Grouping on a particular field.i have put all the fields to be shown in the 'details Section'.One of these fields is a flag.Now if the value of the flag changes in the Group only then i need to show all the Records of that group else i need not show the records for that Group...

In Reebo's solution it concatenates at each record step by step.i need to concatenate it once only, till the end.How can this be done and i have to use this formula as group.

In my report i have a column in which i have to concatenate a database field till the end of all the records.How can i do this.please help me out.