Loading...

torque-dev@db.apache.org

[Prev] Thread [Next]  |  [Prev] Date [Next]

[jira] [Updated] (TORQUE-152) Torque issue with Record.getValue() using jtds jdbc driver for sqlserver Thomas Vandahl (JIRA) Thu Apr 14 15:00:11 2011

     [ 
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<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.
For more information on JIRA, see: http://www.atlassian.com/software/jira

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]