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

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
>

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

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

Kiran wrote:

> 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)

If you haven't assigned explicit specific names, then DB2 will generate them
for you. You can look them up in the catalog
(SYSCAT.ROUTINES.SPECIFICNAME).

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

What does "suspend" mean? Does it just hang? If so, it sounds very much
like a locking issue.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Yeah, it just hangs, and my program is waiting for the response from db2,
but it never returns the response. and when i use sql script like "DROP
PROCEDURE ESTU.TESTPROC
", it works well, it seems a specific name problem, i must use the specific
name to drop the stored procedure when the procedure is created with a
specific name, i am not very clear about this.

--

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
"Knut Stolze" <stolze@de.ibm.com> wrote in message
news:e2kqtf$gb0$2@lc03.rz.uni-jena.de...
> Kiran wrote:
>
>> 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)
>
> If you haven't assigned explicit specific names, then DB2 will generate
> them
> for you. You can look them up in the catalog
> (SYSCAT.ROUTINES.SPECIFICNAME).
>
>>> 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......
>
> What does "suspend" mean? Does it just hang? If so, it sounds very much
> like a locking issue.
>
> --
> Knut Stolze
> DB2 Information Integration Development
> IBM Germany

Liang Zhang wrote:

> Yeah, it just hangs, and my program is waiting for the response from db2,

Which other connections to the database exist? And what are they doing
(what kind of database operations)?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany