[
https://issues.jboss.org/browse/TEIIDDES-1920?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-1920:
----------------------------------------
Lucie,
Can you verify that you can successfully Test Connection in the Connection profile
wizard?
If Data Tools can't connect to your Sybase instance with your attached driver jar,
then it's an Eclipse/Sybase issue and not a Designer issue.
Cannot create relational source with Sybase jconn4.jar
------------------------------------------------------
Key: TEIIDDES-1920
URL:
https://issues.jboss.org/browse/TEIIDDES-1920
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 8.3
Environment: java oracle 1.7, Teiid 8.4.1-redhat4 in DV 6.0.0.ER3, Teiid Designer
8.3.beta3
Reporter: Lucie Fabrikova
Assignee: Barry LaFond
Priority: Blocker
Attachments: jconn4-26666.jar
Creating a relational source model from jdbc connection profile to Sybase database (1st
page of wizard, connecting to database of given profile) which uses jconn4.jar results in
error message :
java.sql.SQLException: JZ0SJ: Metadata accessor information was not found on this
database. Please install the required tables as mentioned in the jConnect documentation.
at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(Unknown Source)
at com.sybase.jdbc4.jdbc.SybConnection.handleSQLE(Unknown Source)
at com.sybase.jdbc4.jdbc.SybConnection.checkMDA(Unknown Source)
at com.sybase.jdbc4.jdbc.SybConnection.getMDA(Unknown Source)
at com.sybase.jdbc4.jdbc.SybLob.<init>(Unknown Source)
at com.sybase.jdbc4.jdbc.SybCharClientLob.<init>(Unknown Source)
at com.sybase.jdbc4.jdbc.SybConnection.resetNullLobs(Unknown Source)
at com.sybase.jdbc4.jdbc.SybConnection.init(Unknown Source)
at com.sybase.jdbc4.jdbc.SybConnection.tryLogin(Unknown Source)
at com.sybase.jdbc4.jdbc.SybConnection.handleHAFailover(Unknown Source)
at com.sybase.jdbc4.jdbc.SybConnection.<init>(Unknown Source)
at com.sybase.jdbc4.jdbc.SybConnection.<init>(Unknown Source)
at com.sybase.jdbc4.jdbc.SybDriver.connect(Unknown Source)
at
org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:298)
at
org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)
at
org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)
at
org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:81)
at
org.eclipse.datatools.enablement.sybase.ase.internal.connection.JDBCASEConnectionFactory.createConnection(JDBCASEConnectionFactory.java:32)
at
org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
at
org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)
at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)
at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)
Errors log:
Modeler Core Exception: Status ERROR: org.teiid.core.designer code=0 JZ0SJ: Metadata
accessor information was not found on this database. Please install the required tables as
mentioned in the jConnect documentation. null
at org.teiid.designer.jdbc.JdbcManagerImpl.createConnection(JdbcManagerImpl.java:202)
at org.teiid.designer.jdbc.JdbcManagerImpl.createConnection(JdbcManagerImpl.java:211)
at org.teiid.designer.jdbc.ui.util.JdbcUiUtil$1.run(JdbcUiUtil.java:80)
at
org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:
http://www.atlassian.com/software/jira