sqlsheet changelog

Changelog of sqlsheet.

sqlsheet-7.2 (2024-08-16)

Features

use ExcelStreamingReader for reading SXFFS and obey firstColumn and firstRow parameters (23e76 Andreas Reichel)
ResultSetMetaData for Streaming PreparedStatement (8ee1f Andreas Reichel)
Streaming DatabaseMetaData support based on ExcelStreamingReader (e23f5 Andreas Reichel)

Other changes

Switch to Java 11

53640 Andreas Reichel 2024-05-17 07:46:43

Update README.md

31230 manticore-projects 2023-06-10 07:14:57

Update README.md

251c6 manticore-projects 2023-06-10 07:14:23

Create gradle.yml

141dd manticore-projects 2023-06-10 06:48:49

format code

d4c95 Andreas Reichel 2023-06-05 00:32:40

remove Travis CI

6da42 Michael Panchenko 2021-02-16 08:01:33

Circle CI

c6670 Michael Panchenko 2021-02-16 08:00:28

Fix managing resources

1559d Michael Panchenko 2021-02-16 06:29:22

remove unused code

eff4e Michael Panchenko 2021-02-16 06:25:50

Apply Java 8 migration changes

c5c83 Michael Panchenko 2021-02-16 06:25:50

Fix error handling

c2e86 Michael Panchenko 2021-02-16 06:25:50

Clean code

a6b6f Michael Panchenko 2021-02-16 06:25:50

Clean code

5a776 Michael Panchenko 2021-02-16 06:25:50

Apply Java 7 migration changes

38106 Michael Panchenko 2021-02-16 06:25:50

fix typo

33a9d Michael Panchenko 2021-02-16 06:25:50

Apply Java 5 migration changes

010b8 Michael Panchenko 2021-02-16 06:25:50

optimize import

d7d2a Michael Panchenko 2021-02-16 04:24:54

Remove unnecessary throws declaration

3913e Michael Panchenko 2021-02-16 04:24:54

Refactor "Not supported yet"

28587 Michael Panchenko 2021-02-16 04:24:54

Migrate logging to slf4j

b98f1 Michael Panchenko 2021-02-16 00:34:16

Update maven plugins

ff3b5 Michael Panchenko 2021-02-15 23:57:58

refactor junit tests (#42)

a881e Michael 2021-02-15 23:46:21

Update Apache POI 5.0.0 (#41)

Update JSqlParser 4.0
Format the java code with Google Code Formatter

2c2d8 manticore-projects 2021-02-15 23:04:17

Update Apache POI 5.0.0

Update JSqlParser 4.0
Format the java code with Google Code Formatter

fa89d Andreas Reichel 2021-01-20 07:23:04

remove travis instruction to build project on specific (not any more supported) JDK versions

we use TravisCI, CircleCI integration is not necessary

d5e60 Klaus Hauschild 2020-11-27 18:53:36

fix the Java Doc

138e7 Andreas Reichel 2020-11-25 12:18:42

add Java Doc

e6b7e Andreas Reichel 2020-11-25 12:08:51

Implement support for relative Connection URLs, such as

jdbc:xls:file://~/headline.xlsx (tilde resolve to $HOME)
jdbc:xls:file://${user.home}/headline.xlsx (system property resolves to $HOME}
jdbc:xls:classpath:/headline.xlsx (resource in classpath)
Resolves Issue #29
Testcase provided

f4719 Andreas Reichel 2020-11-25 11:54:28

Implement Close(), isClosed(), wasNull() and rewrite most of the getXXXX() methods accordingly (#36)

Update versions of POI and COMMONS IO
Add GLOB for SQL like pattern matching
Add test dependency ASCII Table for formatted test output
Add author Andreas Reichel
Implement DatabaseMetaData
for some methods, throw SQLFeatureNotSupported instead of Not Yet Implemented so SQL Clients can continue instead of failing
Provide separate DatabaseMetaData (work in progress)
Test case for DatabaseMetaData
Update Driver Class name and call it only before the test
Reformat the tests
exclude Netbeans config folders
implement Statement.close(), Statement.isClosed() and Statement.closeOnCompletion()
throw Unsupported SQL Feature Exception, where we won't be able to implement a solution
implement ResultSet.close(), ResultSet.isClosed()
implement ResultSet.wasNull() because most methods return primitives on NULL
rewrite most of the getXXXX() methods in order the set wasNull on empty rows and empty cells
rewrite most of getXXXX() method parameters (using columnIndex and columnLabel from the API)
avoid NPE on empty rows
rewrite most of the getXXXX() methods returning Objects in order the set wasNull on empty rows and empty cells
rewrite most of getXXXX() returning Objects method parameters (using columnIndex and columnLabel from the API)
Testcase around Close(), isClosed(), closeOnCompletion, wasNull()
Should close issue #1
need to set wasNull=false when value has been found
avoid NPE in getTimestamp()
enhance the Test and show the actual content
Enhance test, particularly testing getXXXX(columnIndex) vs. getXXXX(columnLabel)
Fix everything, we broke (sorry!)
All tests passed.
ensure Tests will have enough Memory available, avoid the large streaming tests to fail.
fix JavaDoc
Evaluate Cell formulas before reading the cell value

38002 manticore-projects 2020-11-21 15:18:17

Evaluate Cell formulas before reading the cell value

e4abd Andreas Reichel 2020-11-21 12:23:41

fix JavaDoc

965b4 Andreas Reichel 2020-10-27 12:46:46

ensure Tests will have enough Memory available, avoid the large streaming tests to fail.

7ee68 Andreas Reichel 2020-10-27 12:43:31

Enhance test, particularly testing getXXXX(columnIndex) vs. getXXXX(columnLabel)

Fix everything, we broke (sorry!)
All tests passed.

3e66e Andreas Reichel 2020-10-27 12:20:03

enhance the Test and show the actual content

bb429 Andreas Reichel 2020-10-27 10:38:38

need to set wasNull=false when value has been found

avoid NPE in getTimestamp()

0911b Andreas Reichel 2020-10-27 10:35:24

Testcase around Close(), isClosed(), closeOnCompletion, wasNull()

Should close issue #1

6d5f8 Andreas Reichel 2020-10-27 10:05:31

rewrite most of the getXXXX() methods returning Objects in order the set wasNull on empty rows and empty cells

rewrite most of getXXXX() returning Objects method parameters (using columnIndex and columnLabel from the API)

d9d03 Andreas Reichel 2020-10-27 10:02:45

implement ResultSet.close(), ResultSet.isClosed()

implement ResultSet.wasNull() because most methods return primitives on NULL
rewrite most of the getXXXX() methods in order the set wasNull on empty rows and empty cells
rewrite most of getXXXX() method parameters (using columnIndex and columnLabel from the API)
avoid NPE on empty rows

54406 Andreas Reichel 2020-10-27 09:51:05

implement Statement.close(), Statement.isClosed() and Statement.closeOnCompletion()

throw Unsupported SQL Feature Exception, where we won't be able to implement a solution

d90fd Andreas Reichel 2020-10-27 09:46:05

Implement DatabaseMetaData (#35)

Update versions of POI and COMMONS IO
Add GLOB for SQL like pattern matching
Add test dependency ASCII Table for formatted test output
Add author Andreas Reichel
Implement DatabaseMetaData
for some methods, throw SQLFeatureNotSupported instead of Not Yet Implemented so SQL Clients can continue instead of failing
Provide separate DatabaseMetaData (work in progress)
Test case for DatabaseMetaData
Update Driver Class name and call it only before the test
Reformat the tests
exclude Netbeans config folders

418ec manticore-projects 2020-10-27 03:48:51

exclude Netbeans config folders

e2ba5 Andreas Reichel 2020-10-26 12:29:05

Test case for DatabaseMetaData

Update Driver Class name and call it only before the test
Reformat the tests

a2b88 Andreas Reichel 2020-10-26 12:27:56

Provide separate DatabaseMetaData (work in progress)

0c325 Andreas Reichel 2020-10-26 12:26:59

Implement DatabaseMetaData

for some methods, throw SQLFeatureNotSupported instead of Not Yet Implemented so SQL Clients can continue instead of failing

2644e Andreas Reichel 2020-10-26 12:26:08

Update versions of POI and COMMONS IO

Add GLOB for SQL like pattern matching
Add test dependency ASCII Table for formatted test output
Add author Andreas Reichel

b9623 Andreas Reichel 2020-10-26 12:20:50

Bump junit from 4.12 to 4.13.1 (#34)

Bumps junit from 4.12 to 4.13.1.
- Release notes
- Changelog
- Commits
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

81fa8 dependabot[bot] 2020-10-12 23:02:07

Create FUNDING.yml

97638 Michael 2020-06-25 22:00:22

add donation button

5af84 Michael 2020-01-11 17:07:00

sqlsheet-7.1 (2019-11-15)

Other changes

prepare for release

e3273 Michael Panchenko 2019-11-15 07:01:33

fix scm

23ca2 Michael Panchenko 2019-11-15 06:45:04

- update to JDK8

- update dependencies
- update plugins

1a053 Michael Panchenko 2019-10-21 23:48:04

read a numeric cell as Date whenever possible, even when the column type would indicate a text

44edc Andreas Reichel 2019-10-21 04:03:19

update JSQLParser to 3.0

update POI to 4.1.1
add a switch to skip tests

6dcad Andreas Reichel 2019-10-21 02:47:05

update JSQLParser to 3.0

0928a Andreas Reichel 2019-10-21 02:46:08

add a test case for first column

8e5da Andreas Reichel 2019-10-21 02:45:42

fix reading doubles

75034 Andreas Reichel 2019-10-21 02:45:23

update POI to 4.1.1

432b0 Andreas Reichel 2019-10-21 02:44:21

update POI to 4.1.1

86902 Andreas Reichel 2019-10-21 02:44:06

add firstColumn connection parameter

b6fac Andreas Reichel 2019-10-21 02:43:43

add firstColumn connection parameter

update POI to 4.1.1

36ffc Andreas Reichel 2019-10-21 02:43:22

add firstColumn connection parameter

1d978 Andreas Reichel 2019-10-21 02:42:42

add firstColumn connection parameter

1bf3d Andreas Reichel 2019-10-21 02:42:16

Deprecate old classes

140b6 Andreas Reichel 2019-10-21 01:44:08

Fix the endless recursive loop on getObject(String columnName)

Fix reading double values

86d80 Andreas Reichel 2019-10-21 01:40:47

Delete ReleaseProcedures.md

8a0a7 Michael 2017-12-23 01:34:46

Move to more fitting package #26

restore SCM

2a5ac Klaus Hauschild 2017-05-22 17:24:23

Move to more fitting package #26

realign GAV coordinates to match new package

56aa7 Klaus Hauschild 2017-05-22 17:20:01

Move to more fitting package #26

fix compile and test failures
reformat whole soruce code

53a5e Klaus Hauschild 2017-05-22 17:20:00

Move to more fitting package #26

move XlsDriver to package com.sqlsheet

caca4 Klaus Hauschild 2017-05-22 17:18:30

fix scm

6ecd2 Michael Panchenko 2017-05-15 05:54:31

fix developerConnection

bbfcd Michael Panchenko 2017-05-15 05:42:27

upgrade poi to 3.14 -> 3.16

18761 Michael Panchenko 2017-05-15 05:12:05

sqlsheet-6.7 (2017-05-15)

Other changes

switch git from https to git protocol

0b3be Michael Panchenko 2017-05-15 05:02:15

prepare pom.xml for releasing

834ba Michael Panchenko 2017-05-15 04:50:37

sqlsheet-6.6 (2017-05-15)

Other changes

downgrade poi to 3.16 -> 3.14

0ce25 Michael Panchenko 2017-05-15 04:04:24

update pom file

48b66 Michael Panchenko 2017-05-15 03:39:29

Fixed javadoc issue

94310 Stephen Rufle 2017-04-22 08:16:20

File backups on XlsConnection.close() breaks the CI builds #24

simplified peristing-to-file mechanism (deactivate backup strategy); may cause other problems but hopefully fix the CI builds

aae89 Klaus Hauschild 2017-04-18 18:53:42

Missing artifact net.sf:jsqlparser:jar:0.8.0 #23

revert failed release attempt

65e41 Klaus Hauschild 2017-04-18 17:45:10

Missing artifact net.sf:jsqlparser:jar:0.8.0 #23

update some plugin versions
update urls

3965f Klaus Hauschild 2017-04-18 17:38:38

add circle.yml

195e9 Michael 2016-04-01 07:02:24

enable XlsxSheetIteratorTest

f656a Michael 2016-04-01 07:01:54

temporary disable XlsxSheetIteratorTest

32d5a Michael 2016-04-01 06:28:17

update maven plugins & dependencies

cbf1c Michael 2016-04-01 06:24:34

Build fixed and jsqlparser upgraded to 0.9.5

b3ecc kadeev 2016-03-24 14:26:58

Bug with quoted columns fixed and 31 symbol excel sheet truncation added

1b944 kadeev 2016-03-23 15:21:36

Determine the data type of each column by scanning the whole sheet, returning java.sql.date in place of java.util.Date

6c27b Gerardnico 2015-12-01 20:51:04

Create unique header,column name if duplicates

48ad5 Gerardnico 2015-12-01 14:00:37

Added help message when the sheet is not found

920b8 Gerardnico 2015-12-01 13:07:04

DataType consistency over the whole records

a1ef4 Gerardnico 2015-12-01 13:01:46

my bad: Maven couldnot refresh the resources file. The drop occurs now after the create table statement

f4b39 Gerardnico 2015-11-27 19:36:26

Added support for a drop table statement because of an error in DriverTest as the sheet name was already present

73d5c Gerardnico 2015-11-27 18:50:34

Last version of POI to resolve an undefined class problem with on org/apache/poi/UnsupportedFileFormatException

c68b1 Gerardnico 2015-11-27 18:49:23

Java doc problem resolved

70240 Gerardnico 2015-11-27 18:47:38

add travis-ci.org

fca87 Michael Panchenko 2015-03-20 05:15:56

remove readme

702f4 Michael Panchenko 2015-03-20 03:10:37

move gpg to release profile

65acc Michael Panchenko 2015-03-20 03:09:37

add travis-ci.org

e9ed6 Michael Panchenko 2015-03-20 03:04:02

add gitignore

5e0f2 Michael Panchenko 2015-03-20 03:03:33

Remove additional subdirectory sqlsheet

06e1f Michael Panchenko 2015-03-20 03:01:43

Create HowToMaven.md

8e90e Michael 2015-03-14 01:07:18

Create ReleaseProcedures.md

2955f Michael 2015-03-14 01:04:52

Create HowToGetDependecies.md

420d5 Michael 2015-03-14 01:03:45

Create HowToProcessLargeFile.md

769e9 Michael 2015-03-14 00:57:36

Update README.md

a53c5 Michael 2015-03-14 00:54:19

Update HowToScriptella.md

11e29 Michael 2015-03-14 00:47:29

Update HowToScriptella.md

33eec Michael 2015-03-14 00:46:00

Update HowToScriptella.md

a79f1 Michael 2015-03-14 00:43:22

Create HowToScriptella.md

699d4 Michael 2015-03-14 00:37:59

Create README.md

18892 Michael 2015-03-14 00:34:48

update version of jsqlparser

09114 vasilievip@gmail.com 2014-10-08 11:40:09

update plugins and dependencies

29230 klaus.hauschild.1984@gmail.com 2014-08-23 22:18:52

introduce the connection parameter "headLine" to define the index of the first row within a sheet (if the the parameter is not specified the default of 1 will be used)