Examples in the basic directory

The following table lists the files in the basic directory.

Demo program name Description
autofree.java Shows how to use the IFX_AUTOFREE environment variable
BatchUpdate.java Shows how to send batch updates to the server
ByteType.java Shows how to insert into and select from a table that contains a column of data type BYTE
CallOut1.java Executes a C function that has an OUT parameter using CallableStatement methods
CallOut2.java Executes an SPL function that has an OUT parameter using CallableStatement methods
CallOut3.java Executes a C function that has a Boolean OUT parameter using the IfmxCallableStatement.IfxRegisterOut Parameter() method
CallOut4.java Executes a C function that has a CLOB type OUT parameter and uses the IfmxCallableStatement.hasOutParameter() method
CreateDB.java Creates a database called testDB
DBCENTURYSelect.java Uses the getString() method to retrieve a date string representation in which the four-digit year expansion is based on the DBCENTURY property value
DBCENTURYSelect2.java Retrieves a date string representation in which the four-digit year expansion is based on the DBCENTURY property value using string-to-binary conversion

Uses the getDate() method to build a java.sql.Date object upon which the date string representation is based
DBCENTURYSelect3.java Retrieves a date string representation in which the four-digit year expansion is based on the DBCENTURY property value using string-to-binary conversion

Uses the getTimestamp() method to build a java.sql.Timestamp object upon which the date string representation is based
DBCENTURYSelect4.java Retrieves a date string representation in which the four-digit year expansion is based on the DBCENTURY property value using binary-to-string conversion

Uses the getDate() method to build a java.sql.Date object upon which the date string representation is based
DBCENTURYSelect5.java Retrieves a date string representation in which the four-digit year expansion is based on the DBCENTURY property value using binary-to-string conversion

Uses the getTimestamp() method to build a java.sql.Timestamp object upon which the date string representation is based
DBConnection.java Creates connections to both a database and a database server
DBDATESelect.java Shows how to retrieve a date object and a date string representation from the database based on the DBDATE property value from the URL string
DBMetaData.java Shows how to retrieve information about a database with the DatabaseMetaData interface
DropDB.java Drops a database called testDB
ErrorHandling.java Shows how to retrieve RSAM error messages
GLDATESelect.java Shows how to retrieve a date object and a date string representation from the database based on the GL_DATE property value from the URL string
Intervaldemo.java Shows how to insert and select HCL OneDB™ interval data
LOCALESelect.java Shows how to retrieve a date object and a date string representation from the database based on the CLIENT_LOCALE property value from the URL string
locmsg.java Shows how to use HCL OneDB extension methods that support localized error messages
MultiRowCall.java Shows how to return multiple rows in a stored procedure call
OptimizedSelect.java Shows how to use the FET_BUF_SIZE environment variable to adjust the HCL OneDB JDBC Driver tuple buffer size
optofc.java Shows how to use the OPTOFC environment variable
PropertyConnection.java Shows how to specify connection environment variables via a property list
RSMetaData.java Shows how to retrieve information about a result set with the ResultSetMetaData interface
ScrollCursor.java Shows how to retrieve a result set with a scroll cursor
Serial.java Shows how to insert and select HCL OneDB SERIal and SERIal8 data
SimpleCall.java Shows how to call a stored procedure
SimpleConnection.java Shows how to connect to a database or database server
SimpleSelect.java Shows how to send a simple SELECT query to the database server
TextConv.java Shows how to convert a file from the client code set to Unicode and then from Unicode to the database code set
TextType.java Shows how to insert into and select from a table that contains a column of data type TEXT
UpdateCursor1.java Shows how to create an updatable scroll cursor using a ROWID column in the query
UpdateCursor2.java Shows how to create an updatable scroll cursor using a SERIAL column in the query
UpdateCursor3.java Shows how to create an updatable scroll cursor using a primary key column in the query