Re: Connection Pooling/JDBC Connections

[Thorbjørn Ravn Andersen <ravn@xxxxxxxxxx>]

James Perkins skrev:
> Thanks Sarah!
>
> I guess I should really start looking at some of these persistence libraries
> a better look ;-)
>
> Has anyone successfully used any of these on a System i?
> - persist http://code.google.com/p/persist/
> - EoD SQL https://eodsql.dev.java.net/
> - Ebean http://www.avaje.org/
>
>   
It is my experience that DB2/400 is an uncommon database for Java folks, 
so you should start with ensuring that it is supported.

I have no experience with the projects you mention, but I have 
successfully used Hibernate with DB2/400.   I used MyEclipse (30 day 
trial available) to generate the Java beans from the database tables - I 
found that you most likely need to hint what the indexes are as the 
database layer often is not told what record level access programs use 
to index.