jOOQ 2.3.1 freeware    

Author Lukas Eder OS WinXP, Windows Vista, Windows Vista x64, Windows 7, Windows 7 x64 Date Released May 15, 2012 Downloads 317 Filesize 1.10 MB Keywords model SQL statement, create serializable object, serializable object generator, creator, create, generate Your Rating   - click to rate - you will be first!

[ View full size screenshot ]

Download jOOQ   Save Freeware   Report Spyware

jOOQ generates a simple Java representation of your database schema. Every table, view, stored procedure, enum, UDT is a class. jOOQ implements an easy-to-use active record pattern. It is NOT an OR-mapper, but provides a 1:1 mapping between tables/views and classes. Between columns and members. jOOQ allows for writing compile-time typesafe querying using its built-in DSL. ...

Download jOOQ   Save Freeware   Report Spyware

Database - jOOQ freeware - Download Notice

jOOQ Free Download - we do not host any jOOQ torrent files or links of jOOQ on rapidshare.com, depositfiles.com, megaupload.com etc. All jOOQ download links are direct jOOQ full download from publisher site or their selected mirrors.

Database - jOOQ freeware - Latest User Reviews

 Write a Review   

Database - jOOQ freeware - The Latest Versions History

Version	Date Released	Status	Release Notes
2.3.1	May 15, 2012	New Release	· Fix inaccurate simulation of TRUNC(number, decimals) for Derby · Documentation bug: ctx.statement() can be replaced in executeStart(). This is not documented · Compilation errors in generated source code when Postgres stored procedure parameter is called "NAME" · Compilation errors in generated source code when Postgres data-type is "any" (with quotes!) · Postgres code generation broken when not connecting with the owner of a schema
2.2.2	Apr 30, 2012	New Release	Bug fixes: · Oracle's DataTypeDefinition reports the length of a BLOB / CLOB data type to be 4000 · Code generation error in Oracle 10g when generating stored procedures · NullPointerException when passing null to timestampDiff(Field, Field) · Regression in insertInto(...).values(...). Cannot pass Field to values() · NPE at org.jooq.util.AbstractDatabase.getOutputSchema()
2.2.1	Apr 16, 2012	New Release	Bug fixes: · Remove oracle.sql dependency also from OSGi information in pom.xml · SQL syntax errors from sequences when using RenderMapping with defaultSchema · DefaultBindContext logs as Util.class · Compilation error in CUBRID generated artefacts referencing OBJECT types · Avoid source code generation errors when generating code for unknown, dialect-specific data types
2.1.0	Mar 20, 2012	New Release	Features and improvements: · Add runtime configuration to pretty print rendered SQL · Add SQLite relations support · Add runtime configuration for SQL keyword style (upper case, lower case) · Add runtime configuration for SQL reference style (upper case, lower case, as-is, quoted) · Add code generation option to disable generation of records · Add support for SQL Server data types timestamp and rowversion · Load default Settings from the classpath at · /jooq-settings.xml, or from -Dorg.jooq.settings · Specify main-class in jOOQ Console's manifest.mf and include dependency in jar file · Add ColumnDefinition.isNullable() Add support for the relational division operation: · A.divideBy(B).on(A.ID.equal(B.A_ID)).returning(A.X, ...) · Add Factory.batch(Collection
2.0.5	Mar 1, 2012	New Release	Features and improvements: · Add Field.equalIgnoreCase(), Field.notEqualIgnoreCase() · Add class prefixes, suffixes and other options to the code generator · Add runtime configuration · Let Field.contains() support the Postgres ARRAY @> ARRAY operator · Add ResultQuery.fetchResultSet() to return the underlying JDBC result set · Add Result.isNotEmpty() for convenience · Add runtime configuration to specify whether jOOQ should execute java.sql.PreparedStatement (with bind variables) or a java.sql.Statement (with inlined parameters) · Add Query.getSQL(boolean) to indicate that bind values should be inlined (as a convenience for Factory.renderInlined(QueryPart)) · Add Cursor.resultSet() to expose the underlying ResultSet · Allow for optional "http://www.jooq.org/xsd/jooq-codegen-2.0.4.xsd" · namespace in jooq-codegen configuration · Add E MySQLFactory.enumType(Class, int) for enum reverse lookups of MySQL-specific enums · Support matching numbers with LIKE, e.g. ID LIKE '3%'
2.0.4	Feb 14, 2012	New Release	This release introduced many improvements to source code generation. These improvements include: · Maven and standalone code generation now use the same XML configuration, which is read by jOOQ-codegen using JAXB. This allows for more complex configuration elements in the future jOOQ-codegen can now handle multi-schema databases and generate code for tables referencing tables from other schemata. This is integration tested against the SQL Server AdventureWorks database jOOQ now allows to generate simple POJOs in addition to Records and to annotate both POJOs and Records with JPA annotations such as @Entity, @Table, @Id, @Column, @UniqueConstraint, etc. · You can migrate your existing .properties configuration by running org.jooq.util.GenerationTool /your.properties migrate · Besides that, there is a lot of ongoing work to improve the integration of Oracle's TABLE and VARRAY types. Features and improvements: · Add JPA annotations to generated POJOs / Records
2.0.3	Feb 6, 2012	New Release	This release focuses on increased compatibility between various SQL dialect integrations as far as ARRAY and JOIN support is concerned: · ARRAY types are only available in H2, HSQLDB, Oracle, Postgres. Nevertheless, they can be somewhat simulated in other dialects using nested selects with UNION ALL. Increased compatibility leads to a nicer API, where ARRAYs are used along with ALL/ANY quantifiers, for instance. · JOIN syntaxes can be quite powerful in SQL. Apart from simulating NATURAL JOIN, JOIN USING clauses, as well as a synthetic "KEY JOIN" syntax, jOOQ now also supports nesting · JOIN expressions to create more complex table sources. Features and improvements: · 578 - Add KEY JOIN syntax to simulate joining using generated · foreign keys · 577 - Simulate NATURAL JOIN syntax, where this is unavailable · 582 - Simulate JOIN USING syntax, where this is unavailable · 671 - Allow for nesting JOIN clauses · 676 - Add Table.join() methods to create more flexible table · sources
2.0.2	Jan 10, 2012	New Release	The main improvements include: · The whole jOOQ API is now annotated with a new org.jooq.Support annotation to help you assess whether a certain SQL clause is available in your database or not. This is particularly useful when your application should support several databases at once (e.g. MySQL, Postgres, Oracle) · The Oracle PIVOT clause is now formally supported for advanced statistical queries in Oracle. This clause will be simulated in other dialects in the future. · The DATE data type can be mapped to TIMESTAMP. This important when you query a legacy Oracle database, where DATE columns can also contain time information · Several convenience methods have been added for more fluent syntax, when using plain SQL result queries, subqueries as tables, or when unnesting arrays in ANY() and ALL() quantifiers Features and improvements: · Add support for Oracle's PIVOT clause · Add support for using ANY, ALL with arrays, not just with subselects
1.7.0	Nov 28, 2011	New Release	· Bug fixes · SelectConditionStep should extend SelectConnectByStep, not SelectGroupByStep · AbstractRecord.into() fails to convert java.sql.Date into java.util.Date · In the event of name clash (same name for table and field) generated code has errors · Calling UpdatableRecord.setValue() twice with the same argument causes the changed flag to be reset to false · Always set the changed flag to true in Record.setValue() · Empty Password for jooq-codegen-maven causes NPE
1.6.5	Aug 29, 2011	New Release	Features and improvements: · Add Result.exportXML() to retrieve a DOM document similar to that of .formatXML() · Add support for loading of CSV data into tables · Add List fetch(int, Class) and fetch(String, Class) convenience methods · Add support for INSERT .. RETURNING or simulate it where not available · Add T[] fetchArray(int, Class) and fetchArray(String, Class) convenience methods · Add T fetchOne(int, Class) and fetchOne(String, Class) convenience methods