Max,

Thanks much for your quick response. I am trying to build a model wherein I would be importing relational and SalesForce models and then deploying them as a VDB. In order to do that, I will need SOA-P and EDS.

Please let me know if I have understood this correctly:

1. Teiid Designer version 8 is required to import models from SalesForce which in turn requires Eclipse 3.8/4.0 (available
2. JBDS 6 is required to be able to install the Teiid 8 plug-in
3. JBDS 6 may or may not function correctly with SOA-P and EDS

Thanks again

rajesh

Barry/Max,

Thank you again for your response and breaking it down in simple terms. I am a complete newbie to this and my apologies if some of my questions/terminology is basic. Essentially, what prompted me to go the Teiid 8 route was the error ( There was an import error.The Salesforce ModelExtensionAssistant subclass was not found by the model extension registry.), when trying to import a SF model. I thought I had read somewhere that I needed to upgrade to Teiid 8 to get around this - maybe I misunderstood.

It is good to know that based on your response, I can stay with Teiid 7.7 or 7.8 and JBDS ver 5. I have reinstalled JBDS ver 5 and the Teiid 7.8 plug-in. However, when I try to import a SF model, I receive the error message -There was an import error.The Salesforce ModelExtensionAssistant subclass was not found by the model extension registry - consistently.

On a somewhat related note, I also receive a sporadic error (java.lang.NullPointerException) when I try to connect to SalesForce. This error, however seems to go away if I remove the workspace files and folders and start from scratch. The error from the previous paragraph just doesn't go away.

The uploaded document contains screen shots of both the error messages referenced here.

Any help on what else needs to be done to get around this will be much appreciated.

Finally, a quick question - I can open a different thread if it makes more sense. What is the access mechanism for the end user once I have a VDB created and deployed. I am clear as to how users can run queries against the deployed VDB. Would they require some sort of a JBoss client tool?

Thanks

rajesh

Mark,

Thanks for your response. I uninstalled JBDS and tried to install "SOA and Data Services Tool" from JBossCentral -> Software/Update, but the following errors came up. When I paste the URL (from Error 1 below), I get the following response.

This XML file does not appear to have any style information associated with it. The document tree is shown below.

<?compositeMetadataRepository version='1.0.0'?><repository name="JBoss Developer Studio Central Update Site - SOA Tooling" type="org.eclipse.equinox.internal.p2.metadata.repository.CompositeMetadataRepository" version="1.0.0"><properties size="2"><property name="p2.compressed" value="true"/><!--

     get new time w/

      date +%s000

--><property name="p2.timestamp" value="1351887891000"/></properties><children size="3"><child location="../../soa-tooling/"/><child location="../../extras/"/><child location="../../"/></children></repository>

Error 1:

Unable to read repository at https://devstudio.jboss.com/updates/5.0/central/soa-tooling/compositeContent.xml.

Stack Trace 1:

java.net.SocketException: socket closed

    at java.net.SocketInputStream.socketRead0(Native Method)

    at java.net.SocketInputStream.read(SocketInputStream.java:129)

    at com.sun.net.ssl.internal.ssl.InputRecord.readFully(InputRecord.java:293)

    at com.sun.net.ssl.internal.ssl.InputRecord.read(InputRecord.java:331)

    at com.sun.net.ssl.internal.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:789)

    at com.sun.net.ssl.internal.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1096)

    at com.sun.net.ssl.internal.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1123)

    at com.sun.net.ssl.internal.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1107)

    at sun.net.www.protocol.https.HttpsClient.afterConnect(HttpsClient.java:405)

    at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:166)

    at sun.net.www.protocol.https.HttpsURLConnectionImpl.connect(HttpsURLConnectionImpl.java:133)

    at org.eclipse.ecf.provider.filetransfer.browse.URLFileSystemBrowser.runRequest(URLFileSystemBrowser.java:113)

    at org.eclipse.ecf.provider.filetransfer.browse.AbstractFileSystemBrowser$DirectoryJob.run(AbstractFileSystemBrowser.java:69)

    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

Error 2:

Invalid URL: http://download.jboss.org/jbosstools/examples/project-examples-category-jbds-3.3.xml

No stack trace for Error 2

Error 3:

HttpClient Provider is not configured to support NTLM proxy authentication.

Stack Trace 3:

org.eclipse.ecf.filetransfer.IncomingFileTransferException: HttpClient Provider is not configured to support NTLM proxy authentication.

    at org.eclipse.ecf.provider.filetransfer.httpclient.HttpClientRetrieveFileTransfer.openStreams(HttpClientRetrieveFileTransfer.java:730)

    at org.eclipse.ecf.provider.filetransfer.retrieve.AbstractRetrieveFileTransfer.sendRetrieveRequest(AbstractRetrieveFileTransfer.java:889)

    at org.eclipse.ecf.provider.filetransfer.retrieve.AbstractRetrieveFileTransfer.sendRetrieveRequest(AbstractRetrieveFileTransfer.java:576)

    at org.eclipse.ecf.provider.filetransfer.retrieve.MultiProtocolRetrieveAdapter.sendRetrieveRequest(MultiProtocolRetrieveAdapter.java:106)

    at org.jboss.tools.project.examples.filetransfer.ECFExamplesTransport.transfer(ECFExamplesTransport.java:319)

    at org.jboss.tools.project.examples.filetransfer.ECFExamplesTransport.performDownload(ECFExamplesTransport.java:246)

    at org.jboss.tools.project.examples.filetransfer.ECFExamplesTransport.download(ECFExamplesTransport.java:206)

    at org.jboss.tools.project.examples.model.ProjectExampleUtil.getProjectExamplesFile(ProjectExampleUtil.java:796)

    at org.jboss.tools.project.examples.model.ProjectExampleUtil.handleCategories(ProjectExampleUtil.java:544)

    at org.jboss.tools.project.examples.model.ProjectExampleUtil.getProjects(ProjectExampleUtil.java:491)

    at org.jboss.tools.project.examples.model.ProjectExampleUtil.getProjects(ProjectExampleUtil.java:305)

    at org.jboss.tools.central.jobs.RefreshTutorialsJob.run(RefreshTutorialsJob.java:53)

    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

As always, thanks much for helping me get through this issue.

As for the end user question, would you mind please elaborating or pointing me to a doc that might contain such information. My apologies, but I am not clear how the end user would run queries against the deployed VDB. You mention JDBC, but are there end user/client based tools that they would use to run such queries?

Thanks

rajesh

Thank you Mark. I checked the "SOA and Data Services Tool" box and hit Install, and that's when the errors come up. I am attaching a screen shot.

I will look at the Developer's guide and Squirrel SQL as well in the meantime.

Thanks again

rajesh

Mark,

I was able to get past the Install error (from JBoss Central -> Software/Update) by adding our proxy host in Windows->Preferences->General->Network Connections. Once I did that, clicking on Install provided me with a list of plug-ins to choose from and as you pointed out, the Teiid plug-ins were at the bottom.

I successfully installed version 7.7.2 and connect to SalesForce; however, the error when I try to Import a SF Model still persists. I am attaching a screen shot of the error.

Thanks again

rajesh

Mark,

Here is the stack trace from the import error. I am hoping this sheds more light on what might be going on.

java.lang.IllegalStateException: The Salesforce ModelExtensionAssistant subclass was not found by the model extension registry.

    at com.metamatrix.modeler.modelgenerator.salesforce.RelationalModelgenerator.<init>(RelationalModelgenerator.java:90)

    at com.metamatrix.modeler.modelgenerator.salesforce.SalesforceImportWizardManager.createModel(SalesforceImportWizardManager.java:233)

    at com.metamatrix.modeler.modelgenerator.salesforce.SalesforceImportWizardManager.runFinish(SalesforceImportWizardManager.java:200)

    at com.metamatrix.modeler.modelgenerator.salesforce.ui.wizards.SalesforceToRelationalImportWizard$1.run(SalesforceToRelationalImportWizard.java:147)

    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)

Thanks

rajesh

Mark,

I am attaching the log file. I believe the error related to SalesForce is @2013-01-08 18:24:45.647.

As for the Model Extension Registry, it shows me an empty table with column headers - Built-in, Namespace-Prefix, Namespace URI, Model Class etc.

And, yes, I did choose all 3 Teiid components

Thanks again

rajesh