add some validation for integrity enforced relationships

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

implement fkref writing; more error context; make relationship name unique

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

add row rel row to sys catalog as well

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

update

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

implement logic to determine if relationship is one-to-one

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

update comment

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

some fixups to get rel insert functional

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

updates

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

implement method for writing new relationship to db

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

add some utility methods for creating relationship indexes

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

begin work on adding relationships

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

reorg to prep for RelationshipBuilder; move remaining table creation logic from TableBuilder to TableCreator

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

few minor cleanups

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

rework public api for adding index/column, ditch TableModBuilder

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

populate new index data after creation

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

get add index def functional

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

implement check for determining backing index data

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

implement most of the dirty work for adding indexes

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

checkpointing some progress on add index

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

add support for sharing backing index data across indexes during table creation

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

merge trunk changes through r992

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/mutateops@993 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@992 f203690c-595d-4dc9-a70b-905162fa7fd2

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

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

prep for release

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

primary key indexes should also have required flag

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

primary key indexes should also have required flag

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

actually write added column usage maps correctly

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

add usage maps for lval cols

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

begin adding umap support

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

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