executeUpdate takes forever

Hi All,

If I do the following:

String cmd = "INSERT INTO Orders(Id, CompilationTitle,
Template, PurchaseDate, RecievedPayment, CompilationDate, TotalCost,
TotalLength, Customer_Id) VALUES(Orders_sequence.nextval, ";

cmd += "'" + cl.getOptionValue("title") + "', '" +
cl.getOptionValue("template") + "', NULL, 'N', SYSDATE, 0.00, 0, " +
cl.getOptionValue("customerId") + ")";

// run the command
System.out.println(cmd);
stmt.executeUpdate(cmd);

.... it takes forever (over 10 minutes). Is there anyway I can debug
this to see what is going on ?

If I run the exact same command on the SQL prompt it takes it
*instantaneously*. Am I missing something ?

Cheers
rouble

.

Relevant Pages

  • Re: How to disable console on serial when needed ?
    ... don't fit for me when I need to debug my program. ... the serial console is gone forever. ...
    (comp.os.linux.embedded)
  • VS.NET 2005
    ... When trying to debug a windows form, if there is any kind of exception, ... VS.NET takes forever to go to the line and give me information about ...
    (microsoft.public.vsnet.general)
  • Online Debugging
    ... I'm trying to debug a script on my server and it's taking forever ... I've tried to use the debugging ...
    (comp.lang.python)
  • Re: debug/release
    ... line number and a "clear" error message in case of an error. ... the debug file attached to it, but there will not be "clear" error messages ... > All this technology and it still takes forever to get anywhere. ...
    (microsoft.public.dotnet.languages.vb)