You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by "Sethuraman Ramasubramanian (JIRA)" <ji...@apache.org> on 2010/10/17 18:27:22 UTC
[jira] Created: (TORQUE-152) Torque issue with Record.getValue()
using jtds jdbc driver for sqlserver
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
[jira] Commented: (TORQUE-152) Torque issue with Record.getValue()
using jtds jdbc driver for sqlserver
Posted by "Sethuraman Ramasubramanian (JIRA)" <ji...@apache.org>.
[ 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.
Thanks
Sethu
> 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
[jira] Commented: (TORQUE-152) Torque issue with Record.getValue()
using jtds jdbc driver for sqlserver
Posted by "Thomas Fox (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/TORQUE-152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12925756#action_12925756 ]
Thomas Fox commented on TORQUE-152:
-----------------------------------
the svn url is https://svn.apache.org/repos/asf/db/torque/village/trunk. No user and password is required.
> 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
[jira] Assigned: (TORQUE-152) Torque issue with Record.getValue()
using jtds jdbc driver for sqlserver
Posted by "Thomas Vandahl (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/TORQUE-152?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas Vandahl reassigned TORQUE-152:
-------------------------------------
Assignee: Thomas Vandahl
> 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
[jira] Commented: (TORQUE-152) Torque issue with Record.getValue()
using jtds jdbc driver for sqlserver
Posted by "Thomas Vandahl (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/TORQUE-152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12924208#action_12924208 ]
Thomas Vandahl commented on TORQUE-152:
---------------------------------------
Would you please try to check out the current trunk of Village and see if this issue still applies? I made a couple of changes recently and I remember something similar being addressed.
> 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
>
> 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