3:27 p.m.
Mark Drilling created TEIID-1976:
------------------------------------
Summary: Metadata TYPE_NAME value is null for String Columns
Key: TEIID-1976
URL: https://issues.jboss.org/browse/TEIID-1976
Project: Teiid
Issue Type: Bug
Components: Common
Affects Versions: 8.0
Reporter: Mark Drilling
Assignee: Ramesh Reddy
The metadata TYPE_NAME value for string datatypes is apparently returning null. I am
running against a JBoss AS7.1Final server with Teiid 8.0Beta2.
My application (openshift web client) establishes connection from a DataSource, eg
connection = dataSource.getConnection(),
then resultSet = connection.getMetaData().getColumns();
when iterating thru the resultSet, the value for columnName="TYPE_NAME" is null
for string types. Other types seem to return a correct value.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:56 p.m.
[
https://issues.jboss.org/browse/TEIID-1976?page=com.atlassian.jira.plugin...
]
Ramesh Reddy updated TEIID-1976:
--------------------------------
Fix Version/s: 8.0
Metadata TYPE_NAME value is null for String Columns
---------------------------------------------------
Key: TEIID-1976
URL: https://issues.jboss.org/browse/TEIID-1976
Project: Teiid
Issue Type: Bug
Components: Common
Affects Versions: 8.0
Reporter: Mark Drilling
Assignee: Ramesh Reddy
Fix For: 8.0
The metadata TYPE_NAME value for string datatypes is apparently returning null. I am
running against a JBoss AS7.1Final server with Teiid 8.0Beta2.
My application (openshift web client) establishes connection from a DataSource, eg
connection = dataSource.getConnection(),
then resultSet = connection.getMetaData().getColumns();
when iterating thru the resultSet, the value for columnName="TYPE_NAME" is null
for string types. Other types seem to return a correct value.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:58 a.m.
[
https://issues.jboss.org/browse/TEIID-1976?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-1976:
-------------------------------------
Mark,
I do not see "getColumns" call on the DatabaseMetadata interface. Which version
of JDBC API are you using? I tried below, and it works correctly.
{code:JAVA}
ResultSetMetaData metadata = results.getMetaData();
int columns = metadata.getColumnCount();
System.out.println("Results");
for (int row = 0; row < columns; row++) {
System.out.print(metadata.getColumnName(row+1));
System.out.print("(");
System.out.print(metadata.getColumnTypeName(row+1));
System.out.print(")");
System.out.print(",");
}
{code}
Metadata TYPE_NAME value is null for String Columns
---------------------------------------------------
Key: TEIID-1976
URL: https://issues.jboss.org/browse/TEIID-1976
Project: Teiid
Issue Type: Bug
Components: Common
Affects Versions: 8.0
Reporter: Mark Drilling
Assignee: Ramesh Reddy
Fix For: 8.0
The metadata TYPE_NAME value for string datatypes is apparently returning null. I am
running against a JBoss AS7.1Final server with Teiid 8.0Beta2.
My application (openshift web client) establishes connection from a DataSource, eg
connection = dataSource.getConnection(),
then resultSet = connection.getMetaData().getColumns();
when iterating thru the resultSet, the value for columnName="TYPE_NAME" is null
for string types. Other types seem to return a correct value.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
noon
[
https://issues.jboss.org/browse/TEIID-1976?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-1976:
-------------------------------------
Sorry, did not see that was DatabaseMetaData. I was using ResultSetMetadta. Let me try the
other one.
Metadata TYPE_NAME value is null for String Columns
---------------------------------------------------
Key: TEIID-1976
URL: https://issues.jboss.org/browse/TEIID-1976
Project: Teiid
Issue Type: Bug
Components: Common
Affects Versions: 8.0
Reporter: Mark Drilling
Assignee: Ramesh Reddy
Fix For: 8.0
The metadata TYPE_NAME value for string datatypes is apparently returning null. I am
running against a JBoss AS7.1Final server with Teiid 8.0Beta2.
My application (openshift web client) establishes connection from a DataSource, eg
connection = dataSource.getConnection(),
then resultSet = connection.getMetaData().getColumns();
when iterating thru the resultSet, the value for columnName="TYPE_NAME" is null
for string types. Other types seem to return a correct value.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:22 p.m.
[
https://issues.jboss.org/browse/TEIID-1976?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-1976:
-------------------------------------
I tried below with couple different VDBs
{code:JAVA}
ResultSet results = connection.getMetaData().getColumns(null, null, null, null);
for (int row = 1; results.next(); row++) {
System.out.print(results.getString("TYPE_NAME"));
}
{code}
I did not see the behaviour you described. Please attach your VDB or test case.
Metadata TYPE_NAME value is null for String Columns
---------------------------------------------------
Key: TEIID-1976
URL: https://issues.jboss.org/browse/TEIID-1976
Project: Teiid
Issue Type: Bug
Components: Common
Affects Versions: 8.0
Reporter: Mark Drilling
Assignee: Ramesh Reddy
Fix For: 8.0
The metadata TYPE_NAME value for string datatypes is apparently returning null. I am
running against a JBoss AS7.1Final server with Teiid 8.0Beta2.
My application (openshift web client) establishes connection from a DataSource, eg
connection = dataSource.getConnection(),
then resultSet = connection.getMetaData().getColumns();
when iterating thru the resultSet, the value for columnName="TYPE_NAME" is null
for string types. Other types seem to return a correct value.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:06 a.m.
[
https://issues.jboss.org/browse/TEIID-1976?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1976:
---------------------------------------
Mark,
Can this be resolved as Not Reproducible, or do you have more information?
Metadata TYPE_NAME value is null for String Columns
---------------------------------------------------
Key: TEIID-1976
URL: https://issues.jboss.org/browse/TEIID-1976
Project: Teiid
Issue Type: Bug
Components: Common
Affects Versions: 8.0
Reporter: Mark Drilling
Assignee: Ramesh Reddy
Fix For: 8.0
The metadata TYPE_NAME value for string datatypes is apparently returning null. I am
running against a JBoss AS7.1Final server with Teiid 8.0Beta2.
My application (openshift web client) establishes connection from a DataSource, eg
connection = dataSource.getConnection(),
then resultSet = connection.getMetaData().getColumns();
when iterating thru the resultSet, the value for columnName="TYPE_NAME" is null
for string types. Other types seem to return a correct value.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:03 a.m.
[
https://issues.jboss.org/browse/TEIID-1976?page=com.atlassian.jira.plugin...
]
Mark Drilling commented on TEIID-1976:
--------------------------------------
I will take another look today and supply a VDB / code example if reproducible.
Metadata TYPE_NAME value is null for String Columns
---------------------------------------------------
Key: TEIID-1976
URL: https://issues.jboss.org/browse/TEIID-1976
Project: Teiid
Issue Type: Bug
Components: Common
Affects Versions: 8.0
Reporter: Mark Drilling
Assignee: Ramesh Reddy
Fix For: 8.0
The metadata TYPE_NAME value for string datatypes is apparently returning null. I am
running against a JBoss AS7.1Final server with Teiid 8.0Beta2.
My application (openshift web client) establishes connection from a DataSource, eg
connection = dataSource.getConnection(),
then resultSet = connection.getMetaData().getColumns();
when iterating thru the resultSet, the value for columnName="TYPE_NAME" is null
for string types. Other types seem to return a correct value.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:48 p.m.
[
https://issues.jboss.org/browse/TEIID-1976?page=com.atlassian.jira.plugin...
]
Mark Drilling updated TEIID-1976:
---------------------------------
Attachment: PortfolioVDB.vdb
attached the VDB I'm using.
Maybe doing something wacky in populating names and types, but other types work...
{code}
ResultSet resultSet = connection.getMetaData().getColumns(null, schemaName, tableName,
null);
int columnCount = resultSet.getMetaData().getColumnCount();
while (resultSet.next()) {
String columnName = null;
String columnType = null;
for (int i=1 ; i<=columnCount ; ++i) {
String colName = resultSet.getMetaData().getColumnName(i);
String value = resultSet.getString(i);
if (colName.equalsIgnoreCase("COLUMN_NAME")) {
columnName = value;
} else if(colName.equalsIgnoreCase("TYPE_NAME")) {
columnType = value;
}
}
columnNameList.add(columnName);
columnTypeList.add(columnType);
}
{code}
Metadata TYPE_NAME value is null for String Columns
---------------------------------------------------
Key: TEIID-1976
URL: https://issues.jboss.org/browse/TEIID-1976
Project: Teiid
Issue Type: Bug
Components: Common
Affects Versions: 8.0
Reporter: Mark Drilling
Assignee: Ramesh Reddy
Fix For: 8.0
Attachments: PortfolioVDB.vdb
The metadata TYPE_NAME value for string datatypes is apparently returning null. I am
running against a JBoss AS7.1Final server with Teiid 8.0Beta2.
My application (openshift web client) establishes connection from a DataSource, eg
connection = dataSource.getConnection(),
then resultSet = connection.getMetaData().getColumns();
when iterating thru the resultSet, the value for columnName="TYPE_NAME" is null
for string types. Other types seem to return a correct value.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:42 p.m.
[
https://issues.jboss.org/browse/TEIID-1976?page=com.atlassian.jira.plugin...
]
Steven Hawkins edited comment on TEIID-1976 at 3/30/12 5:42 PM:
----------------------------------------------------------------
You should instead use getString("COLUMN_NAME") and
getString("TYPE_NAME"), or at the least
resultSet.getMetaData().getColumnLable\(i\). We do not guarantee that the column name
will match the label since the actual query may not fetch columns with the same names as
expected by JDBC.
was (Author: shawkins):
You should instead use getString("COLUMN_NAME") and
getString("TYPE_NAME"), or at the least
resultSet.getMetaData().getColumnLable(i). We do not guarantee that the column name will
match the label since the actual query may not fetch columns with the same names as
expected by JDBC.
Metadata TYPE_NAME value is null for String Columns
---------------------------------------------------
Key: TEIID-1976
URL: https://issues.jboss.org/browse/TEIID-1976
Project: Teiid
Issue Type: Bug
Components: Common
Affects Versions: 8.0
Reporter: Mark Drilling
Assignee: Ramesh Reddy
Fix For: 8.0
Attachments: PortfolioVDB.vdb
The metadata TYPE_NAME value for string datatypes is apparently returning null. I am
running against a JBoss AS7.1Final server with Teiid 8.0Beta2.
My application (openshift web client) establishes connection from a DataSource, eg
connection = dataSource.getConnection(),
then resultSet = connection.getMetaData().getColumns();
when iterating thru the resultSet, the value for columnName="TYPE_NAME" is null
for string types. Other types seem to return a correct value.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:42 p.m.
[
https://issues.jboss.org/browse/TEIID-1976?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1976:
---------------------------------------
You should instead use getString("COLUMN_NAME") and
getString("TYPE_NAME"), or at the least
resultSet.getMetaData().getColumnLable(i). We do not guarantee that the column name will
match the label since the actual query may not fetch columns with the same names as
expected by JDBC.
Metadata TYPE_NAME value is null for String Columns
---------------------------------------------------
Key: TEIID-1976
URL: https://issues.jboss.org/browse/TEIID-1976
Project: Teiid
Issue Type: Bug
Components: Common
Affects Versions: 8.0
Reporter: Mark Drilling
Assignee: Ramesh Reddy
Fix For: 8.0
Attachments: PortfolioVDB.vdb
The metadata TYPE_NAME value for string datatypes is apparently returning null. I am
running against a JBoss AS7.1Final server with Teiid 8.0Beta2.
My application (openshift web client) establishes connection from a DataSource, eg
connection = dataSource.getConnection(),
then resultSet = connection.getMetaData().getColumns();
when iterating thru the resultSet, the value for columnName="TYPE_NAME" is null
for string types. Other types seem to return a correct value.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:11 p.m.
[
https://issues.jboss.org/browse/TEIID-1976?page=com.atlassian.jira.plugin...
]
Ramesh Reddy resolved TEIID-1976.
---------------------------------
Resolution: Won't Fix
See Steve's comment for correct way to access the data.
Metadata TYPE_NAME value is null for String Columns
---------------------------------------------------
Key: TEIID-1976
URL: https://issues.jboss.org/browse/TEIID-1976
Project: Teiid
Issue Type: Bug
Components: Common
Affects Versions: 8.0
Reporter: Mark Drilling
Assignee: Ramesh Reddy
Fix For: 8.0
Attachments: PortfolioVDB.vdb
The metadata TYPE_NAME value for string datatypes is apparently returning null. I am
running against a JBoss AS7.1Final server with Teiid 8.0Beta2.
My application (openshift web client) establishes connection from a DataSource, eg
connection = dataSource.getConnection(),
then resultSet = connection.getMetaData().getColumns();
when iterating thru the resultSet, the value for columnName="TYPE_NAME" is null
for string types. Other types seem to return a correct value.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:39 p.m.
[
https://issues.jboss.org/browse/TEIID-1976?page=com.atlassian.jira.plugin...
]
Ramesh Reddy reopened TEIID-1976:
---------------------------------
Looks like there is bug in the VDBRepository while setting the loaded data types to match
the DataTypeManager types. There are multiple "string" based base data types in
system vdb loaded data types map.
Metadata TYPE_NAME value is null for String Columns
---------------------------------------------------
Key: TEIID-1976
URL: https://issues.jboss.org/browse/TEIID-1976
Project: Teiid
Issue Type: Bug
Components: Common
Affects Versions: 8.0
Reporter: Mark Drilling
Assignee: Ramesh Reddy
Fix For: 8.0
Attachments: PortfolioVDB.vdb
The metadata TYPE_NAME value for string datatypes is apparently returning null. I am
running against a JBoss AS7.1Final server with Teiid 8.0Beta2.
My application (openshift web client) establishes connection from a DataSource, eg
connection = dataSource.getConnection(),
then resultSet = connection.getMetaData().getColumns();
when iterating thru the resultSet, the value for columnName="TYPE_NAME" is null
for string types. Other types seem to return a correct value.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:57 p.m.
[
https://issues.jboss.org/browse/TEIID-1976?page=com.atlassian.jira.plugin...
]
Ramesh Reddy resolved TEIID-1976.
---------------------------------
Resolution: Done
index stores need to use the data types defined by system store to match with uuid based
look ups. The sub-selection data types defined in the teiid map correctly with designer
data types in terms of runtime type, however they do not align with uuids or their names.
This fixes the both issues.
Metadata TYPE_NAME value is null for String Columns
---------------------------------------------------
Key: TEIID-1976
URL: https://issues.jboss.org/browse/TEIID-1976
Project: Teiid
Issue Type: Bug
Components: Common
Affects Versions: 8.0
Reporter: Mark Drilling
Assignee: Ramesh Reddy
Fix For: 8.0
Attachments: PortfolioVDB.vdb
The metadata TYPE_NAME value for string datatypes is apparently returning null. I am
running against a JBoss AS7.1Final server with Teiid 8.0Beta2.
My application (openshift web client) establishes connection from a DataSource, eg
connection = dataSource.getConnection(),
then resultSet = connection.getMetaData().getColumns();
when iterating thru the resultSet, the value for columnName="TYPE_NAME" is null
for string types. Other types seem to return a correct value.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:15 a.m.
[
https://issues.jboss.org/browse/TEIID-1976?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-1976.
---------------------------------
Metadata TYPE_NAME value is null for String Columns
---------------------------------------------------
Key: TEIID-1976
URL: https://issues.jboss.org/browse/TEIID-1976
Project: Teiid
Issue Type: Bug
Components: Common
Affects Versions: 8.0
Reporter: Mark Drilling
Assignee: Ramesh Reddy
Fix For: 8.0
Attachments: PortfolioVDB.vdb
The metadata TYPE_NAME value for string datatypes is apparently returning null. I am
running against a JBoss AS7.1Final server with Teiid 8.0Beta2.
My application (openshift web client) establishes connection from a DataSource, eg
connection = dataSource.getConnection(),
then resultSet = connection.getMetaData().getColumns();
when iterating thru the resultSet, the value for columnName="TYPE_NAME" is null
for string types. Other types seem to return a correct value.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
4513
days inactive
4669
days old
13 comments
3 participants
participants (3)
-
Mark Drilling (JIRA) -
Ramesh Reddy (JIRA)
-
Steven Hawkins (JIRA)