5:07 p.m.
jdbc Oracle import does not create connector
--------------------------------------------
Key: TEIIDDES-194
URL: https://jira.jboss.org/jira/browse/TEIIDDES-194
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 6.0.0
Environment: eclipse.buildId=M20080911-1700
java.version=1.6.0_04
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=it_IT
Command-line arguments: -os win32 -ws win32 -arch x86
Reporter: Luca Gioppo
Importing model from jdbc
Creating a new source for an Oracle 9 DB
using jdbc14.jar and adding to udf (and a second time in the source definition)
the jar from the oracle instant client
the connection work, tables are imported but at hte end of the import the error is:
Error post processing import (extension class=class
com.metamatrix.modeler.internal.dqp.ui.jdbc.ConnectorBindingImportPostProcessor)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:09 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-194) jdbc Oracle import does not create connector
[
https://jira.jboss.org/jira/browse/TEIIDDES-194?page=com.atlassian.jira.p...
]
Barry LaFond commented on TEIIDDES-194:
---------------------------------------
E-mail to Luca 5/22/09
Luca,
could you add any additional info to your JIRA?
1) Log (under your workspace .metadata directory)
2) Which Designer Install (assuming teiid_designer_6.0.0_v20090514.zip ?)
3) The Designer was probably trying to match a Driver class from your import with a
Connector Class, so could you include that info also found by looking at properties of
your "Data Source" under your model?
Barry LaFond
Teiid Designer Project
jdbc Oracle import does not create connector
--------------------------------------------
Key: TEIIDDES-194
URL: https://jira.jboss.org/jira/browse/TEIIDDES-194
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 6.0.0
Environment: eclipse.buildId=M20080911-1700
java.version=1.6.0_04
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=it_IT
Command-line arguments: -os win32 -ws win32 -arch x86
Reporter: Luca Gioppo
Importing model from jdbc
Creating a new source for an Oracle 9 DB
using jdbc14.jar and adding to udf (and a second time in the source definition)
the jar from the oracle instant client
the connection work, tables are imported but at hte end of the import the error is:
Error post processing import (extension class=class
com.metamatrix.modeler.internal.dqp.ui.jdbc.ConnectorBindingImportPostProcessor)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:55 a.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-194) jdbc Oracle import does not create connector
[
https://jira.jboss.org/jira/browse/TEIIDDES-194?page=com.atlassian.jira.p...
]
Luca Gioppo updated TEIIDDES-194:
---------------------------------
Attachment: .log
Here the log file, the Oracle Connector refer to the Anaprod name (DB)
jdbc Oracle import does not create connector
--------------------------------------------
Key: TEIIDDES-194
URL: https://jira.jboss.org/jira/browse/TEIIDDES-194
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 6.0.0
Environment: eclipse.buildId=M20080911-1700
java.version=1.6.0_04
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=it_IT
Command-line arguments: -os win32 -ws win32 -arch x86
Reporter: Luca Gioppo
Attachments: .log
Importing model from jdbc
Creating a new source for an Oracle 9 DB
using jdbc14.jar and adding to udf (and a second time in the source definition)
the jar from the oracle instant client
the connection work, tables are imported but at hte end of the import the error is:
Error post processing import (extension class=class
com.metamatrix.modeler.internal.dqp.ui.jdbc.ConnectorBindingImportPostProcessor)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:03 a.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-194) jdbc Oracle import does not create connector
[
https://jira.jboss.org/jira/browse/TEIIDDES-194?page=com.atlassian.jira.p...
]
Luca Gioppo commented on TEIIDDES-194:
--------------------------------------
The release of the plugin is the teiid_designer_6.0.0_v20090514.zip
The import has been done just using the jdbc14.jar file from Oracle and choosing Oracle
from the source dialog (I supposed that I just needed to specify the Oracle driver and
that TEIID had all what was needed).
It seemed right to do so since it read the tables and produced the model, but it did not
create the connector (which is the bug in my opinion).
The jar was also added to the udf (adding external jars).
Note that this is the same way I used for MySQL and for MySQL it worked without problems
(even if there are some errors in the log for MySQL that I do not understand, but since it
work I decided to ignore them (I know is a bed practice, but you know if it doesn't
hurt just leave it alone).
I remember that his problem was present also in the previous release (see
http://www.jboss.org/index.html?module=bb&op=viewtopic&t=152908) and rareddy
posted a Oracle cdk to use, now in this new version (as he stated in the post) that cdk is
no longer valid (you changed the packages from metamatrix to teiid and also some classes
are different).
Hopes this can help.
Luca
jdbc Oracle import does not create connector
--------------------------------------------
Key: TEIIDDES-194
URL: https://jira.jboss.org/jira/browse/TEIIDDES-194
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 6.0.0
Environment: eclipse.buildId=M20080911-1700
java.version=1.6.0_04
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=it_IT
Command-line arguments: -os win32 -ws win32 -arch x86
Reporter: Luca Gioppo
Attachments: .log
Importing model from jdbc
Creating a new source for an Oracle 9 DB
using jdbc14.jar and adding to udf (and a second time in the source definition)
the jar from the oracle instant client
the connection work, tables are imported but at hte end of the import the error is:
Error post processing import (extension class=class
com.metamatrix.modeler.internal.dqp.ui.jdbc.ConnectorBindingImportPostProcessor)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:04 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-194) jdbc Oracle import does not create connector
[
https://jira.jboss.org/jira/browse/TEIIDDES-194?page=com.atlassian.jira.p...
]
Luca Gioppo commented on TEIIDDES-194:
--------------------------------------
Tryed again after removing all the errors , the previous import, the tentative oracle 9
cdk
and this is the error it gives at the end of the import process (as stated before it
connect to Oracle get the tables ad generates the model)
!ENTRY org.teiid.designer.dqp.ui 4 0 2009-05-25 11:54:20.843
!MESSAGE Missing connector type (model=Anaprod, driver=Oracle)
!ENTRY org.teiid.designer.jdbc.ui 4 0 2009-05-25 11:54:20.843
!MESSAGE Error post processing import (extension class=class
com.metamatrix.modeler.internal.dqp.ui.jdbc.ConnectorBindingImportPostProcessor)
!STACK 0
java.lang.NullPointerException
at
com.metamatrix.modeler.dqp.internal.workspace.WorkspaceConfigurationManager.createSourceBinding(WorkspaceConfigurationManager.java:230)
at
com.metamatrix.modeler.internal.dqp.ui.jdbc.ConnectorBindingImportPostProcessor.postProcess(ConnectorBindingImportPostProcessor.java:199)
at
com.metamatrix.modeler.internal.jdbc.ui.wizards.JdbcImportWizard.runFinish(JdbcImportWizard.java:691)
at
com.metamatrix.modeler.internal.jdbc.ui.wizards.JdbcImportWizard$1.run(JdbcImportWizard.java:262)
at
org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
The running man is disabled.
Now try to create the connector by hand so new connector on "Oracle Connector"
in the connector tab.
It creates it.
Do the binding.
The running man is enabled so try to get a preview of the data: here is the error
!ENTRY org.teiid.designer.dqp.ui 4 0 2009-05-25 12:00:32.562
!MESSAGE ############# PW EXITING on 00000000-0000-0001-0000-000000000001.0 - error
occurred ###########
!STACK 0
[MetaMatrixComponentException]Unable to find capabilities for AnaProd
at
org.teiid.dqp.internal.process.capabilities.SharedCachedFinder.findCapabilities(SharedCachedFinder.java:66)
at
com.metamatrix.query.optimizer.relational.rules.CapabilitiesUtil.getCapabilities(CapabilitiesUtil.java:511)
at
com.metamatrix.query.optimizer.relational.rules.CapabilitiesUtil.requiresCriteria(CapabilitiesUtil.java:522)
at
com.metamatrix.query.optimizer.relational.rules.RulePlaceAccess.addAccessNode(RulePlaceAccess.java:139)
at
com.metamatrix.query.optimizer.relational.rules.RulePlaceAccess.execute(RulePlaceAccess.java:77)
at
com.metamatrix.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:400)
at
com.metamatrix.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:144)
at com.metamatrix.query.optimizer.QueryOptimizer.optimize(QueryOptimizer.java:241)
at
com.metamatrix.query.optimizer.QueryOptimizer.recursiveOptimize(QueryOptimizer.java:215)
at com.metamatrix.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:123)
at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:534)
at
org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:167)
at org.teiid.dqp.internal.process.Request.processRequest(Request.java:623)
at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:373)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:206)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:44)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
!ENTRY org.teiid.designer.dqp.ui 4 0 2009-05-25 12:00:32.609
!MESSAGE Unable to find capabilities for AnaProd
!STACK 0
com.metamatrix.jdbc.MMSQLException: Unable to find capabilities for AnaProd
at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:82)
at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:63)
at com.metamatrix.jdbc.MMStatement.executeSql(MMStatement.java:424)
at com.metamatrix.jdbc.MMPreparedStatement.executeQuery(MMPreparedStatement.java:192)
at
com.metamatrix.modeler.dqp.ui.workspace.WorkspaceExecutor.executeSQL(WorkspaceExecutor.java:204)
at
com.metamatrix.modeler.internal.dqp.ui.actions.PreviewTableDataContextAction$1QueryExecutor.run(PreviewTableDataContextAction.java:279)
at
org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
Caused by: [MetaMatrixComponentException]Unable to find capabilities for AnaProd
at
org.teiid.dqp.internal.process.capabilities.SharedCachedFinder.findCapabilities(SharedCachedFinder.java:66)
at
com.metamatrix.query.optimizer.relational.rules.CapabilitiesUtil.getCapabilities(CapabilitiesUtil.java:511)
at
com.metamatrix.query.optimizer.relational.rules.CapabilitiesUtil.requiresCriteria(CapabilitiesUtil.java:522)
at
com.metamatrix.query.optimizer.relational.rules.RulePlaceAccess.addAccessNode(RulePlaceAccess.java:139)
at
com.metamatrix.query.optimizer.relational.rules.RulePlaceAccess.execute(RulePlaceAccess.java:77)
at
com.metamatrix.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:400)
at
com.metamatrix.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:144)
at com.metamatrix.query.optimizer.QueryOptimizer.optimize(QueryOptimizer.java:241)
at
com.metamatrix.query.optimizer.QueryOptimizer.recursiveOptimize(QueryOptimizer.java:215)
at com.metamatrix.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:123)
at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:534)
at
org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:167)
at org.teiid.dqp.internal.process.Request.processRequest(Request.java:623)
at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:373)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:206)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:44)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
So it's unable to find capabilities from the newly created connector.
I'm out of idea if not for the fact that the connector for Oracle does not work nor do
its automatic creation and binding (but maybe just the creation, perhaps once it gets
created without error the binding should happen as for MySQL)
Luca
jdbc Oracle import does not create connector
--------------------------------------------
Key: TEIIDDES-194
URL: https://jira.jboss.org/jira/browse/TEIIDDES-194
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 6.0.0
Environment: eclipse.buildId=M20080911-1700
java.version=1.6.0_04
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=it_IT
Command-line arguments: -os win32 -ws win32 -arch x86
Reporter: Luca Gioppo
Attachments: .log
Importing model from jdbc
Creating a new source for an Oracle 9 DB
using jdbc14.jar and adding to udf (and a second time in the source definition)
the jar from the oracle instant client
the connection work, tables are imported but at hte end of the import the error is:
Error post processing import (extension class=class
com.metamatrix.modeler.internal.dqp.ui.jdbc.ConnectorBindingImportPostProcessor)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:54 p.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-194) jdbc Oracle import does not create connector
[
https://jira.jboss.org/jira/browse/TEIIDDES-194?page=com.atlassian.jira.p...
]
Barry LaFond updated TEIIDDES-194:
----------------------------------
Fix Version/s: Future
jdbc Oracle import does not create connector
--------------------------------------------
Key: TEIIDDES-194
URL: https://jira.jboss.org/jira/browse/TEIIDDES-194
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 6.0.0
Environment: eclipse.buildId=M20080911-1700
java.version=1.6.0_04
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=it_IT
Command-line arguments: -os win32 -ws win32 -arch x86
Reporter: Luca Gioppo
Fix For: Future
Attachments: .log
Importing model from jdbc
Creating a new source for an Oracle 9 DB
using jdbc14.jar and adding to udf (and a second time in the source definition)
the jar from the oracle instant client
the connection work, tables are imported but at hte end of the import the error is:
Error post processing import (extension class=class
com.metamatrix.modeler.internal.dqp.ui.jdbc.ConnectorBindingImportPostProcessor)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:52 p.m.
New subject: [JBoss JIRA] Closed: (TEIIDDES-194) jdbc Oracle import does not create connector
[
https://jira.jboss.org/browse/TEIIDDES-194?page=com.atlassian.jira.plugin...
]
Barry LaFond closed TEIIDDES-194.
---------------------------------
Assignee: Barry LaFond
Resolution: Won't Fix
Connection framework has been totally replaced. Obsolete defect
jdbc Oracle import does not create connector
--------------------------------------------
Key: TEIIDDES-194
URL: https://jira.jboss.org/browse/TEIIDDES-194
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 6.0.0
Environment: eclipse.buildId=M20080911-1700
java.version=1.6.0_04
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=it_IT
Command-line arguments: -os win32 -ws win32 -arch x86
Reporter: Luca Gioppo
Assignee: Barry LaFond
Fix For: Future
Attachments: .log
Importing model from jdbc
Creating a new source for an Oracle 9 DB
using jdbc14.jar and adding to udf (and a second time in the source definition)
the jar from the oracle instant client
the connection work, tables are imported but at hte end of the import the error is:
Error post processing import (extension class=class
com.metamatrix.modeler.internal.dqp.ui.jdbc.ConnectorBindingImportPostProcessor)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5054
days inactive
5474
days old
teiid-designer-issues@lists.jboss.org
6 comments
2 participants
participants (2)
-
Barry LaFond (JIRA) -
Luca Gioppo (JIRA)