Hi Groovy Users, There is one more area where the power of Groovy can now be utilized: I developed a JDBC driver called dyna4JDBC (http://dyna4jdbc.org/), which allows Groovy (or any JSR-223 compatible scripting language) to be called via the JDBC API. The standard output echoed by the script is parsed to a JDBC Result Set, so that the caller application can process it further.
The goal of this driver was to allow JDBC-compatible reporting and ETL applications calling dynamic JVM language scripts as if they were databases and exposing the script output as a result set for further processing (e.g.: advanced visualizations: charts etc.) For example, you can now use Eclipse BIRT [1] reporting application and create reports, which are backed by a Groovy script: You can simply configure a JDBC datasource in Eclipse BIRT and write a Groovy script against that datasource instead of SQL. The output the script prints to the standard output will appear as the result set of the "query". You can get a quick introduction on the project home page [2]. The documentation is on GitHub Wiki [3], and the binary version of the driver can be downloaded from GitHub [4] or from Maven Central [5]. I am sharing it here in the hope that it might be useful for some people and that I could potentially get some feedback you. :) Cheers, Peter [1] http://www.eclipse.org/birt/ [2] http://dyna4jdbc.org/ [3] https://github.com/peter-gergely-horvath/dyna4jdbc/wiki [4] https://github.com/peter-gergely-horvath/dyna4jdbc/releases [5] http://search.maven.org/#search%7Cga%7C1%7Cg%3A%22com. github.peter-gergely-horvath%22%20a%3A%22dyna4jdbc%22
