DPSP
Contacts About Us


Powered by Dynamic PSP
Dynamic PSP

Welcome to dynamicpsp.com, home of Dynamic PSP™ and Objective PSP™ technologies for Oracle 11g, Oracle 10g, 8i/9i-based Internet development.

Blog on Russian is here. On English coming soon.
If you have any question do not hesitate, ask me.

February 5, 2011: Dynamic PSP is still alive and will never gets old. We started to develop a new version Dynamic PSP and JOPA™ Gateway Servlet for Oracle 11g. We have also in our plans to make a version of JOPA™ Gateway Servlet where you can rule a site within iPhone 4g and iPad.

June 20, 2007: The JOPA™ Gateway Servlet v.2007 provide connection to Oracle APEX (formally known as HTMDB), within one simple way. Because Oracle XE does not have any web interface and by using our servlet you can develop Oracle XE plus APEX on one site. Click here to view how it is works.

THE JOPA™ GATEWAY SERVLET v.2007 tested with Adobe Dreamweaver CS3

June 19, 2007: The JOPA™ Gateway Servlet v.2007 can provide connecton within WEBDAV protocol by using Adobe Dreamweaver CS3 to Dynamic PSP product and hundred persent tested. more...

December 29, 2006: The task: Uploading data from .dbf file to Oracle, by using PL/SQL convert file from *.dbf file to *.csv file and use the result *.csv file for Oracle external table.
Solution: Create Java class to convert file.
PL/SQL:
set serverout on
declare
Path varchar2(1000) := '/temp/'; -- directory with perms
DFBFile varchar2(1000) := 'DFBFile.dbf';
CSVFile varchar2(1000) := 'CSVFile.csv';
Fine varchar2(1000);
begin
Fine :=
nn$dbf2csv.dbf2csv(Path||DFBFile, Path||CSVFile, ';');
dbms_output.put_line(substr(Fine,1,255));
end;
/

Result
: Done.
Will be created 'CSVFile.csv' file inside '/temp/' dir.
Fine will return a sql script for create external table
Install:
1. loadjava -user user/user@ora -grant public -resolve dbf2csv.jar
2. sqlplus user/user@ora @dbf2csv.sql


Note:
run dbms_java.grant_permission for '/temp/'

April 11, 2006: DPSP Version 2.5.1 build for Oracle Database 10g/9i and Oracle Express Edition (Oracle Database XE).
* Oracle XE non Java version file - create_xe.sql
* Oracle 10g/9i with Java version file - create_all.sql
* Oracle 8i with Java version file - create_all.sql
* Servlet for Tomcat 5.5 with source code included
* JSP access for Tomcat 5.5 with source code included
* Admin Unit's with source code included
* Added Unit's function whoCalledMe return number of unit caller
* Added Unit's function getUnitAttr(id in varchar2, attr in varchar2 default null) return varchar2
* Added Unit's attributes COMMENT, ANNOUNCEMENT, LOCAL_PATH, PARAMS

----------------------------------------------------------------------
How to Install Dynamic PSP, Version 2.5.1 - Oracle XE/10g/9i
----------------------------------------------------------------------
Oracle XE
>
sqlplus "sys/...@... as sysdba" @create_xe.sql
Oracle 8/9/10g
> sqlplus "sys/...@... as sysdba" @create_all.sql or
> sqlplus "sys/...@... as sysdba" @create_java.sql

----------------------------------------------------------------------
Please Read Section "4. IMPORTANT!" in Readme.txt
----------------------------------------------------------------------

Also includes Dynamic PSP core, unlimited units license, JOPA and licenses for all released DPSP add-ons, unit sources and more.

April 10, 2006: The task: Uploading data from .xls file to Oracle, by using PL/SQL convert file from *.xls file to *.csv file and use the result *.csv file for Oracle external table.
Solution: Create Java class to convert file.
PL/SQL:
set serverout on
declare
Path varchar2(1000) := '/temp/'; -- directory with perms
Fname varchar2(1000) := 'ExcelFile.xls';
Fine varchar2(1000);
begin
Fine := nn$gocsv.ConvertCSV(Path,Fname,';');
dbms_output.put_line(substr(Fine,1,255));
end;

/
Result: Done.
Will be created 'ExcelFile.xls.csv' file inside '/temp/' dir.
Note: run dbms_java.grant_permission for '/temp/'

Dynamic PSP Version 2.4.5

February 15, 2006: DPSP Version 2.4.5 build for Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that's free to develop, deploy, and distribute; fast to download; and simple to administer.

DPSP Version 2.4.5

* Oracle 10g/XE tested
* Apache2 and Tomcat 5.5 tested
* JOPA GATEWAY SERVLET included
* Site-Ready UNITs with visial editor

Also includes Dynamic PSP core, unlimited units license, JOPA and licenses for all released DPSP add-ons, unit sources and more.

DEPLOYING JOPA GATEWAY SERVLET TO APACHE TOMCAT 5.X.X

September 13, 2005: Apache Tomcat 5.x.x is the JServ offspring fully conformant to the J2EE 1.3 and later specifications. Deployment to the Tomcat server is very simple:Copy the jopa.war file to the {CATALINA_HOME}/webapps directory or upload it through the Tomcat management interface. The Tomcat server will detect the new WAR and deploy it automatically. However, before the JOPA Servlet can be used, you need to edit the WEB-INF/web.xml file in the {CATALINA_HOME}/webapps/jopa directory, where the servlet will be automatically deployed, and set cfgfile initialization parameter to contain correct full path to the JOPA configuration file. Save the web.xml file and the Servlet will be fully functional. more info

May 16, 2005: JOPA servlet and Dynamic PSP were 100% tested at Oracle JDeveloper10g.
  • 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)
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. more info

Dynamic PSP Version 2.4.4

Installation instructions

April 25, 2005: Dynamic PSP Version 2.4.4 Enterprise Edition includes Dynamic PSP core, unlimited units license, JOPA Runtime and licenses for all released DPSP add-ons, plus at least one license for all new add-ons which will be released within 1 year of purchase date.
* Fixed UTF-8 support in DPSP Kernel
* Fixed EditorMainForm (build in Unit Editor) to save long files. Now limit is 200000 bytes per unit.
* Added new DPSP Example 5: Upload File
* Added new DPSP Example 6: Download File
* Added ErrorDocument-401 support
* Added ErrorDocument-403 support
* Added ErrorDocument-404 support

Installation instructions is here

March 14, 2005: You may deploy the servlet manually or automatically through the server management and deployment tools. To deploy the servlet manually, you need to copy the supplied JAR or WAR file (jopa.jar or jopa.war) to the application server and add it to the servlets container class path. Deploying servlets differs from container to container, so you need to consult your container's documentation for instructions on servlet deployment. This chapter will describe in detail how to deploy the servlet on Apache JServ and Oracle OC4J. Other containers may require different deployment procedures, though since the servlet is provided in standard WAR archive, there should be no problems deploying it to any J2EE 1.3 compatible container. more info

January 24, 2005: Dynamic PSP API allows you to create a simple JSP code to access any DPSP unit. Do not lose your time to write complicated code for JSP just use this simple example to access any DPSP page. By using DPSP you can write any PL/SQL code and run it by using just one JSP page.

THE JOPA™ GATEWAY SERVLET FOR ORACLE® PL/SQL™ WEB APPLICATIONS.

January 24, 2005: You are developing a web application which is based on an Oracle® database. You want to use PSP (PL/SQL™ Server Pages) technology along with other server-side scripting technologies, like JSP, to build the application and leverage the power of PL/SQL where appropriate. However, your developers are working remotely and you don’t want to open direct access to the database for them or anyone else outside your local network. Dynamic PSP™ seems to be natural choice for these requirements, but your developers are unfamiliar with its web-based development interface or find it too simple and limited compared to web development tools like Macromedia DreamWeaver® or Microsoft® FrontPage®. You need some way to provide them with access to the Dynamic PSP unit repository, the database and the web server without putting the database at risk by opening it to the whole world and opening too many alternate access paths to the web server file system. You also want your Dynamic PSP application to process requests as quickly as possible with minimal overhead introduced by the middleware. more info

December 29, 2004: Dynamic PSP Version 2.4.2 Enterprise Edition includes Dynamic PSP core, unlimited units license and licenses for all released DPSP add-ons, plus at least one license for all new add-ons which will be released within 1 year of purchase date.
* Added Impex - Dynamic PSP(tm) Import/Export Utility
* Added NLP (Natural Language Processing) - is an add-on to Dynamic PSPT (DPSPT). NLP allows teaching your DPSP units to speak different languages.
* Added Name-Tree Service (NTS) is a Dynamic PSP add-on module, which provides developers and content managers with familiar and comfortable file system-like resource naming subsystem for managing Dynamic PSP units and static content, like images and documents, over the web. When installed on Dynamic PSP system, NTS provides name resolution layer for DPSP Kernel and adds web interfaces for managing the tree structure and resources of the site. NTS is transparent to the end users and developers accessing the DPSP site. In addition, NTS provides a framework API that allows developers to extend basic capabilities of the system by adding new resource types and mechanisms for accessing and processing them. NTS is also a vital component for JOPA Gateway servlets WebDAV support. JOPA servlet (available by request) relies on NTS for building the virtual file system and managing resources (Dynamic PSP units and files) of a DPSP-powered site.
Installation instructions is here

Forget about mod_plsql and try our JOPA servlet !

December 7, 2004: By clicking on that link whole our site will be displayed throw JOPA™ Gateway Servlet - an alternative to mod_plsql gateway, the JOPA Gateway Servlet supports latest IETF standards and is designed to overcome limitations and flaws in mod_plsql.
Look here how to use DreamWeaver™ MX 2004 and Dynamic PSP for Oracle !

Dynamic PSP™ for Macromedia® DreamWeaver™ is here.
JOPA™User Guide is here.

We published a new demo and now you can try a power of Dynamic PSP !

December 5, 2004: Here you can try to edit any screen of our site and looked at your changes online. Sure it is will not related to real data, because this is only a demo.
By clicking on that link you can try to edit our home page and look at your results online.

Dynamic PSP website goes online - www.mazservice.ru !

November 15, 2004: "MAZService" as Russian's company, changed website by using our technology, which provides fastest and easiest solution for building sophisticated interactive and responsive Web based applications. This is totally redesigned information system based on Dynamic PSP.

A very Easy Reports !

May 14, 2004: Using our "Easy Reports" from Dynamic PSP you can publish Reports in three easy steps. Our "Easy Reports" is fully supports sorting by columns names !
Click Here to view a real example online.

Getting Started Macromedia® DreamWeaver™ and Dynamic PSP® for Oracle™ !

April 19, 2004: Look at our "Getting Started" and you will see how easy to manage sites within JOPA™ and Dynamic PSP.
And you can test it online right away - just download connection for DreamWeaver to our Demo site. Do not forget to install Dynamic PSP support Site Extension for Macromedia Products.

Dynamic PSP technology provides fastest and easiest solution for building sophisticated interactive and responsive Web based applications using Oracle RDBMS. Combining simplicity and power it gives developers really rapid way for creating high-performance business applications for intranets and Internet. Based on Oracle 11g, Oracle 10g, 8i/9i and its native programming language, PL/SQL, Dynamic PSP technology allows developers to use all capabilities of this most powerful database for rapid Internet/intranet applications development right from their browsers.

Main features:

  • Browser-based development environment
  • No intermediate steps like compilation and uploading files are required
  • Changes in applications can be done fast and easily
  • No additional software except Oracle Database and web browser is required
  • Tight integration with Oracle Database
  • Platform independence (runs anywhere Oracle does)
  • Easy to learn and use

More about features and benefits...

Click here for more info and news...

We are also offering web-enabled software development services using our advanced technologies and expertise. Head over here to find out in which areas we may be of service to you.

 
News
10 January, 2014
Free UTL_BinFile Suite updated to Version 1.0.11, compatible with 11g Release 2!
UTL_BinFile Suite is shipped as part of our PSP_Mail product. Now it is freely available as separate download. The suite allows listing, reading and writing binary files in Oracle server's OS file system, as well as listing archive contents and extracting files from external and internal (stored in BLOBs in the database) ZIP/JAR archives, copying, moving, deleting and renaming files, creating directories, and creating and updating ZIP archives (either internal or external) from PL/SQL programs. New version improves compatibility with latest Oracle Database releases. And it's still absolutely free of charge! Go to our Download section to grab your copy.
12 April, 2011
Java XML-RPC publisher for Dynamic PSP
Java XML-RPC page/unit/post for Dynamic PSP just finished. Now you can post pages to Oracle by using full list of Weblog Clients.
23 March, 2011
New version UTL_B64 of PSP_Mail tested for Oracle 11.
UTL_BinFile Suite is shipped as part of our PSP_Mail product. Now it is freely available as separate download. The suite allows listing, reading and writing binary files in Oracle server's OS file system, as well as listing archive contents and extracting files from external and internal (stored in BLOBs in the database) ZIP/JAR archives, copying, moving, deleting and renaming files, creating directories, and creating and updating ZIP archives (either internal or external) from PL/SQL programs. New version coming soon. Fully tested for 11gR2 in UTF-8 encoding.
20 February, 2011
Wordpress and Dynamic PSP
Now you can use any Wordpress site and Dynamic PSP within Jopa servlet. Ask me how.
5 February, 2011
Create a new site?
You are in the right place. Dynamic PSP is still alive and will never gets old. We started to develop a new version Dynamic PSP and JOPA™ Gateway Servlet for Oracle 11g. We have also in our plans to make a version of JOPA™ Gateway Servlet where you can rule a site within iPhone 4g and iPad. If have any question try a new contact form. Stay tuned.
9 March, 2006
Free UTL_BinFile Suite is updated to Version 1.0.9!
UTL_BinFile Suite is shipped as part of our PSP_Mail product. Now it is freely available as separate download. The suite allows listing, reading and writing binary files in Oracle server's OS file system, as well as listing archive contents and extracting files from external and internal (stored in BLOBs in the database) ZIP/JAR archives, copying, moving, deleting and renaming files, creating directories, and creating and updating ZIP archives (either internal or external) from PL/SQL programs. New version adds routines for file copying and moving and features some internal optimizations. And it's still absolutely free of charge! Go to our Download section to grab your copy.
15 February, 2006
Apache2, Tomcat and Oracle XE.
That is a good article JSP Quick-Start Guide for Windows how to link Tomcat and Apache2. By using Dynamic PSP 2.4.5 for Oracle XE you can start your developing based on the best database today.
1 October, 2005
JOPA Gateway Servlet Release 1.6.2 is now available.
This maintenance release fixes a few outstanding issues with the servlet and adds several minor enhancements in Administrative Interface and various database access modules. System requirements section of the User's Guide and Reference is also updated - please read it to make sure this release is interoperable with your Oracle database release. You can download free edition from our Downloads page.
9 June, 2005
How to avoid redirection from index.html to DPSP unit ?
If you want to use dynamic page instead of static index.html, you can use an Apache mod_rewrite to prevent redirection from static index.html page to Dynamic PSP unit.
16 May, 2005
Developing Dynamic PSP with JDeveloper 10g.
This page shows you how to develop Dynamic PSP with JDeveloper 10g. 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.
25 April, 2005
Java Server Pages (JSP) for Dynamic PSP Access
Dynamic PSP API allows you to create a simple JSP code to access any DPSP unit. Do not lose your time to write complicated code for JSP just use this simple example to access any DPSP page. By using DPSP you can write any PL/SQL code and run it by using just one JSP page. More info or go to download section.
29 December, 2004
Now you can download some sources for Dynamic PSP!
Using our "Easy Reports" to Dynamic PSP you can publish Reports in three easy steps. Our "Easy Reports" is fully supports sorting by columns names ! Click Here to view a real example online.
You can also install Dynamic PSP and download a Reports source code.
18 December, 2004
An Universal Lookup is online!
An Universal Lookup based on DPSP can save your time to create a large application, based on several types of lookups. This is only two tables and you can create a unlimited lookups and do not need to create several procedures to support application data.
Click here for more info.
You can also get an Universal Lookup source units from our download page.
20 September, 2004
PSP_Mail Version 1.4.5 is released!
PSP_Mail Version 1.4.5 is now available! This maintenance release includes a few minor enhancements and fixes. To see complete list of what's new in this release, please read Version 1.4.5 Release Notes.
13 September, 2004
A new Dynamic PSP powered site goes online!
A new project "Anglo" fully based on Dynamic PSP techology goes online. You can create your website within one-two weeks. You only need your own design, which you can put inside frame, if you have one! If you do not have it, we will create a new design for you!
Act now! Now it is cost only $399 with one year support included!
24 June, 2004
We made a new Talent Agency Demo based on Dynamic PSP and data model.
We created that demo product based on our Dynamic PSP Forms. Using this 100% functional Demo you can add and modify data and make an Appointment and Assignment logistics. Send to us a request to create your own demo, based on your own structure.
13 May, 2004
JOPA can edit your static html pages!
Started from now you can edit a whole site only using Macromedia Dreamweaver MX 2004 and JOPA !
You can upload any binary, html or any other file types into local directories to build your own site using JOPA !
Futured updates will available soon.
12 March, 2004
There is some screenshots here will help to understand how easy it is to use Dynamic PSP products from within Macromedia Dreamweaver MX 2004 !
Dynamic PSP and Macromedia Dreamweaver MX 2004 are working together !
16 December, 2003
Macromedia Dreamweaver support Site Extension for Dynamic PSP is available for download!
10 July, 2003
Now you can get a start kit for your website at lowest price!
Act now! and you can get a start kit for your own website only for $99,95.
That start kit includes:
- unlimited license DPSP Version 2.3.3 SE;
- free one year license Dynamic PSP Version 2.3.3, without no obligations;
- free DPSP Forms;
- free Name-Tree Service (NTS);
- free JOPA Gateway Servlet;
- free DPSP units to support your website;
- free technical support, error correction support and consulting for 1 year after purchase date;
- free minor updates and special prices on upgrades clean conscience and good karma.
You can create your website at 1-2 weeks. You only need your own design, which you can put inside frame, if you have one! If you do not have it, we can create a design for you!
Act now!
More news...
email us
Copyright © 2000-2014 by HitMedia LLC. All Rights Reserved.