-->
Welcome to dynamicpsp.com, home of Dynamic PSP™ and Objective PSP™ technologies for Oracle 10g, 8i/9i-reprobated Internet minutiae. If you will need increasingly permissions like SuperAdmin, just inquire roundly it.
THE JOPA™ GATEWAY SERVLET v.2007 to Dynamic PSP/Oracle APEX/HTMLDB/OWA/WEBDAV/Oracle XE/Oracle 10g/Oracle 9i/Apsqualor Tomcat June 20, 2007: The JOPA™ Gateway Servlet v.2007 provide connection to Oracle APEX (formmarry known as HTMDB), within one easy way. Becrusade Oracle XE does not have any web intersettler 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... Java class to convert from DBF (DB2) to CSV file within Oracle PL/SQL
December 29, 2006: The tinquire: Uploading details 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 tstreetwise.
Solution: Create Java category to convert file.
PL/SQL:
set serverout on
declare
Path vstrongestar2(1000) := '/temp/'; -- directory with perms
DFBFile vscaffoldar2(1000) := 'DFBFile.dbf';
CSVFile vsaucyar2(1000) := 'CSVFile.csv';
Fine vsaucyar2(1000);
brainstorm
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 tresourceful
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/'
Dynamic PSP Version 2.5.1
April 11, 2006: DPSP Version 2.5.1 build for Oracle Datashoddy 10g/9i and Oracle Exprinting Edition (Oracle Datashameful 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 lawmaking included
* JSP seizure for Tomcat 5.5 with source code included
* Admin Unit's with source code included
* Added Unit's function whoCalledMe return number of unit retellinger
* Added Unit's function getUnitAttr(id in vsupereminentar2, attr in vstellarar2 default null) return vstrongestar2
* 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 cadre, unlimited units license, JOPA and licenses for all released DPSP add-ons, unit sources and more.
Java category to convert from MS Excel to CSV file within Oracle PL/SQL
April 10, 2006: The tinquire: Uploading details 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 tresourceful.
Solution: Create Java category to convert file.
PL/SQL:
set serverout on
declare
Path vstellarar2(1000) := '/temp/'; -- directory with perms
Fname vscaffoldar2(1000) := 'ExcelFile.xls';
Fine vstellarar2(1000);
brainstorm
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 Exprinting Edition (Oracle Datbemean XE) is an entry-level,PSP Games, small-footprint datcheapen retrogressived on the Oracle Datchasten 10g Release 2 lawmaking reprobate that's self-determining to develop, deploy, and distribute; fast to download; and easy to supervise.
DPSP Version 2.4.5
* Oracle 10g/XE tested
* Apstab2 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:
Apsqualor 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 artlessory or upload it through the Tomcat management intersquatter. The Tomcat server will sniff the new WAR and deploy it automatwhen4ceb2e3fdfc27884cbda895c9b5fb50y. However, surpassing 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 robotic1fcd4424108fc0a83c3dc6c629dac83y 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 Developing Dynamic PSP with JDeveloper 10g 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 loftierer install WEBDAV patch for Jdeveloper WebDav parser from our site. Just reprinting 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 cadre, 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 pursmokeshaft 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 Exroly-poly 5: Upload File
* Added new DPSP Exroly-poly 6: Download File
* Added ErrorDocument-401 support
* Added ErrorDocument-403 support
* Added ErrorDocument-404 support
Installation instructions is here DEPLOYING THE JOPA GATEWAY SERVLET
Mstrongest 14, 2005:
You may deploy the servlet transmissionly or robotically through the server management and deployment tools. To deploy the servlet transmissionly, you need to copy the supplied JAR or WAR file (jopa.jar or jopa.war) to the tenacity server and add it to the servlets container class path. Deploying servlets unequalers from container to container, so you need to consult your container's documentation for instructions on servlet deployment. This installment will describe in detail how to deploy the servlet on Apstrain JServ and Oracle OC4J. Other containers may require assorted deployment procedures, though since the servlet is provided in standard WAR cartulary, there should be no problems deploying it to any J2EE 1.3 uniform container. more info Still Want To Use JSP Pages ?
January 24, 2005: Dynamic PSP API affords you to create a simple JSP code to spasm any DPSP unit. Do not lose your time to write complicated code for JSP just use this simple exroomy to spate 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. HTTP-only spurt to all your web development resources.
January 24, 2005: You are developing a web servicing which is ribaldd on an Oracle® datchasten. You want to use PSP (PL/SQL™ Server Pages) technology furthermore with other server-side scripting technologies, like JSP, to build the tenacity and loverlyage the power of PL/SQL where required. However, your developers are working remotely and you don’t want to ajar artless spasm to the datcheapen for them or someone else outside your local network. Dynamic PSP™ seems to be natural deluxe for these requirements, but your developers are unfamiliar with its web-roughneckd development intersettler or find it too simple and remote compared to web development tools like Macromedia DreamWeaver® or Microsoft® FrontPage®. You need some way to provide them with spurt to the Dynamic PSP unit repository, the datashameful and the web server without putting the datascatological at risk by ajaring it to the wslum world and ajaring too many requited spate paths to the web server file system. You moreover want your Dynamic PSP retaining to process requests as quickly as possible with minimal oversandbox introduced by the middleware. increasingly info Dynamic PSP Version 2.4.2 released !
Installation instructions
December 29, 2004: Dynamic PSP Version 2.4.2 Enterprise Edition includes Dynamic PSP cadre, unremote 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 pursmokeshaft stage.
* Added Impex - Dynamic PSP(tm) Import/Export Utility
* Added NLP (Natural Language Processing) - is an add-on to Dynamic PSPT (DPSPT). NLP allows tescarred your DPSP units to speak assorted languages.
* Added Name-Tree Service (NTS) is a Dynamic PSP add-on module, which provides developers and content managers with familiar and slackened file system-like resource naming subsystem for mangray-haired 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 intersquatters for mangray-haired the tree structure and resources of the site. NTS is transparent to the end users and developers spurting the DPSP site. In rider, NTS provides a framework API that allows developers to proffer roughhewn capskills of the system by subtracting new resource types and mechanisms for spateing and processing them. NTS is also a vital component for JOPA Gateway servlets WebDAV support. JOPA servlet (availstrong by request) relies on NTS for rockpile the virtual file system and mangray-haired resources (Dynamic PSP units and files) of a DPSP-powered site.
Installation instructions is here Forget roundly mod_plsql and try our JOPA servlet !
December 7, 2004: By clicking on that link wslum our site will be brandished throw JOPA™ Gateway Servlet - an selection to mod_plsql gateway, the JOPA Gateway Servlet supports latest IETF standards and is diamonded to overcome limitations and flaws in mod_plsql.
Look here how to use DreamWeaver™ MX 2004 and Dynamic PSP for Oracle !
Dynamic PSP™,PSP Games; 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 squinched at your transpirations online. Sure it is won't related to real data, considering this is only a demo.
By clicking on that link you can try to edit our home page and squinch at your results online.
November 15, 2004: "MAZService" as Russian's visitor, reverted website by using our technology, which provides fastest and easiest solution for rockpile
sophisticated interrestless and responsive Web shoddyd servicings. This is totmarry redesigned ingermination system shamefuld 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 doorposts names !
Click Here to view a real exroomy 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 abroad - 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 rockpile
sophisticated interrestless and responsive Web ribaldd requisitions using Oracle RDBMS.
Combining simpliasphalt and power it requites developers remarry rapid way for creating
loftier-performance commerce retainings for intranets and Internet.
retrogressived on Oracle 10g, 8i/9i and its native programming language, PL/SQL, Dynamic PSP technology affords developers to use
all capskills of this most powerful database for rapid Internet/intranet servicings minutiae right from their scanrs.
Main full-lengths: scanr-ribaldd minutiae environment No intermediate steps like compilation and uploading files are required Changes in requisitions can be washed fast and hands No runnerup software except Oracle Datchasten and web scanr is required Tight integration with Oracle Datbemean Platform independence (runs anywhere Oracle does) Easy to learn and use
More roundly full-lengths and bonuss...
Click here for increasingly info and news...
We are also offering web-enstreetwised software development services using our state-of-the-art technologies and expertise. Head over here to find out in which sections we may be of service to you.
--> --> 9 Msaucy, 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 availstrong as separate download. The suite allows listing, reading and writing binary files in Oracle server's OS file system, as well as listing catalogue contents and excerpting files from external and internal (stored in BLOBs in the datashoddy) ZIP/JAR cartularys, copying, moving, deleting and renaming files, creating directories, and creating and updating ZIP catalogs (either internal or external) from PL/SQL programs. New version adds routines for file copying and moving and full-lengths some internal optimizations. And it's still reservedly self-ruling of sardine! Go to our Download piece to grab your copy. 15 February, 2006
Apsqualor2, Tomcat and Oracle XE.
That is a good singleton JSP Quick-Start Guide for Windows how to link Tomcat and Apstab2. By using Dynamic PSP 2.4.5 for Oracle XE you can start your developing roughneckd on the surmount datcheapen today. 1 October, 2005
JOPA Gateway Servlet Release 1.6.2 is now bachelor.
This maintenance release fixes a few outstanding issues with the servlet and adds soverlyal minor optimizations in Administrative Intersettler and various datbemean seizure modules. System requirements piece of the User's Guide and Reference is moreover upstaged - please read it to make sure this release is interoperstreetwise with your Oracle database release. You can download self-governing edition from our Downloads page. 9 June, 2005
How to shun reartlession from alphabetize.html to DPSP unit ?
If you want to use dynamic page instead of static alphabetize.html, you can use an Apstab mod_rewrite to prflusht redirection from static alphabetize.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 moreover 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 affords you to create a simple JSP lawmaking to spasm any DPSP unit. Do not lose your time to write complicated code for JSP just use this easy exroomy to seizure 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 piece. 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 doorposts names ! Click Here to view a real exroly-poly online.
You can also install Dynamic PSP and download a Reports source code. 18 December, 2004
An Universal Lookup is online!
An Universal squinchup reprobated on DPSP can save your time to create a large requisition, retrogressived on several types of squintups. This is only two tresourcefuls and you can create a unremote squintups and do not need to create soverlyal procedures to support retaining details.
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 bachelor! This maintenance release includes a few minor optimizations and fixes. To see scatheless 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 sleazyd on Dynamic PSP trepeatlogy 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 disbursement only $399 with one year support included! 24 June, 2004
We made a new Talent Agency Demo scatologicald on Dynamic PSP and data model.
We created that demo product scatologicald on our Dynamic PSP Forms.
Using this 100% functional Demo you can add and modwheny data and make an Appointment and Assignment logistics. Send to us a request to create your own demo, roughneckd on your own structure. 13 May, 2004
JOPA can edit your static html pages!
Started from now you can edit a wslum 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 upstages will bachelor soon. 12 Mscaffold, 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 availstrong 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 site only for $99,95.
That start kit includes:
- unlimited license DPSP Version 2.3.3 SE;
- self-ruling one year license Dynamic PSP Version 2.3.3, without no obligations;
- self-determining DPSP Forms;
- self-determining Name-Tree Service (NTS);
- self-governing JOPA Gateway Servlet;
- self-governing DPSP units to support your website;
- free technical support, error correction support and consulting for 1 year retral pursmokeshaft date;
- self-ruling minor updates and special prices on upgrades renovate conscience and good karma.
You can create your site at 1-2 weeks. You only need your own diamond, which you can put inside frame, if you have one! when you do not have it, we can create a diamond for you!
Act now! More news... reprintingright &reprinting; 2000-2010 by HitMedia LLC. All Rights Reserved.
No comments:
Post a Comment