In this article Barry Mavin, CEO and Chief Software Architect for Recital, details on how to use the Client Drivers provided with the Recital Database Server to work with local or remote server-side JDBC data sources.

Overview

The Recital Universal .NET Data Provider provides connectivity to the Recital Database Server running on any supported platform (Windows, Linux, Unix, OpenVMS) using the RecitalConnection object.

The Recital Universal JDBC Driver provides the same functionality for java applications.

The Recital Universal ODBC Driver provides the same functionality for applications that use ODBC.

Each of the above Client Drivers use a connection string to describe connections parameters.

The basic format of a connection string consists of a series of keyword/value pairs separated by semicolons. The equals sign (=) connects each keyword and its value.

The following table lists the valid names for keyword/values.

To connect to a server-side JDBC data source, you ue the gateway=value key/value pair in the following way.

gateway=jdbc:jdbc_driver_path_on_server;jdbc:Recital:args

You can find examples of connection strings for most ODBC and OLE DB data sources by clicking here.

Example in C# using the Recital Universal .NET Data Provider:

////////////////////////////////////////////////////////////////////////
// include the references below
using System.Data;
using Recital.Data;

////////////////////////////////////////////////////////////////////////
// The following code example creates an instance of a DataAdapter that 
// uses a Connection to the Recital Database Server, and a gateway to
// Recital Southwind database. It then populates a DataTable 
// in a DataSet with the list of customers via the JDBC driver. 
// The SQL statement and Connection arguments passed to the DataAdapter 
// constructor are used to create the SelectCommand property of the
// DataAdapter.
public DataSet SelectCustomers()
{
	string gateway = "jdbc:/usr/java/lib/RecitalJDBC/Recital/sql/RecitalDriver;"+
			"jdbc:Recital:Data Source=localhost;database=southwind";       
	RecitalConnection swindConn = new
			RecitalConnection("Data Source=localhost;gateway=\""+gateway+"\");
	RecitalCommand selectCMD = new
			RecitalCommand("SELECT CustomerID, CompanyName FROM Customers", swindConn);
	selectCMD.CommandTimeout = 30;
	RecitalDataAdapter custDA = new RecitalDataAdapter();    
	custDA.SelectCommand = selectCMD;    
	swindConn.Open();    
	DataSet custDS = new DataSet();
	custDA.Fill(custDS, "Customers");    
	swindConn.Close();
	return custDS;
}

Example in Java using the Recital Universal JDBC Driver:

////////////////////////////////////////////////////////////////////////
// standard imports required by the JDBC driver
import java.sql.*;
import java.io.*;
import java.net.URL;
import java.math.BigDecimal;
import Recital.sql.*;

////////////////////////////////////////////////////////////////////////
// The following code example creates a Connection to the Recital 
// Database Server, and a gateway to the Recital Southwind database. 
// It then retrieves all the customers via the JDBC driver.
public void SelectCustomers()
{
    // setup the Connection URL for JDBC
    String gateway = "jdbc:/usr/java/lib/RecitalJDBC/Recital/sql/RecitalDriver;"+
			"jdbc:Recital:Data Source=localhost;database=southwind";       
    String url = "jdbc:Recital:Data Source=localhost;gateway=\""+gateway+"\";

    // load the Recital Universal JDBC Driver
    new RecitalDriver();

    // create the connection
    Connection con = DriverManager.getConnection(url);

    // create the statement
    Statement stmt = con.createStatement();

    // perform the SQL query
    ResultSet rs = stmt.executeQuery("SELECT CustomerID, CompanyName FROM Customers");

    // fetch the data
    while (rs.next()) 
    {
        String CompanyID = rs.getString("CustomerID");
        String CompanyName = rs.getString("CompanyName");
        // do something with the data...
    }
    
    // Release the statement
    stmt.close();

    // Disconnect from the server
    con.close();
}

1. New MD5( expC ) function to calculate an MD5 crypto key from any character expression
2. New MD5FILE( expC ) function calculates an MD5 crypto key for a given filename. If the filename is a pattern e.g *.* it will calculate the key across all files matching the pattern
3. New mod_recital.so available for using Recital Web on linux x86_32
4. New mod_recital64.so available for using Recital Web on linux x86_64 

DB_SAMBA=YES ;export DB_SAMBA 

preserve case = no 
default case = lower 
mangle case = yes 

oplocks = False 
share modes = no

Recital 10 Express Edition Linux x86 Free Download.

	Recital 10 A powerful scripting language with an embedded database used for developing desktop database applications on Linux and Unix. Recital has a high degree of compatibility with Microsoft FoxPRO enhanced with many additional enterprise class extensions.		Recital 10 Web A server-side scripting language with an embedded database for creating web 2.0 applications. Includes plugins for apache and IIS. Coming soon! Recital Web Framework, a comprehensive OO framework built on YUI for building RIA (Rich Internet Applications) in Recital Web.
	Recital 10 Server A cross-platform SQL database and application server which includes client drivers for ODBC, JDBC and .NET enabling Recital data to be accessed client/server from Windows, Linux and Mac.		Recital 10 Replication A comprehensive replication product that addresses urgent data movement and synchronization needs to help support disaster recovery and business continuity for Recital applications.

Graphical Installation

Note: The installation must be run as root. For systems with a hidden root account, please use ’Run as Root’.

1. Download the distribution file into a temporary directory
2. Check that the distribution file has the execute permission set
3. Run the distribution file
4. Follow the on screen instructions:
   1. License agreement
   2. Select components
   3. Installation directory and shortcuts
   4. Linking to /usr/bin
   5. ODBC Installation type (Recital Server / Recital Client Drivers)
   6. Java Virtual Machine selection (Recital Server / Recital Client Drivers)
   7. TomCat Installation type (Recital Server / Recital Client Drivers)
   8. Apache Firecat Plugin Installation (Recital Web Developer)
   9. Replication Service Type (Recital Replication Server)
   10. Install license file

Text Installation

Note: The installation must be run as root. For systems with a hidden root account, please precede commands with ’sudo’.

1. Download the distribution file into a temporary directory
2. Check that the distribution file has the execute permission set
3. Run the distribution file
4. Follow the on screen instructions:
   1. License agreement
   2. Select components
   3. Installation directory and shortcuts
   4. Linking to /usr/bin
   5. ODBC Installation type (Recital Server / Recital Client Drivers)
   6. Java Virtual Machine selection (Recital Server / Recital Client Drivers)
   7. TomCat Installation type (Recital Server / Recital Client Drivers)
   8. Apache Firecat Plugin Installation (Recital Web Developer)
   9. Replication Service Type (Recital Replication Server)
   10. Install license file