About : BIRT JPA or JDO Connector

Abstract

The Java Persistence API (JPA)is the Java API for the management of persistence and object/relational mapping for Java EE and Java SE environments. The persistence consists of three areas:

   * the API, defined in the javax.persistence package
   * the Java Persistence Query Language
   * object/relational metadata

The purpose of this project proposal is to implement a Connector JPA for BIRT framework, and so able to handle data source from the persistence API. Is so great the importance of the project because JPA is a specification that is being used widely in the development of applications, precisely from the advantages it.

The implemntation is to make the JPA ODA driver, extending each one of the interface required in the Data Tools Plataform given in the package org.eclipse.datatools.connectivity.oda.

Finalizing it first part will be an improvement approaching also advanced options in regard to the parameters and also will be implemented JPA ODA IU extensions.

Participants

• Student: Victoriano Alfonso Phocco Diaz <vphocco@gmail.com> - http://alfonso777.blogspot.com/
• Mentor: Jason Weathersby - http://www.blogger.com/profile/13114050439576571984

http://eclipse.sys-con.com/author/jasonweathersby.htm

• CVS:

Planned Features

1. Handling of configuration file: persistence.xml.
2. JPA utilities for get current EntityManager and EntityManagerFactory
3. JPQL queries validation.
4. Get the metadata information such as column names, column types, column class for the query .
5. Instantiation of ResulSetMetaData, DataSetMetaData, ResulSet.
6. Soport in the preparement and execution of Queries.
7. Working good with the implementations de JPA: Hibernate and TopLink.

Should Have

• Handling of other configuration file: orm.xml
• Soport more advance of Parameters into queries.

• • Code snippets

Nice to have

• Soport JDO and JPA at the same time.

Community proposals

Feel free to add your comments and ideas.

Getting the source

Download the source from SourceForge Eclipse Incubator.

ViewCVS: eclipse-incub.cvs.sourceforge.net/eclipse-incub/org.eclipse.wst.xquery [1]

CVS: eclipse-incub.cvs.sourceforge.net/cvsroot/eclipse-incub/org.eclipse.wst.xquery

References

BIRT References

• http://www.w3.org/XML/Query
• http://www.w3.org/TR/xquery-11-requirements
• http://www.w3.org/TR/xpath20
• http://www.w3.org/TR/xpath-datamodel
• http://www.w3.org/TR/xquery-use-cases
• http://www.w3.org/TandS/QL/QL98/pp/xql.html

JPA References

• http://www.antlr.org
• http://www.exist-db.org
• http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.php.core