2 Replies Latest reply on Jun 10, 2009 3:52 AM by Dan Keeley

    Text connector, and oracle

    Dan Keeley Newbie

      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)