some initial code for mutation support

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/mutateops@983 f203690c-595d-4dc9-a70b-905162fa7fd2

create branch for mutation operations

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/mutateops@982 f203690c-595d-4dc9-a70b-905162fa7fd2

Add support for cascade null on delete relationships.  Add support for the required flag for an index.

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@981 f203690c-595d-4dc9-a70b-905162fa7fd2

Allow null values in foreign key fields when enforcing referential integrity.  Fixes issue #136

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@980 f203690c-595d-4dc9-a70b-905162fa7fd2

Add Database.getTableMetaData method to enable getting basic info about a Table (by name) without actually loading it. fixes feature request #33

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@979 f203690c-595d-4dc9-a70b-905162fa7fd2

updates

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@978 f203690c-595d-4dc9-a70b-905162fa7fd2

Fix missing column names in AppendQuery SQL strings.  Fixes #131

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@977 f203690c-595d-4dc9-a70b-905162fa7fd2

typo

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@976 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare for next development iteration

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@975 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare release jackcess-2.1.3

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@973 f203690c-595d-4dc9-a70b-905162fa7fd2

prep for release

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@972 f203690c-595d-4dc9-a70b-905162fa7fd2

move some common site config to parent pom

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@971 f203690c-595d-4dc9-a70b-905162fa7fd2

Add FileFormat.GENERIC_JET4 in order to support getting the file format for jet4 databases with no AccessVersion property (e.g. those created programmatically using ADOX). fixes issue #129

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@970 f203690c-595d-4dc9-a70b-905162fa7fd2

more site cleanup

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@969 f203690c-595d-4dc9-a70b-905162fa7fd2

minor tweak to iterator

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@968 f203690c-595d-4dc9-a70b-905162fa7fd2

some aq updates

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@967 f203690c-595d-4dc9-a70b-905162fa7fd2

Add some utility methods for handling Dates in an Access compatible manner.  fixes issue #128

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@966 f203690c-595d-4dc9-a70b-905162fa7fd2

suppress some useless warnings

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@965 f203690c-595d-4dc9-a70b-905162fa7fd2

suppress some useless warnings

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@964 f203690c-595d-4dc9-a70b-905162fa7fd2

throw better exception when attempting to create file which does not support creation

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@963 f203690c-595d-4dc9-a70b-905162fa7fd2

update parent pom

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@962 f203690c-595d-4dc9-a70b-905162fa7fd2

cleanup findbugs report

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@961 f203690c-595d-4dc9-a70b-905162fa7fd2

Throw a prettier exception when maxing out the row size during row creation. fixes #127

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@960 f203690c-595d-4dc9-a70b-905162fa7fd2

pretty up the site

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@959 f203690c-595d-4dc9-a70b-905162fa7fd2

add github mirror link to site

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@958 f203690c-595d-4dc9-a70b-905162fa7fd2

undo accidental commit

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@957 f203690c-595d-4dc9-a70b-905162fa7fd2

add readme

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@956 f203690c-595d-4dc9-a70b-905162fa7fd2

fix borked javadoc tag

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@955 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare for next development iteration

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@954 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare release jackcess-2.1.2

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@952 f203690c-595d-4dc9-a70b-905162fa7fd2

prep for release

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@951 f203690c-595d-4dc9-a70b-905162fa7fd2

Fix handling of dateTimes before the access epoch. fixes issue #126

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@950 f203690c-595d-4dc9-a70b-905162fa7fd2

handle reading null calculated values, fixes #125

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@949 f203690c-595d-4dc9-a70b-905162fa7fd2

update version info.  fixes #124

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@948 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare for next development iteration

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@947 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare release jackcess-2.1.1

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@945 f203690c-595d-4dc9-a70b-905162fa7fd2

prep for release

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@944 f203690c-595d-4dc9-a70b-905162fa7fd2

add links to ucanaccess

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@943 f203690c-595d-4dc9-a70b-905162fa7fd2

tweak some docs

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@942 f203690c-595d-4dc9-a70b-905162fa7fd2

Allow optional direct insert/update of autonumber values.  This is disabled by default, but can be selectively enabled per-jvm (using system property), per-database, and per-table. fixes feature #32

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@941 f203690c-595d-4dc9-a70b-905162fa7fd2

more unit test speedups using in mem dbs

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@940 f203690c-595d-4dc9-a70b-905162fa7fd2

refactor DatabaseTest into more test classes

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@939 f203690c-595d-4dc9-a70b-905162fa7fd2

reorg a bunch of utility code into the TestUtil class

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@938 f203690c-595d-4dc9-a70b-905162fa7fd2

use inmem dbs to speed up slow unit tests

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@937 f203690c-595d-4dc9-a70b-905162fa7fd2

more user friendly exception message

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@936 f203690c-595d-4dc9-a70b-905162fa7fd2

Load linked table info from system table when reading databases with unsupported sort orders. Fixes issue #123

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@935 f203690c-595d-4dc9-a70b-905162fa7fd2

tweak site

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@934 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare for next development iteration

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@933 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare release jackcess-2.1.0

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@931 f203690c-595d-4dc9-a70b-905162fa7fd2

relicense with Apache License

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@930 f203690c-595d-4dc9-a70b-905162fa7fd2

remove unused loggers

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@929 f203690c-595d-4dc9-a70b-905162fa7fd2

need to compare primitive short

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@928 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare for next development iteration

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@927 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare release jackcess-2.0.9

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@925 f203690c-595d-4dc9-a70b-905162fa7fd2

prep for release

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@924 f203690c-595d-4dc9-a70b-905162fa7fd2

cleanup some ColumnBuilder stuff around copying existing columns, remove useless warning; fixes #120

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@923 f203690c-595d-4dc9-a70b-905162fa7fd2

better index setup call

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@922 f203690c-595d-4dc9-a70b-905162fa7fd2

Implement support for indexes on BINARY fields

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@921 f203690c-595d-4dc9-a70b-905162fa7fd2

missed a few more error context usages

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@920 f203690c-595d-4dc9-a70b-905162fa7fd2

lower log level for certain system table warnings; add contextual info to many errors/warnings: feature #29

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@919 f203690c-595d-4dc9-a70b-905162fa7fd2

add some convenience methods for new TableIterableBuilder; add change notes for linked table updates

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@918 f203690c-595d-4dc9-a70b-905162fa7fd2

fix linked table test; add unit tests for new table iteration methods

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@917 f203690c-595d-4dc9-a70b-905162fa7fd2

add more flexible table iteration, feature #28

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@916 f203690c-595d-4dc9-a70b-905162fa7fd2

test isLinkedTable method, feature #28

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@915 f203690c-595d-4dc9-a70b-905162fa7fd2

add method to simplify testing whether or not a Table is linked to a Database, feature #28

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@914 f203690c-595d-4dc9-a70b-905162fa7fd2

removed '-server' jvm flag to allow build to run on client jvm (e.g. RaspberryPi).

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@913 f203690c-595d-4dc9-a70b-905162fa7fd2

handle input String boolean values

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@912 f203690c-595d-4dc9-a70b-905162fa7fd2

handle input String boolean values

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@911 f203690c-595d-4dc9-a70b-905162fa7fd2

Make ColumnBuilder.setMaxLength do the right thing regardless of column type.  Add setMaxScale and setMaxPrecision helpers.  Make default length for TEXT columns the max length

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@910 f203690c-595d-4dc9-a70b-905162fa7fd2

minor cleanup in toInternalValue

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@909 f203690c-595d-4dc9-a70b-905162fa7fd2

make SimpleColumnMatcher handle a wider range of input data types by coercing them to the appropriate internal value typefg

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@908 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare for next development iteration

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@907 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare release jackcess-2.0.8

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@905 f203690c-595d-4dc9-a70b-905162fa7fd2

prep for release

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@904 f203690c-595d-4dc9-a70b-905162fa7fd2

update some out of date info on the faq

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@903 f203690c-595d-4dc9-a70b-905162fa7fd2

Better validation of identifier names (disallow invalid characters according to access naming rules)

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@902 f203690c-595d-4dc9-a70b-905162fa7fd2

Don't double quote already quoted identifiers. fixes patch 18

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@901 f203690c-595d-4dc9-a70b-905162fa7fd2

Fix table name quoting for append and make table queries. fixes patch #17

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@900 f203690c-595d-4dc9-a70b-905162fa7fd2

Add newer sql type to access type mappings if the jvm supports them.  fixes #113

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@899 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare for next development iteration

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@898 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare release jackcess-2.0.7

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@896 f203690c-595d-4dc9-a70b-905162fa7fd2

prep for release

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@895 f203690c-595d-4dc9-a70b-905162fa7fd2

make money columns report accurate scale/precision, fixes #112

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@894 f203690c-595d-4dc9-a70b-905162fa7fd2

more unit tests for unicode compression

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@893 f203690c-595d-4dc9-a70b-905162fa7fd2

rework unicode compression support, fixes issue 111

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@892 f203690c-595d-4dc9-a70b-905162fa7fd2

updates

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@891 f203690c-595d-4dc9-a70b-905162fa7fd2

more unit test perf tweaks

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@890 f203690c-595d-4dc9-a70b-905162fa7fd2

fix code example

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@889 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare for next development iteration

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@888 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare release jackcess-2.0.6

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@886 f203690c-595d-4dc9-a70b-905162fa7fd2

prep for release

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@885 f203690c-595d-4dc9-a70b-905162fa7fd2

fix regression where empty memo values are returned as null (issue 110)

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@884 f203690c-595d-4dc9-a70b-905162fa7fd2

only need to generate index row values once per lookup iteration

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@883 f203690c-595d-4dc9-a70b-905162fa7fd2

add unit test for iteration early exit fix

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@882 f203690c-595d-4dc9-a70b-905162fa7fd2

IndexCursor can early exit when searching based on indexed values, fixes 109

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@881 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare for next development iteration

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@880 f203690c-595d-4dc9-a70b-905162fa7fd2

[maven-release-plugin] prepare release jackcess-2.0.5

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@878 f203690c-595d-4dc9-a70b-905162fa7fd2

prepare for release

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@877 f203690c-595d-4dc9-a70b-905162fa7fd2

fix creation of calculated fields

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@876 f203690c-595d-4dc9-a70b-905162fa7fd2

updates

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@875 f203690c-595d-4dc9-a70b-905162fa7fd2