Chapter 3: Notes on Interstage Operation

3) Stored Procedure

A stored procedure cannot be used.

4) API when datetime Type is Used

When the following API is used for the datetime type, only the values within the smalltime type are valid.

PreparedStatement.setTimestamp(int parameterIndex, Timestamp x)

5)Unsupported API

Among the JDBC API standard specifications, the following APIs are not supported.

Connection class

nativeSQL(String sql)

setCatalog(String catalog)

getCatalog()

DatabaseMetaData class

getCatalogTerm()

isCatalogAtStart()

supportsCatalogsInProcedureCalls()

supportsCatalogsInTableDefinitions()

getMaxCatalogNameLength()

getCatalogSeparator()

supportsCatalogsInDataManipulation()

supportsCatalogsInIndexDefinitions()

supportsCatalogsInPrivilegeDefinitions()

getTableTypes()

getCatalogs()

getColumnPrivileges(String catalog, String schema, String table,String columnNamePattern)

getVersionColumns(String catalog, String schema, String table)

getCrossReference(String primaryCatalog, String primarySchema,String primaryTable, String foreignCatalog,String foreignSchema, String foreignTable)

getTablePrivileges(String catalog, String schemaPattern,String tableNamePattern)

getBestRowIdentifier(String catalog, String schema,String table, int scope, boolean nullable)

getImportedKeys(String catalog, String schema, String table)

getExportedKeys(String catalog, String schema, String table)

PreparedStatement class

setBoolean(int parameterIndex, boolean x)

setByte(int parameterIndex, byte x)

3-20

Page 72
Image 72
Fujitsu V6.0 manual Stored Procedure, API when datetime Type is Used, Unsupported API