a307c8f58f
Expose the ddl attribute on properties. Set the attribute appropriately for known builtin properties. fixes issue #145
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1137 f203690c-595d-4dc9-a70b-905162fa7fd2
6 years ago
d1dcbd5dfb
implement sql type to DataType conversions specific to access 2016 format
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1132 f203690c-595d-4dc9-a70b-905162fa7fd2
6 years ago
4fb8409266
Add full support for access 2016 databases including the new 'Large Number' (aka Bigint) data type. Fixes feature #37
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1130 f203690c-595d-4dc9-a70b-905162fa7fd2
6 years ago
813f732029
Handle more advanced query join constructs. fixes issue #141
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1110 f203690c-595d-4dc9-a70b-905162fa7fd2
7 years ago
c1eb52f4f6
handle missing table name for join expression
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1105 f203690c-595d-4dc9-a70b-905162fa7fd2
7 years ago
16fa12b67a
Add option to specify relationship name, fixes pull request #4
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1103 f203690c-595d-4dc9-a70b-905162fa7fd2
7 years ago
ae032248c9
Add CustomLinkResolver which facilitates loading linked tables from files which are not access databases. fixes feature request #36
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1095 f203690c-595d-4dc9-a70b-905162fa7fd2
7 years ago
ae60e32d40
Allow inserting negative auto number fields, fixes pull request #3
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1094 f203690c-595d-4dc9-a70b-905162fa7fd2
7 years ago
54972c4de5
Cover the GENERIC_JET4 format in unit tests, thanks to Gord Thompson
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1093 f203690c-595d-4dc9-a70b-905162fa7fd2
7 years ago
4feb8fbfd1
Implement support for partial index lookups. Efficient IndexCursor lookups can now be done with multi-column indexes using only some of the columns in the index.
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1087 f203690c-595d-4dc9-a70b-905162fa7fd2
7 years ago
a30708e2ce
Add support for global usage maps which are reference type maps. fixes issue #138
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1056 f203690c-595d-4dc9-a70b-905162fa7fd2
7 years ago
7b8f4c32d5
automatically switch to read-only mode when opening a file format which does not support writing, fixes feature #34
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1055 f203690c-595d-4dc9-a70b-905162fa7fd2
7 years ago
f8212d111e
misc cleanups; doc updates
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1034 f203690c-595d-4dc9-a70b-905162fa7fd2
7 years ago
545c026985
more update tests; fix minor bug with allocating new usage maps
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1032 f203690c-595d-4dc9-a70b-905162fa7fd2
7 years ago
4de28cb4f6
update javadocs, minor cleanups
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/mutateops@1030 f203690c-595d-4dc9-a70b-905162fa7fd2
7 years ago
8fdd98bd2a
expand unit tests
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/mutateops@1029 f203690c-595d-4dc9-a70b-905162fa7fd2
7 years ago
e651d85f15
add some unit tests
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/branches/mutateops@1026 f203690c-595d-4dc9-a70b-905162fa7fd2
7 years ago
70eb4cc43c
minor cleanups
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1024 f203690c-595d-4dc9-a70b-905162fa7fd2
7 years ago
e9dcad296a
Change multi-value complex columns so that they return all relevant column properties.
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@1022 f203690c-595d-4dc9-a70b-905162fa7fd2
7 years ago
aa9555c667
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
8 years ago
914e5af35c
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
8 years ago
4e5fe7ec04
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
8 years ago
69b84ac737
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
8 years ago
6deaa095c7
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
8 years ago
b7fd6e39bb
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
8 years ago
be706546be
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
9 years ago
e8616e6476
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
9 years ago
ee49db8317
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
9 years ago
0e1f59df4d
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
9 years ago
fcf9ef1843
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
9 years ago
4920d75eee
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
9 years ago
17908417ae
relicense with Apache License
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@930 f203690c-595d-4dc9-a70b-905162fa7fd2
9 years ago
fad035e0b9
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
9 years ago
babfdb1947
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
9 years ago
4ffcf30a2a
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
9 years ago
535c89ba66
test isLinkedTable method, feature #28
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@915 f203690c-595d-4dc9-a70b-905162fa7fd2
9 years ago
e6e0208c97
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
9 years ago
d50370e04a
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
9 years ago
a0c7c8dc68
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
9 years ago
f8ba282d71
more unit test perf tweaks
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@890 f203690c-595d-4dc9-a70b-905162fa7fd2
9 years ago
f17433f2de
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
9 years ago
8249b36e98
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
9 years ago
a960782626
fix creation of calculated fields
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@876 f203690c-595d-4dc9-a70b-905162fa7fd2
9 years ago
a822f36a9c
add some unit tests for calc fields
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@874 f203690c-595d-4dc9-a70b-905162fa7fd2
9 years ago
84089cb137
add tests for builder property setters
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@872 f203690c-595d-4dc9-a70b-905162fa7fd2
9 years ago
7d4abaafe2
add some unit test for property type inference
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@871 f203690c-595d-4dc9-a70b-905162fa7fd2
9 years ago
40842f747e
initial support for reading and writing calculated columns (issue #105)
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@868 f203690c-595d-4dc9-a70b-905162fa7fd2
9 years ago
5ab3c60555
more test speedups
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@867 f203690c-595d-4dc9-a70b-905162fa7fd2
9 years ago
31ade43566
speed up unit tests by delaying disk syncs
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@866 f203690c-595d-4dc9-a70b-905162fa7fd2
9 years ago
7049764860
Add Cursor.findRow(RowId) for moving to a specific Table row using only the RowId
git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@864 f203690c-595d-4dc9-a70b-905162fa7fd2
10 years ago
James Ahlborn