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.
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.
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
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
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.
JOPAUser 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.
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.
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.
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.
- 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...