[
https://issues.apache.org/jira/browse/TUSCANY-1220?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Adriano Crestani closed TUSCANY-1220.
-------------------------------------
Resolution: Won't Fix
DAS C++ is no more using the class Database.
> FK columns name retrieved by dbms contain invalid characters
> ------------------------------------------------------------
>
> Key: TUSCANY-1220
> URL: https://issues.apache.org/jira/browse/TUSCANY-1220
> Project: Tuscany
> Issue Type: Task
> Components: C++ DAS
> Reporter: Adriano Crestani
> Priority: Minor
> Fix For: Cpp-Next
>
>
> The method ResultSet* Database::getFKs(std::string tableName) const returns a
> ResultSet containing information about the tableName foreign keys. When
> getting specially the pk column name and fk column name, it is returning the
> column name surrounded by " ' ". For example:
> std::cout << "FK Column Name = " << fksResultSet->getSQLVarchar(7); // 7th
> column contains the fk column name
> std::cout << "\nPK Column Name = " << fksResultSet->getSQLVarchar(3); // 3th
> column contains the fk column name
> std::cout << "\nPK Table Name = " << fksResultSet->getSQLVarchar(2); // 2nd
> column contains the pk table name
> output:
> FK Column Name = 'COMPANY_ID'
> PK Column Name = 'ID'
> PK Table Name = DEPARTMENT
> As seen on the output, only the pk and fk column name are surrounded by " ' "
> . I'm actually solving this problem removing the " ' " from the string:
> std::string fkColumnName = fksResultSet->getSQLVarchar(7);
> std::string pkTableName = fksResultSet->getSQLVarchar(2);
> std::string pkColumnName = fksResultSet->getSQLVarchar(3);
> fkColumnName = fkColumnName.substr(1, fkColumnName.size() - 2);
> pkColumnName = pkColumnName.substr(1, pkColumnName.size() - 2);
> I'm using MySQL server. I don't know if it happens only with MySQL server or
> if there are others which do the same.
> I propose to test it using others DBMSs to test if it happens only on MySQL
> server or not.
--
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
