Problem to connect to data (based on the quick example)
sharkin Aug 27, 2009 6:07 PMHi,
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.