Testing JDBC Driver For PostgreSQL

Junzo SATO

University Of Kumamoto
jsato@fc.kuh.kumamoto-u.ac.jp

Nov 18th 2002
Nov 17th 2002

The following sample table customerlist, which is provided by a publisher's website, was installed in PostgreSQL. The simple SQL statement "select * from customerlist" was executed from a terminal. The result was shown on the display. In this notebook, JDBC connection to the PostgreSQL database was tested from the Mathematica.

[Graphics:Images/PQSQLJDBC_gr_1.gif]

InstallJava

JLink is loaded and installed.

Connection

Jar file of the PostgreSQL JDBC driver is available from http://jdbc.postgresql.org.
The class org.postgresql.Driver is loaded.

Connection to the PostgreSQL is established.

Some informations about the connection are received using accessors.

Simple SQL statement is created and executed.

The result table is converted to the Mathematica's list.

The list is shown in TableForm.

`1`	`デューク東郷`	`1`
`2`	`アーネスト東郷`	`2`
`3`	`アランサイジョー`	`4`
`4`	`ダグラストウゴウ`	`5`
`5`	`宗経民`	`6`
`6`	`周雷峰`	`1`
`7`	`トウゴウダイジロウ`	`3`
`8`	`田中`	`1`
`9`	`太田`	`2`
`10`	`伊集院`	`1`
`11`	`コサキン`	`2`

Connection is closed.

Uninstall

JLink is uninstalled.

Reference

[1] Windows Programming Club, "SQL 600 Tips", Gijutsu-hyoron-sya, 2002, ISBN4-7741-1611-4 C3055 (Japanese)

Converted by Mathematica November 17, 2002