Apologies for the delay ... I have lots of content and examples for you but I did not have a means for you to test your data templates. I have now rectified that and have taken one of our internal testbeds and packaged it up so you can test to your hearts content. The test bed is a web application that runs inside OC4J, I have not tested it with any other mid tier flavors but if you're game.
Before we start on the content lets install the app and test a sample data template.
- Download the EAR file here.
Well you would be able to download it if I can find somewhere that can host it. for now drop me a mail and I'll get it to you.
Finally found a home for the file on my website, you can get the file here, http://www.banzel.com/download/DTTestBed.ear
- I have tested with OC4J 9.0.4, 10.1.2 and 10.1.3 so once you have the EAR its a simple case of deploying it. If you do not have OC4J installed, go for the latest 10.1.3 release and have a nice UI to help you deploy the app.
- Once installed you just need to point your browser to http://yourserver:port/DTTestBed/DT1.jsp
4. The first page you'll see is:
I have created a small data template that will run against the scott/tiger schema, so download it from here. Then use the browse button to find it and hit Upload.
- You'll then get a page like this:
Heres where the fun starts, so in the page you have a parameter section, these are the parameters parsed out of the data template in this case we only have one, pDeptNo. You can fill in a value or leave it blank to get the complete data set.
Then we have the runtime options:
- Generate XML Schema - fairly obvious but very useful if you are going to be doing some PDF template mapping
- Generate Default Layout - this will generate an RTF template for you based on the data structure of the data template, again useful to get you started
- Layout Template - if you have already developed an RTF template (no it does not support PDF templates yet) then you can load it to be applied to the resulting data. If you choose this option then a default template will not be generated.
- Database - we need a connect string to the database, hostname:port:sid
- User Name - obvious
- Password - obvious if you have it
- ORG ID - this is for EBS customers that want to test data templates running against the EBS db - its not required.
- Generate XML Schema - fairly obvious but very useful if you are going to be doing some PDF template mapping
- So fill in some values so you have something like this:
and hit Submit
7. If all went well then you'll get a page of results similar to this:
There will be links to the various objects that XMLP has generated. These are all created in a temp directory under the root of the web app in mycase
D:Oc4j10.1.3j2eehomeapplicationsDTTestBedDTTestBedtemp
. Be sure to clean that directory up regularly it will fill your disk all to quickly.
So thats the test bed we are going to use in the coming articles ... get it up and running and you'll be able to try your first data template.
Comments (7)
Hi
the error is that you do not have a parameter defined:
Variable not defined: 'CURRENT_SERVER_URL'
So in your template you are referring to the above parameter but you have not declared it.
Regards
Tim
Posted by Tim Dexter | December 13, 2006 8:59 AM
Posted on December 13, 2006 08:59
i sent a message earlier...i cannot download the ear file since your mediamax account is not allowing downloads of file greater than 10MB. is there any other way we can download it?!?! it will make life so much easier...
Posted by Eric | March 11, 2007 5:59 AM
Posted on March 11, 2007 05:59
I have updated the links ... had to split the zip into two ...see the updated blog text for details.
Tim
Posted by Tim Dexter | March 15, 2007 10:11 AM
Posted on March 15, 2007 10:11
thanks so much.
Posted by Eric | March 25, 2007 7:39 AM
Posted on March 25, 2007 07:39
hi! i'm trying to unzip the second file, dttestbed.z01 but it says that the file is corrupted. anyway you can upload the correct file? thanks...
Posted by Eric | April 3, 2007 7:17 AM
Posted on April 3, 2007 07:17
Hmmm ... works for me and others ... make sure when you download the files they are called:
DTTestBed.zip
DTTestBed.z01
Then use zip to open the the first file and the z01 should be pulled into the process automatically. You should not need to deal with the z01 file at all.
Tim
Posted by Tim Dexter | April 3, 2007 9:00 AM
Posted on April 3, 2007 09:00
I've deployed this application on a 10.1.3 and 10.1.2.2 application server and I receive this error after entering the Data Template Runtime Options on DT2.jsp:
500 Internal Server Error
java.lang.NullPointerException at _DT3._jspService(_DT3.java:447) [SRC:/DT3.jsp:392] at com.orionserver[Oracle Containers for J2EE 10g (10.1.3.0.0) ].http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:416) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:299) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:187) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:595)
Any suggestions?
Eric V
Posted by Eric V | June 9, 2008 4:34 PM
Posted on June 9, 2008 16:34