Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » setup for viewing PSP in a web browser
setup for viewing PSP in a web browser [message #530979] Fri, 11 November 2011 11:38
nh02173
Messages: 7
Registered: September 2011
Junior Member
hello,

I am trying to test some PSP files, so I need to view them in my web browser and everything i have been trying is not working any help would be amazing.

additional information:

the PSP has been loaded into the database and runs perfect in SQL developer. (loaded using loadpsp).

I setup the DAD through the sql command line using the name "classpsp" dbms_epg.create_dad('classpsp','/classpsp/*');
i got a message for successful execution.

all of the examples I'm seeing show the URL as http://server-name/DAD/userid.psp_file_name

so I'm assuming that my server-name would just be my computer name that i am using now and running oracle on.

the DAD part would be classpsp. just like i setup
the userid would just be my regular userid. (b/c the userid worked for the loadpsp command)

and the last part would just be the psp file that i loaded into the database

example

server-name: darko-d3279xxxx

DAD: classpsp

userid: system

psp file: psp_example

so shouldn't the URL look like this:

http://darko-d3279xxxx/classpsp/system.psp_example

One thing I'm not sure about is my psp is a procedure, so in sql developer it is under procedures when i look at my connections. and i don't see classpsp anywhere.

I might be making a stupid or really simple mistake, so any help would be great.

also here is my information for my computer, sql developer and the properties/extensions (maybe i don't have something installed that i need)


Windows XP Home edition
version 2002
service pack 3


About
-----

Oracle SQL Developer 2.1.1.64
Version 2.1.1.64
Build MAIN-64.45
Copyright © 2005,2009 Oracle. All Rights Reserved.
IDE Version: 11.1.1.2.36.55.30
Product ID: oracle.sqldeveloper
Product Version: 11.1.1.64.45

Version
-------

Component Version
========= =======
Java(TM) Platform 1.6.0_11
Oracle IDE 2.1.1.64.45
Versioning Support 2.1.1.64.45

Properties
----------

Name Value
==== =====
awt.toolkit sun.awt.windows.WToolkit
class.load.environment oracle.ide.boot.IdeClassLoadEnvironment
class.load.log.level CONFIG
class.transfer delegate
file.encoding Cp1252
file.encoding.pkg sun.io
file.separator \
http.agent Mozilla/5.0 (Java 1.6.0_11; Windows XP 5.1 x86; en_US) ICEbrowser/v6_1_3
ice.browser.forcegc false
ice.pilots.html4.ignoreNonGenericFonts true
ice.pilots.html4.tileOptThreshold 0
ide.AssertTracingDisabled true
ide.bootstrap.start 7849207672724
ide.build MAIN-64.45
ide.conf C:\Documents and Settings\Nate\Desktop\Spring11\CIS528\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf
ide.config_pathname C:\Documents and Settings\Nate\Desktop\Spring11\CIS528\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf
ide.debugbuild false
ide.devbuild false
ide.extension.search.path sqldeveloper/extensions:jdev/extensions:ide/extensions
ide.firstrun true
ide.java.minversion 1.6.0_04
ide.launcherProcessId 5744
ide.main.class oracle.ide.boot.IdeLauncher
ide.patches.dir ide/lib/patches
ide.pref.dir C:\Documents and Settings\Nate\Application Data\SQL Developer
ide.pref.dir.base C:\Documents and Settings\Nate\Application Data
ide.product oracle.sqldeveloper
ide.shell.enableFileTypeAssociation C:\Documents and Settings\Nate\Desktop\Spring11\CIS528\sqldeveloper\sqldeveloper.exe
ide.splash.screen splash.gif
ide.startingArg0 C:\Documents and Settings\Nate\Desktop\Spring11\CIS528\sqldeveloper\sqldeveloper.exe
ide.startingcwd C:\Documents and Settings\Nate\Desktop\Spring11\CIS528\sqldeveloper
ide.user.dir C:\Documents and Settings\Nate\Application Data\SQL Developer
ide.user.dir.var IDE_USER_DIR
ide.work.dir C:\Documents and Settings\Nate\My Documents\SQL Developer
ide.work.dir.base C:\Documents and Settings\Nate\My Documents
java.awt.graphicsenv sun.awt.Win32GraphicsEnvironment
java.awt.printerjob sun.awt.windows.WPrinterJob
java.class.path ..\..\ide\lib\ide-boot.jar
java.class.version 50.0
java.endorsed.dirs C:\Documents and Settings\Nate\Desktop\Spring11\CIS528\sqldeveloper\jdk\jre\lib\endorsed
java.ext.dirs C:\Documents and Settings\Nate\Desktop\Spring11\CIS528\sqldeveloper\jdk\jre\lib\ext;C:\windows\Sun\Java\lib\ext
java.home C:\Documents and Settings\Nate\Desktop\Spring11\CIS528\sqldeveloper\jdk\jre
java.io.tmpdir C:\DOCUME~1\Nate\LOCALS~1\Temp\
java.library.path C:\Documents and Settings\Nate\Desktop\Spring11\CIS528\sqldeveloper;.;C:\windows\Sun\Java\bin;C:\windows\system32;C:\windows;C:\oraclexe\app\oracle\pr oduct\10.2.0\server\bin;C:\Program Files\PC Connectivity Solution\;C:\windows\system32;C:\windows;C:\windows\System32\Wbem;C:\Program Files\Intel\DMIX\C:\Program Files\Java\jdk1.6.0_18\bin;C:\Program Files\Common Files\Roxio Shared\DLLShared\;C:\Program Files\Common Files\Roxio Shared\9.0\DLLShared\;C:\android\tools\;C:\Program Files\Java\jdk1.6.0_18\bin;C:\Program Files\QuickTime\QTSystem\
java.naming.factory.initial oracle.javatools.jndi.LocalInitialContextFactory
java.runtime.name Java(TM) SE Runtime Environment
java.runtime.version 1.6.0_11-b03
java.specification.name Java Platform API Specification
java.specification.vendor Sun Microsystems Inc.
java.specification.version 1.6
java.util.logging.config.file logging.conf
java.vendor Sun Microsystems Inc.
java.vendor.url http://java.sun.com/
java.vendor.url.bug http://java.sun.com/cgi-bin/bugreport.cgi
java.version 1.6.0_11
java.vm.info mixed mode
java.vm.name Java HotSpot(TM) Client VM
java.vm.specification.name Java Virtual Machine Specification
java.vm.specification.vendor Sun Microsystems Inc.
java.vm.specification.version 1.0
java.vm.vendor Sun Microsystems Inc.
java.vm.version 11.0-b16
jdbc.library /C:/Documents and Settings/Nate/Desktop/Spring11/CIS528/sqldeveloper/jdbc/lib/ojdbc5.jar
line.separator \r\n
oracle.home C:\Documents and Settings\Nate\Desktop\Spring11\CIS528\sqldeveloper
oracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG true
oracle.jdbc.Trace true
oracle.translated.locales de,es,fr,it,ja,ko,pt_BR,zh_CN,zh_TW
oracle.xdkjava.compatibility.version 9.0.4
orai18n.library /C:/Documents and Settings/Nate/Desktop/Spring11/CIS528/sqldeveloper/jlib/orai18n.jar
os.arch x86
os.name Windows XP
os.version 5.1
path.separator ;
reserved_filenames con,aux,prn,lpt1,lpt2,lpt3,lpt4,lpt5,lpt6,lpt7,lpt8,lpt9,com1,com2,com3,com4,com5,com6,com7,com8,com9,conin$,conout,conout$
sqldev.debug false
sun.arch.data.model 32
sun.boot.class.path C:\Documents and Settings\Nate\Desktop\Spring11\CIS528\sqldeveloper\jdk\jre\lib\resources.jar;C:\Documents and Settings\Nate\Desktop\Spring11\CIS528\sqldeveloper\jdk\jre\lib\rt.jar;C:\Documents and Settings\Nate\Desktop\Spring11\CIS528\sqldeveloper\jdk\jre\lib\sunrsasign.jar;C:\Documents and Settings\Nate\Desktop\Spring11\CIS528\sqldeveloper\jdk\jre\lib\jsse.jar;C:\Documents and Settings\Nate\Desktop\Spring11\CIS528\sqldeveloper\jdk\jre\lib\jce.jar;C:\Documents and Settings\Nate\Desktop\Spring11\CIS528\sqldeveloper\jdk\jre\lib\charsets.jar;C:\Documents and Settings\Nate\Desktop\Spring11\CIS528\sqldeveloper\jdk\jre\classes
sun.boot.library.path C:\Documents and Settings\Nate\Desktop\Spring11\CIS528\sqldeveloper\jdk\jre\bin
sun.cpu.endian little
sun.cpu.isalist pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86
sun.desktop windows
sun.io.unicode.encoding UnicodeLittle
sun.java2d.ddoffscreen false
sun.jnu.encoding Cp1252
sun.management.compiler HotSpot Client Compiler
sun.os.patch.level Service Pack 3
svnkit.sax.useDefault true
user.country US
user.dir C:\Documents and Settings\Nate\Desktop\Spring11\CIS528\sqldeveloper\sqldeveloper\bin
user.home C:\Documents and Settings\Nate
user.language en
user.name Nate
user.timezone America/Los_Angeles
user.variant
windows.shell.font.languages

Extensions
----------

Name Identifier Version Status
==== ========== ======= ======
Check For Updates oracle.ide.webupdate 11.1.1.2.36.55.30 Loaded
Code Editor oracle.ide.ceditor 11.1.1.2.36.55.30 Loaded
Database Connection Support oracle.jdeveloper.db.connection 11.1.1.2.36.55.30 Loaded
Database Object Explorers oracle.ide.db.explorer 11.1.1.2.36.55.30 Loaded
Database UI oracle.ide.db 11.1.1.2.36.55.30 Loaded
Diff/Merge oracle.ide.diffmerge 11.1.1.2.36.55.30 Loaded
Extended IDE Platform oracle.javacore 11.1.1.2.36.55.30 Loaded
External Tools oracle.ide.externaltools 11.1.1.2.36.55.30 Loaded
File Support oracle.ide.files 11.1.1.2.36.55.30 Loaded
File System Navigator oracle.sqldeveloper.filenavigator 11.1.1.64.45 Loaded
Help System oracle.ide.help 11.1.1.2.36.55.30 Loaded
History Support oracle.jdeveloper.history 11.1.1.2.36.55.30 Loaded
Import/Export Support oracle.ide.importexport 11.1.1.2.36.55.30 Loaded
Index Migrator support oracle.ideimpl.indexing-migrator 11.1.1.2.36.55.30 Loaded
JDeveloper Runner oracle.jdeveloper.runner 11.1.1.2.36.55.30 Loaded
Log Window oracle.ide.log 11.1.1.2.36.55.30 Loaded
Mac OS X Adapter oracle.ideimpl.apple 11.1.1.2.36.55.30 Loaded
Navigator oracle.ide.navigator 11.1.1.2.36.55.30 Loaded
Object Gallery oracle.ide.gallery 11.1.1.2.36.55.30 Loaded
Object Viewer oracle.sqldeveloper.oviewer 11.1.1.64.45 Loaded
Oracle Data Modeler Reports oracle.sqldeveloper.datamodeler_reports 11.1.1.64.45 Loaded
Oracle Database Browser oracle.sqldeveloper.thirdparty.browsers 11.1.1.64.45 Loaded
Oracle IDE oracle.ide 11.1.1.2.36.55.30 Loaded
Oracle SQL Developer oracle.sqldeveloper 11.1.1.64.45 Loaded
Oracle SQL Developer Data Modeler Viewer oracle.datamodeler 2.0.0.584 Loaded
Oracle SQL Developer Extras oracle.sqldeveloper.extras 1.1.1.64.45 Loaded
Oracle SQL Developer Migrations oracle.sqldeveloper.migration 11.1.1.64.45 Loaded
Oracle SQL Developer Migrations - Antlr3 Translation Core oracle.sqldeveloper.migration.translation.core_antlr3 11.1.1.64.45 Loaded
Oracle SQL Developer Migrations - DB2 oracle.sqldeveloper.migration.db2 11.1.1.64.45 Loaded
Oracle SQL Developer Migrations - Microsoft Access oracle.sqldeveloper.migration.msaccess 11.1.1.64.45 Loaded
Oracle SQL Developer Migrations - MySQL oracle.sqldeveloper.migration.mysql 11.1.1.64.45 Loaded
Oracle SQL Developer Migrations - SQLServer oracle.sqldeveloper.migration.sqlserver 11.1.1.64.45 Loaded
Oracle SQL Developer Migrations - Sybase oracle.sqldeveloper.migration.sybase 11.1.1.64.45 Loaded
Oracle SQL Developer Migrations - Teradata oracle.sqldeveloper.migration.teradata 11.1.1.64.45 Loaded
Oracle SQL Developer Migrations - Translation Core oracle.sqldeveloper.migration.translation.core 11.1.1.64.45 Loaded
Oracle SQL Developer Migrations - Translation Db2 oracle.sqldeveloper.migration.translation.db2 11.1.1.64.45 Loaded
Oracle SQL Developer Migrations - Translation UI oracle.sqldeveloper.migration.translation.gui 11.1.1.64.45 Loaded
Oracle SQL Developer Reports oracle.sqldeveloper.report 11.1.1.64.45 Loaded
Oracle SQL Developer SearchBar oracle.sqldeveloper.searchbar 11.1.1.64.45 Loaded
Oracle SQL Developer TimesTen oracle.sqldeveloper.timesten 2.0.0.64.45 Loaded
Oracle SQL Developer Unit Test oracle.sqldeveloper.unit_test 11.1.1.64.45 Loaded
Oracle SQL Developer Worksheet oracle.sqldeveloper.worksheet 11.1.1.64.45 Loaded
Oracle XML Schema Support oracle.sqldeveloper.xmlschema 11.1.1.64.45 Loaded
PROBE Debugger oracle.jdeveloper.db.debug.probe 11.1.1.2.36.55.30 Loaded
Peek oracle.ide.peek 11.1.1.2.36.55.30 Loaded
Persistent Storage oracle.ide.persistence 11.1.1.2.36.55.30 Loaded
QuickDiff oracle.ide.quickdiff 11.1.1.2.36.55.30 Loaded
Replace With oracle.ide.replace 11.1.1.2.36.55.30 Loaded
Runner oracle.ide.runner 11.1.1.2.36.55.30 Loaded
Snippet Window oracle.sqldeveloper.snippet 11.1.1.64.45 Loaded
Sql Monitoring Project oracle.sqldeveloper.sqlmonitor 11.1.1.64.45 Loaded
Tuning oracle.sqldeveloper.tuning 11.1.1.64.45 Loaded
User Extensions Support oracle.sqldeveloper.userextensions 11.1.1.64.45 Loaded
VHV oracle.ide.vhv 11.1.1.2.36.55.30 Loaded
Versioning Support oracle.jdeveloper.vcs 11.1.1.2.36.55.30 Loaded
Versioning Support for Subversion oracle.jdeveloper.subversion 11.1.1.2.36.55.30 Loaded
Virtual File System oracle.ide.vfs 11.1.1.2.36.55.30 Loaded
Web Browser and Proxy oracle.ide.webbrowser 11.1.1.2.36.55.30 Loaded
oracle.ide.indexing oracle.ide.indexing 11.1.1.2.36.55.30 Loaded

Thank you in advance for any help


P.S i don't know if this matters, but i sometimes run XAMPP off of a memory stick, but it is not running and out of my computer at the moment.


Previous Topic: Dynamically writing js file
Next Topic: url problem of oracle 9i application server
Goto Forum:
  


Current Time: Sun Aug 09 18:44:10 CDT 2020