|
P: n/a
|
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 li*********@sap.com
SAP LABS CHINA : INNOVATE THE FUTURE | |
Share this Question
|
P: n/a
|
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 li*********@sap.com
SAP LABS CHINA : INNOVATE THE FUTURE
"Liang Zhang" <li*********@sap.com> wrote in message
news:e2**********@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 li*********@sap.com
SAP LABS CHINA : INNOVATE THE FUTURE | |
|
P: n/a
|
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 li*********@sap.com
SAP LABS CHINA : INNOVATE THE FUTURE
"Liang Zhang" <li*********@sap.com> wrote in message
news:e2**********@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 li*********@sap.com
SAP LABS CHINA : INNOVATE THE FUTURE | |
|
P: n/a
|
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 li*********@sap.com
SAP LABS CHINA : INNOVATE THE FUTURE
"Kiran" <ki************@gmail.com> wrote in message
news:11**********************@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 li*********@sap.com
SAP LABS CHINA : INNOVATE THE FUTURE
"Liang Zhang" <li*********@sap.com> wrote in message
news:e2**********@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 li*********@sap.com
>
> SAP LABS CHINA : INNOVATE THE FUTURE
> | |
|
P: n/a
|
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 | |
|
P: n/a
|
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 li*********@sap.com
SAP LABS CHINA : INNOVATE THE FUTURE
"Knut Stolze" <st****@de.ibm.com> wrote in message
news:e2**********@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 | |
|
P: n/a
|
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 | | This discussion thread is closed Replies have been disabled for this discussion. | |  Question stats - viewed: 1685
- replies: 6
- date asked: Apr 25 '06
|
