Adding Databases and Application Servers to your Developer Studio Environment

Adding Databases and Application Servers to your Developer Studio Environment


distributed application it is a best
practice to a database and an application server to your development
environment our application requires a database and we see here that the
customer business entity class requires the customer table in the database this
code will not compile without errors unless the project has a connection to
the database first let’s focus on ending database typically you make a copy of
the databases that changes you make to it during development will not affect
other developers to get started we renfro Eng which opens a window in the
open network directory as you can see open network contains files related to
open image server processes wespro db2 copy database into this folder in this
case we copy the sample database seconds of the opening-day named Sports 2000
because we want multiple connections to this database we must start it as a
database server process to do this we use the pro surf command where we
specify the name of the database in the port number the database server will
remain running until the system shuts down or you stopped using the pros shut
utility now that we have a database server running we can connect to it from
the server project her workspace to do this we can trigger the database
connection as a workspace preference to begin we open the wizard for configuring
a new database connection we name the connection and select the database we must specify the hostname of local
host and the same port number there was used to start the database server a best
practice is to test the connection testing the connection requires an AVM
we select a project and then click OK to run the test once the connection test
succeeds we continuously configuration in SQL connection is required by
Developer Studio to run some of the utility plugins associated with
accessing a database so we must also configure in a secure connection in the
wizard we accept the defaults we test the SqlConnection on the last
green of the database connection wizard notice that the box is checked out of
start the database server you should leave this box check so that when
Developer Studio starts it will automatically start the database server
for you as you can see the sports 2000 database connection is to find for the
workspace we need to associate the database connection with our server
project next we must recompile our application codes of the database tables
used for the server code are recognized as you can see database table names and
shields are now displayed in orange next let’s add an application server toward
development environment classic observer so we can make use of
its debugging capabilities first we must ensure that we have a connection to the
admin server we open the workspace preference area and navigate to the
server carrier for open inch Explorer here we see the connection to the admin
server for opening Explorer if we click Test Connection and the test fails then
we must enter the correct admin password and retest now our connection is
successful silly click create servers and finish and then click
OK we are now ready to Manager server process seized from Developer Studio to
make sure servers you appear we selected in her current perspective to view the
server processes if they are not visible you must select the servers view the
servers few shows the open edge server processes available in turn development
environment we will use to classic app server named a/s broker one as our
application server double-click the server to open the server editor we want
to configure have this application server starts and where it will find our
server code we click open launch configuration first in the Startup tab
application server will log its messages best practices to see open edge work
directory next we had the server project directories to the Pro pass for the
application server finally we want the application server
to open a connection to the database server so we select our already
configured database connection we save our runtime configuration and start the
application server we wait a moment for the server to start now let’s test the application we see
that it successfully retrieves the data from the database using the application
server we have no showing how to add an open-ended database and application
server to development environment to learn about developing open a JBL
applications take the course developing a program open a JBL application

Danny Hutson

Leave a Reply

Your email address will not be published. Required fields are marked *