Ingres Community Blogs

The Ingres dialect for SQLAlchemy 0.6 is now available through SVN from [url=http://code.ingres.com/apps/SQLAlchemy]http://code.ingres.com/apps/SQLAlchemy[/url].

SQLAlchemy is an ORM framework for Python, allowing Python objects to be direclty mapped to database tables.

Ingres has a DBI driver for Python; this is available for download from [url=http://esd.ingres.com]http://esd.ingres.com[/url] or from the Ingres Subversion repository ([url=http://code.ingres.com/ingres/drivers/python]http://code.ingres.com/ingres/drivers/python[/url])....

I thought I'd post a link to an article about the new features in the JPA 2.0 spec, written by Kevin Sutter, who also contributes to OpenJPA. [URL="http://www.ibm.com/developerworks/websphere/techjournal/0909_col_sutter/0909_col_sutter.html"]Check out the article here[/URL].

I've also been working with the Python ORM framework [URL="http://www.sqlalchemy.org/"]SQLAlchemy[/URL]. This has a basic dialect for Ingres 9.2 now, which we hope to release to the community...

The Ingres Dictionary for OpenJPA is now part of the main Apache OpenJPA release (trunk and version 1.3.0). Download it now from [url=http://openjpa.apache.org]openjpa.apache.org[/url].

To use Ingres as the data store, set the openjpa.ConnectionDriverName property to com.ingres.jdbc.IngresDriver and the openjpa.ConnectionURL property to the Ingres JDBC URL. You can also set openjpa.ConnectionUserName and openjpa.ConnectionPassword if required. Finally ensure that the iijdbc.jar...

A few weeks ago, I posted a little bit of information about Maven.

Since then I found a very good reference for Maven: [URL="http://www.sonatype.com/books/maven-book/reference/"]Maven: The Definitive Guide[/URL] by Sonatype.

If you're a Java developer who is unfamiliar with Maven, I strongly recommend that you read it.

Java developers may be familiar with [url=http://maven.apache.org]Maven[/url], the dependency management and project lifecycle mananagement tool. It's really good at managing a structured project and best of all it automatically downloads and adds to the Java classpath any declared dependencies.

These dependency JARs are stored in Maven repositories and by default Maven only looks in the so-called "Central" repository, at [url=http://repo1.maven.org/maven2]repo1.maven.org/maven2[/url]....