Hi,
I am executing a custom SQL using the createResultsetSQL() method of the workspace class in my service handler.
When trying to retrieve the column values in the resultset, I am having to give the column name in a specific format. I believe the workspace class converts the column names to the database specific format and when retrieving the values from the result set, the case of the column name should not matter. What is more baffling is that the format of the column name that we have to use to retrieve the value is varying from dev environment to test which is causing the code working in one env failing in the other.
Below is the snippet of code that I am using.
| | try { |
| | Resultset rs = this.m_workspace.createResultSetSQL("select Divisionid, branchID from branches"); |
| | } |
| | catch (DataException de) { |
| | | |
| | } |
| | DataResultSet drs = new DataResultSet(); |
| | drs.copy(rs); |
| | |
| | String divisionid = ResultSetUtils.getValue(drs, "DIVISIONID"); |
| | String branchid = ResultSetUtils.getValue(drs, "branchid"); |
To retrieve the values from the resultset, I have to give the column names as "DIVISIONID", "branchid" in one environment and as "DivisionID", "branchID" in the other. This is UCM 11G using Oracle 11G as the database. Is there any configuration that is causing this issue?
Any pointers to help me resolve this mystery are much appreciated.
Thank you,
bssr.