Torque issue with Record.getValue() using jtds jdbc driver for sqlserver
------------------------------------------------------------------------
Key: TORQUE-152
URL: https://issues.apache.org/jira/browse/TORQUE-152
Project: Torque
Issue Type: Bug
Components: Runtime, Village
Affects Versions: 3.3
Environment: windows xp
Reporter: Sethuraman Ramasubramanian
Fix For: 3.3
This is my code that cause a problem:
Criteria crit=new Criteria();
crit.addSelectColumn(FilingDtlsPeer.FILING_NO);
crit.addJoin(FilingDtlsPeer.FILING_NO,CmpnyFilingPeer.FILING_NO);
crit.addJoin(CmpnyFilingPeer.COMPANY_ID,CompanyPeer.COMPANY_ID);
crit.add(CmpnyFilingPeer.COMPANY_ID,5);
List<Record> toBeFiledDtls=BasePeer.doSelect(crit);
for(Record r : toBeFiledDtls){
System.out.println(r);
System.out.println(r.getValue(FilingDtlsPeer.FILING_NO));
}
At this line "System.out.println(r.getValue(FilingDtlsPeer.FILING_NO));" I get
an error - Column name: filing_no does not exist!
The reason behind this is resultmetadata .getTableName() returns back an empty
string from jtds.
This is used in QueryDataSet(Connection conn, String
selectStmt)->schema.populate(resultSet.getMetaData(), null)->col.populate(meta,
i, tableName);->this.tableName = rsmd.getTableName(columnNumber)
Since this tablename is null, in Record.getValue(String
columnName)->index(columnName)->index(table,colname) - Over here it fails to
find the table name and fails.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
