CastorSocProjects

Title

Improve Castor DDL Generator

Keywords

Java, SQL

Description

At the moment DDL Generator is able to generate almost all SQL schema objects for various database engines into a file from Castor mapping. But there is still some space for improvements like:

• Improve mapping to allow specification of additional information needed by ddlgen
  
• Use Class- and FieldDescriptor's instead of directly accessing classes of org.exolab.castor.mapping.xml classes
  
• Replace org.castor.ddlgen.Configuration by org.castor.util.Configuration
  
• Replace PrintStream and StringBuffer by a Writer implementation
  
• Execute script on database engine
  
• Extract ordering strategies of DDL statements into an interface with 2 implementations
  
• Add a advanced ordering strategy for DDL statements that takes relations into account
  
• Merge multiple mappings to same table
  
• Resolve collisions of name/many-key defintions at generation of n:m relation tables
  
• Generate lookup table for HIGH-LOW keygenerator

Mentor(s)

Ralf Joachim (rjoachim AT codehaus DOT org)
Werner Guttmann (wguttmn AT codehaus DOT org)

Title

Implement new OQL query engine for Castor (Part 1)

Keywords

Java, OQL, ANTLR

Description

The first part of the OQL query engine project contains 2 subtasks:

• Create class hierarchy to define OQL queries programmaticaly also know as  "query objects".
  
• Analyze properties of a given example entity and transform it into "query objects". This approach is known as "query by example".

Mentor(s)

Ralf Joachim (rjoachim AT codehaus DOT org)
Werner Guttmann (wguttmn AT codehaus DOT org)

Title

Implement new OQL query engine for Castor (Part 2)

Keywords

Java, OQL, ANTLR

Description

The second part of the OQL query engine project also contains 2 subtasks and depends on the first:

• Parse queries with current CastorQL syntax using ANTLR and transform them into "query objects".
  
• Parse queries with EJB QL syntax using ANTLR and transform them into "query objects".

Mentor(s)

Ralf Joachim (rjoachim AT codehaus DOT org)
Werner Guttmann (wguttmn AT codehaus DOT org)