Revision: 549
http://datanucleus.svn.sourceforge.net/datanucleus/?rev=549&view=rev
Author: andy_jefferson
Date: 2008-04-18 06:34:49 -0700 (Fri, 18 Apr 2008)
Log Message:
-----------
initial snapshot
Added Paths:
-----------
documentation/datastore.info/
documentation/datastore.info/trunk/
documentation/datastore.info/trunk/README
documentation/datastore.info/trunk/db2-8.2.0-jdbc-2.2.49.txt
documentation/datastore.info/trunk/db2-8.2.0-jdbc-8.2.0.txt
documentation/datastore.info/trunk/db2-as400-5.0-jdbc-5.0.txt
documentation/datastore.info/trunk/derby-10.1.1.0-jdbc-10.1.1.0.txt
documentation/datastore.info/trunk/h2-1.0-jdbc-1.0.txt
documentation/datastore.info/trunk/hsqldb-1.8.0.4-jdbc-1.8.0.4.txt
documentation/datastore.info/trunk/mckoi-1.0.3-jdbc-1.0.3.txt
documentation/datastore.info/trunk/mssql-8.00.76-jdbc-2.2.0040.txt
documentation/datastore.info/trunk/mssql-8.00.818-jdbc-jtds-1.2.txt
documentation/datastore.info/trunk/mysql-4.0.12-jdbc-3.0.16.txt
documentation/datastore.info/trunk/mysql-4.0.12-jdbc-3.1.12.txt
documentation/datastore.info/trunk/mysql-5.0.18-jdbc-5.0.3.txt
documentation/datastore.info/trunk/oracle-10.1.0.2-jdbc-10.1.0.2.txt
documentation/datastore.info/trunk/postgresql-8.0.8-jdbc-8.1.405.txt
documentation/datastore.info/trunk/sapdb-7.6.0-jdbc-7.6.0.txt
documentation/datastore.info/trunk/sybase-12.5.2-jdbc-5.5.txt
documentation/datastore.info/trunk/sybase-15.0.1-jdbc-6.0.5.txt
Added: documentation/datastore.info/trunk/README
===================================================================
--- documentation/datastore.info/trunk/README (rev 0)
+++ documentation/datastore.info/trunk/README 2008-04-18 13:34:49 UTC (rev 549)
@@ -0,0 +1,13 @@
+Datastores
+===============
+This directory contains information relating to the capabilities of the
+various datastores supported
+
+For RDBMS datastores this is the output from SchemaTool "dbinfo".
+The filename is
+{datastore}-{version}-{driver-type}-{driver-version}.txt
+e.g mysql-4.1.12-jdbc-3.0.16.txt
+
+
+
+
Added: documentation/datastore.info/trunk/db2-8.2.0-jdbc-2.2.49.txt
===================================================================
--- documentation/datastore.info/trunk/db2-8.2.0-jdbc-2.2.49.txt (rev 0)
+++ documentation/datastore.info/trunk/db2-8.2.0-jdbc-2.2.49.txt 2008-04-18 13:34:49 UTC (rev 549)
@@ -0,0 +1,367 @@
+DB2Adapter : DB2/NT version=SQL08020, major=8, minor=2, revision=0
+Identifier Names supported : UPPERCASE
+Driver name=IBM DB2 JDBC Universal Driver Architecture, version=2.2.49, major=2, minor=2
+Identifier Max Lengths : Table=128 Constraints=18 Index=18 Column=30 Delimeters="
+Identifier Support in DDL : catalog=false schema=true
+
+JPOX SchemaTool : Database Type Info
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = CHAR () FOR BIT DATA
+jdbcTypeName = Types.BINARY
+dataType = -2
+precision = 254
+literalPrefix = '
+literalSuffix = '
+createParams = LENGTH
+nullable = 1
+caseSensitive = false
+searchable = 3
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = INTEGER
+jdbcTypeName = Types.INTEGER
+dataType = 4
+precision = 10
+literalPrefix = null
+literalSuffix = null
+createParams = null
+nullable = 1
+caseSensitive = false
+searchable = 2
+unsignedAttribute = false
+fixedPrecScale = true
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 10
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = DOUBLE
+jdbcTypeName = Types.DOUBLE
+dataType = 8
+precision = 53
+literalPrefix = null
+literalSuffix = null
+createParams = null
+nullable = 1
+caseSensitive = false
+searchable = 2
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 2
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = BLOB
+jdbcTypeName = Types.BLOB
+dataType = 2004
+precision = 2147483647
+literalPrefix = null
+literalSuffix = null
+createParams = LENGTH
+nullable = 1
+caseSensitive = false
+searchable = 1
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = LONG VARCHAR
+jdbcTypeName = Types.LONGVARCHAR
+dataType = -1
+precision = 32700
+literalPrefix = '
+literalSuffix = '
+createParams = LENGTH
+nullable = 1
+caseSensitive = true
+searchable = 1
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = CLOB
+jdbcTypeName = Types.CLOB
+dataType = 2005
+precision = 2147483647
+literalPrefix = '
+literalSuffix = '
+createParams = LENGTH
+nullable = 1
+caseSensitive = true
+searchable = 1
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = DECIMAL
+jdbcTypeName = Types.DECIMAL
+dataType = 3
+precision = 31
+literalPrefix = null
+literalSuffix = null
+createParams = PRECISION,SCALE
+nullable = 1
+caseSensitive = false
+searchable = 2
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 31
+numPrecRadix = 10
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = DATE
+jdbcTypeName = Types.DATE
+dataType = 91
+precision = 10
+literalPrefix = '
+literalSuffix = '
+createParams = null
+nullable = 1
+caseSensitive = false
+searchable = 2
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = REAL
+jdbcTypeName = Types.REAL
+dataType = 7
+precision = 24
+literalPrefix = null
+literalSuffix = null
+createParams = null
+nullable = 1
+caseSensitive = false
+searchable = 2
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 2
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = VARCHAR
+jdbcTypeName = Types.VARCHAR
+dataType = 12
+precision = 4000
+literalPrefix = '
+literalSuffix = '
+createParams = LENGTH
+nullable = 1
+caseSensitive = true
+searchable = 3
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = BIGINT
+jdbcTypeName = Types.BIGINT
+dataType = -5
+precision = 20
+literalPrefix = null
+literalSuffix = null
+createParams = null
+nullable = 1
+caseSensitive = false
+searchable = 2
+unsignedAttribute = false
+fixedPrecScale = true
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 10
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = DISTINCT
+jdbcTypeName = Types.DISTINCT
+dataType = 2001
+precision = 0
+literalPrefix = null
+literalSuffix = null
+createParams = null
+nullable = 0
+caseSensitive = false
+searchable = 0
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = TIME
+jdbcTypeName = Types.TIME
+dataType = 92
+precision = 8
+literalPrefix = '
+literalSuffix = '
+createParams = null
+nullable = 1
+caseSensitive = false
+searchable = 2
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = LONG VARCHAR FOR BIT DATA
+jdbcTypeName = Types.LONGVARBINARY
+dataType = -4
+precision = 32700
+literalPrefix = '
+literalSuffix = '
+createParams = null
+nullable = 1
+caseSensitive = false
+searchable = 0
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = DATALINK
+jdbcTypeName = Unrecognized type (70)
+dataType = 70
+precision = 254
+literalPrefix = null
+literalSuffix = null
+createParams =
+nullable = 1
+caseSensitive = false
+searchable = 0
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = CHAR
+jdbcTypeName = Types.CHAR
+dataType = 1
+precision = 254
+literalPrefix = '
+literalSuffix = '
+createParams = LENGTH
+nullable = 1
+caseSensitive = true
+searchable = 3
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = TIMESTAMP
+jdbcTypeName = Types.TIMESTAMP
+dataType = 93
+precision = 26
+literalPrefix = '
+literalSuffix = '
+createParams = null
+nullable = 1
+caseSensitive = false
+searchable = 2
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 6
+maximumScale = 6
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = VARCHAR () FOR BIT DATA
+jdbcTypeName = Types.VARBINARY
+dataType = -3
+precision = 32762
+literalPrefix = '
+literalSuffix = '
+createParams = LENGTH
+nullable = 1
+caseSensitive = false
+searchable = 3
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = SMALLINT
+jdbcTypeName = Types.SMALLINT
+dataType = 5
+precision = 5
+literalPrefix = null
+literalSuffix = null
+createParams = null
+nullable = 1
+caseSensitive = false
+searchable = 2
+unsignedAttribute = false
+fixedPrecScale = true
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 10
Property changes on: documentation/datastore.info/trunk/db2-8.2.0-jdbc-2.2.49.txt
___________________________________________________________________
Name: svn:eol-style
+ native
Added: documentation/datastore.info/trunk/db2-8.2.0-jdbc-8.2.0.txt
===================================================================
--- documentation/datastore.info/trunk/db2-8.2.0-jdbc-8.2.0.txt (rev 0)
+++ documentation/datastore.info/trunk/db2-8.2.0-jdbc-8.2.0.txt 2008-04-18 13:34:49 UTC (rev 549)
@@ -0,0 +1,405 @@
+DB2Adapter : DB2/NT version=08.02.0000, major=8, minor=2, revision=0
+Identifier Names supported : UPPERCASE
+Driver name=IBM DB2 JDBC 2.0 Type 2, version=08.02.0000, major=8, minor=1
+Identifier Max Lengths : Table=128 Constraints=18 Index=18 Column=30 Delimeters="
+Identifier Support in DDL : catalog=false schema=true
+
+JPOX SchemaTool : Database Type Info
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = CHAR () FOR BIT DATA
+jdbcTypeName = Types.BINARY
+dataType = -2
+precision = 254
+literalPrefix = '
+literalSuffix = '
+createParams = LENGTH
+nullable = 1
+caseSensitive = false
+searchable = 3
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = INTEGER
+jdbcTypeName = Types.INTEGER
+dataType = 4
+precision = 10
+literalPrefix = null
+literalSuffix = null
+createParams = null
+nullable = 1
+caseSensitive = false
+searchable = 2
+unsignedAttribute = false
+fixedPrecScale = true
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 10
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = DOUBLE
+jdbcTypeName = Types.DOUBLE
+dataType = 8
+precision = 53
+literalPrefix = null
+literalSuffix = null
+createParams = null
+nullable = 1
+caseSensitive = false
+searchable = 2
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 2
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = BLOB
+jdbcTypeName = Types.BLOB
+dataType = 2004
+precision = 2147483647
+literalPrefix = null
+literalSuffix = null
+createParams = LENGTH
+nullable = 1
+caseSensitive = false
+searchable = 1
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = LONG VARCHAR
+jdbcTypeName = Types.LONGVARCHAR
+dataType = -1
+precision = 32700
+literalPrefix = '
+literalSuffix = '
+createParams = null
+nullable = 1
+caseSensitive = true
+searchable = 1
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = CLOB
+jdbcTypeName = Types.CLOB
+dataType = 2005
+precision = 2147483647
+literalPrefix = '
+literalSuffix = '
+createParams = LENGTH
+nullable = 1
+caseSensitive = true
+searchable = 1
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = DECIMAL
+jdbcTypeName = Types.DECIMAL
+dataType = 3
+precision = 31
+literalPrefix = null
+literalSuffix = null
+createParams = PRECISION,SCALE
+nullable = 1
+caseSensitive = false
+searchable = 2
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 31
+numPrecRadix = 10
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = DATE
+jdbcTypeName = Types.DATE
+dataType = 91
+precision = 10
+literalPrefix = '
+literalSuffix = '
+createParams = null
+nullable = 1
+caseSensitive = false
+searchable = 2
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = REAL
+jdbcTypeName = Types.REAL
+dataType = 7
+precision = 24
+literalPrefix = null
+literalSuffix = null
+createParams = null
+nullable = 1
+caseSensitive = false
+searchable = 2
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 2
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = VARCHAR
+jdbcTypeName = Types.VARCHAR
+dataType = 12
+precision = 32672
+literalPrefix = '
+literalSuffix = '
+createParams = LENGTH
+nullable = 1
+caseSensitive = true
+searchable = 3
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = BIGINT
+jdbcTypeName = Types.BIGINT
+dataType = -5
+precision = 20
+literalPrefix = null
+literalSuffix = null
+createParams = null
+nullable = 1
+caseSensitive = false
+searchable = 2
+unsignedAttribute = false
+fixedPrecScale = true
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 10
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = DISTINCT
+jdbcTypeName = Types.DISTINCT
+dataType = 2001
+precision = 0
+literalPrefix = null
+literalSuffix = null
+createParams = null
+nullable = 0
+caseSensitive = false
+searchable = 0
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = NUMERIC
+jdbcTypeName = Types.NUMERIC
+dataType = 2
+precision = 31
+literalPrefix = null
+literalSuffix = null
+createParams = PRECISION,SCALE
+nullable = 1
+caseSensitive = false
+searchable = 2
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 31
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = TIME
+jdbcTypeName = Types.TIME
+dataType = 92
+precision = 8
+literalPrefix = '
+literalSuffix = '
+createParams = null
+nullable = 1
+caseSensitive = false
+searchable = 2
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = LONG VARCHAR FOR BIT DATA
+jdbcTypeName = Types.LONGVARBINARY
+dataType = -4
+precision = 32700
+literalPrefix = '
+literalSuffix = '
+createParams = null
+nullable = 1
+caseSensitive = false
+searchable = 0
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = DATALINK
+jdbcTypeName = Unrecognized type (70)
+dataType = 70
+precision = 254
+literalPrefix = null
+literalSuffix = null
+createParams =
+nullable = 1
+caseSensitive = false
+searchable = 0
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = FLOAT
+jdbcTypeName = Types.FLOAT
+dataType = 6
+precision = 53
+literalPrefix = null
+literalSuffix = null
+createParams = null
+nullable = 1
+caseSensitive = false
+searchable = 2
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = CHAR
+jdbcTypeName = Types.CHAR
+dataType = 1
+precision = 254
+literalPrefix = '
+literalSuffix = '
+createParams = LENGTH
+nullable = 1
+caseSensitive = true
+searchable = 3
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = TIMESTAMP
+jdbcTypeName = Types.TIMESTAMP
+dataType = 93
+precision = 26
+literalPrefix = '
+literalSuffix = '
+createParams = null
+nullable = 1
+caseSensitive = false
+searchable = 2
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 6
+maximumScale = 6
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = VARCHAR () FOR BIT DATA
+jdbcTypeName = Types.VARBINARY
+dataType = -3
+precision = 32672
+literalPrefix = '
+literalSuffix = '
+createParams = LENGTH
+nullable = 1
+caseSensitive = false
+searchable = 3
+unsignedAttribute = false
+fixedPrecScale = false
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 0
+
+org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+typeName = SMALLINT
+jdbcTypeName = Types.SMALLINT
+dataType = 5
+precision = 5
+literalPrefix = null
+literalSuffix = null
+createParams = null
+nullable = 1
+caseSensitive = false
+searchable = 2
+unsignedAttribute = false
+fixedPrecScale = true
+autoIncrement = false
+localTypeName = null
+minimumScale = 0
+maximumScale = 0
+numPrecRadix = 10
Property changes on: documentation/datastore.info/trunk/db2-8.2.0-jdbc-8.2.0.txt
___________________________________________________________________
Name: svn:eol-style
+ native
Added: documentation/datastore.info/trunk/db2-as400-5.0-jdbc-5.0.txt
===================================================================
--- documentation/datastore.info/trunk/db2-as400-5.0-jdbc-5.0.txt (rev 0)
+++ documentation/datastore.info/trunk/db2-as400-5.0-jdbc-5.0.txt 2008-04-18 13:34:49 UTC (rev 549)
@@ -0,0 +1,898 @@
+[schematool] DB2Adapter : DB2 UDB for AS/400 version=05.02.0000 V5R2m0, major=5, minor=0, revision=0
+[schematool] Identifier Names supported : UPPERCASE "MixedCase"
+[schematool] Driver name=AS/400 Toolbox for Java JDBC Driver, version=5.0, major=5, minor=0
+[schematool] Identifier Max Lengths : Table=128 Constraints=18 Index=18 Column=30 Delimeters="
+[schematool] Identifier Support in DDL : catalog=false schema=true
+[schematool] JPOX SchemaTool : Database Type Info
+[schematool] org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+[schematool] typeName = CHAR() FOR BIT DATA
+[schematool] jdbcTypeName = Types.BINARY
+[schematool] dataType = -2
+[schematool] precision = 32765
+[schematool] literalPrefix = X'
+[schematool] literalSuffix = '
+[schematool] createParams = MAX LENGTH
+[schematool] nullable = 1
+[schematool] caseSensitive = true
+[schematool] searchable = 3
+[schematool] unsignedAttribute = true
+[schematool] fixedPrecScale = false
+[schematool] autoIncrement = false
+[schematool] localTypeName = CHAR
+[schematool] minimumScale = 0
+[schematool] maximumScale = 0
+[schematool] numPrecRadix = 0
+[schematool] org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+[schematool] typeName = INTEGER
+[schematool] jdbcTypeName = Types.INTEGER
+[schematool] dataType = 4
+[schematool] precision = 10
+[schematool] literalPrefix = null
+[schematool] literalSuffix = null
+[schematool] createParams = null
+[schematool] nullable = 1
+[schematool] caseSensitive = false
+[schematool] searchable = 3
+[schematool] unsignedAttribute = false
+[schematool] fixedPrecScale = false
+[schematool] autoIncrement = false
+[schematool] localTypeName = INTEGER
+[schematool] minimumScale = 0
+[schematool] maximumScale = 0
+[schematool] numPrecRadix = 10
+[schematool] org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+[schematool] typeName = DOUBLE
+[schematool] jdbcTypeName = Types.DOUBLE
+[schematool] dataType = 8
+[schematool] precision = 53
+[schematool] literalPrefix = null
+[schematool] literalSuffix = null
+[schematool] createParams = null
+[schematool] nullable = 1
+[schematool] caseSensitive = false
+[schematool] searchable = 3
+[schematool] unsignedAttribute = false
+[schematool] fixedPrecScale = false
+[schematool] autoIncrement = false
+[schematool] localTypeName = FLOAT
+[schematool] minimumScale = 0
+[schematool] maximumScale = 0
+[schematool] numPrecRadix = 2
+[schematool] org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+[schematool] typeName = BLOB
+[schematool] jdbcTypeName = Types.BLOB
+[schematool] dataType = 2004
+[schematool] precision = 2147483646
+[schematool] literalPrefix = null
+[schematool] literalSuffix = null
+[schematool] createParams = MAX LENGTH
+[schematool] nullable = 1
+[schematool] caseSensitive = true
+[schematool] searchable = 3
+[schematool] unsignedAttribute = true
+[schematool] fixedPrecScale = false
+[schematool] autoIncrement = false
+[schematool] localTypeName = BLOB
+[schematool] minimumScale = 0
+[schematool] maximumScale = 0
+[schematool] numPrecRadix = 0
+[schematool] org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+[schematool] typeName = LONG VARCHAR
+[schematool] jdbcTypeName = Types.LONGVARCHAR
+[schematool] dataType = -1
+[schematool] precision = 32739
+[schematool] literalPrefix = '
+[schematool] literalSuffix = '
+[schematool] createParams = MAX LENGTH
+[schematool] nullable = 1
+[schematool] caseSensitive = true
+[schematool] searchable = 3
+[schematool] unsignedAttribute = true
+[schematool] fixedPrecScale = false
+[schematool] autoIncrement = false
+[schematool] localTypeName = LONG VARCHAR
+[schematool] minimumScale = 0
+[schematool] maximumScale = 0
+[schematool] numPrecRadix = 0
+[schematool] org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+[schematool] typeName = CLOB
+[schematool] jdbcTypeName = Types.CLOB
+[schematool] dataType = 2005
+[schematool] precision = 2147483646
+[schematool] literalPrefix = null
+[schematool] literalSuffix = null
+[schematool] createParams = MAX LENGTH
+[schematool] nullable = 1
+[schematool] caseSensitive = true
+[schematool] searchable = 3
+[schematool] unsignedAttribute = true
+[schematool] fixedPrecScale = false
+[schematool] autoIncrement = false
+[schematool] localTypeName = CLOB
+[schematool] minimumScale = 0
+[schematool] maximumScale = 0
+[schematool] numPrecRadix = 0
+[schematool] org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+[schematool] typeName = DECIMAL
+[schematool] jdbcTypeName = Types.DECIMAL
+[schematool] dataType = 3
+[schematool] precision = 31
+[schematool] literalPrefix = null
+[schematool] literalSuffix = null
+[schematool] createParams = PRECISION,SCALE
+[schematool] nullable = 1
+[schematool] caseSensitive = false
+[schematool] searchable = 3
+[schematool] unsignedAttribute = false
+[schematool] fixedPrecScale = false
+[schematool] autoIncrement = false
+[schematool] localTypeName = DECIMAL
+[schematool] minimumScale = 0
+[schematool] maximumScale = 31
+[schematool] numPrecRadix = 10
+[schematool] org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+[schematool] typeName = DATE
+[schematool] jdbcTypeName = Types.DATE
+[schematool] dataType = 91
+[schematool] precision = 10
+[schematool] literalPrefix = '
+[schematool] literalSuffix = '
+[schematool] createParams = null
+[schematool] nullable = 1
+[schematool] caseSensitive = false
+[schematool] searchable = 3
+[schematool] unsignedAttribute = true
+[schematool] fixedPrecScale = false
+[schematool] autoIncrement = false
+[schematool] localTypeName = DATE
+[schematool] minimumScale = 0
+[schematool] maximumScale = 0
+[schematool] numPrecRadix = 10
+[schematool] org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+[schematool] typeName = REAL
+[schematool] jdbcTypeName = Types.REAL
+[schematool] dataType = 7
+[schematool] precision = 24
+[schematool] literalPrefix = null
+[schematool] literalSuffix = null
+[schematool] createParams = null
+[schematool] nullable = 1
+[schematool] caseSensitive = false
+[schematool] searchable = 3
+[schematool] unsignedAttribute = false
+[schematool] fixedPrecScale = false
+[schematool] autoIncrement = false
+[schematool] localTypeName = REAL
+[schematool] minimumScale = 0
+[schematool] maximumScale = 0
+[schematool] numPrecRadix = 2
+[schematool] org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+[schematool] typeName = VARCHAR
+[schematool] jdbcTypeName = Types.VARCHAR
+[schematool] dataType = 12
+[schematool] precision = 32739
+[schematool] literalPrefix = '
+[schematool] literalSuffix = '
+[schematool] createParams = MAX LENGTH
+[schematool] nullable = 1
+[schematool] caseSensitive = true
+[schematool] searchable = 3
+[schematool] unsignedAttribute = true
+[schematool] fixedPrecScale = false
+[schematool] autoIncrement = false
+[schematool] localTypeName = VARCHAR
+[schematool] minimumScale = 0
+[schematool] maximumScale = 0
+[schematool] numPrecRadix = 0
+[schematool] org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+[schematool] typeName = BIGINT
+[schematool] jdbcTypeName = Types.BIGINT
+[schematool] dataType = -5
+[schematool] precision = 19
+[schematool] literalPrefix = null
+[schematool] literalSuffix = null
+[schematool] createParams = null
+[schematool] nullable = 1
+[schematool] caseSensitive = false
+[schematool] searchable = 3
+[schematool] unsignedAttribute = false
+[schematool] fixedPrecScale = false
+[schematool] autoIncrement = false
+[schematool] localTypeName = BIGINT
+[schematool] minimumScale = 0
+[schematool] maximumScale = 0
+[schematool] numPrecRadix = 10
+[schematool] org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+[schematool] typeName = NUMERIC
+[schematool] jdbcTypeName = Types.NUMERIC
+[schematool] dataType = 2
+[schematool] precision = 31
+[schematool] literalPrefix = null
+[schematool] literalSuffix = null
+[schematool] createParams = PRECISION,SCALE
+[schematool] nullable = 1
+[schematool] caseSensitive = false
+[schematool] searchable = 3
+[schematool] unsignedAttribute = false
+[schematool] fixedPrecScale = false
+[schematool] autoIncrement = false
+[schematool] localTypeName = NUMERIC
+[schematool] minimumScale = 0
+[schematool] maximumScale = 31
+[schematool] numPrecRadix = 10
+[schematool] org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+[schematool] typeName = LONG VARCHAR FOR BIT DATA
+[schematool] jdbcTypeName = Types.LONGVARBINARY
+[schematool] dataType = -4
+[schematool] precision = 32739
+[schematool] literalPrefix = X'
+[schematool] literalSuffix = '
+[schematool] createParams = MAX LENGTH
+[schematool] nullable = 1
+[schematool] caseSensitive = true
+[schematool] searchable = 3
+[schematool] unsignedAttribute = true
+[schematool] fixedPrecScale = false
+[schematool] autoIncrement = false
+[schematool] localTypeName = LONG VARCHAR
+[schematool] minimumScale = 0
+[schematool] maximumScale = 0
+[schematool] numPrecRadix = 0
+[schematool] org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+[schematool] typeName = TIME
+[schematool] jdbcTypeName = Types.TIME
+[schematool] dataType = 92
+[schematool] precision = 8
+[schematool] literalPrefix = '
+[schematool] literalSuffix = '
+[schematool] createParams = null
+[schematool] nullable = 1
+[schematool] caseSensitive = false
+[schematool] searchable = 3
+[schematool] unsignedAttribute = true
+[schematool] fixedPrecScale = false
+[schematool] autoIncrement = false
+[schematool] localTypeName = TIME
+[schematool] minimumScale = 0
+[schematool] maximumScale = 0
+[schematool] numPrecRadix = 10
+[schematool] org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+[schematool] typeName = DATALINK
+[schematool] jdbcTypeName = Unrecognized type (70)
+[schematool] dataType = 70
+[schematool] precision = 32717
+[schematool] literalPrefix = '
+[schematool] literalSuffix = '
+[schematool] createParams =
+[schematool] nullable = 1
+[schematool] caseSensitive = true
+[schematool] searchable = 3
+[schematool] unsignedAttribute = true
+[schematool] fixedPrecScale = false
+[schematool] autoIncrement = false
+[schematool] localTypeName = DATALINK
+[schematool] minimumScale = 0
+[schematool] maximumScale = 0
+[schematool] numPrecRadix = 0
+[schematool] org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+[schematool] typeName = FLOAT
+[schematool] jdbcTypeName = Types.FLOAT
+[schematool] dataType = 6
+[schematool] precision = 53
+[schematool] literalPrefix = null
+[schematool] literalSuffix = null
+[schematool] createParams = null
+[schematool] nullable = 1
+[schematool] caseSensitive = false
+[schematool] searchable = 3
+[schematool] unsignedAttribute = false
+[schematool] fixedPrecScale = false
+[schematool] autoIncrement = false
+[schematool] localTypeName = FLOAT
+[schematool] minimumScale = 0
+[schematool] maximumScale = 0
+[schematool] numPrecRadix = 2
+[schematool] org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+[schematool] typeName = CHAR
+[schematool] jdbcTypeName = Types.CHAR
+[schematool] dataType = 1
+[schematool] precision = 32765
+[schematool] literalPrefix = '
+[schematool] literalSuffix = '
+[schematool] createParams = MAX LENGTH
+[schematool] nullable = 1
+[schematool] caseSensitive = true
+[schematool] searchable = 3
+[schematool] unsignedAttribute = true
+[schematool] fixedPrecScale = false
+[schematool] autoIncrement = false
+[schematool] localTypeName = CHAR
+[schematool] minimumScale = 0
+[schematool] maximumScale = 0
+[schematool] numPrecRadix = 0
+[schematool] org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+[schematool] typeName = VARCHAR() FOR BIT DATA
+[schematool] jdbcTypeName = Types.VARBINARY
+[schematool] dataType = -3
+[schematool] precision = 32739
+[schematool] literalPrefix = X'
+[schematool] literalSuffix = '
+[schematool] createParams = MAX LENGTH
+[schematool] nullable = 1
+[schematool] caseSensitive = true
+[schematool] searchable = 3
+[schematool] unsignedAttribute = true
+[schematool] fixedPrecScale = false
+[schematool] autoIncrement = false
+[schematool] localTypeName = VARCHAR
+[schematool] minimumScale = 0
+[schematool] maximumScale = 0
+[schematool] numPrecRadix = 0
+[schematool] org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+[schematool] typeName = TIMESTAMP
+[schematool] jdbcTypeName = Types.TIMESTAMP
+[schematool] dataType = 93
+[schematool] precision = 26
+[schematool] literalPrefix = '
+[schematool] literalSuffix = '
+[schematool] createParams = null
+[schematool] nullable = 1
+[schematool] caseSensitive = false
+[schematool] searchable = 3
+[schematool] unsignedAttribute = true
+[schematool] fixedPrecScale = false
+[schematool] autoIncrement = false
+[schematool] localTypeName = TIMESTAMP
+[schematool] minimumScale = 6
+[schematool] maximumScale = 6
+[schematool] numPrecRadix = 10
+[schematool] org.jpox.store.rdbms.typeinfo.DB2TypeInfo
+[schematool] typeName = SMALLINT
+[schematool] jdbcTypeName = Types.SMALLINT
+[schematool] dataType = 5
+[schematool] precision = 5
+[schematool] literalPrefix = null
+[schematool] literalSuffix = null
+[schematool] createParams = null
+[schematool] nullable = 1
+[schematool] caseSensitive = false
+[schematool] searchable = 3
+[schematool] unsignedAttribute = false
+[schematool] fixedPrecScale = false
+[schematool] autoIncrement = false
+[schematool] localTypeName = SMALLINT
+[schematool] minimumScale = 0
+[schematool] maximumScale = 0
+[schematool] numPrecRadix = 10
+[schematool] JPOX SchemaTool : Database Keywords
+[schematool] INDEX
+[schematool] MAP
+[schematool] FETCH
+[schematool] PCTFREE
+[schematool] DSNHATTR
+[schematool] INTO
+[schematool] ORDINALITY
+[schematool] BUFFERPOOL
+[schematool] NUMBER
+[schematool] DEFINITION
+[schematool] METHOD
+[schematool] RENAME
+[schematool] COLUMN_NAME
+[schematool] MODE
+[schematool] ATOMIC
+[schematool] CALLED
+[schematool] VIEW
+[schematool] LOCALTIMESTAMP
+[schematool] ALIAS
+[schematool] UNCOMMITTED
+[schematool] LINKTYPE
+[schematool] COLLATION_NAME
+[schematool] PACKAGE
+[schematool] CONNECT
+[schematool] TIMEZONE_MINUTE
+[schematool] BINARY
+[schematool] DB2SQL
+[schematool] CONTINUE
+[schematool] CONSTRAINT_SCHEMA
+[schematool] CONSTRAINT
+[schematool] COBOL
+[schematool] DETERMINISTIC
+[schematool] SELECT
+[schematool] MODULE
+[schematool] FIELDPROC
+[schematool] CONNECTION
+[schematool] NUMERIC
+[schematool] LOCKSIZE
+[schematool] GO
+[schematool] SESSION
+[schematool] UNION
+[schematool] LC_CTYPE
+[schematool] SYSPROC
+[schematool] NONE
+[schematool] FINAL
+[schematool] OBID
+[schematool] UPDATE
+[schematool] ZONE
+[schematool] NULLS
+[schematool] SCALE
+[schematool] LOCATORS
+[schematool] ARE
+[schematool] ANY
+[schematool] EQUALS
+[schematool] BOOLEAN
+[schematool] ALLOW
+[schematool] SESSION_USER
+[schematool] SECURITY
+[schematool] NULL
+[schematool] DIAGNOSTICS
+[schematool] NAMED
+[schematool] SCRATCHPAD
+[schematool] SET
+[schematool] MESSAGE_TEXT
+[schematool] INDICATOR
+[schematool] DAY
+[schematool] UNIQUE
+[schematool] PATH
+[schematool] TYPE
+[schematool] PUBLIC
+[schematool] LONG
+[schematool] NULLABLE
+[schematool] INPUT
+[schematool] EXPLAIN
+[schematool] ELSEIF
+[schematool] NOMINVALUE
+[schematool] LAST
+[schematool] FLOAT
+[schematool] VALUES
+[schematool] NUMPARTS
+[schematool] OLD
+[schematool] OUT
+[schematool] QYERYNO
+[schematool] OR
+[schematool] PROGRAM
+[schematool] AFTER
+[schematool] FULL
+[schematool] INTEGER
+[schematool] PRIVILEGES
+[schematool] CORRESPONDING
+[schematool] RESULT_SET_LOCATOR
+[schematool] RELEASE
+[schematool] SQLERROR
+[schematool] CONNECTION_NAME
+[schematool] AUXILIARY
+[schematool] ESCAPE
+[schematool] CURRENT_TRANSFORM_GROUP_FOR_TYPE
+[schematool] MUMPS
+[schematool] EXIT
+[schematool] CURRENT_DATE
+[schematool] CYCLE
+[schematool] PIECESIZE
+[schematool] REAL
+[schematool] SUM
+[schematool] CONDITION_NUMBER
+[schematool] WHENEVER
+[schematool] CHARACTER_LENGTH
+[schematool] FROM
+[schematool] NODENUMBER
+[schematool] DELETE
+[schematool] MAX
+[schematool] NULLIF
+[schematool] INCLUDING
+[schematool] JAR
+[schematool] DO
+[schematool] CONSTRAINT_CATALOG
+[schematool] SUBSTRING
+[schematool] ONLY
+[schematool] CURRENT_TIME
+[schematool] MATCH
+[schematool] LIKE
+[schematool] COMMIT
+[schematool] NATIONAL
+[schematool] SMALLINT
+[schematool] SQLWARNING
+[schematool] IF
+[schematool] CALL
+[schematool] DISCONNECT
+[schematool] FOR
+[schematool] LOCALTIME
+[schematool] MODIFIES
+[schematool] PRESERVE
+[schematool] DEFAULT
+[schematool] DISALLOW
+[schematool] AVG
+[schematool] CURSOR
+[schematool] BEFORE
+[schematool] DEREF
+[schematool] NOT
+[schematool] DEFAULTS
+[schematool] PAGES
+[schematool] ISOBID
+[schematool] OPTION
+[schematool] INSENSITIVE
+[schematool] ENCODING
+[schematool] UNDO
+[schematool] AUDIT
+[schematool] TREAT
+[schematool] ASENSITIVE
+[schematool] RETURNED_SQLSTATE
+[schematool] SUBMULTISET
+[schematool] USAGE
+[schematool] VOLUMES
+[schematool] GENERAL
+[schematool] FORTRAN
+[schematool] PART
+[schematool] AND
+[schematool] SERIALIZABLE
+[schematool] CASCADED
+[schematool] FUNCTION
+[schematool] FILE
+[schematool] GLOBAL
+[schematool] ROLLBACK
+[schematool] END-EXEC1
+[schematool] DATE
+[schematool] BETWEEN
+[schematool] BOTH
+[schematool] WLM
+[schematool] FREE
+[schematool] VALIDPROC
+[schematool] INTERSECT
+[schematool] AT
+[schematool] DISTINCT
+[schematool] DBA
+[schematool] CACHE
+[schematool] YEARS
+[schematool] SYSTEM_USER
+[schematool] PRIOR
+[schematool] SECQTY
+[schematool] TRANSLATE
+[schematool] NEW
+[schematool] ASSOCIATE
+[schematool] DATA
+[schematool] SERVER_NAME
+[schematool] GRAPHIC
+[schematool] DB2GENERAL
+[schematool] SCROLL
+[schematool] CASE
+[schematool] ITERATE
+[schematool] TABLE
+[schematool] DEALLOCATE
+[schematool] SQLCODE
+[schematool] KEY
+[schematool] SIMPLE
+[schematool] NODENAME
+[schematool] PSID
+[schematool] LOCK
+[schematool] COLUMN
+[schematool] NAME
+[schematool] EACH
+[schematool] CREATE
+[schematool] WHERE
+[schematool] CHARACTER_SET_NAME
+[schematool] WITHOUT
+[schematool] MICROSECONDS
+[schematool] USING
+[schematool] LEADING
+[schematool] INITIALLY
+[schematool] TIMEZONE_HOUR
+[schematool] INTEGRITY
+[schematool] CHAR_LENGTH
+[schematool] CURSOR_NAME
+[schematool] PAGE
+[schematool] MONTHS
+[schematool] VALUE
+[schematool] DECIMAL
+[schematool] COLLATION_CATALOG
+[schematool] SUBCLASS_ORIGIN
+[schematool] DATETIME_INTERVAL_CODE
+[schematool] EXEC
+[schematool] TRANSLATION
+[schematool] MERGE
+[schematool] GROUP
+[schematool] IDENTITY
+[schematool] SCOPE
+[schematool] FENCED
+[schematool] VARIANT
+[schematool] RUN
+[schematool] TEMPORARY
+[schematool] RESULT
+[schematool] MINUTES
+[schematool] OUTER
+[schematool] GROUPING
+[schematool] SYNONYM
+[schematool] SQL
+[schematool] CATALOG_NAME
+[schematool] UNDER
+[schematool] SPECIFIC
+[schematool] ROLLUP
+[schematool] CLUSTER
+[schematool] APPLICATION
+[schematool] BLOB
+[schematool] IMMEDIATE
+[schematool] USER
+[schematool] SHARE
+[schematool] NO
+[schematool] STORPOOL
+[schematool] ALLOCATE
+[schematool] ROUTINE
+[schematool] COLLATION
+[schematool] VARIABLE
+[schematool] NAMES
+[schematool] SQLID
+[schematool] CLOSE
+[schematool] PARAMETER
+[schematool] OVERRIDING
+[schematool] REVOKE
+[schematool] MESSAGE_OCTET_LENGTH
+[schematool] CLASS_ORIGIN
+[schematool] COLLID
+[schematool] COLLATION_SCHEMA
+[schematool] EXISTS
+[schematool] CURRENT_TIMESTAMP
+[schematool] SPECIFICTYPE
+[schematool] END
+[schematool] DAYS
+[schematool] WORK
+[schematool] SCHEDULE
+[schematool] CURRENT_TIMEZONE
+[schematool] SAVEPOINT
+[schematool] NATURAL
+[schematool] ASYMMETRIC
+[schematool] INCREMENT
+[schematool] RESTART
+[schematool] STORES
+[schematool] ACCESS
+[schematool] CCSID
+[schematool] ON
+[schematool] RECURSIVE
+[schematool] STATISTICS
+[schematool] RELATIVE
+[schematool] ORDER
+[schematool] COLLATE
+[schematool] SIMILAR
+[schematool] GET
+[schematool] SYSTEM
+[schematool] CONDITION
+[schematool] FOUND
+[schematool] CHARACTER_SET_CATALOG
+[schematool] UNTIL
+[schematool] MONTH
+[schematool] DESC
+[schematool] DECLARE
+[schematool] TRIM
+[schematool] PREPARE
+[schematool] BREADTH
+[schematool] MAXVALUE
+[schematool] ASSERTION
+[schematool] PRIMARY
+[schematool] RANGE
+[schematool] FILTER
+[schematool] WHEN
+[schematool] OVER
+[schematool] CURRENT_ROLE
+[schematool] COMMAND_FUNCTION
+[schematool] EXCLUSIVE
+[schematool] YEAR
+[schematool] ABSOLUTE
+[schematool] SYMMETRIC
+[schematool] CATALOG
+[schematool] SOURCE
+[schematool] REPEAT
+[schematool] OPTIMIZE
+[schematool] CURRENT_DEFAULT_TRANSFORM_GROUP
+[schematool] STATIC
+[schematool] TIME
+[schematool] NHEADER
+[schematool] CONSTRAINT_NAME
+[schematool] PLAN
+[schematool] ALTER
+[schematool] ELSE
+[schematool] SENSITIVE
+[schematool] BIGINT
+[schematool] COUNT
+[schematool] DYNAMIC
+[schematool] UNNEST
+[schematool] HAVING
+[schematool] SYSIBM
+[schematool] TRUE
+[schematool] ADD
+[schematool] CURRENT_LC_PATH
+[schematool] SEARCH
+[schematool] RESET
+[schematool] UNKNOWN
+[schematool] GRANT
+[schematool] MINUTE
+[schematool] NEW_TABLE
+[schematool] OUTPUT
+[schematool] PARTITION
+[schematool] DATABASE
+[schematool] EXTERNAL
+[schematool] RESIGNAL
+[schematool] COLLECTION
+[schematool] RESTRICT
+[schematool] CUBE
+[schematool] CAST
+[schematool] PROCEDURE
+[schematool] LOCATOR
+[schematool] LABEL
+[schematool] EXECUTE
+[schematool] GOTO
+[schematool] EXCEPT
+[schematool] COALESCE
+[schematool] END-EXEC
+[schematool] MESSAGE_LENGTH
+[schematool] TIMESTAMP
+[schematool] BY
+[schematool] STANDARD
+[schematool] SECOND
+[schematool] POSITION
+[schematool] INT
+[schematool] DESCRIBE
+[schematool] UNNAMED
+[schematool] DYNAMIC_FUNCTION
+[schematool] CURRENT_PATH
+[schematool] CHARACTER
+[schematool] TRAILING
+[schematool] JOIN
+[schematool] RESOURCE
+[schematool] HANDLER
+[schematool] QUERYNO
+[schematool] WHILE
+[schematool] LATERAL
+[schematool] DESCRIPTOR
+[schematool] DEFERRABLE
+[schematool] CURRENT_LC_CTYPE
+[schematool] RETURNED_OCTET_LENGTH
+[schematool] DSSIZE
+[schematool] COMMENT
+[schematool] TABLESAMPLE
+[schematool] PRECISION
+[schematool] WITH
+[schematool] IN
+[schematool] SOME
+[schematool] CLOB
+[schematool] DROP
+[schematool] NEXT
+[schematool] DEC
+[schematool] PARTIAL
+[schematool] RETURN
+[schematool] NCLOB
+[schematool] PASCAL
+[schematool] SQLSTATE
+[schematool] INOUT
+[schematool] EDITPROC
+[schematool] RECOVERY
+[schematool] REPEATABLE
+[schematool] READ
+[schematool] EXCEPTION
+[schematool] DBINFO
+[schematool] INTERVAL
+[schematool] STATE
+[schematool] DB2GENRL
+[schematool] WITHIN
+[schematool] ELEMENT
+[schematool] SECONDS
+[schematool] AS
+[schematool] ARRAY
+[schematool] OPTIMIZATION
+[schematool] MORE
+[schematool] DOUBLE
+[schematool] GENERATED
+[schematool] DEPTH
+[schematool] ADA
+[schematool] FALSE
+[schematool] LOCKMAX
+[schematool] ERASE
+[schematool] THEN
+[schematool] LOCALE
+[schematool] REF
+[schematool] FOREIGN
+[schematool] AUTHORIZATION
+[schematool] MULTISET
+[schematool] DATETIME_INTERVAL_PRECISION
+[schematool] PRIVATE
+[schematool] TO
+[schematool] JAVA
+[schematool] LOCAL
+[schematool] CURRENT_SERVER
+[schematool] RIGHT
+[schematool] CONCAT
+[schematool] TABLE_NAME
+[schematool] TRIGGER
+[schematool] LANGUAGE
+[schematool] CONSTRAINTS
+[schematool] LEVEL
+[schematool] COUNT_BIG
+[schematool] SCHEMA
+[schematool] EXCLUDING
+[schematool] NOCYCLE
+[schematool] MEMBER
+[schematool] SPACE
+[schematool] CASCADE
+[schematool] CHAR
+[schematool] NCHAR
+[schematool] WRITE
+[schematool] LOOP
+[schematool] NOORDER
+[schematool] OF
+[schematool] RRN
+[schematool] LOWER
+[schematool] HOLD
+[schematool] WINDOW
+[schematool] VARCHAR
+[schematool] OLD_TABLE
+[schematool] CURRENT_USER
+[schematool] PCTINDEX
+[schematool] SCHEMA_NAME
+[schematool] DEFERRED
+[schematool] PRIQTY
+[schematool] SECTION
+[schematool] C
+[schematool] OPEN
+[schematool] STYLE
+[schematool] REFERENCES
+[schematool] CHECK
+[schematool] FIRST
+[schematool] DOMAIN
+[schematool] PAD
+[schematool] ALL
+[schematool] INSERT
+[schematool] VARYING
+[schematool] STOGROUP
+[schematool] SIGNAL
+[schematool] MICROSECOND
+[schematool] CARDINALITY
+[schematool] SYSFUN
+[schematool] CURRENT
+[schematool] ROW_COUNT
+[schematool] INNER
+[schematool] MINVALUE
+[schematool] ROWS
+[schematool] SUBPAGES
+[schematool] PLI
+[schematool] BIT
+[schematool] NOMAXVALUE
+[schematool] CAPTURE
+[schematool] SETS
+[schematool] CHARACTER_SET_SCHEMA
+[schematool] TABLESPACE
+[schematool] BIT_LENGTH
+[schematool] START
+[schematool] CONTAINS
+[schematool] NOCACHE
+[schematool] LEFT
+[schematool] ASUTIME
+[schematool] OCTET_LENGTH
+[schematool] REFERENCING
+[schematool] OBJECT
+[schematool] OVERLAPS
+[schematool] RETURNED_LENGTH
+[schematool] INHERIT
+[schematool] SQLEXCEPTION
+[schematool] VCAT
+[schematool] READS
+[schematool] ISOLATION
+[schematool] STAY
+[schematool] AUX
+[schematool] LENGTH
+[schematool] IS
+[schematool] ACTION
+[schematool] MIN
+[schematool] ASC
+[schematool] RETURNS
+[schematool] BEGIN
+[schematool] DBSPACE
+[schematool] HOUR
+[schematool] CONSTRUCTOR
+[schematool] HOURS
+[schematool] CONVERT
+[schematool] LEAVE
+[schematool] UPPER
+[schematool] EXTRACT
+[schematool] CROSS
+[schematool] SIZE
+[schematool] LARGE
+[schematool] COMMITTED
+[schematool] IDENTIFIED
+[schematool] ROLE
+[schematool] TRANSACTION
+[schematool] ROW
Property changes on: documentation/datastore.info/trunk/db2-as400-5.0-jdbc-5.0.txt
___________________________________________________________________
Name: svn:eol-style
+ native
Added: documentation/datastore.info/trunk/derby-10.1.1.0-jdbc-10.1.1.0.txt
===================================================================
--- documentation/datastore.info/trunk/derby-10.1.1.0-jdbc-10.1.1.0.txt (rev 0)
+++ documentation/datastore.info/trunk/derby-10.1.1.0-jdbc-10.1.1.0.txt 2008-04-18 13:34:49 UTC (rev 549)
@@ -0,0 +1,785 @@
+ [java] DerbyAdapter : Apache Derby version=10.1.1.0, major=10, minor=1, revision=1
+ [java] Identifier Names : UPPERCASE
+ [java] Driver name=Apache Derby Embedded JDBC Driver, version=10.1.1.0, major=10, minor=1
+ [java] Identifier Max Lengths : Table=128 Column=128 Constraint=18 Index=18 Delimeters="
+ [java] Identifier Support in DDL : catalog=false schema=true
+ [java]
+ [java] JPOX SchemaTool : Database Type Info
+ [java] org.jpox.store.rdbms.typeinfo.DerbyTypeInfo
+ [java] typeName = CHAR () FOR BIT DATA
+ [java] jdbcTypeName = Types.BINARY
+ [java] dataType = -2
+ [java] precision = 254
+ [java] literalPrefix = X'
+ [java] literalSuffix = '
+ [java] createParams = length
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 2
+ [java] unsignedAttribute = true
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = CHAR () FOR BIT DATA
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.DerbyTypeInfo
+ [java] typeName = INTEGER
+ [java] jdbcTypeName = Types.INTEGER
+ [java] dataType = 4
+ [java] precision = 10
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 2
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = true
+ [java] localTypeName = INTEGER
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 10
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.DerbyTypeInfo
+ [java] typeName = DOUBLE
+ [java] jdbcTypeName = Types.DOUBLE
+ [java] dataType = 8
+ [java] precision = 52
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 2
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = DOUBLE
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 2
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.DerbyTypeInfo
+ [java] typeName = BLOB
+ [java] jdbcTypeName = Types.BLOB
+ [java] dataType = 2004
+ [java] precision = 2147483647
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = length
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 1
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = BLOB
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.DerbyTypeInfo
+ [java] typeName = LONG VARCHAR
+ [java] jdbcTypeName = Types.LONGVARCHAR
+ [java] dataType = -1
+ [java] precision = 32700
+ [java] literalPrefix = '
+ [java] literalSuffix = '
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = true
+ [java] searchable = 3
+ [java] unsignedAttribute = true
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = LONG VARCHAR
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.DerbyTypeInfo
+ [java] typeName = CLOB
+ [java] jdbcTypeName = Types.CLOB
+ [java] dataType = 2005
+ [java] precision = 2147483647
+ [java] literalPrefix = '
+ [java] literalSuffix = '
+ [java] createParams = length
+ [java] nullable = 1
+ [java] caseSensitive = true
+ [java] searchable = 1
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = CLOB
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.DerbyTypeInfo
+ [java] typeName = DECIMAL
+ [java] jdbcTypeName = Types.DECIMAL
+ [java] dataType = 3
+ [java] precision = 31
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = precision,scale
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 2
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = true
+ [java] autoIncrement = false
+ [java] localTypeName = DECIMAL
+ [java] minimumScale = 0
+ [java] maximumScale = 32767
+ [java] numPrecRadix = 10
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.DerbyTypeInfo
+ [java] typeName = DATE
+ [java] jdbcTypeName = Types.DATE
+ [java] dataType = 91
+ [java] precision = 10
+ [java] literalPrefix = DATE'
+ [java] literalSuffix = '
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 2
+ [java] unsignedAttribute = true
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = DATE
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 10
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.DerbyTypeInfo
+ [java] typeName = REAL
+ [java] jdbcTypeName = Types.REAL
+ [java] dataType = 7
+ [java] precision = 23
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 2
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = REAL
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 2
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.DerbyTypeInfo
+ [java] typeName = VARCHAR
+ [java] jdbcTypeName = Types.VARCHAR
+ [java] dataType = 12
+ [java] precision = 32672
+ [java] literalPrefix = '
+ [java] literalSuffix = '
+ [java] createParams = length
+ [java] nullable = 1
+ [java] caseSensitive = true
+ [java] searchable = 3
+ [java] unsignedAttribute = true
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = VARCHAR
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.DerbyTypeInfo
+ [java] typeName = BIGINT
+ [java] jdbcTypeName = Types.BIGINT
+ [java] dataType = -5
+ [java] precision = 19
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 2
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = true
+ [java] localTypeName = BIGINT
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 10
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.DerbyTypeInfo
+ [java] typeName = NUMERIC
+ [java] jdbcTypeName = Types.NUMERIC
+ [java] dataType = 2
+ [java] precision = 31
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = precision,scale
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 2
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = true
+ [java] autoIncrement = false
+ [java] localTypeName = NUMERIC
+ [java] minimumScale = 0
+ [java] maximumScale = 32767
+ [java] numPrecRadix = 10
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.DerbyTypeInfo
+ [java] typeName = TIME
+ [java] jdbcTypeName = Types.TIME
+ [java] dataType = 92
+ [java] precision = 8
+ [java] literalPrefix = TIME'
+ [java] literalSuffix = '
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 2
+ [java] unsignedAttribute = true
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = TIME
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 10
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.DerbyTypeInfo
+ [java] typeName = LONG VARCHAR FOR BIT DATA
+ [java] jdbcTypeName = Types.LONGVARBINARY
+ [java] dataType = -4
+ [java] precision = 32700
+ [java] literalPrefix = X'
+ [java] literalSuffix = '
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 2
+ [java] unsignedAttribute = true
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = LONG VARCHAR FOR BIT DATA
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.DerbyTypeInfo
+ [java] typeName = FLOAT
+ [java] jdbcTypeName = Types.FLOAT
+ [java] dataType = 6
+ [java] precision = 52
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = precision
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 2
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = FLOAT
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 2
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.DerbyTypeInfo
+ [java] typeName = CHAR
+ [java] jdbcTypeName = Types.CHAR
+ [java] dataType = 1
+ [java] precision = 254
+ [java] literalPrefix = '
+ [java] literalSuffix = '
+ [java] createParams = length
+ [java] nullable = 1
+ [java] caseSensitive = true
+ [java] searchable = 3
+ [java] unsignedAttribute = true
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = CHAR
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.DerbyTypeInfo
+ [java] typeName = TIMESTAMP
+ [java] jdbcTypeName = Types.TIMESTAMP
+ [java] dataType = 93
+ [java] precision = 26
+ [java] literalPrefix = TIMESTAMP'
+ [java] literalSuffix = '
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 2
+ [java] unsignedAttribute = true
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = TIMESTAMP
+ [java] minimumScale = 0
+ [java] maximumScale = 6
+ [java] numPrecRadix = 10
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.DerbyTypeInfo
+ [java] typeName = VARCHAR () FOR BIT DATA
+ [java] jdbcTypeName = Types.VARBINARY
+ [java] dataType = -3
+ [java] precision = 32762
+ [java] literalPrefix = X'
+ [java] literalSuffix = '
+ [java] createParams = length
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 2
+ [java] unsignedAttribute = true
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = VARCHAR () FOR BIT DATA
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.DerbyTypeInfo
+ [java] typeName = SMALLINT
+ [java] jdbcTypeName = Types.SMALLINT
+ [java] dataType = 5
+ [java] precision = 5
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 2
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = true
+ [java] localTypeName = SMALLINT
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 10
+ [java]
+ [java]
+ [java] JPOX SchemaTool : Database Keywords
+ [java] INDEX
+ [java] MAP
+ [java] FETCH
+ [java] INTO
+ [java] ORDINALITY
+ [java] NUMBER
+ [java] METHOD
+ [java] RENAME
+ [java] COLUMN_NAME
+ [java] ATOMIC
+ [java] CALLED
+ [java] VIEW
+ [java] LOCALTIMESTAMP
+ [java] ALIAS
+ [java] UNCOMMITTED
+ [java] COLLATION_NAME
+ [java] CONNECT
+ [java] TIMEZONE_MINUTE
+ [java] BINARY
+ [java] CONTINUE
+ [java] CONSTRAINT_SCHEMA
+ [java] CONSTRAINT
+ [java] COBOL
+ [java] DETERMINISTIC
+ [java] SELECT
+ [java] MODULE
+ [java] CONNECTION
+ [java] NUMERIC
+ [java] GO
+ [java] PUBLICATION
+ [java] SESSION
+ [java] UNION
+ [java] NONE
+ [java] UPDATE
+ [java] ZONE
+ [java] SCALE
+ [java] ARE
+ [java] ANY
+ [java] EQUALS
+ [java] BOOLEAN
+ [java] SESSION_USER
+ [java] TINYINT
+ [java] NULL
+ [java] DIAGNOSTICS
+ [java] SET
+ [java] MESSAGE_TEXT
+ [java] INDICATOR
+ [java] DAY
+ [java] UNIQUE
+ [java] PATH
+ [java] TYPE
+ [java] PUBLIC
+ [java] NULLABLE
+ [java] STATEMENT
+ [java] INPUT
+ [java] EXPLAIN
+ [java] ELSEIF
+ [java] LAST
+ [java] FLOAT
+ [java] VALUES
+ [java] OLD
+ [java] OUT
+ [java] OR
+ [java] AFTER
+ [java] FULL
+ [java] INTEGER
+ [java] PRIVILEGES
+ [java] CORRESPONDING
+ [java] RELEASE
+ [java] SQLERROR
+ [java] CONNECTION_NAME
+ [java] INSTANCEOF
+ [java] ESCAPE
+ [java] CURRENT_TRANSFORM_GROUP_FOR_TYPE
+ [java] MUMPS
+ [java] EXIT
+ [java] CURRENT_DATE
+ [java] CYCLE
+ [java] REAL
+ [java] SUM
+ [java] CONDITION_NUMBER
+ [java] WHENEVER
+ [java] CHARACTER_LENGTH
+ [java] FROM
+ [java] DELETE
+ [java] MAX
+ [java] NULLIF
+ [java] DO
+ [java] CONSTRAINT_CATALOG
+ [java] SUBSTRING
+ [java] ONLY
+ [java] CURRENT_TIME
+ [java] MATCH
+ [java] LIKE
+ [java] COMMIT
+ [java] NATIONAL
+ [java] SMALLINT
+ [java] WAIT
+ [java] SQLWARNING
+ [java] IF
+ [java] CALL
+ [java] DISCONNECT
+ [java] FOR
+ [java] LOCALTIME
+ [java] MODIFIES
+ [java] PRESERVE
+ [java] DEFAULT
+ [java] AVG
+ [java] CURSOR
+ [java] BEFORE
+ [java] DEREF
+ [java] NOT
+ [java] OPTION
+ [java] RTRIM
+ [java] INSENSITIVE
+ [java] UNDO
+ [java] TREAT
+ [java] ASENSITIVE
+ [java] RETURNED_SQLSTATE
+ [java] SUBMULTISET
+ [java] USAGE
+ [java] GENERAL
+ [java] FORTRAN
+ [java] AND
+ [java] SERIALIZABLE
+ [java] CASCADED
+ [java] FUNCTION
+ [java] FILE
+ [java] GLOBAL
+ [java] ROLLBACK
+ [java] PROPERTIES
+ [java] DATE
+ [java] BETWEEN
+ [java] BOTH
+ [java] FREE
+ [java] INTERSECT
+ [java] AT
+ [java] DISTINCT
+ [java] SYSTEM_USER
+ [java] PRIOR
+ [java] TRANSLATE
+ [java] NEW
+ [java] DATA
+ [java] SERVER_NAME
+ [java] SCROLL
+ [java] CASE
+ [java] ITERATE
+ [java] TABLE
+ [java] DEALLOCATE
+ [java] SQLCODE
+ [java] KEY
+ [java] COLUMN
+ [java] NAME
+ [java] EACH
+ [java] CREATE
+ [java] WHERE
+ [java] COPY
+ [java] CHARACTER_SET_NAME
+ [java] WITHOUT
+ [java] USING
+ [java] LEADING
+ [java] INITIALLY
+ [java] TIMEZONE_HOUR
+ [java] CHAR_LENGTH
+ [java] CURSOR_NAME
+ [java] GETCURRENTCONNECTION
+ [java] VALUE
+ [java] DECIMAL
+ [java] COLLATION_CATALOG
+ [java] SUBCLASS_ORIGIN
+ [java] RECOMPILE
+ [java] GET_CURRENT_CONNECTION
+ [java] DATETIME_INTERVAL_CODE
+ [java] EXEC
+ [java] TRANSLATION
+ [java] MERGE
+ [java] GROUP
+ [java] IDENTITY
+ [java] SCOPE
+ [java] TEMPORARY
+ [java] RESULT
+ [java] OUTER
+ [java] GROUPING
+ [java] NVARCHAR
+ [java] SQL
+ [java] CATALOG_NAME
+ [java] UNDER
+ [java] SPECIFIC
+ [java] ROLLUP
+ [java] BLOB
+ [java] IMMEDIATE
+ [java] USER
+ [java] NO
+ [java] ALLOCATE
+ [java] ROUTINE
+ [java] COLLATION
+ [java] TIMING
+ [java] NAMES
+ [java] CLOSE
+ [java] PARAMETER
+ [java] REVOKE
+ [java] MESSAGE_OCTET_LENGTH
+ [java] CLASS_ORIGIN
+ [java] COLLATION_SCHEMA
+ [java] EXISTS
+ [java] CURRENT_TIMESTAMP
+ [java] SPECIFICTYPE
+ [java] END
+ [java] WORK
+ [java] SAVEPOINT
+ [java] NATURAL
+ [java] ASYMMETRIC
+ [java] ON
+ [java] RECURSIVE
+ [java] STATISTICS
+ [java] RELATIVE
+ [java] ORDER
+ [java] COLLATE
+ [java] SIMILAR
+ [java] GET
+ [java] SYSTEM
+ [java] CONDITION
+ [java] FOUND
+ [java] CHARACTER_SET_CATALOG
+ [java] UNTIL
+ [java] MONTH
+ [java] DESC
+ [java] DECLARE
+ [java] TRIM
+ [java] PREPARE
+ [java] BREADTH
+ [java] ASSERTION
+ [java] PRIMARY
+ [java] RANGE
+ [java] FILTER
+ [java] WHEN
+ [java] OVER
+ [java] CURRENT_ROLE
+ [java] COMMAND_FUNCTION
+ [java] YEAR
+ [java] ABSOLUTE
+ [java] SYMMETRIC
+ [java] CATALOG
+ [java] REPEAT
+ [java] REFRESH
+ [java] CURRENT_DEFAULT_TRANSFORM_GROUP
+ [java] STATIC
+ [java] TIME
+ [java] CONSTRAINT_NAME
+ [java] ALTER
+ [java] ELSE
+ [java] SENSITIVE
+ [java] BIGINT
+ [java] COUNT
+ [java] DYNAMIC
+ [java] UNNEST
+ [java] HAVING
+ [java] TRUE
+ [java] ADD
+ [java] SEARCH
+ [java] UNKNOWN
+ [java] GRANT
+ [java] MINUTE
+ [java] LTRIM
+ [java] OUTPUT
+ [java] SUBSTR
+ [java] PARTITION
+ [java] EXTERNAL
+ [java] RESIGNAL
+ [java] RESTRICT
+ [java] CUBE
+ [java] CAST
+ [java] PROCEDURE
+ [java] LOCATOR
+ [java] EXECUTE
+ [java] GOTO
+ [java] EXCEPT
+ [java] COALESCE
+ [java] END-EXEC
+ [java] MESSAGE_LENGTH
+ [java] TIMESTAMP
+ [java] BY
+ [java] LONGINT
+ [java] SECOND
+ [java] POSITION
+ [java] INT
+ [java] DESCRIBE
+ [java] UNNAMED
+ [java] DYNAMIC_FUNCTION
+ [java] CURRENT_PATH
+ [java] CHARACTER
+ [java] TRAILING
+ [java] JOIN
+ [java] HANDLER
+ [java] WHILE
+ [java] LATERAL
+ [java] DESCRIPTOR
+ [java] DEFERRABLE
+ [java] RETURNED_OCTET_LENGTH
+ [java] TABLESAMPLE
+ [java] PRECISION
+ [java] WITH
+ [java] IN
+ [java] SOME
+ [java] CLOB
+ [java] DROP
+ [java] NEXT
+ [java] DEC
+ [java] PARTIAL
+ [java] RETURN
+ [java] NCLOB
+ [java] PASCAL
+ [java] SQLSTATE
+ [java] INOUT
+ [java] REPEATABLE
+ [java] READ
+ [java] EXCEPTION
+ [java] INTERVAL
+ [java] STATE
+ [java] WITHIN
+ [java] ELEMENT
+ [java] AS
+ [java] ARRAY
+ [java] DB2J_DEBUG
+ [java] MORE
+ [java] DOUBLE
+ [java] DEPTH
+ [java] ADA
+ [java] FALSE
+ [java] THEN
+ [java] REF
+ [java] FOREIGN
+ [java] AUTHORIZATION
+ [java] MULTISET
+ [java] DATETIME_INTERVAL_PRECISION
+ [java] TO
+ [java] LOCAL
+ [java] RIGHT
+ [java] TABLE_NAME
+ [java] TRIGGER
+ [java] LANGUAGE
+ [java] CONSTRAINTS
+ [java] LEVEL
+ [java] SCHEMA
+ [java] MEMBER
+ [java] SPACE
+ [java] CASCADE
+ [java] CHAR
+ [java] NCHAR
+ [java] WRITE
+ [java] LOOP
+ [java] OF
+ [java] LOWER
+ [java] HOLD
+ [java] WINDOW
+ [java] VARCHAR
+ [java] CURRENT_USER
+ [java] SCHEMA_NAME
+ [java] DEFERRED
+ [java] OFF
+ [java] SECTION
+ [java] C
+ [java] OPEN
+ [java] REFERENCES
+ [java] CHECK
+ [java] FIRST
+ [java] DOMAIN
+ [java] PAD
+ [java] ALL
+ [java] INSERT
+ [java] VARYING
+ [java] SIGNAL
+ [java] CURRENT
+ [java] ROW_COUNT
+ [java] INNER
+ [java] ROWS
+ [java] PLI
+ [java] BIT
+ [java] SETS
+ [java] CHARACTER_SET_SCHEMA
+ [java] RUNTIMESTATISTICS
+ [java] BIT_LENGTH
+ [java] START
+ [java] LEFT
+ [java] OCTET_LENGTH
+ [java] REFERENCING
+ [java] OBJECT
+ [java] OVERLAPS
+ [java] RETURNED_LENGTH
+ [java] SQLEXCEPTION
+ [java] READS
+ [java] ISOLATION
+ [java] LENGTH
+ [java] IS
+ [java] ENDEXEC
+ [java] ACTION
+ [java] MIN
+ [java] ASC
+ [java] RETURNS
+ [java] BEGIN
+ [java] HOUR
+ [java] CONSTRUCTOR
+ [java] CLASS
+ [java] CONVERT
+ [java] LEAVE
+ [java] UPPER
+ [java] EXTRACT
+ [java] CROSS
+ [java] SIZE
+ [java] LARGE
+ [java] COMMITTED
+ [java] ROLE
+ [java] TRANSACTION
+ [java] ROW
+
Property changes on: documentation/datastore.info/trunk/derby-10.1.1.0-jdbc-10.1.1.0.txt
___________________________________________________________________
Name: svn:eol-style
+ native
Added: documentation/datastore.info/trunk/h2-1.0-jdbc-1.0.txt
===================================================================
--- documentation/datastore.info/trunk/h2-1.0-jdbc-1.0.txt (rev 0)
+++ documentation/datastore.info/trunk/h2-1.0-jdbc-1.0.txt 2008-04-18 13:34:49 UTC (rev 549)
@@ -0,0 +1,819 @@
+ [java] ================ DatabaseAdapter ==================
+ [java] Adapter : org.jpox.store.rdbms.adapter.H2Adapter
+ [java] Datastore : name="H2" version="1.0 (2006-08-31)" (major=1, minor=0, revision=0)
+ [java] Driver : name="H2 JDBC Driver" version="1.0 (2006-08-31)" (major=1, minor=0)
+ [java] ===================================================
+ [java]
+ [java] JPOX SchemaTool : Database Type Info
+ [java] org.jpox.store.rdbms.typeinfo.H2TypeInfo
+ [java] typeName = BINARY
+ [java] jdbcTypeName = BINARY
+ [java] dataType = -2
+ [java] precision = 2147483647
+ [java] literalPrefix = '
+ [java] literalSuffix = '
+ [java] createParams = LENGTH
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = BINARY
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.H2TypeInfo
+ [java] typeName = INTEGER
+ [java] jdbcTypeName = INTEGER
+ [java] dataType = 4
+ [java] precision = 10
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = INTEGER
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 10
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.H2TypeInfo
+ [java] typeName = DOUBLE
+ [java] jdbcTypeName = DOUBLE
+ [java] dataType = 8
+ [java] precision = 17
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = DOUBLE
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 10
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.H2TypeInfo
+ [java] typeName = TINYINT
+ [java] jdbcTypeName = TINYINT
+ [java] dataType = -6
+ [java] precision = 3
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = TINYINT
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 10
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.H2TypeInfo
+ [java] typeName = BLOB
+ [java] jdbcTypeName = BLOB
+ [java] dataType = 2004
+ [java] precision = 2147483647
+ [java] literalPrefix = '
+ [java] literalSuffix = '
+ [java] createParams = LENGTH
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = BLOB
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.H2TypeInfo
+ [java] typeName = BOOLEAN
+ [java] jdbcTypeName = BOOLEAN
+ [java] dataType = 16
+ [java] precision = 1
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = BOOLEAN
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 10
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.H2TypeInfo
+ [java] typeName = LONGVARCHAR
+ [java] jdbcTypeName = LONGVARCHAR
+ [java] dataType = -1
+ [java] precision = 2147483647
+ [java] literalPrefix = '
+ [java] literalSuffix = '
+ [java] createParams = LENGTH
+ [java] nullable = 1
+ [java] caseSensitive = true
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = LONGVARCHAR
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.H2TypeInfo
+ [java] typeName = CLOB
+ [java] jdbcTypeName = CLOB
+ [java] dataType = 2005
+ [java] precision = 2147483647
+ [java] literalPrefix = '
+ [java] literalSuffix = '
+ [java] createParams = LENGTH
+ [java] nullable = 1
+ [java] caseSensitive = true
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = CLOB
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.H2TypeInfo
+ [java] typeName = DECIMAL
+ [java] jdbcTypeName = DECIMAL
+ [java] dataType = 3
+ [java] precision = 2147483647
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = PRECISION,SCALE
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = DECIMAL
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 10
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.H2TypeInfo
+ [java] typeName = DATE
+ [java] jdbcTypeName = DATE
+ [java] dataType = 91
+ [java] precision = 8
+ [java] literalPrefix = DATE '
+ [java] literalSuffix = '
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = DATE
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.H2TypeInfo
+ [java] typeName = REAL
+ [java] jdbcTypeName = REAL
+ [java] dataType = 7
+ [java] precision = 7
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = REAL
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 10
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.H2TypeInfo
+ [java] typeName = VARCHAR
+ [java] jdbcTypeName = VARCHAR
+ [java] dataType = 12
+ [java] precision = 2147483647
+ [java] literalPrefix = '
+ [java] literalSuffix = '
+ [java] createParams = LENGTH
+ [java] nullable = 1
+ [java] caseSensitive = true
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = VARCHAR
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.H2TypeInfo
+ [java] typeName = BIGINT
+ [java] jdbcTypeName = BIGINT
+ [java] dataType = -5
+ [java] precision = 19
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = BIGINT
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 10
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.H2TypeInfo
+ [java] typeName = NUMERIC
+ [java] jdbcTypeName = NUMERIC
+ [java] dataType = 2
+ [java] precision = 2147483647
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = PRECISION,SCALE
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = NUMERIC
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 10
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.H2TypeInfo
+ [java] typeName = OTHER
+ [java] jdbcTypeName = OTHER
+ [java] dataType = 1111
+ [java] precision = 2147483647
+ [java] literalPrefix = '
+ [java] literalSuffix = '
+ [java] createParams = LENGTH
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = OTHER
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.H2TypeInfo
+ [java] typeName = TIME
+ [java] jdbcTypeName = TIME
+ [java] dataType = 92
+ [java] precision = 6
+ [java] literalPrefix = TIME '
+ [java] literalSuffix = '
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = TIME
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.H2TypeInfo
+ [java] typeName = LONGVARBINARY
+ [java] jdbcTypeName = LONGVARBINARY
+ [java] dataType = -4
+ [java] precision = 2147483647
+ [java] literalPrefix = '
+ [java] literalSuffix = '
+ [java] createParams = LENGTH
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = LONGVARBINARY
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.H2TypeInfo
+ [java] typeName = FLOAT
+ [java] jdbcTypeName = FLOAT
+ [java] dataType = 6
+ [java] precision = 17
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = FLOAT
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 10
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.H2TypeInfo
+ [java] typeName = CHAR
+ [java] jdbcTypeName = CHAR
+ [java] dataType = 1
+ [java] precision = 2147483647
+ [java] literalPrefix = '
+ [java] literalSuffix = '
+ [java] createParams = LENGTH
+ [java] nullable = 1
+ [java] caseSensitive = true
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = CHAR
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.H2TypeInfo
+ [java] typeName = TIMESTAMP
+ [java] jdbcTypeName = TIMESTAMP
+ [java] dataType = 93
+ [java] precision = 23
+ [java] literalPrefix = TIMESTAMP '
+ [java] literalSuffix = '
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = TIMESTAMP
+ [java] minimumScale = 0
+ [java] maximumScale = 10
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.H2TypeInfo
+ [java] typeName = VARBINARY
+ [java] jdbcTypeName = VARBINARY
+ [java] dataType = -3
+ [java] precision = 2147483647
+ [java] literalPrefix = '
+ [java] literalSuffix = '
+ [java] createParams = LENGTH
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = VARBINARY
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.H2TypeInfo
+ [java] typeName = SMALLINT
+ [java] jdbcTypeName = SMALLINT
+ [java] dataType = 5
+ [java] precision = 5
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = SMALLINT
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 10
+ [java]
+ [java]
+ [java] JPOX SchemaTool : Database Keywords
+ [java] MAP
+ [java] FETCH
+ [java] INTO
+ [java] ORDINALITY
+ [java] NUMBER
+ [java] METHOD
+ [java] COLUMN_NAME
+ [java] ATOMIC
+ [java] CALLED
+ [java] VIEW
+ [java] LOCALTIMESTAMP
+ [java] UNCOMMITTED
+ [java] COLLATION_NAME
+ [java] CONNECT
+ [java] TIMEZONE_MINUTE
+ [java] BINARY
+ [java] CONTINUE
+ [java] CONSTRAINT_SCHEMA
+ [java] CONSTRAINT
+ [java] COBOL
+ [java] DETERMINISTIC
+ [java] SELECT
+ [java] MODULE
+ [java] CONNECTION
+ [java] NUMERIC
+ [java] GO
+ [java] SESSION
+ [java] UNION
+ [java] NONE
+ [java] UPDATE
+ [java] ZONE
+ [java] SCALE
+ [java] ARE
+ [java] ANY
+ [java] EQUALS
+ [java] BOOLEAN
+ [java] SESSION_USER
+ [java] NULL
+ [java] DIAGNOSTICS
+ [java] SET
+ [java] MESSAGE_TEXT
+ [java] INDICATOR
+ [java] DAY
+ [java] UNIQUE
+ [java] PATH
+ [java] TYPE
+ [java] PUBLIC
+ [java] NULLABLE
+ [java] INPUT
+ [java] ELSEIF
+ [java] LAST
+ [java] FLOAT
+ [java] VALUES
+ [java] OLD
+ [java] OUT
+ [java] OR
+ [java] AFTER
+ [java] FULL
+ [java] INTEGER
+ [java] PRIVILEGES
+ [java] CORRESPONDING
+ [java] RELEASE
+ [java] SQLERROR
+ [java] CONNECTION_NAME
+ [java] ESCAPE
+ [java] CURRENT_TRANSFORM_GROUP_FOR_TYPE
+ [java] MUMPS
+ [java] EXIT
+ [java] CURRENT_DATE
+ [java] CYCLE
+ [java] REAL
+ [java] SUM
+ [java] CONDITION_NUMBER
+ [java] WHENEVER
+ [java] CHARACTER_LENGTH
+ [java] FROM
+ [java] DELETE
+ [java] MAX
+ [java] NULLIF
+ [java] DO
+ [java] CONSTRAINT_CATALOG
+ [java] SUBSTRING
+ [java] ONLY
+ [java] CURRENT_TIME
+ [java] MATCH
+ [java] LIKE
+ [java] COMMIT
+ [java] NATIONAL
+ [java] SMALLINT
+ [java] SQLWARNING
+ [java] IF
+ [java] CALL
+ [java] DISCONNECT
+ [java] FOR
+ [java] LOCALTIME
+ [java] MODIFIES
+ [java] PRESERVE
+ [java] DEFAULT
+ [java] AVG
+ [java] CURSOR
+ [java] BEFORE
+ [java] DEREF
+ [java] NOT
+ [java] OPTION
+ [java] INSENSITIVE
+ [java] UNDO
+ [java] TREAT
+ [java] ASENSITIVE
+ [java] RETURNED_SQLSTATE
+ [java] SUBMULTISET
+ [java] USAGE
+ [java] GENERAL
+ [java] FORTRAN
+ [java] AND
+ [java] SERIALIZABLE
+ [java] CASCADED
+ [java] FUNCTION
+ [java] GLOBAL
+ [java] ROLLBACK
+ [java] DATE
+ [java] BETWEEN
+ [java] BOTH
+ [java] FREE
+ [java] INTERSECT
+ [java] AT
+ [java] DISTINCT
+ [java] SYSTEM_USER
+ [java] PRIOR
+ [java] TRANSLATE
+ [java] NEW
+ [java] DATA
+ [java] SERVER_NAME
+ [java] SCROLL
+ [java] CASE
+ [java] ITERATE
+ [java] TABLE
+ [java] DEALLOCATE
+ [java] SQLCODE
+ [java] KEY
+ [java] COLUMN
+ [java] NAME
+ [java] EACH
+ [java] CREATE
+ [java] WHERE
+ [java] CHARACTER_SET_NAME
+ [java] WITHOUT
+ [java] USING
+ [java] LEADING
+ [java] INITIALLY
+ [java] TIMEZONE_HOUR
+ [java] CHAR_LENGTH
+ [java] CURSOR_NAME
+ [java] VALUE
+ [java] DECIMAL
+ [java] COLLATION_CATALOG
+ [java] SUBCLASS_ORIGIN
+ [java] DATETIME_INTERVAL_CODE
+ [java] EXEC
+ [java] TRANSLATION
+ [java] MERGE
+ [java] GROUP
+ [java] IDENTITY
+ [java] SCOPE
+ [java] TEMPORARY
+ [java] RESULT
+ [java] OUTER
+ [java] GROUPING
+ [java] SQL
+ [java] CATALOG_NAME
+ [java] UNDER
+ [java] SPECIFIC
+ [java] ROLLUP
+ [java] BLOB
+ [java] IMMEDIATE
+ [java] USER
+ [java] NO
+ [java] ALLOCATE
+ [java] ROUTINE
+ [java] COLLATION
+ [java] NAMES
+ [java] CLOSE
+ [java] PARAMETER
+ [java] REVOKE
+ [java] MESSAGE_OCTET_LENGTH
+ [java] CLASS_ORIGIN
+ [java] COLLATION_SCHEMA
+ [java] EXISTS
+ [java] CURRENT_TIMESTAMP
+ [java] SPECIFICTYPE
+ [java] END
+ [java] WORK
+ [java] SAVEPOINT
+ [java] NATURAL
+ [java] ASYMMETRIC
+ [java] ON
+ [java] RECURSIVE
+ [java] RELATIVE
+ [java] ORDER
+ [java] COLLATE
+ [java] SIMILAR
+ [java] GET
+ [java] SYSTEM
+ [java] CONDITION
+ [java] FOUND
+ [java] CHARACTER_SET_CATALOG
+ [java] UNTIL
+ [java] MONTH
+ [java] DESC
+ [java] DECLARE
+ [java] TRIM
+ [java] PREPARE
+ [java] BREADTH
+ [java] ASSERTION
+ [java] PRIMARY
+ [java] RANGE
+ [java] FILTER
+ [java] WHEN
+ [java] OVER
+ [java] CURRENT_ROLE
+ [java] COMMAND_FUNCTION
+ [java] YEAR
+ [java] ABSOLUTE
+ [java] SYMMETRIC
+ [java] CATALOG
+ [java] REPEAT
+ [java] CURRENT_DEFAULT_TRANSFORM_GROUP
+ [java] STATIC
+ [java] TIME
+ [java] CONSTRAINT_NAME
+ [java] ALTER
+ [java] ELSE
+ [java] SENSITIVE
+ [java] BIGINT
+ [java] COUNT
+ [java] DYNAMIC
+ [java] UNNEST
+ [java] HAVING
+ [java] TRUE
+ [java] ADD
+ [java] SEARCH
+ [java] UNKNOWN
+ [java] GRANT
+ [java] MINUTE
+ [java] OUTPUT
+ [java] PARTITION
+ [java] EXTERNAL
+ [java] RESIGNAL
+ [java] RESTRICT
+ [java] CUBE
+ [java] CAST
+ [java] PROCEDURE
+ [java] LOCATOR
+ [java] EXECUTE
+ [java] GOTO
+ [java] EXCEPT
+ [java] COALESCE
+ [java] END-EXEC
+ [java] MESSAGE_LENGTH
+ [java] TIMESTAMP
+ [java] BY
+ [java] SECOND
+ [java] POSITION
+ [java] INT
+ [java] DESCRIBE
+ [java] UNNAMED
+ [java] DYNAMIC_FUNCTION
+ [java] CURRENT_PATH
+ [java] CHARACTER
+ [java] TRAILING
+ [java] JOIN
+ [java] HANDLER
+ [java] WHILE
+ [java] LATERAL
+ [java] DESCRIPTOR
+ [java] DEFERRABLE
+ [java] RETURNED_OCTET_LENGTH
+ [java] TABLESAMPLE
+ [java] PRECISION
+ [java] WITH
+ [java] IN
+ [java] SOME
+ [java] CLOB
+ [java] DROP
+ [java] NEXT
+ [java] DEC
+ [java] PARTIAL
+ [java] RETURN
+ [java] NCLOB
+ [java] PASCAL
+ [java] SQLSTATE
+ [java] INOUT
+ [java] REPEATABLE
+ [java] READ
+ [java] EXCEPTION
+ [java] INTERVAL
+ [java] STATE
+ [java] WITHIN
+ [java] ELEMENT
+ [java] AS
+ [java] ARRAY
+ [java] MORE
+ [java] DOUBLE
+ [java] DEPTH
+ [java] ADA
+ [java] FALSE
+ [java] THEN
+ [java] REF
+ [java] FOREIGN
+ [java] AUTHORIZATION
+ [java] MULTISET
+ [java] DATETIME_INTERVAL_PRECISION
+ [java] TO
+ [java] LOCAL
+ [java] RIGHT
+ [java] TABLE_NAME
+ [java] TRIGGER
+ [java] LANGUAGE
+ [java] CONSTRAINTS
+ [java] LEVEL
+ [java] SCHEMA
+ [java] MEMBER
+ [java] SPACE
+ [java] CASCADE
+ [java] CHAR
+ [java] NCHAR
+ [java] WRITE
+ [java] LOOP
+ [java] OF
+ [java] LOWER
+ [java] HOLD
+ [java] WINDOW
+ [java] VARCHAR
+ [java] CURRENT_USER
+ [java] SCHEMA_NAME
+ [java] DEFERRED
+ [java] SECTION
+ [java] C
+ [java] OPEN
+ [java] REFERENCES
+ [java] CHECK
+ [java] FIRST
+ [java] DOMAIN
+ [java] PAD
+ [java] ALL
+ [java] INSERT
+ [java] VARYING
+ [java] SIGNAL
+ [java] CURRENT
+ [java] ROW_COUNT
+ [java] INNER
+ [java] ROWS
+ [java] PLI
+ [java] BIT
+ [java] SETS
+ [java] CHARACTER_SET_SCHEMA
+ [java] BIT_LENGTH
+ [java] START
+ [java] LEFT
+ [java] OCTET_LENGTH
+ [java] REFERENCING
+ [java] OBJECT
+ [java] OVERLAPS
+ [java] RETURNED_LENGTH
+ [java] SQLEXCEPTION
+ [java] READS
+ [java] ISOLATION
+ [java] LENGTH
+ [java] IS
+ [java] ACTION
+ [java] MIN
+ [java] ASC
+ [java] RETURNS
+ [java] BEGIN
+ [java] HOUR
+ [java] CONSTRUCTOR
+ [java] CONVERT
+ [java] LEAVE
+ [java] UPPER
+ [java] EXTRACT
+ [java] CROSS
+ [java] SIZE
+ [java] LARGE
+ [java] COMMITTED
+ [java] ROLE
+ [java] TRANSACTION
+ [java] ROW
+ [java]
+ [java] SchemaTool completed successfully
+BUILD SUCCESSFUL
+Total time: 7 seconds
+Finished at: Sat Oct 07 09:56:19 CEST 2006
+
Property changes on: documentation/datastore.info/trunk/h2-1.0-jdbc-1.0.txt
___________________________________________________________________
Name: svn:eol-style
+ native
Added: documentation/datastore.info/trunk/hsqldb-1.8.0.4-jdbc-1.8.0.4.txt
===================================================================
--- documentation/datastore.info/trunk/hsqldb-1.8.0.4-jdbc-1.8.0.4.txt (rev 0)
+++ documentation/datastore.info/trunk/hsqldb-1.8.0.4-jdbc-1.8.0.4.txt 2008-04-18 13:34:49 UTC (rev 549)
@@ -0,0 +1,788 @@
+ [java] HSQLAdapter : HSQL Database Engine version=1.8.0, major=1, minor=8, revision=0
+ [java] Identifier Names : UPPERCASE
+ [java] Driver name=HSQL Database Engine Driver, version=1.8.0, major=1, minor=8
+ [java] Identifier Max Lengths : Table=128 Column=128 Constraint=128 Index=128 Delimeters="
+ [java] Identifier Support in DDL : catalog=false schema=true
+ [java]
+ [java] JPOX SchemaTool : Database Type Info
+ [java] org.jpox.store.rdbms.typeinfo.HSQLTypeInfo
+ [java] typeName = BINARY
+ [java] jdbcTypeName = Types.BINARY
+ [java] dataType = -2
+ [java] precision = 2147483647
+ [java] literalPrefix = '
+ [java] literalSuffix = '
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = BINARY
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.HSQLTypeInfo
+ [java] typeName = INTEGER
+ [java] jdbcTypeName = Types.INTEGER
+ [java] dataType = 4
+ [java] precision = 10
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = true
+ [java] localTypeName = INTEGER
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 10
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.HSQLTypeInfo
+ [java] typeName = DOUBLE
+ [java] jdbcTypeName = Types.DOUBLE
+ [java] dataType = 8
+ [java] precision = 17
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = DOUBLE
+ [java] minimumScale = -324
+ [java] maximumScale = 306
+ [java] numPrecRadix = 10
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.HSQLTypeInfo
+ [java] typeName = TINYINT
+ [java] jdbcTypeName = Types.TINYINT
+ [java] dataType = -6
+ [java] precision = 3
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = TINYINT
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 10
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.HSQLTypeInfo
+ [java] typeName = BOOLEAN
+ [java] jdbcTypeName = Unrecognized type (16)
+ [java] dataType = 16
+ [java] precision = 1
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = BOOLEAN
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.HSQLTypeInfo
+ [java] typeName = LONGVARCHAR
+ [java] jdbcTypeName = Types.LONGVARCHAR
+ [java] dataType = -1
+ [java] precision = 2147483647
+ [java] literalPrefix = '
+ [java] literalSuffix = '
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = true
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = LONGVARCHAR
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.HSQLTypeInfo
+ [java] typeName = DECIMAL
+ [java] jdbcTypeName = Types.DECIMAL
+ [java] dataType = 3
+ [java] precision = 646456993
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = PRECISION,SCALE
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = DECIMAL
+ [java] minimumScale = 0
+ [java] maximumScale = 32767
+ [java] numPrecRadix = 10
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.HSQLTypeInfo
+ [java] typeName = DATE
+ [java] jdbcTypeName = Types.DATE
+ [java] dataType = 91
+ [java] precision = 10
+ [java] literalPrefix = '
+ [java] literalSuffix = '
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = DATE
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.HSQLTypeInfo
+ [java] typeName = REAL
+ [java] jdbcTypeName = Types.REAL
+ [java] dataType = 7
+ [java] precision = 17
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = REAL
+ [java] minimumScale = -324
+ [java] maximumScale = 306
+ [java] numPrecRadix = 10
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.HSQLTypeInfo
+ [java] typeName = VARCHAR
+ [java] jdbcTypeName = Types.VARCHAR
+ [java] dataType = 12
+ [java] precision = 2147483647
+ [java] literalPrefix = '
+ [java] literalSuffix = '
+ [java] createParams = LENGTH
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = VARCHAR
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.HSQLTypeInfo
+ [java] typeName = BIGINT
+ [java] jdbcTypeName = Types.BIGINT
+ [java] dataType = -5
+ [java] precision = 19
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = true
+ [java] localTypeName = BIGINT
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 10
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.HSQLTypeInfo
+ [java] typeName = NUMERIC
+ [java] jdbcTypeName = Types.NUMERIC
+ [java] dataType = 2
+ [java] precision = 2147483647
+ [java] literalPrefix = null
+ [java] literalSuffix = null
+ [java] createParams = PRECISION,SCALE
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = NUMERIC
+ [java] minimumScale = 0
+ [java] maximumScale = 32767
+ [java] numPrecRadix = 10
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.HSQLTypeInfo
+ [java] typeName = OTHER
+ [java] jdbcTypeName = Types.OTHER
+ [java] dataType = 1111
+ [java] precision = 2147483647
+ [java] literalPrefix = '
+ [java] literalSuffix = '
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = true
+ [java] searchable = 0
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = OTHER
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.HSQLTypeInfo
+ [java] typeName = TIME
+ [java] jdbcTypeName = Types.TIME
+ [java] dataType = 92
+ [java] precision = 8
+ [java] literalPrefix = '
+ [java] literalSuffix = '
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
+ [java] autoIncrement = false
+ [java] localTypeName = TIME
+ [java] minimumScale = 0
+ [java] maximumScale = 0
+ [java] numPrecRadix = 0
+ [java]
+ [java] org.jpox.store.rdbms.typeinfo.HSQLTypeInfo
+ [java] typeName = LONGVARBINARY
+ [java] jdbcTypeName = Types.LONGVARBINARY
+ [java] dataType = -4
+ [java] precision = 2147483647
+ [java] literalPrefix = '
+ [java] literalSuffix = '
+ [java] createParams = null
+ [java] nullable = 1
+ [java] caseSensitive = false
+ [java] searchable = 3
+ [java] unsignedAttribute = false
+ [java] fixedPrecScale = false
@@ Diff output truncated at 100000 characters. @@
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|