P
progresscommunities@progr
Guest
Hello,
I am trying to use Hibernate to build mapping files against an existing Progress database. I'm told that there are established foreign key relationships between tables. However, when I run the hibernate-tools against the database I do not see any of these relationships.
I've also tried something similar to the following, which should return something but does not:
Connection dbConn = DriverManager.getConnection('jdbc:datadirectpenedge://my.server.local:2600;databaseName=name;DIL=READ UNCOMMITTED;AS=500','user','pass');
DatabaseMetaData meta = dbConn.getMetaData();
ResultSet pks = meta.getPrimaryKeys('name','pub','table'); // this returns stuff
ResultSet ifks = meta.getImportedKeys('name','pub','table'); // this does not
ResultSet efks = meta.getExportedKeys('name','pub','table'); // neither does this
What I end up getting w/ Hibernate are mapping files describing each table, including the primary key for each table, but I don't get any of the one-to-many or many-to-many relations. Adding them by hand works but this defeats the purpose.
The driver version I am using is whatever comes with 11.1.
Any ideas?
-Will
Continue reading...
I am trying to use Hibernate to build mapping files against an existing Progress database. I'm told that there are established foreign key relationships between tables. However, when I run the hibernate-tools against the database I do not see any of these relationships.
I've also tried something similar to the following, which should return something but does not:
Connection dbConn = DriverManager.getConnection('jdbc:datadirectpenedge://my.server.local:2600;databaseName=name;DIL=READ UNCOMMITTED;AS=500','user','pass');
DatabaseMetaData meta = dbConn.getMetaData();
ResultSet pks = meta.getPrimaryKeys('name','pub','table'); // this returns stuff
ResultSet ifks = meta.getImportedKeys('name','pub','table'); // this does not
ResultSet efks = meta.getExportedKeys('name','pub','table'); // neither does this
What I end up getting w/ Hibernate are mapping files describing each table, including the primary key for each table, but I don't get any of the one-to-many or many-to-many relations. Adding them by hand works but this defeats the purpose.
The driver version I am using is whatever comes with 11.1.
Any ideas?
-Will
Continue reading...