Jdeveloper, Webdav, Oracle PSP, Dynamic PSP and Java Gateway servlet (JOPA)

Developing Dynamic PSP with JDeveloper 10g

Purpose

This page shows you how to develop Dynamic PSP with JDeveloper 10g.

Overview

JDeveloper provides functionality to view and modify objects by using WEBDAV.

Scenario

You have existing Dynamic PSP pages that you want you manage with JDeveloper. You also want to use JDeveloper to tune SQL statements, create and deploy new Java stored procedures, and create and debug PL/SQL stored procedures.

Prerequisites

In order to work successfully, you will need to have performed the following:

1.	Install Oracle JDeveloper10g. JOPA servlet and Dynamic PSP were 100% tested at Oracle JDeveloper10g. versions : Oracle JDeveloper 10g (Version 10.1.2, build 1811) Oracle JDeveloper 10g (Version 9.0.5.2, build 1618) Oracle JDeveloper 10g (Version 9.0.5.1, build 1605) Oracle9i JDeveloper (Version 9.0.4.1.1, build 1436) Oracle9i JDeveloper Maintenance Release (Version 9.0.3.4, build 1247)
1.1	For use Oracle JDeveloper 10g Version 9.0.5.1 and higher install webdav patch for Jdeveloper WebDav parser from our site. Just copy webdavpatch.jar to jdev\lib\patches and restart Jdeveloper.
2.	Install Dynamic PSP
3.	Install Jopa Servlet

Step 1 - Setup WebDAV connect string to Dynamic PSP

Use URL Location: http://www.dynamicpsp.com/servlets/jopa/ ntsdemo/ to connect to our demo site.

Step 2 - Deploy DPSP Username and Password.

Use username: guest and password: guest to connect to our demo site.

Step 3 - Test connection.

Click on "Test Connection" to connect to our demo site.

Step 4 - Connect to WebDav by Jopa Servlet

Step 5 - Setup highlighting .dpsp and .psp extentions Jdeveloper

Tools > Preferences > File Types > JSP sources > Add

Step 6 - Look at that page throw Jdeveloper 10g.

Click here for download page.