When i try to use Progress Database 9.1 with SQL-92 and SqlDialect with the hibernate 2.1.1 demo eg, i obtain this message during commit transaction:

[java] java.sql.SQLException: [JDBC Progress Driver]:Data type for parameter 5 has changed since first SQLExecute call.
[java] at com.progress.sql.jdbc.JdbcProgress.createSQLException(JdbcProgress.java:6501)
[java] at com.progress.sql.jdbc.JdbcProgress.standardError(JdbcProgress.java:6675)
[java] at com.progress.sql.jdbc.JdbcProgress.SQLExecute(JdbcProgress.java:2789)
[java] at com.progress.sql.jdbc.JdbcProgressPreparedStatement.execute(JdbcProgressPreparedStatement.java:238)
[java] at com.progress.sql.jdbc.JdbcProgressPreparedStatement.executeUpdate(JdbcProgressPreparedStatement.java:144)
[java] at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
[java] at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:469)
[java] at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:443)
[java] at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)
[java] at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2308)
[java] at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2261)
[java] at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2187)
[java] at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
[java] at org.hibernate.auction.Main.createTestAuctions(Main.java:342)
[java] at org.hibernate.auction.Main.main(Main.java:371)
Any idea ?
Thanks per advance.[quote][/quote]

Have absolutely no idea. I guess you'll need to do some digging, there aren't very many progress users here, I think.

Add a parameter in Progress database url : ;wa=536870912

example : hibernate.connection.url jdbc:jdbcprogress:T:localhost:3500:test;wa=536870912

It solve the problem.