problem using vdblessdef file
rkishore999 Aug 24, 2009 5:57 PMWe have written a vdbless.def file to connect to one of our Oracle instances. The file looks like this.
<?xml version="1.0" encoding="UTF-8"?>
db url
extensionjar:classes12.jar
schema
passwd
We have placed the above file in /deploy directory of TEIID server 6.2 home. We started the server and is running on port 31000.
We have run this command.
run.bat vdblessmyvdb "select * from <table_name>"
We are getting the following error.
2009-08-24 14:41:14,193 WARN [main] org.jboss.cache.transaction.GenericTransactionManagerLookup - Falling back to JBoss Cache's internal DummyTransactionManager
2009-08-24 14:42:43,040 ERROR [Worker1_QueryProcessorQueue0] org.teiid.DQP - Unexpected exception for request 0.0
[MetaMatrixComponentException]"Non-uniquely named record detected 'TableRecordImpl name=OGIS_SPATIAL_REFERENCE_SYSTEMS, nameInSource=null, uuid=null, pathInModel=testdev/OGIS_SPATIAL_REFERENCE_SYSTEMS'
1 [ConnectorException]"Non-uniquely named record detected 'TableRecordImpl name=OGIS_SPATIAL_REFERENCE_SYSTEMS, nameInSource=null, uuid=null, pathInModel=testdev/OGIS_SPATIAL_REFERENCE_SYSTEMS'
at com.metamatrix.dqp.embedded.services.EmbeddedDataService.getConnectorMetadata(EmbeddedDataService.java:149)
at org.teiid.metadata.QueryMetadataCache.loadMetadata(QueryMetadataCache.java:195)
at org.teiid.metadata.QueryMetadataCache.lookupMetadata(QueryMetadataCache.java:154)
at com.metamatrix.dqp.embedded.services.EmbeddedMetadataService.lookupMetadata(EmbeddedMetadataService.java:97)
at org.teiid.dqp.internal.process.Request.initMetadata(Request.java:215)
at org.teiid.dqp.internal.process.Request.processRequest(Request.java:581)
at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:365)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:200)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:44)
at com.metamatrix.common.queue.WorkerPoolFactory$StatsCapturingSharedThreadPoolExecutor$1.run(WorkerPoolFactory.java:211)
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)
Caused by: org.teiid.connector.api.ConnectorException: "Non-uniquely named record detected 'TableRecordImpl name=OGIS_SPATIAL_REFERENCE_SYSTEMS, nameInSource=null, uuid=null, pathInModel=testdev/OGIS_SPATIAL_REFERENCE_SYSTEMS'
at org.teiid.connector.metadata.runtime.MetadataFactory.setValuesUsingParent(MetadataFactory.java:105)
at org.teiid.connector.metadata.runtime.MetadataFactory.addTable(MetadataFactory.java:117)
at org.teiid.connector.jdbc.JDBCMetdataProcessor.getTables(JDBCMetdataProcessor.java:171)
at org.teiid.connector.jdbc.JDBCMetdataProcessor.getConnectorMetadata(JDBCMetdataProcessor.java:89)
at org.teiid.connector.jdbc.JDBCConnector.getConnectorMetadata(JDBCConnector.java:334)
at org.teiid.dqp.internal.datamgr.impl.ConnectorWrapper.getConnectorMetadata(ConnectorWrapper.java:167)
at org.teiid.dqp.internal.datamgr.impl.ConnectorManager.getMetadata(ConnectorManager.java:161)
at com.metamatrix.dqp.embedded.services.EmbeddedDataService.getConnectorMetadata(EmbeddedDataService.java:147)
... 12 more
2009-08-24 14:44:10,592 ERROR [Worker1_QueryProcessorQueue1] org.teiid.DQP - Unexpected exception for request 1.0
[MetaMatrixComponentException]"Non-uniquely named record detected 'TableRecordImpl name=OGIS_SPATIAL_REFERENCE_SYSTEMS, nameInSource=null, uuid=null, pathInModel=testdev/OGIS_SPATIAL_REFERENCE_SYSTEMS'
1 [ConnectorException]"Non-uniquely named record detected 'TableRecordImpl name=OGIS_SPATIAL_REFERENCE_SYSTEMS, nameInSource=null, uuid=null, pathInModel=testdev/OGIS_SPATIAL_REFERENCE_SYSTEMS'
at com.metamatrix.dqp.embedded.services.EmbeddedDataService.getConnectorMetadata(EmbeddedDataService.java:149)
at org.teiid.metadata.QueryMetadataCache.loadMetadata(QueryMetadataCache.java:195)
at org.teiid.metadata.QueryMetadataCache.lookupMetadata(QueryMetadataCache.java:154)
at com.metamatrix.dqp.embedded.services.EmbeddedMetadataService.lookupMetadata(EmbeddedMetadataService.java:97)
at org.teiid.dqp.internal.process.Request.initMetadata(Request.java:215)
at org.teiid.dqp.internal.process.Request.processRequest(Request.java:581)
at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:365)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:200)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:44)
at com.metamatrix.common.queue.WorkerPoolFactory$StatsCapturingSharedThreadPoolExecutor$1.run(WorkerPoolFactory.java:211)
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)
Caused by: org.teiid.connector.api.ConnectorException: "Non-uniquely named record detected 'TableRecordImpl name=OGIS_SPATIAL_REFERENCE_SYSTEMS, nameInSource=null, uuid=null, pathInModel=testdev/OGIS_SPATIAL_REFERENCE_SYSTEMS'
at org.teiid.connector.metadata.runtime.MetadataFactory.setValuesUsingParent(MetadataFactory.java:105)
at org.teiid.connector.metadata.runtime.MetadataFactory.addTable(MetadataFactory.java:117)
at org.teiid.connector.jdbc.JDBCMetdataProcessor.getTables(JDBCMetdataProcessor.java:171)
at org.teiid.connector.jdbc.JDBCMetdataProcessor.getConnectorMetadata(JDBCMetdataProcessor.java:89)
at org.teiid.connector.jdbc.JDBCConnector.getConnectorMetadata(JDBCConnector.java:334)
at org.teiid.dqp.internal.datamgr.impl.ConnectorWrapper.getConnectorMetadata(ConnectorWrapper.java:167)
at org.teiid.dqp.internal.datamgr.impl.ConnectorManager.getMetadata(ConnectorManager.java:161)
at com.metamatrix.dqp.embedded.services.EmbeddedDataService.getConnectorMetadata(EmbeddedDataService.java:147)
... 12 more
Regards
Ram