Text connector, and oracle
Hi,
Late now, so i'm about to go home, but there's 2 things i'm stuck on!
Where do i put the oracle drivers so that the designer can pick them up? At the moment i'm getting class not found.
I can't get text file connector to work, see error below. There's not much of help in the log.
for the properties file i have file:///c:/test.properties
and in that i have:
Txt.DispensaryLabels.location = file:///c:/test.csv
Txt.DispensaryLabels.delimiter = ,
Txt.DispensaryLabels.headerLine = 1
Where Txt is the model name, and DispensaryLabels is the table name...
I tried removing the spaces. test.csv definately exists!
com.metamatrix.jdbc.MMSQLException: Connector Binding "New Connector" failed to start, or did not start correctly. Please check the connector binding properties. Check the log file for more information.
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: [ComponentNotFoundException]Connector Binding "New Connector" failed to start, or did not start correctly. Please check the connector binding properties. Check the log file for more information.
at com.metamatrix.dqp.embedded.services.EmbeddedDataService.selectConnector(EmbeddedDataService.java:122)
at org.teiid.dqp.internal.process.capabilities.ConnectorCapabilitiesFinder.findCapabilities(ConnectorCapabilitiesFinder.java:64)
at org.teiid.dqp.internal.process.capabilities.SharedCachedFinder.findCapabilities(SharedCachedFinder.java:64)
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)
