[JBoss JIRA] (TEIIDDES-2458) Wrong "name-in-source" property value for imported tables in Source model (JDBC importer, Sybase 15 Database)
1:22 p.m.
[
https://issues.jboss.org/browse/TEIIDDES-2458?page=com.atlassian.jira.plu...
]
Barry LaFond edited comment on TEIIDDES-2458 at 6/5/15 2:21 PM:
----------------------------------------------------------------
Debugging JDBC Importer, there's a call in JdbcCatalogImpl.addSchemaChildren() to get
schema children from SybDatabaseMetadata.getSchema() that's throwing an exception:
*java.sql.SQLException: JZ0SB: Parameter index out of range: 1.*
As a result, the schema isn't found and not set on the NIS.
{code}
java.sql.SQLException: JZ0SB: Parameter index out of range: 1.
at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError(Unknown Source)
at com.sybase.jdbc4.jdbc.ParamManager.int(Unknown Source)
at com.sybase.jdbc4.jdbc.ParamManager.doSetParam(Unknown Source)
at com.sybase.jdbc4.jdbc.ParamManager.setParam(Unknown Source)
at com.sybase.jdbc4.jdbc.SybPreparedStatement.a(Unknown Source)
at com.sybase.jdbc4.jdbc.SybPreparedStatement.a(Unknown Source)
at com.sybase.jdbc4.jdbc.SybPreparedStatement.setNull(Unknown Source)
at com.sybase.jdbc4.jdbc.SybDatabaseMetaData.a(Unknown Source)
at com.sybase.jdbc4.jdbc.SybDatabaseMetaData.getSchemas(Unknown Source)
at
org.teiid.designer.jdbc.metadata.impl.JdbcCatalogImpl.addSchemaChildren(JdbcCatalogImpl.java:121)
at
org.teiid.designer.jdbc.metadata.impl.JdbcCatalogImpl.computeChildren(JdbcCatalogImpl.java:77)
at org.teiid.designer.jdbc.metadata.impl.JdbcNodeImpl.getChildren(JdbcNodeImpl.java:197)
at
org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage$TreeContentProvider.hasChildren(JdbcImportObjectsPage.java:1007)
{code}
I it appears to be a driver issue? or maybe the Sybase instance set-up is weird
was (Author: blafond):
Debugging JDBC Importer, there's a call in JdbcCatalogImpl.addSchemaChildren() to get
schema children from SybDatabaseMetadata.getSchema() that's throwing an exception:
*java.sql.SQLException: JZ0SB: Parameter index out of range: 1.*
As a result, the schema isn't found and not set on the NIS.
{code}
java.sql.SQLException: JZ0SB: Parameter index out of range: 1.
at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError(Unknown Source)
at com.sybase.jdbc4.jdbc.ParamManager.int(Unknown Source)
at com.sybase.jdbc4.jdbc.ParamManager.doSetParam(Unknown Source)
at com.sybase.jdbc4.jdbc.ParamManager.setParam(Unknown Source)
at com.sybase.jdbc4.jdbc.SybPreparedStatement.a(Unknown Source)
at com.sybase.jdbc4.jdbc.SybPreparedStatement.a(Unknown Source)
at com.sybase.jdbc4.jdbc.SybPreparedStatement.setNull(Unknown Source)
at com.sybase.jdbc4.jdbc.SybDatabaseMetaData.a(Unknown Source)
at com.sybase.jdbc4.jdbc.SybDatabaseMetaData.getSchemas(Unknown Source)
at
org.teiid.designer.jdbc.metadata.impl.JdbcCatalogImpl.addSchemaChildren(JdbcCatalogImpl.java:121)
at
org.teiid.designer.jdbc.metadata.impl.JdbcCatalogImpl.computeChildren(JdbcCatalogImpl.java:77)
at org.teiid.designer.jdbc.metadata.impl.JdbcNodeImpl.getChildren(JdbcNodeImpl.java:197)
at
org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage$TreeContentProvider.hasChildren(JdbcImportObjectsPage.java:1007)
{code}
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, sybase_bqt2_datatools_tree.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)
3449
days inactive
3449
days old
teiid-designer-issues@lists.jboss.org
0 comments
1 participants
participants (1)
-
Barry LaFond (JIRA)