[JBoss JIRA] (TEIIDDES-1777) Unable to connect to a remote domain server
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1777?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-1777:
---------------------------------------------------
belong(a)redhat.com made a comment on [bug 982648|https://bugzilla.redhat.com/show_bug.cgi?id=982648]
Fixed before GA - setting to requires_doc_text- accordingly
> Unable to connect to a remote domain server
> -------------------------------------------
>
> Key: TEIIDDES-1777
> URL: https://issues.jboss.org/browse/TEIIDDES-1777
> Project: Teiid Designer
> Issue Type: Bug
> Components: Teiid Integration
> Affects Versions: 8.2
> Reporter: Van Halbert
> Priority: Critical
>
> Unable to connect to a remote domain server. Getting the following exception:
> !ENTRY org.teiid.designer.dqp 4 0 2013-07-08 16:58:31.613
> !MESSAGE TEIID70036 java.lang.IllegalArgumentException
> !STACK 0
> org.teiid.adminapi.AdminProcessingException: TEIID70036 java.lang.IllegalArgumentException
> at org.teiid.adminapi.AdminFactory$AdminImpl.getVDBs(AdminFactory.java:1433)
> at org.teiid.adminapi.AdminFactory$AdminImpl.getVDBs(AdminFactory.java:1)
> at org.teiid83.runtime.ExecutionAdmin.refreshVDBs(ExecutionAdmin.java:659)
> at org.teiid83.runtime.ExecutionAdmin.init(ExecutionAdmin.java:576)
> at org.teiid83.runtime.ExecutionAdmin.<init>(ExecutionAdmin.java:137)
> at org.teiid83.runtime.ExecutionAdminFactory.createExecutionAdmin(ExecutionAdminFactory.java:29)
> at org.teiid.designer.runtime.registry.TeiidRuntimeRegistry.getExecutionAdmin(TeiidRuntimeRegistry.java:102)
> at org.teiid.designer.runtime.TeiidServer.connect(TeiidServer.java:212)
> at org.teiid.designer.runtime.TeiidServer.reconnect(TeiidServer.java:232)
> at org.teiid.designer.runtime.ui.server.RefreshServerAction$1.run(RefreshServerAction.java:58)
> at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator$2$1.run(UiBusyIndicator.java:206)
> at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
> at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:135)
> at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3976)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3653)
> at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator.executeRunnable(UiBusyIndicator.java:227)
> at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator.showWhileInternal(UiBusyIndicator.java:159)
> at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator.showWhile(UiBusyIndicator.java:116)
> at org.teiid.designer.runtime.ui.server.RefreshServerAction.run(RefreshServerAction.java:54)
> at org.eclipse.ui.actions.BaseSelectionListenerAction.runWithEvent(BaseSelectionListenerAction.java:168)
> at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
> at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
> at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4166)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1466)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1489)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1474)
> at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1279)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4012)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3651)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1113)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:997)
> at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:138)
> at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:610)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:567)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
> at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124)
> at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:354)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:181)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:636)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:591)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1450)
> Caused by: java.lang.IllegalArgumentException
> at org.jboss.dmr.ModelValue.getKeys(ModelValue.java:124)
> at org.jboss.dmr.ModelNode.keys(ModelNode.java:1194)
> at org.teiid.adminapi.AdminFactory$AdminImpl.getDomainAwareList(AdminFactory.java:1349)
> at org.teiid.adminapi.AdminFactory$AdminImpl.getVDBs(AdminFactory.java:1430)
> ... 51 more
--
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-1928) Flat File Importer has problems with header having double quoted names
by Mark Drilling (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1928?page=com.atlassian.jira.plu... ]
Mark Drilling resolved TEIIDDES-1928.
-------------------------------------
Resolution: Done
There were a few issues on this one.
- Extra quotes added to column names if double quotes used
- QUOTE was not added to generated SQL when necessary
- single tick in the generated SQL was not escaped properly.
Retested both scenarios end-to-end - working now.
pull request https://github.com/Teiid-Designer/teiid-designer/pull/262
> Flat File Importer has problems with header having double quoted names
> ----------------------------------------------------------------------
>
> Key: TEIIDDES-1928
> URL: https://issues.jboss.org/browse/TEIIDDES-1928
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 8.2
> Reporter: Mark Drilling
> Assignee: Mark Drilling
> Fix For: 8.3
>
>
> Problem scenario is described below. Designer should strip off the double quotes on header names when generating column names. (It does so for single quoted names)
> =======================================================
> I am having an issue with a CSV whose header row has its columns surrounded by quotes. For example, "ID" becomes """ID""". When I create a source/view for the file, it seems to do it successfully, but does make me reconcile the SQL. To reconcile the SQL I have to match the unmatched SQL symbols. An example of this is where ID equals "ID". Once reconciled, the VDB deploys but fails to find the view once I try to query it. This is the warning that I am getting fromt he server, but it seems more like an error to me because it halts execution of the query at that point.
> 15:47:33,293 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2) TEIID30020 Processing exception for request 7v7hMSEj9U7c.0 'TEIID30181 HEADER entry missing for column name "ID" in file:/home/coty/data/ACCOUNT.csv.'. Originally TeiidProcessingException TextTableNode.java:373.: org.teiid.core.TeiidProcessingException: TEIID30181 HEADER entry missing for column name "ID" in file:/home/coty/data/ACCOUNT.csv.
> at org.teiid.query.processor.relational.TextTableNode.processHeader(TextTableNode.java:373) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> When I strip the quotes from the header row and put it back everything works fine.
--
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 Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1920?page=com.atlassian.jira.plu... ]
Barry LaFond edited comment on TEIIDDES-1920 at 11/19/13 2:26 PM:
------------------------------------------------------------------
I was able to test connection and import into Teiid Designer using
1) jconn4-26502.jar and....
2) used the Sybase JDBC Driver for Sybase ASA 10.x driver definition option
3) specified the driver class as: com.sybase.jbdc4.jdbc.SybDriver
4) Used a QE Sybase instance for BQT2, with port == 5000
There are 2 groups of Sybase connection profiles (ASE and ASA) and multiple flavors/versions for each of those.
So I think you'll need to be clear/concise with your driver type in this test.
NOTE:
* Preview Data fails for the imported tables
* Execute VDB fails containing the same Sybase mode/tables
* Sample Contents fails using the Data Tools direction Connection to the DB
was (Author: blafond):
I was able to test connection and import into Teiid Designer using
1) jconn4-26502.jar and....
2) used the Sybase JDBC Driver for Sybase ASA 10.x driver definition option
3) specified the driver class as: com.sybase.jbdc4.jdbc.SybDriver
4) Used a QE Sybase instance for BQT2, with port == 5000
There are 2 groups of Sybase connection profiles (ASE and ASA) and multiple flavors/versions for each of those.
So I think you'll need to be clear/concise with your driver type in this test.
NOTE:
* Preview Data fails for the imported tables
* Execute VDB containing the Sybase model.
* Sample Contents fails using the Data Tools direction Connection to the DB
> 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
> Components: Import/Export
> 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
> Fix For: 8.3
>
> 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 Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1920?page=com.atlassian.jira.plu... ]
Barry LaFond edited comment on TEIIDDES-1920 at 11/19/13 2:25 PM:
------------------------------------------------------------------
I was able to test connection and import into Teiid Designer using
1) jconn4-26502.jar and....
2) used the Sybase JDBC Driver for Sybase ASA 10.x driver definition option
3) specified the driver class as: com.sybase.jbdc4.jdbc.SybDriver
4) Used a QE Sybase instance for BQT2, with port == 5000
There are 2 groups of Sybase connection profiles (ASE and ASA) and multiple flavors/versions for each of those.
So I think you'll need to be clear/concise with your driver type in this test.
NOTE:
* Preview Data fails for the imported tables
* Execute VDB containing the Sybase model.
* Sample Contents fails using the Data Tools direction Connection to the DB
was (Author: blafond):
I was able to test connection and import into Teiid Designer using
1) jconn4-26502.jar and....
2) used the Sybase JDBC Driver for Sybase ASA 10.x driver definition option
3) specified the driver class as: com.sybase.jbdc4.jdbc.SybDriver
4) Used a QE Sybase instance for BQT2, with port == 5000
There are 2 groups of Sybase connection profiles (ASE and ASA) and multiple flavors/versions for each of those.
So I think you'll need to be clear/concise with your driver type in this test.
NOTE: Both Preview Data fails for the imported tables as does Execute VDB containing the Sybase model.
> 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
> Components: Import/Export
> 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
> Fix For: 8.3
>
> 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 Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1920?page=com.atlassian.jira.plu... ]
Barry LaFond edited comment on TEIIDDES-1920 at 11/19/13 2:10 PM:
------------------------------------------------------------------
I was able to test connection and import into Teiid Designer using
1) jconn4-26502.jar and....
2) used the Sybase JDBC Driver for Sybase ASA 10.x driver definition option
3) specified the driver class as: com.sybase.jbdc4.jdbc.SybDriver
4) Used a QE Sybase instance for BQT2, with port == 5000
There are 2 groups of Sybase connection profiles (ASE and ASA) and multiple flavors/versions for each of those.
So I think you'll need to be clear/concise with your driver type in this test.
NOTE: Both Preview Data fails for the imported tables as does Execute VDB containing the Sybase model.
was (Author: blafond):
I was able to test connection and import into Teiid Designer using
1) jconn4-26502.jar and....
2) used the Sybase JDBC Driver for Sybase ASA 10.x driver definition option
3) specified the driver class as: com.sybase.jbdc4.jdbc.SybDriver
4) Used a QE Sybase instance for BQT2, with port == 5000
There are 2 groups of Sybase connection profiles (ASE and ASA) and multiple flavors/versions for each of those.
So I think you'll need to be clear/concise with your driver type in this test.
> 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
> Components: Import/Export
> 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
> Fix For: 8.3
>
> 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-1928) Flat File Importer has problems with header having double quoted names
by Mark Drilling (JIRA)
Mark Drilling created TEIIDDES-1928:
---------------------------------------
Summary: Flat File Importer has problems with header having double quoted names
Key: TEIIDDES-1928
URL: https://issues.jboss.org/browse/TEIIDDES-1928
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 8.2
Reporter: Mark Drilling
Assignee: Mark Drilling
Fix For: 8.3
Problem scenario is described below. Designer should strip off the double quotes on header names when generating column names. (It does so for single quoted names)
=======================================================
I am having an issue with a CSV whose header row has its columns surrounded by quotes. For example, "ID" becomes """ID""". When I create a source/view for the file, it seems to do it successfully, but does make me reconcile the SQL. To reconcile the SQL I have to match the unmatched SQL symbols. An example of this is where ID equals "ID". Once reconciled, the VDB deploys but fails to find the view once I try to query it. This is the warning that I am getting fromt he server, but it seems more like an error to me because it halts execution of the query at that point.
15:47:33,293 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2) TEIID30020 Processing exception for request 7v7hMSEj9U7c.0 'TEIID30181 HEADER entry missing for column name "ID" in file:/home/coty/data/ACCOUNT.csv.'. Originally TeiidProcessingException TextTableNode.java:373.: org.teiid.core.TeiidProcessingException: TEIID30181 HEADER entry missing for column name "ID" in file:/home/coty/data/ACCOUNT.csv.
at org.teiid.query.processor.relational.TextTableNode.processHeader(TextTableNode.java:373) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
When I strip the quotes from the header row and put it back everything works fine.
--
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