Re: Executing SP in MSSQL takes forever via JDBC?!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: anders.hedstrom (andershedstrom_at_discussions.microsoft.com)
Date: 11/30/04

  • Next message: Jose R Castro: "MSDE + JDBC SP3 - Run Together in WS" 
    Date: Mon, 29 Nov 2004 23:49:01 -0800

    > Try these two things:
    > 1 - Change the URL to "sendStringParametersAsUnicode". Note the initial lowercase 's'.
    > 2 -
    > Statement s = conn.createStatement();
    > ResultSet r = s.executeQuery("exec my_sp " + param1 + ", " + param2 );
    >
    > Joe Weinstein at BEA

    Hi Joe,

    thanx alot for your tip! This fixed my problem;
    > Statement s = conn.createStatement();
    > ResultSet r = s.executeQuery("exec my_sp " + param1 + ", " + param2 );

    It would be quite interesting to know why it takes so long to execute the SP
    when using CallableStatement and PreparedStatement...

    By the way, the lowercase 's' on sendStringParametersAsUnicode made no
    difference.

    Once again Joe, thanx!!!

    Cheers

    //Anders =)

  • Next message: Jose R Castro: "MSDE + JDBC SP3 - Run Together in WS"

    Relevant Pages

    • Re: Im baaaack!
      ... Joe says you had ... safe and stay warm, and hope you get through that storm ok, we'll be praying ... lot of chatter in here about the formula change, ... Alot has changed, and alot has stayed the same. ...
      (alt.support.chronic-pain)
    • Re: Im baaaack!
      ... Hey, stay away from my wife ya hear:) slick, smooth, talking joker you ... I am so glad to see Joe is still keeping a presence up in here and an eye ... formula change seem to have occurred in May right around the arrival ... Alot has changed, and alot has stayed the same. ...
      (alt.support.chronic-pain)
    • Re: Im baaaack!
      ... I am so glad to see Joe is still keeping a presence up in here and an eye out. ... you've been missed, my friend. ... lot of chatter in here about the formula change, ... Alot has changed, and alot has stayed the same. ...
      (alt.support.chronic-pain)
    • Re: Just for mike.
      ... I like MM alot and I am considering buying one, but I agree it is way ... Hell I am willing to pay mid to high 3K's for one in real nice shape! ... Joe ...
      (rec.games.pinball)
    • Re: Unicycle.Com Rocks!
      ... joe wrote: ... I've heard some bad things about alot of companies, ... they were very friendly and blah blah blah." ... johnfoss wrote: ...
      (rec.sport.unicycling)