db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sethuraman Ramasubramanian (JIRA)" <j...@apache.org>
Subject [jira] Created: (TORQUE-152) Torque issue with Record.getValue() using jtds jdbc driver for sqlserver
Date Sun, 17 Oct 2010 16:27:22 GMT
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: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message