Filter
Top Products
Chapter 3: Notes on Interstage Operation
3-20
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)