Can I Use Jaxer with ODBC Drivers?

Yes, you can use Jaxer to access datasources accessible though ODBC

The sample code below demonstrates how to use the mozilla native database support to access an ODBC driver. The code is setup to access a preconfigured DSN ('SQLEXPRESS') and run a query against a table named 'jaxer'. Example results are shown after the code

Included in the comments of the code are links to external documents containing documentation or further examples for the Mozilla native database support.

This sample code is only supported with Jaxer build 2109 or later. you can download the latest version here

var log = Jaxer.Log.forModule("odbc");

/*
 * Utility function for padding text
 */
function rightPad(str, width)
{
    var s = str.toString();
    return (s.length < width) ? (s + (new Array(width - s.length)).join(" ")) : s.substring(0, width - 1);
}

/*
 * create instance of mozilla SqlConnectionODBC (mozISqlConnection)
 * http://lxr.mozilla.org/mozilla1.8/source/extensions/sql/base/public/mozISqlConnection.idl 
 */
var SqlConnectionODBC = Components.Constructor("@mozilla.org/sql/connection;1?type=odbc", "mozISqlConnection", "init");

/*
 * DSN previously configured in Windows.
 * 
 * ODBC drivers for linux are available 
 * http://www.unixodbc.org/
 * http://www.iodbc.org/
 * 
 * ODBC is even found on MACs - who knew!
 * http://www.stata.com/support/faqs/data/odbcmu.html
 */
var DSN = "SQLEXPRESS";		
var conn = new SqlConnectionODBC("", 0, DSN, "", "");

/*
 * get results (mozISqlResult)
 * http://lxr.mozilla.org/mozilla1.8/source/extensions/sql/base/public/mozISqlResult.idl
 * http://lxr.mozilla.org/mozilla1.8/source/extensions/sql/base/public/mozISqlResultEnumerator.idl
 */
var results = conn.executeQuery("SELECT * FROM jaxer;");

var sep = "------------------------------------------------------";
log.info(sep);

var column_count = results.columnCount;
var have_more_data = results.rowCount > 0;
var set = results.enumerate();

// process column names
colHeader = [];
for (var c = 0; c < column_count; c++) 
{
    colHeader.push(rightPad(results.getColumnName(c),40));
}
log.info(colHeader.join(" | "));

log.info(sep);

// process row data
while (have_more_data) 
{
    have_more_data = set.next();
    
    var cols = [];
    
    for (var i = 0; i < column_count; i++) 
    {
        cols.push(rightPad(set.getVariant(i),40));
    }
    log.info((cols.join(" | ")));
}

log.info(sep);
	
/*
 * Further reading...
 * http://xulblog.de/xul/archives/19-SQL-Console-in-Mozilla.html
 * http://eu.mozdev.org/Brussels2003/talks/jan/index.html
 */

When this code is run the output is logged to the Jaxer log file. It should look something like this.

00:01:48 02/13/2008 [  2204] [INFO] [JS Framework] [odbc.] ------------------------------------------------------
00:01:48 02/13/2008 [  2204] [INFO] [JS Framework] [odbc.] comment                                 | tags                                   
00:01:48 02/13/2008 [  2204] [INFO] [JS Framework] [odbc.] ------------------------------------------------------
00:01:48 02/13/2008 [  2204] [INFO] [JS Framework] [odbc.] Jaxer Baby!                             | groovey                                
00:01:48 02/13/2008 [  2204] [INFO] [JS Framework] [odbc.] No Sleep til Jaxer                      | beastie                                
00:01:48 02/13/2008 [  2204] [INFO] [JS Framework] [odbc.] It's Jaxtastic!                         | plastic                                
00:01:48 02/13/2008 [  2204] [INFO] [JS Framework] [odbc.] ------------------------------------------------------

Can I Use Jaxer with ODBC Drivers?

Site Navigation