[Sqlrelay-discussion] SQL Relay 0.42 is out

[David M. <dav...@fi...>]

Hello all,

SQL Relay 0.42 is out (finally).  This is mainly a bug-fix, stability 
and compatibility release.

Highlights include:
* Java api should work on 64-bit machines now
* Updated configure script to detect modern versions of db's and languages
* Oracle CLOB fixes
* Oracle cursor bind fixes
* A fix for the bug that caused address="" in the config file to prevent 
the listener from starting.
* The maxsessioncount parameter defaults to 0 (disabled) now.
* Many, many fixes for obscure bugs, race conditions, memory leaks and 
other stability-related issues

Thanks to everyone who contacted me about issues or submitted patches 
that went into this release.  There were quite a few.  Big thanks go out 
to Renat Sabitov for submitting a dozen or more patches and doing lots 
of testing.

A new release of rudiments, which SQL Relay depends on is out too.  A 
bunch of bugs were fixed in it as well, some of which were the ultimate 
cause of some SQL Relay bugs.

Grab them both at http://sqlrelay.sourceforge.net and 
http://rudiments.sourceforge.net

As always, report any issues you run into.

David Muse
dav...@fi...


The complete changelog for this release follows:

0.42 - fixed a bug causing cursor id's not to get set for some db's
     updated configure script to look for client64 in addition to client
         for oracle intantclient on x86_64
     added setTimeout to all API's
     applied some patches from Alexey Leontev
     bumped BINDVARLENGTH up to 64
     applied Renat Sabitov's scaler -debug patch and 11g configure patch
     applied Stephan van Egmond's sqlrsh history patch
     added configure test for gmake, use it to find ruby.h
     applied mi...@ta...'s scaler patch for -debug
     added getting started notes for Oracle 11.2 on Fedora Core 12
     added test for mdb_sql_run_query and code to use it if it's there
     fixed a bug that caused ping to fail after reconnecting to sybase
     added configure test for xsubpp
     fixed perl dbi inout bind problem
     fixed code that was adding a NULL terminator to oracle clob values
     applied several patches from Renat Sabitov
     applied dynamic cursor patch from Cal Heldenbrand
     applied Claudio Freire's normalized matching and xmlparsing patches
     fixed sqlite connection to use sqlite3_malloc/free
     update freetds connection to get tds version with ct_config if
         TDS_VERSION_NO doesn't exist
     applied a fix for a bug that could cause a crash when a cursor is
         reused
     fixed a shutdown race condition in connection daemons
     moved common startup/shutdown code for connection daemons up into
         static methods/variables of the sqlrconnection_svr class
     fixed a crash in the oracle connection daemon where OCIHandleFree
         was getting called on define handles that weren't created by
         OCIHandleAlloc
     removed rebuild target from Makefiles
     updated tests
     refactored main() method for connections
     added searches for ruby1.8, ruby19 and ruby1.9 in configure script
     fixed a bug that caused addresses="" to cause the sqlr-listener not to
         start
     added entries to FAQ about oracle instantclient and ubunu /bin/dash
     updated postgresql tests to use bpchar rather than char(20) for
         fetching results of stored procedure
     renamed interbase.create.sh to firebird.create.sh
     fixed a bug that could overrun the postgresql bind array
     fixed bug that caused connection daemon sockets to be double-freed on
         shutdown after a suspended session
     precision/scale in output bind buffers is initialized now
     debugstring buffers are no longer build when debug is turned off
     fixed id vs. index bug when requesting a cursor and binding a cursor
     refactored JNI code a bit, fixed getIntField/getLongField problem that
         caused problems on 64-bit machines
     applied patch to make python api return decimals and integers, not
         just strings, refactored some of it
     fixed dump tran docs in getting started with sybase to use sa
     updated sybase connection to use length of cursor name rather than
         CS_NULLTERM to work around an odd, inconsistent bug that would
         cause the connection to hang sometimes
     connections not spawned by scaler don't signal on the semaphore used
         by the scaler to wait for a connection to start now
     updated bind var docs
     updated faq
     fixed a bug where binding an oracle cursor didn't reset some values
         and would cause subsequent cursor binds to fail
     added note to docs about configuring sybase to dump transactions at
         each checkpoint
     applied Renat Sabitov's patch to kill scaler-started connections which
         fail to signal on sem(8) because they either crashed or got
         hung up trying to start
     fixed a bug in the mysql drop-in lib that could cause the client to
         run out of cursors
     added a mapping between sqlite3_free and sqlite_freemem
     added a fix for a race condition in the scaler
     fixed a postgresql bind memory leak
     applied Renat's ruby DESTDIR patch and updated helper scripts to
         remove $(DESTDIR) from all the variables that it outputs
     applied Renat's patch to handle semaphore failures in forked listeners
         during shutdown
     applied Renat's patch to move connection counting for scaler-spawned
         connections entirely into scaler itself
     applied Renat's patch to reap children more regularly and refactored
         it a little
     fixed distclean to remove perl .pm files
     changed maxsessioncount default to 0, updated docs, examples


_______________________________________________________
Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
              http://www.doteasy.com