[
https://issues.jboss.org/browse/TEIIDDES-2458?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-2458:
----------------------------------------
I tested with a sybase BQT2 db set up by QE. For the basic use-case I'm receiving the
following preview error:
{code}
org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote
org.teiid.core.TeiidProcessingException:
TEIID30504 Sybase_ASE_15: 102 TEIID11008:TEIID11004 Error executing statement(s):
[Prepared Values: [] SQL: SELECT g_0."IntKey", g_0."StringKey",
g_0."IntNum", g_0."StringNum", g_0."FloatNum",
g_0."LongNum", g_0."DoubleNum", g_0."ByteNum",
g_0."DateValue", g_0."TimeValue", g_0."TimestampValue",
g_0."BooleanValue", g_0."CharValue", g_0."ShortValue",
g_0."BigIntegerValue", g_0."BigDecimalValue",
g_0."ObjectValue" FROM "bqt2"."MediumA" g_0]
{code}
I tried changing the NIS for the table to:
"bqt2"."dbo"."MediumA" but it resulted in the same error on
preview.
I connected to that DB via Data Tools. I noticed that the folder structure within that
Sybase DB was different than other types of JDBC connections. Note the *(dbo)* added to
each of the tables in this database. I tried to *Sample Data* from the datasource
explorer and it failed with the following message:
{code}
Starting run
SELECT * FROM "dbo"."MediumA"
com.sybase.jdbc4.jdbc.SybSQLException: Incorrect syntax near '.'.
{code}
So there there are issues with both Teiid Designer AND Eclipse data tools in interpreting
the Database/Schema/Catalog information and how to actually query it.
Wrong "name-in-source" property value for imported tables
in Source model (JDBC importer, Sybase 15 Database)
-------------------------------------------------------------------------------------------------------------
Key: TEIIDDES-2458
URL:
https://issues.jboss.org/browse/TEIIDDES-2458
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 9.0.1
Environment: JBDS: 8.0.2GA
TD: 9.0.1.Final
OS: Fedora 20
java: oracle 1.7
JDBC driver: jconn4-26502 - jConnect (TM) for JDBC(TM)/7.00(Build 26502)
Sybase DB: ASE 15.0.3/EBF
Reporter: Juraj DurĂ¡ni
Attachments: parts_sql_catalog_in_name_in_source.png,
parts_sql_include_catalog_in_name.png, parts_sql_schema_tree.png, pic1.png, pic2.png,
pic3.png
I am trying to import a Source model from Sybase database. But imported tables have wrong
"name-in-source" property values.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)