Implements dynamic search_path management
attempt to add failing test
add failing test

fix typos
add get primary key helper

get non-standard primary keys
get failing test to pass
add logic to pull back primary key using table name via ActiveRecord
add rails 2 compatibility
Add support for template in PostgreSQLAdapter
Fetch a sequence value manually for tables with no identity columns

This is to support legacy tables for which the sequence needs to be
manually specified in ActiveRecord
Few more changes to get migrations to run

- translate double and bigint as native types
- silence the explain feature for now
- add runstats methods
- allow running structure_dump with a default schema
- the zos? condition was too generic, make it less so
- don't sub in sub-queries
Use DECIMAL(1) for boolean fields.

Using smallint is agressive, decimal(1) is a much reasonable option for boolean fields.
We needed this because we have many smallints in our database that are NOT booleans.
Support WITH statements in select

Without this, the adapter will try to execute WITH statements using executeUpdate
fix row_number errors on SQL Server 2000

SqlServer2000AddLimitOffset was calling the wrong version of ReplaceLimitOffset
mssql: Fix pessimistic locking

This fixes the error:

  ActiveRecord::StatementInvalid: ActiveRecord::JDBCError: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.

when executing code like this:

  Entry.lock(true).all

Before, it would generate SQL like this:

  SELECT [entries].* FROM [entries]  FOR UPDATE WITH(ROWLOCK,UPDLOCK)

Now, it generates SQL like this:

  SELECT [entries].* FROM [entries]  WITH(ROWLOCK,UPDLOCK)
iseries returns date with two digit year, leave as string instead of breaking
Update PG: rename sequence during table rename

This keeps the ARJDBC implementation behavior in sync with
Rails' Active Record following the acceptance of rails/rails#7031
Add support for DB_STRUCTURE in db:structure:dump

Suggested fix for #203
Merge pull request #204 from sharplet/db-structure-var

Add support for DB_STRUCTURE in db:structure:dump
Added support for Rails 3.2 explain feature per issue #159. I
lifted this code from the mysql2 gem and modified it to work
in the JDBC gem.  I've done testing under JRuby 1.6.7.2 with
MySQL 5.1 and 5.5 with no issues.

Github issue URL:
https://github.com/jruby/activerecord-jdbc-adapter/issues/159
Detect identity columns in db2 structure_dump

Suggested fix for #203. Adds a test for JDBC getColumns field 23,
IS_AUTOINCREMENT. If 'YES', assume GENERATED ALWAYS AS IDENTITY for the
column (don't believe the JDBC adapter reports this with any more
granularity, see JDBC API docs: http://bit.ly/LxjW8f).
Add support for primary keys to structure_dump