Hi,
I have some questions about hibernate. First of all, my company has a as400 with database db2. The database isn't relational database. Then, it's good idea work with hibernate?

This database has libraries and inside this libraries has tables.

LIBRARY
|
|---Table1
|---Table2

When I do a query with sql with ODBC or JDBC the syntax is "SELECT * FROM LIBRARY.TABLE"
I can do the same with hibernate??? Moreover, I can have a class that represents LIBRARY??? I want to have the same organitation between libraries and tables.

Thanks,
SERGI

If I understand correctly, a "library" is what we call "schema".

Other people are using DB2 on AS400.

Which drivers are you using ? The JTOpen drivers? If so this is how we have it configured. then you can just select results like so :

select * from table

and you do not need to specific the schema or library name.


jdbc:as400://SERVERNAME;libraries=lib1,lib2;naming=system;server name=SERVERNAME;database name=DBNAME;

You can get these driver from :

http://www-124.ibm.com/developerworks/oss/jt400/

Mike

Are you using 2E or Cool:Plex programs?

OK
Yes, I have the JTOpen library from IBM.

my hibernate.properties is

hibernate.connection.driver_class = com.ibm.as400.access.AS400JDBCDriver
hibernate.connection.url = jdbc:as400://192.168.xx.xx/library
hibernate.dialect=net.sf.hibernate.dialect.DB2Dialect

I have tryed with jdbc:as400://192.168.xx.xx;libraries=lib1,lib2; and i haven't got any problems. It's fantastic!

Thanks. One question, what is 2E or COOL:PLEX????