Table of Contents
- List of Tables
- Title and Copyright Information
- Preface
-
1
Introduction to Tools and Products that Support Migration
- Oracle Database Features for Migration Support
- Other Oracle Products that Enable Migration
- Migration Support for Other Database Vendors
- 2 SQL Translation Framework Overview
-
3
SQL Translation Framework Configuration
- Installing and Configuring SQL Translation Framework with Oracle SQL Developer
- Installing and Configuring SQL Translation Framework from Command Line
- Granting Necessary Permissions for Installing the SQL Translator
- 4 SQL Translation of JDBC and ODBC Applications
- 5 Example: Application Migration Using SQL Translation Framework
- 6 MySQL Client Library Driver for Oracle
-
7
API Reference for Oracle MySQL Client Library Driver
-
Mapping Data Types
- Mapping Oracle Data Types to MySQL Data Types
-
Data Type Conversions for MySQL Program Variable Data Types
- MYSQL_TYPE_BLOB
- MYSQL_TYPE_DATE
- MYSQL_TYPE_DATETIME
- MYSQL_TYPE_DOUBLE
- MYSQL_TYPE_FLOAT
- MYSQL_TYPE_LONG
- MYSQL_TYPE_LONG_BLOB
- MYSQL_TYPE_LONGLONG
- MYSQL_TYPE_MEDIUM_BLOB
- MYSQL_TYPE_NEWDECIMAL
- MYSQL_TYPE_SHORT
- MYSQL_TYPE_STRING
- MYSQL_TYPE_TIME
- MYSQL_TYPE_TIMESTAMP
- MYSQL_TYPE_TINY
- MYSQL_TYPE_TINY_BLOB
- MYSQL_TYPE_VAR_STRING
- Data Type Conversions for MySQL External Data Types (LOB Data Type Descriptors)
- Data Type Conversions for Datetime and Interval Data Types
- Error Handling
-
Available Oracle Support for MySQL APIs
- my_init()
- mysql_affected_rows()
- mysql_autocommit()
- mysql_change_user()
- mysql_character_set_name()
- mysql_close()
- mysql_commit()
- mysql_connect()
- mysql_create_db()
- mysql_data_seek()
- mysql_debug()
- mysql_debug_info()
- mysql_drop_db()
- mysql_dump_debug_info()
- mysql_eof()
- mysql_errno()
- mysql_error()
- mysql_escape_string()
- mysql_fetch_field()
- mysql_fetch_field_direct()
- mysql_fetch_fields()
- mysql_fetch_lengths()
- mysql_fetch_row()
- mysql_field_count()
- mysql_field_seek()
- mysql_field_tell()
- mysql_free_result()
- mysql_get_character_set_info()
- mysql_get_client_info()
- mysql_get_client_version()
- mysql_get_host_info()
- mysql_get_proto_info()
- mysql_get_server_info()
- mysql_get_server_version()
- mysql_get_ssl_cipher()
- mysql_hex_string()
- mysql_info()
- mysql_init()
- mysql_insert_id()
- mysql_kill()
- mysql_library_end()
- mysql_library_init()
- mysql_list_dbs()
- mysql_list_fields()
- mysql_list_processes()
- mysql_list_tables()
- mysql_more_results()
- mysql_next_result()
- mysql_num_fields()
- mysql_num_rows()
- mysql_options()
- mysql_ping()
- mysql_query()
- mysql_read_query_result()
- mysql_real_connect()
- mysql_real_escape_string()
- mysql_real_query()
- mysql_refresh()
- mysql_reload()
- mysql_rollback()
- mysql_row_seek()
- mysql_row_tell()
- mysql_select_db()
- mysql_send_query()
- mysql_server_end()
- mysql_server_init()
- mysql_set_character_set()
- mysql_set_local_infile_default()
- mysql_set_local_infile_handler()
- mysql_set_server_option()
- mysql_shutdown()
- mysql_sqlstate()
- mysql_ssl_set()
- mysql_stat()
- mysql_stmt_affected_rows()
- mysql_stmt_attr_get()
- mysql_stmt_attr_set()
- mysql_stmt_bind_param()
- mysql_stmt_bind_result()
- mysql_stmt_close()
- mysql_stmt_data_seek()
- mysql_stmt_errno()
- mysql_stmt_error()
- mysql_stmt_execute()
- mysql_stmt_fetch()
- mysql_stmt_fetch_column()
- mysql_stmt_field_count()
- mysql_stmt_free_result()
- mysql_stmt_init()
- mysql_stmt_insert_id()
- mysql_stmt_next_result()
- mysql_stmt_num_rows()
- mysql_stmt_param_count()
- mysql_stmt_param_metadata()
- mysql_stmt_prepare()
- mysql_stmt_reset()
- mysql_stmt_result_metadata()
- mysql_stmt_row_seek()
- mysql_stmt_row_tell()
- mysql_stmt_send_long_data()
- mysql_stmt_sqlstate()
- mysql_stmt_store_result()
- mysql_store_result()
- mysql_thread_end()
- mysql_thread_id()
- mysql_thread_init()
- mysql_thread_safe()
- mysql_use_result()
- mysql_warning_count()
-
Mapping Data Types
- 8 API Reference for SQL Translation of JDBC Applications
- Glossary
- Index