I'm trying to use the tools and database : PROGRESS 9.1D and eclipse hibernate plug-in 3.1.0 but the reverse engeneering doesn't work and i can't see any error. Any suggest?

Thx in advance

what does "it does not work" mean ?

When i'm try the reverse-eng i get the err below, any suggest?. Thx in advance

Error 2006-02-15 16:57:41.703 java.sql.SQLException: [JDBC Progress Driver]:Column _Desc in table PUB._File has value exceeding its max length or precision.
java.sql.SQLException: [JDBC Progress Driver]:Column _Desc in table PUB._File has value exceeding its max length or precision.
at com.progress.sql.jdbc.JdbcProgress.createSQLException(JdbcProgress.java:6650)
at com.progress.sql.jdbc.JdbcProgress.standardError(JdbcProgress.java:6843)
at com.progress.sql.jdbc.JdbcProgress.SQLPrimaryKeys(JdbcProgress.java:4699)
at com.progress.sql.jdbc.JdbcProgressDatabaseMetaData.getPrimaryKeys(JdbcProgressDatabaseMetaData.java:2983)
at com.mchange.v2.c3p0.impl.NewProxyDatabaseMetaData.getPrimaryKeys(NewProxyDatabaseMetaData.java:3036)
at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect.getPrimaryKeys(JDBCMetaDataDialect.java:239)
at org.hibernate.cfg.reveng.JDBCReader.processPrimaryKey(JDBCReader.java:281)
at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:71)
at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter$1.execute(LazyDatabaseSchemaWorkbenchAdapter.java:79)
at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35)
at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.readDatabaseSchema(LazyDatabaseSchemaWorkbenchAdapter.java:70)
at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.getChildren(LazyDatabaseSchemaWorkbenchAdapter.java:39)
at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.getChildren(LazyDatabaseSchemaWorkbenchAdapter.java:31)
at org.hibernate.eclipse.console.workbench.BasicWorkbenchAdapter.fetchDeferredChildren(BasicWorkbenchAdapter.java:70)
at org.eclipse.ui.progress.DeferredTreeContentManager$1.run(DeferredTreeContentManager.java:192)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:76)

this error sounds like a bug in either the database or the driver.

try and limit the reverse engineering to tables you want to reverse engineer and see if you can avoid this weird table.

Hi Max,
ENV: PROGRESS 9.1E and eclipse 3.2 and hibernate plug-in 3.1.0

ok the problem before was about the file on progress and we fix that, but now the error during reverse eng is:

Warning 2006-02-16 10:37:35.31 WARN Worker-41 org.hibernate.cfg.JDBCBinder - Rev.eng. strategy did not report any primary key columns for BD_TpsData


for each table!
I used the JDBC driver alone in Aqua Studio and the primary key are found.

Any suggest?

Thx in advance.

i havent tested with Progress (don't know if it is even available anywhere?)

but if it does not find it is either because of:

a) the driver does not return any columns when asking for primarykey
b) the driver does not handle mixed cased identifier names consistently.

...i'm getting more and more of these and i'll need to find a pattern of these since i'm really just handing the driver the same table name to the getPrimaryKeys methods as i received when asking for the tables.

Hi,

also with the Oracle 9 i get the same error on the primary key?!

Thx in advance

well, then there isn't a primary key defined ;)

...show me the SQL you used to create the table.

Hi Max,

be patient please..

the primary key is defined and a the end we see all the db schema! But now we want to exclude one table from a rev eng and we used the table filter but it seems doesn't work?!

I do a try on a small MySql DB and the result i that the rev eng generate all table java class and not only one as i asked.

Any suggest?

i'm apologize if i'm not using the forumin a right way...

Thx in advance.

Hi all progress-hibernate user,

this problem can be resolved:

Error 2006-02-15 16:57:41.703 java.sql.SQLException: [JDBC Progress Driver]:Column _Desc in table PUB._File has value exceeding its max length or precision.
java.sql.SQLException: [JDBC Progress Driver]:Column _Desc in table PUB._File has value exceeding its max length or precision.

modifing the sql-witdh of the progress sql server because it just says how much the max. length for the content is...

have a good try!

Hi Max,

the primary key is defined and a the end we see all the db schema! But now we want to exclude one table from a rev eng and we used the table filter but it seems doesn't work?!

I do a try on a small MySql DB and the result i that the rev eng generate all table java class and not only one as i asked.

Any suggest?

Thx in advance.

how does your hibernate.properteis/cfg.xml and reveng.xml look like ?