Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sikar
  • Order by date
  1. sikar

    Problem using setString in PreparedStatement

    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...
  2. sikar

    deleting blob, taking too much time

    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...
  3. sikar

    deleting blob, taking too much time

    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...
  4. sikar

    Does Apache Tomcat 4.3 supports Servlet 2.2 API

    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
  5. sikar

    Does Apache Tomcat 4.3 supports Servlet 2.2 API

    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
  6. sikar

    Urgent : Stop a thread from a Class diff from its creation Class

    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
  7. sikar

    Urgent : Stop a thread from a Class diff from its creation Class

    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...
    • sikar
    • Thread
    • Replies: 3
    • Forum: Java
  8. sikar

    Rounding off a number to the next highest integer

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

    How to know if the First Record is Suppressed???

    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...
  10. sikar

    How to know whether previous details is suppressed or not

    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.
  11. sikar

    Sum of a Field with Condition

    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
  12. sikar

    Getting records in a Group for "maximum" value of a particular field

    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...
  13. sikar

    Getting records of a Group

    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...
  14. sikar

    Concatenate a field till the end of all the records

    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.
  15. sikar

    Concatenate a field till the end of all the records

    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.

Part and Inventory Search

Back
Top