[
https://issues.apache.org/jira/browse/TORQUE-152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15094242#comment-15094242
]
Petr Bodnar commented on TORQUE-152:
------------------------------------
Hi, are you sure this is really fixed? I'm also not quite sure about the bug
description, because I don't (logically?) get the error "Column name: filing_no
does not exist!" (to quote), but rather "Column name: <tableName>.filing_no
does not exist!".
Moreover, this doesn't seem to be specific just to SqlServer over JTDs, or is
it?
> 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
> Assignee: Thomas Vandahl
> Fix For: 3.3.1
>
> Original Estimate: 120h
> Remaining Estimate: 120h
>
> 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 was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
