Testing Using the memory IP Java Example

The following procedure uses a shell script on a 64-bit AIX machine.

1. Build the memory IP Java example:

   $ JRE=/usr/java/jre # set JRE to value used in installation

   $ alias javac=$JRE/../bin/javac

   $ javac -classpath ip/oajava/oasql.jar ip/oajava/*/*.java

2. Create a new data source by duplicating the DataSourceName service data source. Set Port to OpenAccessSDK900_Java and ServerDataSource to memory.

   $ vi $ODBCINI
   [MemoryJavaExample]
   Driver=/usr/oaodbclocal900/lib64/ivoal27.so
   Description=Memory Ip Java example
   Host=/usr/oaodbclocal900/cfg/oadm.ini
   Port=OpenAccessSDK900_Java
   ServerDataSource=memory
   CustomProperties=
   

3. If necessary, add platform-specific information (see Platform-specific Requirements).

   • Add the value of JRELIBPATH to library path or edit oalocal.sh.
   • On AIX 64-bit, add LDR_CNTRL=USERREGS.

4. Test the data source MemoryJavaExample using tools/odbcisql.

   $ tools/odbcisql

   ISQL> CONNECT pooh*bear@MemoryJavaExample

   ISQL> SELECT * FROM emp;

   ISQL> SELECT * FROM dept;

   ISQL> SELECT * FROM oa_tables;