JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2.1

3 Accessing SQL Databases with SQL/MX
• “Communication Overview” (page 19)
• “Data Sources” (page 20)
“JDBC Data Source (client-side)” (page 20)◦
◦ “MXCS Data Source (server-side)” (page 20)
• “Security” (page 20)
• “Connecting to SQL/MX” (page 21)
• “Connecting with the DataSource Interface” (page 21)
“Overview of Deploying DataSource Objects” (page 21)◦
◦ “DataSource Object Properties” (page 22)
◦ “Programmatically Creating an Instance of the DataSource Class” (page 22)
◦ “Programmatically Registering the DataSource Object” (page 22)
◦ “Retrieving a DataSource Instance by using JNDI and to the Data Source” (page 23)
◦ “Specifying the Properties File that Configures the Data Source” (page 23)
• “Connecting using the DriverManager Class” (page 23)
“Loading and Registering the Driver” (page 24)◦
◦ “Establishing the Connection” (page 24)
◦ “Guidelines for connecting with the Driver Manager” (page 24)
• “Stored Procedures” (page 25)
• “Connection Pooling” (page 25)
• “Statement Pooling” (page 26)
“Guidelines for Statement Pooling” (page 26)◦
◦ “Troubleshooting Statement Pooling” (page 26)
• “Thread-safe SQL/MX Access” (page 27)
• “"Update ... Where Current of" Operations” (page 27)
• “Internationalization (I18N) Support” (page 28)
“String Literals Used in Applications” (page 28)◦
◦ “Controlling String Literal Conversion by Using the Character-Set Properties” (page 28)
◦ “Trimming Padding for Fixed-Length Character Columns” (page 30)
◦ “Localizing Error Messages and Status Messages” (page 31)
Communication Overview
The Type 4 driver is a three-layer program.
Communication Overview 19