[jira] [Updated] (TORQUE-152) Torque issue with Record.getValue() using jtds jdbc driver for sqlserver
[ https://issues.apache.org/jira/browse/TORQUE-152?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas Vandahl updated TORQUE-152: -- Fix Version/s: (was: 3.3) 3.3.1 > 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 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. For more information on JIRA, see: http://www.atlassian.com/software/jira - To unsubscribe, e-mail: torque-dev-unsubscr...@db.apache.org For additional commands, e-mail: torque-dev-h...@db.apache.org
[jira] [Resolved] (TORQUE-152) Torque issue with Record.getValue() using jtds jdbc driver for sqlserver
[ https://issues.apache.org/jira/browse/TORQUE-152?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas Vandahl resolved TORQUE-152. --- Resolution: Incomplete As I see no response, I mark this as resolved > 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 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. For more information on JIRA, see: http://www.atlassian.com/software/jira - To unsubscribe, e-mail: torque-dev-unsubscr...@db.apache.org For additional commands, e-mail: torque-dev-h...@db.apache.org