Hi Kiran,
Thanks a lot, actually i am a new guy in developing db2 applications, i
will try your suggestions, i hope it works

--

Best Regards

Liang Zhang

Developer
SAP Labs China

T: +86 21 61006699-7775
F: +86 21 65984520
Email liang.zhang@sap.com

SAP LABS CHINA : INNOVATE THE FUTURE
"Kiran" <kiranhariharan@gmail.com> wrote in message
news:1145939365.099200.153640@t31g2000cwb.googlegr oups.com...
> Hi Liang,
> The SQL for dropping an Procedure is
> DROP PROCEDURE ESTU.TESTPROC
>
> And if you have multiple stored procedure with same names, you may
> think of dropping using SPECIFIC name (if you have given specific name
> while creating the stored procedure) or giving the full signture of
> stored procedure
> DROP SPECIFIC PROCEDURE specific_name
> or using signature.
>
> DROP PROCEDURE ESTU.TESTPROC(INTEGER)
>
> I have not sure why the machine hangs You can always troubleshoot
> JDBC programs by taking a JDBC trace
> http://publib.boulder.ibm.com/infoce...d/c0007959.htm
>
> Now when you analyse the trace you will get a very good knowlege of
> what exactly is happening between you Java runtime and DB2.
>
> Since your machine is in VM, you can actually verify the SQL in the
> server or client db2 command line/ control center and then issue the
> same in Java Program.
>
> Regards,
> Kiran Nair
>
>
> Liang Zhang wrote:
>
>> And the dropping sql is very simple: DROP TESTU.TESTPROC, it did work in
>> some early time, but now it always suspends, i have rebooted the VM again
>> an
>> again, i cannot imagine errors can occur here......
>>
>> --
>>
>> Best Regards
>>
>> Liang Zhang
>>
>> Developer
>> SAP Labs China
>>
>> T: +86 21 61006699-7775
>> F: +86 21 65984520
>> Email liang.zhang@sap.com
>>
>> SAP LABS CHINA : INNOVATE THE FUTURE
>> "Liang Zhang" <liang.zhang@sap.com> wrote in message
>> news:e2k4hf$54k$1@news.sap-ag.de...
>> >I am now developing a java program connected to db2 via jdbc, and the
>> >db2
>> >server(version 8.2) is installed in a visual machine running also on my
>> >computer, however, i always found that the java program suspended when
>> >sending a request to drop a stored procedure, I don't know why, and now
>> >i
>> >am really bored with this issue, can someone help me? thanks
>> > --
>> >
>> > Best Regards
>> >
>> > Liang Zhang
>> >
>> > Developer
>> > SAP Labs China
>> >
>> > T: +86 21 61006699-7775
>> > F: +86 21 65984520
>> > Email liang.zhang@sap.com
>> >
>> > SAP LABS CHINA : INNOVATE THE FUTURE
>> >
>