Re: [Hibernate-devel] progress problem (attn: phillip baird)

[Phillip B. <phi...@cl...>]

The stack trace reported is...

java.sql.SQLException: [JDBC Progress Driver]:-20217
at com.progress.sql.jdbc.JdbcProgressConnection.prepareStatement(JdbcProgressConnection.java:518)
at com.progress.sql.jdbc.JdbcProgressConnection.prepareStatement(JdbcProgressConnection.java:466)
at cirrus.hibernate.impl.RelationalDatabaseSession.getPreparedStatement(RelationalDatabaseSession.java:1776)
at cirrus.hibernate.impl.ClassPersister.insert(ClassPersister.java:570)
at cirrus.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:22)
at cirrus.hibernate.impl.RelationalDatabaseSession.executeAll(RelationalDatabaseSession.java:1210)
at cirrus.hibernate.impl.RelationalDatabaseSession.flush(RelationalDatabaseSession.java:1195)
at testhiber.TestHiber.main(TestHiber.java:25)

The number 20217 looks to be an error code which is documented in the 
Progress SQL-92 reference as...

20217 Connection exception Network error on server.

See http://www.progress.com:6336/dynaweb/psdoc91c/sql9291c/s92 for more 
details.

The Progress Knowledge base this to say about this error.  Maybe Gavin 
can advise why so many cursors may be open?

<quote>
Kbase Id: 19878

Title: Limiting the Number of Cursors in SQL-92
Creation: 15-Jun-2000
Modified: 13-Mar-2001

SUMMARY:

The Progress Version 9.x SQL-92 engine has a limit of 50 open cursors
for a given connection. This limitation has been logged as Progress
bug 20000331-019.

When you access the SQL-92 engine from an application you may receive
the error 20217:

     Connection Exception. Network error on server"

It means the application is dynamically opening more than 50 cursors
at once.

SOLUTION:

You must modify your code to limit cursors opened by the application
to the database to less than 50. There is no possible parameter inside
of the SQL-92 engine to resolve the problem at this time.

The Progress SQL-92 Guide and Reference manual will provide you with a
description of what a cursor is and how to open and close them.
</quote>

PhillipB


Gavin_King/Cirrus%CI...@ci... wrote:

>Does Phillip or anyone else who has used Progress does have any idea about
>this problem:
>
>http://sourceforge.net/tracker/index.php?func=detail&aid=545543&group_id=40712&atid=428708
>
>I will try to replicate the bug sometime in the next couple of days, but
>perhaps there is a simple solution....
>
>Thanks
>
>Gavin
>