Communicator e3000 MPE/iX Release 6.0 Express 1 (C.60.01) (30216-90286)

44 Chapter3

Technical Articles

HP Driver for JDBC

Stored Procedures

The HP Driver for JDBC supports the following types of ALLBASE/SQL stored procedures

through the java.sql.CallableStatement interface:

1. Procedures that return one or more result sets.

2. Procedures that take one or more input arguments.

3. Procedures that return one or more output arguments.

4. Procedures that have a return status value.

Troubleshooting

Client Tracing

Tracing of the HP Driver for JDBC client class ﬁles is invoked by adding tracing

commands to the connection URL. The connection URL can be altered to both invoke

tracing and to control the type of information that is traced. The tracing information is

sent to a Java stream, which must be speciﬁed by the application using the

java.sql.DriverManager.setLogStream method.

Both the tracing level and tracing output must be speciﬁed before any tracing can be done.

Note that the use of tracing will impact performance of the application. The greater the

detail in the tracing, the slower the performance of the application.

The URL syntax to invoke tracing is:

“jdbc:allbase://server[:port]/database?TRACE=trace”

where

trace

is any vertical bar (|) separated combination of the values:

ARGUMENTS Trace HP Driver for JDBC class method arguments. Input

arguments and return values are all traced. Only the

methods called by the application are traced.

ARGUMENTS_ALL Trace all HP Driver for JDBC class methods that are

called by both the application and the driver itself.

TIME Include the time in HHMMSSFFF format on all tracing

output lines where HH is the hour from 00 to 23, MM is the

minute from 00 to 59, SS is the second from 00 to 59, and

FFF is the millisecond from 000 to 999. The information

appears in the third column of the tracing output.

DATE Include the date in YYYYMMDD format on all tracing output

lines where YYYY is the year from 0000 to 9999, MM is the

month from 01 to 12, DD is the day of the month from 00 to

31. This information appears in the second column of the

tracing output.

TIMESTAMP Include both the date and the time on all tracing output

lines. This is just a combination of the DATE and TIME

tracing values.