[JBoss JIRA] (TEIIDDES-1918) JDBC importer adds wrong column type for columns of type integer, when importing(Reusing) VDB
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1918?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-1918:
---------------------------------------------------
Filip Elias <felias(a)redhat.com> made a comment on [bug 1026892|https://bugzilla.redhat.com/show_bug.cgi?id=1026892]
Hello Mark,
1) You have to choose any JNDI Name (in the Source Binding Definition ) from the list. Then you should be able to deploy loopback VDB.
2) Do you create the importing VDB in the different Teiid Model Project? Otherwise the model name collides with the model name of the loopback VDB and can't be changed.
> JDBC importer adds wrong column type for columns of type integer, when importing(Reusing) VDB
> ----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-1918
> URL: https://issues.jboss.org/browse/TEIIDDES-1918
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 8.3
> Reporter: Van Halbert
> Assignee: Mark Drilling
> Priority: Critical
> Fix For: 8.3
>
>
> When a VDB is imported(reused) by another VDB and the imported VDB contains table with column of type integer, then the importing VDB will throw validation error.
> Steps to reproduce:
> 1. Create loopback VDB, add table DATA with two columns, one of type integer and one of the string
> 2. Deploy the loopback VDB
> 3. Reuse the looback VDB
> 3.1. Import the loopback VDB through JDBC importer
> "Import as VDB source model" have to be checked
> 3.2 Create view model, use table DATA in the view model
> 3.3 Create and deploy new VDB
> When deploying the VDB, error occures:
> TEIID31080 View data validation error: QueryValidatorException-The definition for data has the wrong type for column 1. Expected bigdecimal, but was biginteger.
> 15:57:48,718 INFO [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40073 The metadata for the VDB aaa.1 is loaded, however it is not valid. Check models for errors. Correct the metadata and re-deploy.
> 15:57:48,719 INFO [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40003 VDB aaa.1 is set to FAILED
--
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
12 years, 5 months
[JBoss JIRA] (TEIIDDES-1920) Cannot create relational source with Sybase jconn4.jar
by Lucie Fabrikova (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1920?page=com.atlassian.jira.plu... ]
Lucie Fabrikova updated TEIIDDES-1920:
--------------------------------------
Attachment: jconn4-26502.jar
> 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-26502.jar, 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
12 years, 5 months
[JBoss JIRA] (TEIIDDES-1920) Cannot create relational source with Sybase jconn4.jar
by Lucie Fabrikova (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1920?page=com.atlassian.jira.plu... ]
Lucie Fabrikova edited comment on TEIIDDES-1920 at 11/11/13 3:10 AM:
---------------------------------------------------------------------
Clicking on Test connection in the connection profile wizard "New Sybase ASE Connection Profile", on page "Specify a Driver and Connection Details":
- Attached driver jconn4-26666.jar: ping fails
- newly attached driver jconn4-26502.jar: ping succeeds, source model cannot be created
was (Author: lfabriko):
I can click on Test connection in the connection profile wizard "New Sybase ASE Connection Profile", on page "Specify a Driver and Connection Details" and the ping succeeds.
> 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
12 years, 5 months
[JBoss JIRA] (TEIIDDES-1920) Cannot create relational source with Sybase jconn4.jar
by Lucie Fabrikova (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1920?page=com.atlassian.jira.plu... ]
Lucie Fabrikova commented on TEIIDDES-1920:
-------------------------------------------
I can click on Test connection in the connection profile wizard "New Sybase ASE Connection Profile", on page "Specify a Driver and Connection Details" and the ping succeeds.
> 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
12 years, 5 months