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 6 1913
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*********@sa p.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(versi on 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
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(I NTEGER)
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*********@sa p.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(versi on 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
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.goo glegroups.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(I NTEGER)
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*********@sa p.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(versi on 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 >
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.ROUTINE S.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 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.ROUTINE S.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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Brian Patterson |
last post by:
I have noticed in the book of words that hasattr works by calling getattr
and raising an exception if no such attribute exists. If I need the value
in any case, am I better off using getattr within a try statement myself, or
is there some clever implementation enhancement which makes this a bad idea?
i.e. should I prefer:
if hasattr(self,"datum"):
datum=getattr("datum")
else:
datum=None
|
by: Fred |
last post by:
Has anyone a link or any information comparing c and c++ as far as
execution speed is concerned?
Signal Processing algorithms would be welcome...
Thanks
Fred
|
by: serge |
last post by:
I have an SP that is big, huge, 700-800 lines.
I am not an expert but I need to figure out every possible way that
I can improve the performance speed of this SP.
In the next couple of weeks I will work on preparing SQL statements
that will create the tables, insert sample record and run the SP.
I would hope people will look at my SP and give me any hints on how
I can better write the SP.
|
by: teedilo |
last post by:
We have an application with a SQL Server 2000 back end that is fairly
database intensive -- lots of fairly frequent queries, inserts, updates
-- the gamut. The application does not make use of performance hogs
like cursors, but I know there are lots of ways the application could
be made more efficient database-wise. The server code is running VB6
of all things, using COM+ database interfaces. There are some
clustered and non-clustered...
|
by: Scott |
last post by:
I have a customer that had developed an Access97 application to track
their business information. The application grew significantly and
they used the Upsizing Wizard to move the tables to SQL 2000. Of
course there were no modifications made to the queries and they
noticed significant performance issues. They recently upgraded the
application to Access XP expecting the newer version to provide
performance benefits and now queries take...
| |
by: Mark Shelor |
last post by:
I've encountered a troublesome inconsistency in the C-language Perl
extension I've written for CPAN (Digest::SHA). The problem involves the
use of a static array within a performance-critical transform function.
When compiling under gcc on my big-endian PowerPC (Mac OS X),
declaring this array as "static" DECREASES the transform throughput by
around 5%. However, declaring it as "static" on gcc/Linux/Intel
INCREASES the throughput by...
|
by: bjarne |
last post by:
Willy Denoyette wrote;
> ... it
> was not the intention of StrousTrup to the achieve the level of efficiency
> of C when he invented C++, ...
Ahmmm. It was my aim to match the performance of C and I achieved that
aim very early on. See, for example "The Design and Evolution of C++".
-- Bjarne Stroustrup; http://www.research.att.com/~bs
|
by: Bern McCarty |
last post by:
I have run an experiment to try to learn some things about floating point
performance in managed C++. I am using Visual Studio
2003. I was hoping to get a feel for whether or not it would make sense to
punch out from managed code to native code (I was using
IJW) in order to do some amount of floating point work and, if so, what that
certain amount of floating point work was
approximately.
To attempt to do this I made a program that...
|
by: Michael D. Ober |
last post by:
When calling Enqueue, the internal array may need to be reallocated. My
question is by how much? In the old MFC array classes, you could tell MFC
how many additional elements to add to the array when it needed to
reallocate, which greatly boosted performance relative to adding 1 element
at a time.
Thanks,
Mike Ober.
|
by: jvn |
last post by:
I am experiencing a particular problem with performance counters.
I have created a set of classes, that uses
System.Diagnostics.PerformanceCounter to increment custom performance
counters (using .Net 2.0)
The performance counter categories have been successfully created.
When the set of classes are used by a WinForm test harness application,
they function as expected, and the performance counters can be seen to
be updated by using the...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |