2 Replies Latest reply on Aug 30, 2009 6:18 AM by sharkin

    Problem to connect to data (based on the quick example)

      Hi,

      I realised a vdb and then tried to deploy it into a standalone application but seems like I'm being wrong somewhere.

      Here is what I did:
      1/ I unzipped teiid-6.1.0-embedded folder in the C:/ location

      2/ I put my test.vdb in the /deploy folder of the teiid-6.1.0-embedded folder

      3/ I created a new project under eclipse and writed a connection class based on the one in the Portfolio example

      4/ I added teiid-6.1.0-client.jar location to the java build path of my project.

      5/ Finally I launched the client.java and it ended with a failed run:

      Exception in thread "main" java.lang.SecurityException: The SunJCE provider may have been tampered.
       at com.sun.crypto.provider.PBEWithMD5AndTripleDESCipher.<init>(DashoA13*..)
       at com.sun.crypto.provider.SunJCE_z.a(DashoA13*..)
       at com.sun.crypto.provider.JceKeyStore.engineGetKey(DashoA13*..)
       at java.security.KeyStore.getKey(Unknown Source)
       at com.metamatrix.common.util.crypto.cipher.SymmetricCryptor.getSymmectricCryptor(SymmetricCryptor.java:94)
       at com.metamatrix.common.util.crypto.CryptoUtil.init(CryptoUtil.java:292)
       at com.metamatrix.common.util.crypto.CryptoUtil.init(CryptoUtil.java:266)
       at com.metamatrix.common.util.crypto.CryptoUtil.getCryptor(CryptoUtil.java:312)
       at com.metamatrix.common.util.crypto.CryptoUtil.stringDecrypt(CryptoUtil.java:347)
       at com.metamatrix.dqp.embedded.services.EmbeddedDataService.decryptProperty(EmbeddedDataService.java:542)
       at com.metamatrix.dqp.embedded.services.EmbeddedDataService.getDecryptedProperties(EmbeddedDataService.java:506)
       at com.metamatrix.dqp.embedded.services.EmbeddedDataService.createConnectorManger(EmbeddedDataService.java:448)
       at com.metamatrix.dqp.embedded.services.EmbeddedDataService.getConnectorManager(EmbeddedDataService.java:405)
       at com.metamatrix.dqp.embedded.services.EmbeddedDataService.getConnectorManager(EmbeddedDataService.java:412)
       at com.metamatrix.dqp.embedded.services.EmbeddedDataService.startConnectorBinding(EmbeddedDataService.java:238)
       at com.metamatrix.dqp.embedded.services.EmbeddedDataService.startService(EmbeddedDataService.java:355)
       at com.metamatrix.dqp.embedded.services.EmbeddedBaseDQPService.start(EmbeddedBaseDQPService.java:73)
       at com.metamatrix.common.application.Application.installService(Application.java:85)
       at com.metamatrix.common.application.Application.start(Application.java:70)
       at org.teiid.dqp.internal.process.DQPCore.start(DQPCore.java:599)
       at com.metamatrix.jdbc.EmbeddedConnectionFactoryImpl.initialize(EmbeddedConnectionFactoryImpl.java:107)
       at com.metamatrix.jdbc.EmbeddedDriver$EmbeddedTransport.<init>(EmbeddedDriver.java:386)
       at com.metamatrix.jdbc.EmbeddedDriver.getDQPTransport(EmbeddedDriver.java:164)
       at com.metamatrix.jdbc.EmbeddedDriver.createConnection(EmbeddedDriver.java:140)
       at com.metamatrix.jdbc.EmbeddedDriver.connect(EmbeddedDriver.java:116)
       at java.sql.DriverManager.getConnection(Unknown Source)
       at java.sql.DriverManager.getConnection(Unknown Source)
       at JDBCClient.getDriverConnection(JDBCClient.java:19)
       at JDBCClient.main(JDBCClient.java:9)


      The problem seems to come from my URL or the com.metamatrix.jdbc.EmbeddedConnectionFactoryImpl but I can't find it.

      I am suspicious with the "deploying teiid embedded", maybe I forgot something.

      Hope someone can help me.