About Site Map Submit Contact Us Log in | Create an account
Create an account Log In
Average Rating
User Rating:
Visitors Rating:
My rating:

Write review
  • License: Freeware
  • Last update: 5 years ago
  • Total downloads: 81
  • Price: Free |
  • Operating system: Win All
  • Publisher: Lukas Eder (4 other programs)
See full specifications

windows default iconjOOQ Publisher's description

jOOQ stands for Java Object Oriented Querying

jOOQ stands for Java Object Oriented Querying. It combines these essential features:

Code Generation:
jOOQ generates a simple Java representation of your database schema. Every table, view, stored procedure, enum, UDT is a class.

Active records:
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.

Typesafe SQL:
jOOQ allows for writing compile-time typesafe querying using its built-in DSL.

SQL standard:
jOOQ supports all standard SQL language features including the more complex UNION's, nested SELECTs, joins, aliasing

Vendor-specific feature support:
jOOQ encourages the use of vendor-specific extensions such as stored procedures, UDT's, ARRAY's and many more.

What's New in This Release:

В· Add support for Oracle ROWID data type
В· PORTABILITY: Create a super-set of RDBMS data types
В· PORTABILITY: Don't create dialect-specific QueryParts
В· Add support for the Oracle CONNECT BY clause
В· Add optional OFFSET clause to form LIMIT .. OFFSET
В· constructs
В· Add extended FOR UDPATE [OF ...] [{WAIT n | NOWAIT | SKIP
В· LOCKED }] support
В· Add support for LEAD() OVER() and LAG() OVER() window
В· functions
В· Add support for the CUME_DIST() OVER() window function
В· Add Factory.literal() convenience methods
В· Add Factory.val() methods to decrease .constant()
В· verbosity
В· Add support for RESPECT NULLS clause in some window
В· functions
В· Add Factory.use(String) for non-generated schemata
В· Add PI function
В· Add Factory.two() literal convenience method
В· Add support for Oracle CONNECT BY pseudo-columns LEVEL,

API changes:
В· PORTABILITY: Create a dialect-independent meta-model
В· Add OVER() keyword to FIRST_VALUE() and LAST_VALUE() API

Test cases:
В· Add in...

System Requirements:

jOOQ runs with Java 1.6+
Program Release Status: Major Update
Program Install Support: Install and Uninstall

Is jOOQ your software?

Manage your software

Most Popular

windows default icon Apache Tomcat 7.0.41
Apache Tomcat is an open source software implementation of the Java Servlet and JavaServer Pages technologies.... Read more
windows default icon WampServer 2.4
WampServer is a Windows web development environment.
windows default icon PS3 Media Server 1.81.0
PS3 Media Server is a DLNA compliant Upnp Media Server for the PS3, written in Java, with the purpose ... Read more
windows default icon TwonkyMedia Server 7.0.7
TwonkyServer makes it possible for your devices to retrieve your media files from wherever they're stored... Read more
windows default icon AnjLab.SqlProfiler 1.1.1423.75
The express edition of Microsoft SQL Server 2005/2008 is free.

Related Category

» FTP Servers (61)
» Mail Servers (122)
» News Servers (5)
» Web Servers (126)