change log

sql2o 1.5.4 released

16 jan 2015 Lars Aaberg

####- Fixed parameter parsing bug that caused an exception if parameter name was only one character #166 >Added throwOnMappingFailure. >fixed by Lars Aaberg

####- Fixed autoclose on exception bug #162 >fixed by Lars Aaberg

####- Add option to ignore mapping errors #134 >Added throwOnMappingFailure(boolean). >fixed by Lars Aaberg

sql2o 1.5.3 released

19 okt 2014 Lars Aaberg

####- Changed behaviour of bind() method #160 >The bind method will no longer try to bind properties, if the corresponding parameter has already been added manually. > Proposed by Yngve Sneen Lindal, fixed by Lars Aaberg

####- Fixed bug if an sql comment contained single quote character in a comment #142 > Issue detected by migel, fixed by Lars Aaberg

sql2o 1.5.2 released

18 sep 2014 Lars Aaberg

####- Fixed executeScalarList() returns partial list when there are nulls #137 >Contributed by mattgilbert

####- Fixed warnings about a possible memory leak when using an application server #138 >Due to use of ThreadLocal >Contributed by Lars Aaberg

####- Fixed a warning for some JDBC drivers, when closing statements #139 >Statement.isClosed is not supported on some JDBC drivers, which made Sql2o to print a warning. Sql2o will no longer call isClosed before closing a statement. >Contributed by Lars Aaberg

####- Basic Android support #140 >Done some refactoring to support Android >Contributed by migel

####- Fixed IndexOutOfRange exception #148 >The exception was thrown when using executeAndFetchTable method with a dataset where more than one column had the same name. >Contributed by Lars Aaberg

@l_aaberg



sql2o 1.5.1 released

27 june 2014 Lars Aaberg

####- Fixes a bug with column mappings #132 >Sql2o would silently ignore, if a column could not be mapped to a property. Sql2o will now throw an exception instead. >Contributed by Lars Aaberg



sql2o 1.5.0 released

26 june 2014 Lars Aaberg

No changes since version 1.5.0-RC2



sql2o 1.5.0-RC2 released

23 june 2014 Lars Aaberg

####- Fixes a bug in OracleQuirks #130 >The getGeneratedKeysByDefault flag was mistakenly set to true for OracleQuirks. Changed back to false. >Contributed by Lars Aaberg

####- Adds setAutoCloseConnection(boolean) on ResultSetIterable interface #131 >Contributed by Lars Aaberg



sql2o 1.5.0-RC1 released

29 may 2014 Lars Aaberg

I am proud to announce the release of sql2o 1.5.0-RC1! In this release, a lot of refactoring has been done that improves performance and flexibility of the library. This is a release candidate, so if no major errors are found, this will become version 1.5.0

A special thanks to Dmitry Alexandrov for all his good ideas, and all the work he has put into this release.


List of changes on github

####- Deprecated some of the old way of doing things #121 >The execute methods are deprecated on Sql2o instance. It is now recommended to open a connection in a try-with-resource block, and call execute methods on that. >Contributed by Lars Aaberg

####- Introducing mockito test framework for better unit testing #117 >Contributed by Dmitry Alexandrov

####- New method withParams for shorten syntax #115 >Contributed by Dmitry Alexandrov

####- Changed target language level to java 1.7 #114 >Contributed by Lars Aaberg

####- Better jodatime handling #112 >This pull request also improves logging, StringConverter, FeatureDetector. >Contributed by Dmitry Alexandrov

####- Keep tack of all statements created on connection, and close them when connection is closed ffecad1 >Contributed by Dmitry Alexandrov

####- Query now implements AutoClosable #110#112 >Contributed by Dmitry Alexandrov

####- Tables and Rows now use quirks #105 >Contributed by Dmitry Alexandrov

####- Added local converters #104 >Extremely useful when using multiple instances of sql2o. >Contributed by Dmitry Alexandrov

####- Fixed incompatibility bug in some converters #102 >Contributed by Dmitry Alexandrov

####- Fixed bug in EnumConverter #101 >Contributed by Dmitry Alexandrov

####- Fixed thread safety issue on Convert class #100 >Contributed by Dmitry Alexandrov

####- Added support for custom resultset mapper #97 >Contributed by Dmitry Alexandrov

####- Refactored handling of named parameters. #95 >Contributed by Lars Aaberg

####- Fixed UnderscoreToCamelCase thread-unsafe issue #93 >Contributed by Dmitry Alexandrov

####- NamedParameterStatement fails on Postgresql :: cast syntax 90 >Fixed by Dmitry Alexandrov

####- Rewrite Query.Bind #87 >Contributed by Dmitry Alexandrov

####- More unit testing #86 >Contributed by Dmitry Alexandrov

####- Changed caching behavior of PojoMetadata 8185 >From now on, PojoMetadata instances will always be cached for improved performance >Pointed out by Dmitry Alexandrov, Fixed by Lars Aaberg

####- Refactoring for more flexibility and better performance #75 >Doing things in a better way! >Contributed by Dmitry Alexandrov

####- Fixed a thread safety issue on PojoMetadata class #68#69 >Pointed out by Dmitry Alexandrov, fixed by Dmitry Alexandrov and Lars Aaberg

####- Greatly improved performance of object mapper using sun.misc.Unsafe #67 >Will fallback to using reflection if sun.misc.Unsafe is not availlable >Contributed by Dmitry Alexandrov

####- Convert table to list of maps #63#66 >It is now possible to convert a Table instance to a list of maps. This is done with the new Table.asList() method. There is also added a similar Row.asMap() method for converting a row to a map. >Proposed by Sachin Walia. Implemented by Alden Quimby

####- Bidirectional converters #62#70 >Bidirectional converters allows for converters to specify conversion both when data is parsed from a ResultSet and when setting parameters. >Contributed by Alden Quimby

####- Better quirks pattern #62#70 >The better Quirks pattern allows for much better control. >Proposed by Dmitry Alexandrov. Implemented by Alden Quimby & Dmitry Alexandrov

####- New project structure for better extensions support #61 >Contributed by Lars Aaberg

####- Bug in inserting date time in mysql, postgres #59#60 >When setting a datetime parameter, only the date would be updated/inserted in the database. >Fixed by Alden Quimby

####- A better Query.bind method #55#80 >Fixes a bug and improves behaviour. >Contributed by Dmitry Alexandrov



Sql2o 1.4.2 released

29 apr 2014 Lars Aaberg

####- Fixed thread safety issue on enum converterd #116 >As the heading say - Fixed a thread safety issue. >Fixed by Lars Aaberg

####- Added Oracle QuirksMode 47eba93 >Using this QuirksMode disables returning of generated keys by default, as Oracle JDBC driver otherwise throws an OperationNotAllowed exception for most queries. >Fixed by Lars Aaberg



Sql2o 1.4.1 released

22 apr 2014 Lars Aaberg

####- Fixed statement-leak #113 >When using autoClose feature, statements was never explicitly closed. >Discovered by Alden Quimby



Sql2o 1.4.0 released

31 mar 2014 Lars Aaberg

####- Performance testing against other frameworks #54 >Guess who won! Check out the result here >Mainly contributed by Alden Quimby

####- Added executeAndFetchTableLazy method #49 >Contributed by Alden Quimby

####- Made Connection class AutoClosable #51 >Contributed by Lars Aaberg

####- Made it possible to run multiple statements on the same Connection instance #52 >On damn time! >Contributed by Lars Aaberg

####- Added ability to return keys from a batch #57 >Contributed by Alden Quimby

####- …And some generel bug fixing. > Full list of fixed issues in this version



Sql2o 1.3.0 released

10 feb 2014 Lars Aaberg

#####- Make joda time dependency optional #47
>For those of you who doesn’t use jodatime. >Contributed by Alden Quimby

#####- executeAndFetch method can fallback to use executeScalar methods#46
>executeAndFetch and executeAndFetchFirst methods can fallback to use executeScalar and executeScalarList methods. This makes the api easier to use. >Contributed by Alden Quimby

#####- Moved to maven central repository for hosting #44
>On damn time! >Contributed by Lars Aaberg

#####- added executeAndFetchLazy(Class) method #42
>Using the executeAndFetchLazy(Class) method greatly improves performance on large datasets. Check out the documentation here >Contributed by Alden Quimby

#####- Custom enum converter #39
>It is now possible to add a custom enum converter. For use when you want to change default behavior of the enum converter. >Contributed by Alden Quimby

#####- Make Slf4j dependeny optional #37
>If Slf4j is not in class path, sql2o will log directly to System.err. >Contributed by Lars Aaberg

A special thanks to Alden Quimby, who has done most of the work for this release.



Sql2o 1.2.1 released

21 jan 2014 Lars Aaberg

#####- Bug fix #41 >when using the Query.addParameter(String, Date) method, IBM DB2 jdbc driver would throw an exception when column is ‘date’ datatype >Fixed by Lars Aaberg



Sql2o 1.2.0 released

14 jan 2014 Lars Aaberg

#####- Auto mapping of field names with underscore. #33
>As of version 1.2.0, a database column with name “field_name”, will automatically be mapped to a java property with name “fieldName”.
>Contributed by Ryan Carlson

#####- getObject() method now has an overload that uses a registered converter. #32 >Example >MyModel value = query.getObject(“colname”, MyModel.class); >contributed by Lars Aaberg

#####- Changed setColumnMappings(Map) method public instead of private. And changed the method to return the Query instance, to support chaining. #23 >contributed by kaliy

#####- New LocalTime converter. #22 >contributed by Lars Aaberg

#####- Added JNDI support #21 >Contributed by Manuel de la Peña

#####- Added Query.bind(Object bean) method #20 >Example: >String sql = “insert into mytable(co1, col2, col3) values (:prop1, :prop2, prop3)”; >If we have a POJO with properties prop1, prop2 and prop3, we can call: >sql2o.createQuery(sql).bind(myPojo).executeUpdate(); >Contributed by Juan Noriega

#####- Added new UUID converter #17 >Contributed by Tomasz Kubacki

#####- Support for java.io.InputStream when inserting into blobs #15 >Contributed by rwozniak

… And a lot of bugs has been fixed!

Thanks for all the contributions. You guys are amazing!

I will try to get the documentation updated with the new features soon. Help is greatly appreciated.

@l_aaberg

Fork me on GitHub