DAOMedge / News: Recent posts

Version 10.9.3 has been released. It contains a couple of new features and a couple of bug fixes.

I've found a bug in how the DAOMedge library handles NULL values. Also the LocalTimeDateEndoder fails on strings unlike the DateEncoder. I've added NULL as a value in NotSQL so you can now say "= NULL" (which becomes "is null") or "<> NULL (which NOW becomes "is not null") and "!= NULL (which also becomes "is not null").
These have led me to decide to release next Wednesday after the test suite has finished finding the issues.

Creating two interfaces during one session threw a null pointer and index out of range exception in one incident. I cannot reproduce under controlled conditions. The interface is remembered but not displayed. Stopping and starting fixed it.

The extn backup will backup the initial empty list of extn and inter files into extn_1 on the first save.

I have released version 10.9.2. It has a lot of small but significant changes.

Ok, stable release. I've uploaded this version four or five times over the last hour, remembering that I need to adjust all of the the documentation accordingly. Including release date which is everywhere (well in two places) and version history documentation.
Now my testing covers the multi column primary key thing and I can relax, I think.

Found MAJOR bug in updates/deletes where you have multiple columns as part of the primary key.
I only ever had one (a UUID) so it was never triggered in any of my tests.
I tested against a table in my 'tutorial' database with three columns as a primary key and there it was.
So I am releasing the next version very early.
Sorry for any inconvenience caused, particularly as I've actually had downloads now.... read more

It was released yesterday, but I had created the 10.9.1 folder and put it there!
It is now in the correct spot.

This is close to the final release as I'll add no new features to this.
Using it in house for the moment to "bed it down".
Also added this to source forge's git repository.

Connect is no longer passive. Customizable default when/who/ changed/created and change index columns.
Report writer now has a HTML output style which honors the include headers option.

With limit and offset support built in.

I'll run through the tests overnight and release in a couple of days (8th Apr.).

Where you are using notsql and have no filter. Screwed up the testing as none of my tests where missing a filter!
10.7.1 fix coming a.s.a.p.

I have released 10.7.0.
Of course I've found something straight away, but it was just an unused import in one of the classes.

I have implemented a feature freeze on 10.7.0.
Now in the debugging period. Rather happy with the NotSQL querying language.

Has been released.

Bugs fixed:
13/07/2024 - 10.3.0
Fixed bug that was ignoring filter on multi table selects, ie those methods with SelectColumn[].

Features enhanced:
08/07/2024
Date and number encoders will use the string value if the value is a string!

19/07/2024
Added a class type constructor for each table type constructor in PropertyFilter
Use first table in select column for all select columns missing a table.... read more

Added syntax highlighting to the table's interfaces as well. Non-editable obviously, well not on the table version anyway.
Java doc is no longer rooted at dist/javadoc it is now just .

I have added default code functionality for interfaces and, while doing that I found that editing of imports for those interfaces was configured but not called so they were not editable as it turned out they weren't being used either. So I have fixed all that. I'm not going to upload it just yet as I am still testing. But in the next few days for sure.

After thinking that a default order by while loading related lists was pointless we had a heat wave come through and I wasn't going out so I added it.

Fixed a bug in the Sequel generation for an IN clause.

The Sorter class has always been there, making OrderBy compliant with Compare. I've now added it to the documentation and added a sort method on the class. It now sorts by type to a greater extent.

So this is 10.0.10.

There is an unlogged NPE in the object browser if there is a coded type on a table and the coded type is not in the class path.
I've changed the way the browser responds to this so it will still browser, but report the issue.
The work around is to ensure the latest jar with the latest coded types are in the class path.

Release 17th December 2023.

Some subtle changes and one big one.
Each DAO object has its own TableProperty instance.

I've actually checked and used the use of a connection pooling Data Source. Mild changes were required. I have added sample code to the documentation to show how it can be used (the example code is for Hikari Connection Pooling).

There is now a command line interface that just builds the jar and data dictionary from the command line.

I noticed in 10.0.6 that the fix I used to avoid duplicate relationship links caused the links to disappear. So that version was removed.
10.0.7 uses a different and better way of keeping track of the joins (IE NOT on the link painter (what was I thinking?)!) .
10.0.7 also detects if all of the links are removed from the relationship join, then the join is removed during save, generate, and data dictionary building.

It is apparent that the 10.0.3 release is stable enough so I have moved from fix/release to release/fix in next version. This won't affect anyone as it isn't being used.

Changes slated for 10.0.4:
* executeStatement now has an optional column parameter so you can retrieve the second or third column not just the first. Useful for things like 'show create table ????' on mariadb and the actual create table SQL is in column 2