JoSQL (SQL for Java Objects) / News: Recent posts

Version 1.9 contains a number of minor enhancements:

* Now possible to define a list of expressions using [ ] brackets.
* Added a new interface that indicates that all functions with a function handler will NOT return a fixed result.

See: http://josql.sourceforge.net/manual/version-changes.html for full details.

Version 1.8 contains a number of minor bug fixes relating to making the :_currobj and :_allobjs special bind variables available for use in the correct places.

See: http://josql.sourceforge.net/manual/version-changes.html for full details.

A bug fix release, small fixes.

For full details of the changes see:

http://josql.sourceforge.net/manual/version-changes.html

A bug fix release, most notably it's now possible to use JoSQL keywords as (and in) Java identifiers.

For full details of the changes see:

http://josql.sourceforge.net/manual/1-5.html

Version 1.3 has been released.

Is a minor functionality/bug fix release.

See: http://josql.sourceforge.net/manual/1-5.html for full details of the changes.

Version 1.2 is now available, the main addition is ability to perform sub-queries on Collections/Maps in objects.

For example:

SELECT *
FROM MyObject
WHERE (SELECT *
FROM listInnerList
WHERE name = 'me')

In this case, the collection returned by the "listInnerList" accessor from the "MyObject" class will be used for the sub-query. The exact class to use will be discovered when the query is executed.... read more

Version 1.1 is a minor bug fix version and focuses on the use of JoSQL with JFreeChart (as a dataset), Ant (as a file selector) and in JSPs (as a way of selecting/filtering and ordering data).

A new package "incubator" has been added where some experimental code is placed... Try it, you might like it... ;)

See the release notes for full details.

NOTE: JoSQL release numbers increment by 0.1 per release, the 1.0 has no significant meaning other than it is a new release!

New in this release (see release notes for full details):

1. Can now create new objects anywhere an expression can be used, this includes returning new objects in the SELECT clause.

2. New "stack trace element" filter added that allows the stack trace in a Throwable instance to be filtered to only those elements you are interested in.... read more

With a number of enhancements, it also has support for the upcoming 1.0 release of JoSQL!

See the release notes for full details of the improvements.

A rough and ready GUI is available for applying a JoSQL statement against a set of files in a directory. (See the "gui" package)

Please note: no bugs will be accepted against the GUI.

It is there so that you can quickly play with a JoSQL statement and see how they operate without having to write any code. (The GUI is also used in regression testing).

The GUI also indicates how the JoSQLSwingTableModel can be used, see:... read more

New version available. Substantial new functionality available. New syntax for adding objects from collections/map, new special bind variable for accessing group by columns, improved function identification, implementation of javax.swing.table.TableModel to allow a JoSQL statement to be used with a JTable. Dynamic re-ordering of the statements now also possible.

Since the downloads for JoSQL are approaching 1000 (and surprisingly no-one has mentioned any bugs... maybe it doesn't work... who knows...) I've decided to mark JoSQL as stable.

It has already proved itself in the polliwog project (http://polliwog.sourceforge.net) so I consider it now to be "production quality", that is I'd be happy to use it in a commercial product.

This release focuses on extending the "GROUP BY" functionality. This is mainly for use in the "polliwog" project (http://polliwog.sourceforge.net) but it has a plethora of uses.

You can now limit the number of group by results via a GROUP BY LIMIT clause. The LIMIT clause now applies to the List generated per GROUP BY result. This provides the ability to generate summary information in the group by and then provide further "drill-down" information in the List of results per group by.... read more

This release focuses more on the usage of JoSQL.

To that end a general purpose Comparator has been written whereby the ORDER BY clause can be used to sort objects using Collections.sort or to keep objects sorted in a TreeMap/TreeSet.

Also, a data source for JasperReports has been created (see the contrib package) so that you can now report on ANY list of objects, who needs a RDBMS ;) See the user manual for details of how to integrate JoSQL with JasperReports.... read more

The download files (due to an oversight on my part) did not contain the JoSQL-0.6.jar file. My apologies for any inconvenience.

This version allows for the use of regular expressions via a function. I've tried to make the use of the expressions as simple as possible.

There is "built-in" support for ORO, Apache RegExp, the Java 1.4 java.util.regex and GNU implementations. The default implementation is the Java 1.4, but this will only be the default if you are on 1.4 or higher. There is currently no fallback. See the user manual for full details of how to handle regular expressions. Interestingly the RegExpFactory that is now available can easily (with minor tweaks) be used outside of JoSQL, if you have any questions don't hesitate to ask!... read more

JoSQL is now at "beta" (I would put it as "production" but it hasn't been tested enough for that, although no-ones complained/raised a bug yet ;)

This release allows for accessors on function return values and a fix of a major bug relating to <= and >= operations.

Also, I've now packaged up the user manual and the javadocs together (see the file releases for details) in a single .tar.gz file.... read more

The JoSQL home page is now available and an extensive user-manual is also available (from the home page).

Yet another version. This one is mainly to correct the bugs found the other day.

See the release notes for full details.

New functions are available and some new examples.

Also, done some more Javadoc comments and made it possible for functions to take an Expression themselves for execution.

This version work has been done to remove the dependence on JDOM via the gentlyWEB jar and to strip down the gentlyWEB jar to only contain (nearly) the necessary classes. Thus making the download and footprint required much smaller.

Also, a few minor bug fixes and inconsistencies are fixed as well as lots of Javadoc comments added (still more to go!).

Version 0.1 is now done. There are a few areas to tidy-up but nearly all the functionality is there. The documentation needs a little work but is workable for now. Also, need better documentation of the source.

Have done a lot of work on performance and it now works at a very reasonable rate!

Try it, you might like it!