Updates from October, 2011 Toggle Comment Threads | Keyboard Shortcuts

  • Subinkrishna Gopi 2:41 pm on October 5, 2011 Permalink |
    Tags: , database, db2,   

    An encounter with DB2 – How to apply “limit” to queries? 

    My new assignment wanted me to experiment with DB2. And like everyone else who is new to DB2, I couldn’t find a way to limit the result set! After a lot of googling and phone calls I ended up with a stupid solution – but it works.

    The solution looks like this:

    SELECT * FROM
    	( SELECT ROW_NUMBER() OVER (ORDER BY column_to_be_sorted) AS rownumber, col1, col2, other_cols
    	  FROM my_db2_table WHERE col1 = ‘something’ )
    AS tmp_table
    WHERE rownumber BETWEEN start_index AND end_index
    

    I hope this helps. But I really wish if there was some better ways.

    Advertisements
     
  • Subinkrishna Gopi 11:44 am on December 14, 2010 Permalink |
    Tags: crash, , , putty, ,   

    Today’s read: What to do when your website goes down? 

    Smashin Magazine

    What to do when your website goes down? is an awesome post, trust me. Perhaps one of the most useful one, that can help anyone.

    Have you ever heard a colleague answer the phone like this: “Good afterno… Yes… What? Completely?… When did it go down?… Really, that long?… We’ll look into it right away… Yes, I understand… Of course… Okay, speak to you soon… Bye.” The call may have been followed by some cheesy ’80s rock ballad coming from the speaker phone, interrupted by “Thank you for holding. You are now caller number 126 in the queue.” That’s your boss calling the hosting company’s 24 hour “technical support” line.

    An important website has gone down, and sooner or later, heads will turn to the Web development corner of the office, where you are sitting quietly, minding your own business, regretting that you ever mentioned “Linux” on your CV. You need to take action. Your company needs you. Your client needs you. Here’s what to do.

    Source: Smashing Magazine

    Read the original post

     
  • Subinkrishna Gopi 2:54 pm on March 25, 2010 Permalink |
    Tags: , chrome, , , ,   

    Gmail or Google Chrome ! Who is the culprit? 

    I am not able to access Gmail!
    I am not able to access Gmail from Google Chrome!
    I am not able to access Gmail from Google Chrome in Ubuntu!

    But I can access it in FireFox! So whom should I put the blame on? Gmail, Chrome or Ubuntu?

    The behavior is li’l inconsistent. Sometimes a page refresh works, but most of the times it doesn’t !

     
  • Subinkrishna Gopi 2:45 pm on February 24, 2010 Permalink |
    Tags: , , , google voice,   

    Funny: How Google Voice can ruin your relationships ! 


    This is seriously funny! Funnily serious too. I read it in gizmodo.com.

    Read the article here:
    http://gizmodo.com/5478789/this-is-how-google-voice-will-ruin-your-relationships

     
  • Subinkrishna Gopi 11:37 am on February 23, 2010 Permalink |
    Tags: , help, htmlunit, , , , memory leak, ,   

    HTMLUnit issue 

    We are using HTMLUnit in one of our modules and we use it to crawl through the webpages. But we are facing serious memory leak issues with HTMLUnit. We are unable to kill the JavaScript threads even after the functionality is completed. All my search to fix this issue ended up in one solution,

    webClient.closeAllWindows();
    

    But even this did not help us in solving the leak. The method call claims to kill all the running JavaScript threads associated with the WebClient though! If anyone can help us in fixing this, can share their thoughts here. I will update this post as soon as we have a solution.

    Thank you.

     
    • kkperf 11:28 pm on April 9, 2010 Permalink

      We seem to be running into a similar issue.
      We noticed “leaking windows” – always with a scriptable object tied to it. Here is what we did to confirm this (in addition to heap dump analysis)

      System.out.println(“windows size before closeAllWindows: ” + windows.size());
      webClient.closeAllWindows();
      System.out.println(“windows size after closeAllWindows: ” + windows.size());

      List windowsAfterClose = webClient.getWebWindows();
      System.out.println(“windowsAfterClose size: ” + windowsAfterClose.size());
      for (WebWindow ww : windowsAfterClose) {
      System.out.println(“Window name: ” + ww.getName());

      This shows that there is 1 window with no name still open.

      Trying to figure out whats going on. I’m going to perhaps end up logging a bug with htmlunit.
      Let me know if you have found a solution to the problem.
      Thanks
      -KK

    • kswenson 2:53 am on August 3, 2010 Permalink

      I have this exact problem.

      I have iterated through all the of the windows, gotten the ThreadManager, and interrupted all treads managed by those windows.

      Then I close all windows.

      But background JavaScript is still running. Every few seconds it creates a new thread and executes something.

      There is a class JavaScriptBackgroundJob which is running, but this class is not mentioned anywhere in the JavaDoc shipped with the library.

      I would appreciate help from anyone who can tell me how to COMPLETELY shut down all htmlunit processing.

    • Subinkrishna G 12:44 pm on August 4, 2010 Permalink

      We still dont have any solution 😦 I will update this post as soon as I have one.

c
Compose new post
j
Next post/Next comment
k
Previous post/Previous comment
r
Reply
e
Edit
o
Show/Hide comments
t
Go to top
l
Go to login
h
Show/Hide help
shift + esc
Cancel