Kbase P117326: JDBC clients on Windows have better performance when fetching records than JDBC clients on Linux
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/07/2006 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1E
Windows
Linux Intel
SYMPTOM(s):
JDBC clients on Windows have better performance when fetching records than JDBC clients on Linux
The database is located on Linux
This happens when the query is run from different Java threads
The problem does not appear in OpenEdge 10.0B
This does not occur in OpenEdge 10.1A using the Type 4 JDBC driver
CAUSE:
This is a known issue being investigated by Development
FIX:
Upgrade to OpenEdge 10.0B and later.
The client and the server need to be upgraded since OpenEdge 10 SQL client can only connect to OpenEdge 10 database.
If upgrading is not option, change the following parameter when calling the createStatement method:
Statement stmt = con.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);