<div>
Is your DB2 database running &quot;embedded&quot; within the rest of your Java code, or is it a client/server model? (Even if the client code and database server is on the same machine, if they are separate processes, this is still client/server.
</div>


Is your DB2 database running "embedded" within the rest of your Java code, or is it a client/server model? (Even if the client code and database server is on the same machine, if they are separate processes, this is still client/server.

<div>
No, DB2 database server is is not embedded - it is &nbsp;standalone to the full extent of client server architecture (yes I know what is client/server architecture, thank you :) , complete setup is complex - multiple app servers, multiple db servers, load balancers etc)
</div>


No, DB2 database server is is not embedded - it is  standalone to the full extent of client server architecture (yes I know what is client/server architecture, thank you :) , complete setup is complex - multiple app servers, multiple db servers, load balancers etc)

<div>
<div class="content wysiwyg-content">
I am debugging some legacy java code which is using a lot of stored procedures. All of them are in source code and in DB2. When I debug code occasionally I run into situation that some stored procedure is called but I don't know from where or which procedure. Stepping into [with F5] would be too tedious to find exact place where procedure is called.<br />
<br />
What I would like is that eclipse opens that specific stored procedure or at least to know which procedure is called. How can I do that?<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/06_w23/916666/Pic01.PNG" target="_blank" title="pic 01 (20 KB)"><img alt="pic 01" class="file-block lazyload" style="max-width: 340px;" data-src="https://filedb.experts-exchange.com/incoming/2015/06_w23/916666/Pic01.PNG" /></a><br />
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2015/06_w23/916668/Pic02.PNG" target="_blank" title="Pic 02 (88 KB)"><img alt="Pic 02" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2015/06_w23/800_916668/Pic02.PNG" /></a>
</div>
</div>


Pic02.PNG

Pic01.PNG

I am debugging some legacy java code which is using a lot of stored procedures. All of them are in source code and in DB2. When I debug code occasionally I run into situation that some stored procedure is called but I don't know from where or which procedure. Stepping into [with F5] would be too tedious to find exact place where procedure is called.

What I would like is that eclipse opens that specific stored procedure or at least to know which procedure is called. How can I do that?



 

eclipse find/step into stored procedure

Development in most programming languages is frequently done with an editor or integrated development environment (IDE). An IDE is a software application that provide comprehensive facilities to computer programmers for software development. An IDE normally consists of a source code editor, build automation tools and a debugger. XCode, Visual Studio, Adobe Dreamweaver and Eclipse are some of the more popular development tools, but an editor or IDE can be anything from simple text editors to sophisticated programs. Related topics: All programming and development language, database and web based content management systems topics

Editors IDEs

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.

Java

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.