Faster development. Full flexibility¶

• Not a traditional ORM. You write the SQL. This allows you to hand tune any query, even after deployment, is faster than configuring some obscure XML syntax.
• Automatic resource handling. Never forget to close Statement, ResultSet, Connection, etc.
• Named parameters in SQL
• Full freedom on class design. O/R Broker does not place any limitations on how you design your classes. No conventions to conform to. No classes to extend. No interfaces to implement. No annotations to apply. No restrictions whatsoever.
• Full support for JOIN queries, both one-to-one and one-to-many.
• No N+1 select problem and no transactionally inconsistent lazy loading
• Support for stored procedure calls.
• You write the query-to-object extractor code in Scala (or Java). No tired old XML mapping needed.
• SQL can be in code or, preferably, in simple text files, ready for editing and optimizing if needed.
• Dynamic SQL using Velocity or FreeMarker template engines. Both are supported, but neither are required.
• Dealing with new database schema, legacy schema, JavaBeans, or immutable classes? All possible, full flexibility.

<sub>YourKit is kindly supporting open source projects with its full-featured Java Profiler.

YourKit, LLC is the creator of innovative and intelligent tools for profiling Java and .NET applications.

Take a look at YourKit's leading software products: YourKit Java Profiler and YourKit .NET Profiler.</sub>