-
1. Re: Deployment Excpetions for VDB created for WS View Generated FromRelational Model
rareddy Mar 24, 2013 10:17 AM (in response to darnowsi)You can open the .vdb file with a zip utility and take look at the vd.xml file, it should list the errors why VDB is not valid. The same errors should be in eclipse problem view too. I suggest cleaning the project and rebuilding it.
Ramesh.. -
2. Re: Deployment Excpetions for VDB created for WS View Generated FromRelational Model
darnowsi Mar 24, 2013 2:49 PM (in response to rareddy)Ramesh,
I tried cleaning the project and rebuilding but the persist.
When I look at the vdb I do find errors for 2 of the models. But these are the models created by the desinger during web service generation.
Attached is thecomplete vdb file.
</model>
<property value="3759526602" name="checksum" /><property value="XML Schema (XSD)" name="modelClass" /><property value="false" name="builtIn" /><property value="2864732308.INDEX" name="indexName" /><validation-error severity="ERROR">Referenced file contains errors (http://www.metamatrix.com/metamodels/SimpleDatatypes-instance). For more information, right click on the message in the Problems View and select "Show Details..."</validation-error></model>
<property value="4192914346" name="checksum" /><property value="XML Schema (XSD)" name="modelClass" /><property value="false" name="builtIn" /><property value="2654916427.INDEX" name="indexName" /><validation-error severity="ERROR">Referenced file contains errors (http://www.metamatrix.com/metamodels/SimpleDatatypes-instance). For more information, right click on the message in the Problems View and select "Show Details..."</validation-error></model>
</vdb
Steve
-
oracle_view_Ws.zip 23.2 KB
-
-
3. Re: Deployment Excpetions for VDB created for WS View Generated FromRelational Model
rareddy Mar 25, 2013 8:12 AM (in response to darnowsi)Which version of Teiid Designer? with Teiid 7.7 you want to use Teiid Designer 7.8
If the problem still exists, please check with latest Designer version, then log a JIRA.
Ramesh..
-
4. Re: Deployment Excpetions for VDB created for WS View Generated FromRelational Model
darnowsi Mar 25, 2013 11:31 AM (in response to rareddy)Ramesh,
I have actually been using Teiid Designer 7.8. Just to be clear my understanding is the final stable version of Teiid Designer is 8.0 . 8.1 is released but still Alpha.
So is the recommendation is to install Teiid runtime 8.3, Teiid Designer 8.0, Eclipse 4.2 and Jboss 7.1
Also you can you tell me how these versions line up with product version from Red hat?
-
5. Re: Deployment Excpetions for VDB created for WS View Generated FromRelational Model
rareddy Mar 25, 2013 12:33 PM (in response to darnowsi)Steve,
Designer 8.x versions support --> Teiid 8.x versions.
Redhat EDS is based on
EDS 5.3 is based on --> Teiid 7.7.x version, only Teiid 7.7 is released in community
JBDS is has Teiid Designer plugin based Designer 7.8.x
If you are working with community version, you can go up latest Teiid 8.3, and Teiid Designer 8.1.Alpha versions. if problen exists open a JIRA.
If you are already using the product then you have the stable version, and you can open a ticket with Redhat for resolution.
Ramesh..
-
6. Re: Deployment Excpetions for VDB created for WS View Generated FromRelational Model
darnowsi Mar 26, 2013 10:18 AM (in response to rareddy)Ramesh,
I have instllaed Teiid 8.3 and 8.1 designer.
I can create an oracle data source but oracle translator is not being deployed What do I have to do for this to happen?
Also what version of jbossws-cxf should I install?
Steve
-
7. Re: Deployment Excpetions for VDB created for WS View Generated FromRelational Model
rareddy Mar 26, 2013 11:53 AM (in response to darnowsi)Steve,
Not sure what you mean by "oracle" translator not deployed? If you installed Teiid correctly (unzip over JBoss AS 7.1.1.Final), then you should see it in the deployment. If you are talking about, not showing up in the Teiid Designer, you need to configure the Server instance before installed translators show up in the VDB explorer window.
Teiid 8.3 only works with JBoss AS 7.1.1, and AS 7.1.1 comes with "cxf" installed, no further installation required as before with JBoss AS 5.1.0
Ramesh..
-
8. Re: Deployment Excpetions for VDB created for WS View Generated FromRelational Model
darnowsi Mar 27, 2013 6:26 PM (in response to rareddy)Ramesh,
I was not specifying the standalone teiid config as a parameter to JBoss AS 7.1 server. I corrected this and am now getting all the expected translators deployed. I also followed the instructions for configure the oralcle jdbc driver as a data source that are in the teiid doc directory. The oracle ds is listed as deployed in the teiid server however the following error appears in the log: JBAS014775: New missing/unsatisfied dependencies:
service jboss.jdbc-driver.oraclejdbc (missing) dependents: [service jboss.data-source.java:/OracleDS] . I have attached the teid standalone config and the oracle module file. I am now able to generate a web service now after the upgrade to 8.3/8.1. I had to manaully build the war since the teiid web service generator did not find a jdk in the project build path.The jbossws-cxf file generated by teiid for web service project does not verify but I was able to go ahead and generate a war file and deploy it to the server. One other hitch I had to manually copy the xsd schema file for WSDL to the same directory and the WSDL. After doing that I was able to publish the wsdl so that it can be loaded into Soap UI and the also the Eclipse built web service explorer. When I try a request from Soap UI I get a text message back that the resource was not available. From web service explorer in eclipse I get the error: IWAB0135E An unexpected error has occurred.403 Forbidden. I don;'t see anything the server log so this maybe a web access problem. The test tool and the server are on my local system. Any suggestions on how to troubleshoot these problems would be appreciated.Steve
.-
standalone-teiid.xml 21.7 KB
-
module.xml 290 bytes
-
-
9. Re: Deployment Excpetions for VDB created for WS View Generated FromRelational Model
rareddy Mar 27, 2013 9:41 PM (in response to darnowsi)Steve,
Did you place the "module.xml" along with "ojdbc6.jar" in the "<jboss-as>/modules/com/oracle/main" directory? Your configuration inside the "standalone-teiid.xml" look correct.
I had to manaully build the war since the teiid web service generator did not find a jdk in the project build path.The jbossws-cxf file generated by teiid for web service project does not verify but I was able to go ahead and generate a war file and deploy it to the server.
Did you configure the JDK inside the Eclipse? go into Eclipse preferences, JAVA and configure JDK, then it should work.
One other hitch I had to manually copy the xsd schema file for WSDL to the same directory and the WSDL.
hmm, that is not good. You should open a JIRA on this.
After doing that I was able to publish the wsdl so that it can be loaded into Soap UI and the also the Eclipse built web service explorer. .
The war deployed correctly in that case. Make sure you se log message on the JBoss log that war deployed and shows the WSDL url and context for it. See if you can access the wsdl from the browser.
When I try a request from Soap UI I get a text message back that the resource was not available. From web service explorer in eclipse I get the error: IWAB0135E An unexpected error has occurred.403 Forbidden. I don;'t see anything the server log so this maybe a web access problem. The test tool and the server are on my local system. Any suggestions on how to troubleshoot these problems would be appreciated
I suspect there is still an issue with deployment, check to make sure that is right and endpoint is correct. SOAP-UI has http-logs see those.
If you want share your vdb and xsd file, war file I can take a look.
Ramesh..
-
10. Re: Deployment Excpetions for VDB created for WS View Generated FromRelational Model
darnowsi Mar 28, 2013 11:53 AM (in response to rareddy)Did you place the "module.xml" along with "ojdbc6.jar" in the "<jboss-as>/modules/com/oracle/main" directory? Your configuration inside the "standalone-teiid.xml" look correct.
Yes, I checked and the jar is in the same folder.
I had to manaully build the war since the teiid web service generator did not find a jdk in the project build path.The jbossws-cxf file generated by teiid for web service project does not verify but I was able to go ahead and generate a war file and deploy it to the server.
Did you configure the JDK inside the Eclipse? go into Eclipse preferences, JAVA and configure JDK, then it should work.
I have jdk 1.6 set as the jre in windows preferences. Is there something else I need to check.
One other hitch I had to manually copy the xsd schema file for WSDL to the same directory and the WSDL.
hmm, that is not good. You should open a JIRA on this.
After doing that I was able to publish the wsdl so that it can be loaded into Soap UI and the also the Eclipse built web service explorer. .
The war deployed correctly in that case. Make sure you se log message on the JBoss log that war deployed and shows the WSDL url and context for it. See if you can access the wsdl from the browser.
When I try a request from Soap UI I get a text message back that the resource was not available. From web service explorer in eclipse I get the error: IWAB0135E An unexpected error has occurred.403 Forbidden. I don;'t see anything the server log so this maybe a web access problem. The test tool and the server are on my local system. Any suggestions on how to troubleshoot these problems would be appreciated
I suspect there is still an issue with deployment, check to make sure that is right and endpoint is correct. SOAP-UI has http-logs see those.
The endpoint is wrtws/wrtsviewbase- the SOAP UI log indicates this resource can't be found. Looking at the war deployment on the server it looks like this does not match the directory structure. There is no directory wrtsws??
If you want share your vdb and xsd file, war file I can take a look.
I have attached the war file as deployed on the server , wdb, soapUI log and console output after publishing the war.
-
soapUILog.txt.zip 1.3 KB
-
wrtswebservice.war.zip 299.3 KB
-
vdb.xml 2.3 KB
-
-
11. Re: Deployment Excpetions for VDB created for WS View Generated FromRelational Model
darnowsi Mar 28, 2013 3:21 PM (in response to darnowsi)Ramesh,
I tried creating a the war the same name (wrtsws) as the vdb and got a little further.
When running from SOAPUI I now get an internal server error. Looking at the console the ws provider code got a naming exception trying to do a jndi lookup for java:wrtsws to use as part of the connection. Isn't this name for the vdb?
4:34:04,657 SEVERE [org.teiid.soap] (http-localhost-127.0.0.1-8080-2) Exception in executeDataservice: {0}: java.lang.Throwable:
javax.naming.NameNotFoundException
: java:wrtsws
.Steve
-
12. Re: Deployment Excpetions for VDB created for WS View Generated FromRelational Model
tejones Mar 28, 2013 4:39 PM (in response to darnowsi)Hi Steve,
The JNDI name should be the Teiid VDB datasource defined in your standalone-teiid.xml.. for example:
<datasource jndi-name="java:/someJNDIName" pool-name="somePoolName" enabled="true"> <connection-url>jdbc:teiid:MyVDB@mm://localhost:31000</connection-url> <driver>teiid-local</driver> <security> <user-name>user</user-name> <password>password</password> </security> </datasource>
Also w.r.t. compilation of the WAR, you can specify the JDK in the shortcut to your Designer instance.For example, append something like this in your Eclipse shortcut:
...install_dir\eclipse.exe -vm "C:\Program Files\Java\jdk1.6.0_16\bin\javaw.exe"
That will allow you to compile the WAR in Designer.
Thanks,
Ted
-
13. Re: Deployment Excpetions for VDB created for WS View Generated FromRelational Model
darnowsi Apr 1, 2013 11:57 AM (in response to tejones)Ted,
I added the data source as you suggested. When I run the server I can see the ds deplyoyed in the teiid server. I also can see the data source and a jndi string of "java:wrtsws" in the admin console. However whenr I try to connect from my SOAP UI client I am still getting the name not found error for java:wrtsws error in the console log. Any suggestions on how to troubleshoot this problem further would be very much apprecaited. I also the run -vm option for eclipse and this did result in the war being generated from the designer. However I was not succesful when deplyong the resultant WAR, so I remove this option in the Eclipse startup since being able to breakpoint the source seems to be useful when troubleshooting this problem.
Steve
-
14. Re: Deployment Excpetions for VDB created for WS View Generated FromRelational Model
tejones Apr 1, 2013 12:08 PM (in response to darnowsi)Steve,
I think the format of the JNDI name is wrong. It should be
java:/wrtsws.
You can enter that in the WAR Generation wizard and regenerate or edit the teiidsoap.properties file directly. It is in the web-inf/classes folder.Thanks,
Ted