1.1.1

Persist Table Data to a Disk Store...............................................................................................................86
Optimizing Availability and Performance.....................................................................................................87
Starting System with Disk Stores................................................................................................................87
Disk Store Management.............................................................................................................................90
Chapter 15: Exporting and Importing Data with vFabric SQLFire.......99
Using SQLF Commands to Export and Import Data..................................................................................99
Using Apache DdlUtils to Import Data......................................................................................................101
Exporting and Importing Data from Text Files...........................................................................................104
Chapter 16:Using Table Functions to Import Data as a SQLFire Tables.107
Overview of SQLFire Table Functions.......................................................................................................107
Example Table Function............................................................................................................................109
Part III: Developing Applications with SQLFire....................................111
Chapter 17:Starting SQLFire Servers with the FabricServer Interface.113
Starting a Network Server........................................................................................................................114
Chapter 18: Developing Java Clients and Peers..................................117
Connect to a SQLFire Server with the Thin Client JDBC Driver...............................................................117
Start a SQLFire Peer with the Peer Client JDBC Driver...........................................................................120
Chapter 19: Configuring SQLFire as a JDBC Datasource..................123
Using SQLFire with Hibernate..................................................................................................................112
Chapter 20: Storing and Loading JAR Files in SQLFire......................125
Class Loading Overview...........................................................................................................................125
Alternate Methods for Managing JAR Files..............................................................................................127
Chapter 21: Developing ADO.NET Client Applications.......................131
About the ADO.NET Driver.......................................................................................................................131
ADO.NET Driver Classes..........................................................................................................................132
Installing and Using the ADO.NET driver..................................................................................................133
Connecting to SQLFire with the ADO.NET Driver....................................................................................134
Managing Connections.............................................................................................................................134
Executing SQL Commands.......................................................................................................................135
Working with Result Sets..........................................................................................................................135
Storing a Table..........................................................................................................................................136
Storing Multiple Tables..............................................................................................................................137
Specifying Command Parameters with SQLFParameter..........................................................................138
Updating Row Data...................................................................................................................................139
Adding Rows to a Table............................................................................................................................140
Managing SQLFire Transactions...............................................................................................................141
Performing Batch Updates........................................................................................................................142
v
Contents