| ## picoJDBC - picoSQL JDBC support | Corso Italia, 178 - 56125 Pisa Telefono/fax 050 46380 e-mail picosoft@picosoft.it

picoJDBC is a JDBC 1.4 compliant driver for picoSQL. It is a type 4 driver (thin client), written in pure Java, who accesses picoSQL using a socket connection. The communication protocol is IIOP 1.0 which is implemented by the org.omg.CORBA package. picoJDBC consists in a JAR file that must be included in CLASSPATH. Current release is compiled using the j2sdk1.4.0, but the driver has been teste with all the releases, starting from jdk1.2.

The driver class to load is:

    IT.picosoft.jdbc.PicoDriver

The url to specify for opening a connection is a string divided in five fields by a semicolon (:) character. A valid URL, for example, is the following:

    jdbc:picoDB:localhost:6789:default

The first two fields are fixed.
Third field locate the host computer where picoSQL resides.
Fourth field locate the port number where picoSQL is listening.
Last field locate the server database name.