JDBCdsOAS

Unofficial Content

How to define an Oracle JDBC datasource in Oracle Application Server 10g

There are two alternatives for connection pooling in GeneXus java web applications. One possibility is using the GeneXus connection pool, and the other one is using the server connection pool. In order to use the server connection pool, you have to define a JDBC datasource for the DBMS, in the application server.

In addition, there are three ways of defining an oracle JDBC datasource in the OAS 10g.
1. You can do it manually, by editing configuration files:

http://www.oracle.com/technology/tech/java/oc4j/1013/how_to/how-to-datasource/doc/how-to-datasource.html

2. Using the admin_client.jar Utility:
http://download-west.oracle.com/docs/cd/B31017_01/web.1013/b28951/adminclient.htm#CHDFDIFE

3. Using a graphical assistant provided by the Application Server Control. The Application Server Control is a web interfase for administering the OAS.

http://download-west.oracle.com/otndocs/tech/ias/portal/files/RG/OBE/deployj2ee/deployj2ee.htm#o

Next, we explain how we defined an oracle JDBC datasource by using the Oracle Application Server Control:

1.
Image13oas

2.
Image14oas

3.
Image15oas

4.
Image16oas

5.
Image17oas

6.
Image18oas

7.
Image19oas

8.
Image20oas

In GeneXus, you should set the following DBMS properties:
-Use JDBC datasource for web based applications
-JDBC datasource
See the following link for more information about these model properties:
http://www2.gxtechnical.com/portal/hgxpp001.aspx?15,4,61,O,S,0,,15514

Image21oas