Using Cache' Post RDBMS From Mathematica By Java Classes

Junzo SATO

June 7th 2001

Cache' Post RDBMS from InterSystems is an OODB. It possesses data and functions in classes. Because Cache' can export definitions of these classes in Java format, Mathematica is able to use Cache' by J/Link. In this document how to use Cache' database from Mathematica is demonstrated.

Configurations

Cache' database and J/Link library are installed on a remote Windows2000 computer. Mathematica with J/Link is installed on a local machine, which is opening this document.

Establishing J/Link Connection

On a remote computer, the following command should be evaluated.

java com.wolfram.jlink.Install -linkname 1192 -linkmode listen -linkprotocol tcp

The mathlink connection for J/Link is established.

NOTE:
Using two computers is not essential. If the user can install both Cache' and Mathematica in a single machine, simple evaluation
<<JLink`
lnk = InstallJava[ ]
is enough. However, the separation of MathKernel with Cache' server would be effective when the user's platform is not supported by Cache' or when the stability of the computation is required.

Establishing Cache' Connection

ObjectFactory is loaded.

NewObjectFactory[] establishes a connection to the specified namespace in Cache'.

In this example, connection to the namespace "ZIP" which is prepared in Cache' is established.

As the following output shows, the connection between J/Link and Cache' is 'local' inside the remote computer.

Connection -> cn_iptcp:127.0.0.1[1972]:ZIP

Cache' Version -> Cache for Windows NT (Intel) 4.0 (Build 135.1U su) Fri Dec 29 2000 15:45:52 EST

Server Version -> 4.0.0.381

Zip.ZipTable holds zip data and queries.

First record in the Zip.ZipTable is retrieved using an object id.

Fields of the obj are as follows.

Values of the first object are listed.

01101

060

0600000

北海道

以下に掲載がない場合

札幌市中央区

ﾎｯｶｲﾄﾞｳ

ｻｯﾎﾟﾛｼﾁｭｳｵｳｸ

ｲｶﾆｹｲｻｲｶﾞﾅｲﾊﾞｱｲ

0

Query_getTown(zip7)

Compiled query getTown(zip7) in Zip.ZipTable class is accessible from Mathematica. It takes one argument zip7, or zip code with seven digits, and returns corresponding area name.

Information about the result columns is retrieved.

`False`	`1`	`zip7`	`zip7`	`String`
`False`	`2`	`kanjiPref`	`kanjiPref`	`String`
`False`	`3`	`kanjiCity`	`kanjiCity`	`String`
`False`	`4`	`kanjiTown`	`kanjiTown`	`String`
`False`	`5`	`kanaPref`	`kanaPref`	`String`
`False`	`6`	`kanaCity`	`kanaCity`	`String`
`False`	`7`	`kanaTown`	`kanaTown`	`String`

Information about parameters of the query is retrieved.

1

paramZip7

String

Query is executed.

Result of the query is shown.

ResultSet is discarded.

Query_getZipCode(kanjiPref, kanjiCity)

The query method getZipCode(kanjiPref, kanjiCity) returns a list of zip7 and kanjiTown.

`False`	`1`	`zip7`	`zip7`	`String`
`False`	`2`	`kanjiTown`	`kanjiTown`	`String`

`1`	`paramKanjiPref`	`String`
`2`	`paramKanjiCity`	`String`

Dynamic SQL

Instead of generating precompiled queries in Cache' classes, it is possible to use a dynamic SQL command.

The ResultSet object is created.

Information about resulting columns is shown.

`True`	`1`	`ID`	`ID`	`int`
`False`	`2`	`zip7`	`zip7`	`String`
`False`	`3`	`kanjiPref`	`kanjiPref`	`String`
`False`	`4`	`kanjiCity`	`kanjiCity`	`String`
`False`	`5`	`kanjiTown`	`kanjiTown`	`String`