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] Commented: (TORQUE-152) Torque issue with Record.getValue() using jtds jdbc driver for sqlserver
Date Wed, 27 Oct 2010 17:23:21 GMT

    [ https://issues.apache.org/jira/browse/TORQUE-152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12925469#action_12925469

Sethuraman Ramasubramanian commented on TORQUE-152:

Thomas, I took the latest from SVN for torque but I couldnt find any difference between what
I have and whats in the SVN. I checked Record.java alone and there was no difference between
what I had except for a small fix with a result set not being closed in Record.refresh().
I was unable to check other files in village because I am not sure about the SVN URL. I used
this URL but Eclipse subversive failed to get anything http://svn.apache.org/viewvc/db/torque/village/trunk/.

Could you tell me the SVN URL to use please? And what is the user ID and password if any is
required. I will check the remaining classes of village for any difference with what I have
and revert.


> 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
>   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.
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

View raw message