Consultor Eletrônico

Status: Unverified

FACT(s) (Environment):

Progress 9.x
OpenEdge 10.x

SYMPTOM(s):

Error 7182 when calling the getColumnLabel function from a Java Open Client

A not supported result set method. (7182)

The exception thrown is:

com.progress.open4gl.ProSQLException: A not supported result set method. (7182)

CAUSE:

This is expected behavior. The getColumnLabel function is only supported with the Java SDOResultSet object.

FIX:

In order to work around this limit, there are 2 options:

1. Use the GetColumnName function instead:

java.sql.ResultSetMetaData meta = custorder.getMetaData();
String sColumnName = meta.getColumnName(1);
System.out.println(sColumnName);

or

2. Use the Java SDOResultSet object.