Menu

Tree [r220] /
 History

HTTPS access


File Date Author Commit
 dist 2011-04-19 ckindler [r215]
 tools 2011-04-20 ckindler [r218]
 www 2011-04-26 ckindler [r220]
 ORANETTED.ACTION#.PACKAGE_BODY 2011-03-30 ckindler [r199] save downloaded data and use as external table
 ORANETTED.ACTION#.PACKAGE_SPEC 2011-03-29 ckindler [r198] more functions implemented in netted_api
 ORANETTED.ACTION.TABLE 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.ACTION.TABLE_DATA 2011-04-06 ckindler [r211]
 ORANETTED.ACTION_COMMANDS_V.VIEW 2011-04-05 ckindler [r210] smal bugfixes
 ORANETTED.ACTION_ERROR_LOG.TABLE 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.ACTION_ERROR_LOG_TST_I.INDEX 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.ACTION_ERROR_LOG_V.VIEW 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.ACTION_SCRIPT.PACKAGE_BODY 2011-04-26 ckindler [r219]
 ORANETTED.ACTION_SCRIPT.PACKAGE_SPEC 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.BLOB_TO_CLOB.FUNCTION 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.BROWSER.PACKAGE_BODY 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.BROWSER.PACKAGE_SPEC 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.CLOB_CURSOR.PACKAGE_BODY 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.CLOB_CURSOR.PACKAGE_SPEC 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.CLOB_TO_BLOB.FUNCTION 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.CONFIG#.PACKAGE_BODY 2011-04-26 ckindler [r219]
 ORANETTED.CONFIG#.PACKAGE_SPEC 2011-04-26 ckindler [r219]
 ORANETTED.CONFIG.TABLE 2011-04-26 ckindler [r219]
 ORANETTED.CONFIG.TABLE_DATA 2011-04-26 ckindler [r219]
 ORANETTED.CONTENT_T.TYPE 2011-03-16 ckindler [r174] cleanings
 ORANETTED.CONTENT_T.TYPE_BODY 2011-03-16 ckindler [r174] cleanings
 ORANETTED.DL_JOB#.PACKAGE_BODY 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_JOB#.PACKAGE_SPEC 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_JOB.TABLE 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_JOB.TABLE_DATA 2011-02-09 ckindler [r149]
 ORANETTED.DL_JOB_DEL_JOB_TRG.TRIGGER 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_JOB_GEN_JOB_TRG.TRIGGER 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_JOB_NR_PARALLEL_GE_0.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_JOB_SEQ.SEQUENCE 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_JOB_SEQ_TRG.TRIGGER 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_JOB_UI.INDEX 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_JOB_UPD_JOB_TRG.TRIGGER 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_JOB_UPR_TRG.TRIGGER 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_SCHEDULE#.PACKAGE_BODY 2011-02-09 ckindler [r153] work on jobs
 ORANETTED.DL_SCHEDULE#.PACKAGE_SPEC 2011-02-09 ckindler [r153] work on jobs
 ORANETTED.DL_SCHEDULE.TABLE 2011-02-09 ckindler [r153] work on jobs
 ORANETTED.DL_SCHEDULE_CLDR_TRG.TRIGGER 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_SCHEDULE_LOG#.PACKAGE_BODY 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_SCHEDULE_LOG#.PACKAGE_SPEC 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_SCHEDULE_LOG.TABLE 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_SCHEDULE_LOG_SEQ.SEQUENCE 2011-02-10 ckindler [r155] work on jobs
 ORANETTED.DL_SCHEDULE_LOG_SEQ_TRG.TRIGGER 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_SCHEDULE_LOG_UI.INDEX 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_SCHEDULE_OFF_DAY#.PACKAGE_BODY 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_SCHEDULE_OFF_DAY#.PACKAGE_SPEC 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_SCHEDULE_OFF_DAY.TABLE 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_SCHEDULE_OFF_DAY.TABLE_DATA 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_SCHEDULE_OFF_DAY_SEQ.SEQUENCE 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_SCHEDULE_OFF_DAY_UI.INDEX 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_SCHEDULE_SEQ.SEQUENCE 2011-03-17 ckindler [r175]
 ORANETTED.DL_SCHEDULE_SEQ_TRG.TRIGGER 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DL_SCHEDULE_UI.INDEX 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DOS2UNIX.FUNCTION 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DOWNLOAD.PACKAGE_BODY 2011-03-29 ckindler [r198] more functions implemented in netted_api
 ORANETTED.DOWNLOAD.PACKAGE_SPEC 2011-03-29 ckindler [r198] more functions implemented in netted_api
 ORANETTED.DOWNLOADED.TABLE 2011-03-01 ckindler [r158] store blobs compressed now
 ORANETTED.DOWNLOADED_SEQ#_TRG.TRIGGER 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DOWNLOADED_SEQ.SEQUENCE 2011-04-26 ckindler [r219]
 ORANETTED.DOWNLOADED_SEQ_TRG.TRIGGER 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.DUMMY_JOB_LOG.TABLE 2011-02-10 ckindler [r154] init
 ORANETTED.EVALUATE_CALENDAR_STRING.FUNCTION 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.FIRST_USE.PROCEDURE 2011-04-26 ckindler [r219]
 ORANETTED.GET_LIST_OF_DATES.FUNCTION 2011-02-09 ckindler [r150]
 ORANETTED.IS_VALID_CALENDAR_STRING.FUNCTION 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.JOB.PACKAGE_BODY 2011-03-29 ckindler [r198] more functions implemented in netted_api
 ORANETTED.JOB.PACKAGE_SPEC 2011-02-10 ckindler [r155] work on jobs
 ORANETTED.LOG_ACTION_ERR.PROCEDURE 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.MIGRT#.PACKAGE_BODY 2011-03-29 ckindler [r198] more functions implemented in netted_api
 ORANETTED.MIGRT#.PACKAGE_SPEC 2011-03-29 ckindler [r198] more functions implemented in netted_api
 ORANETTED.MIGRT.TABLE 2011-03-26 ckindler [r191] prepare migration
 ORANETTED.MIGRT_DLS_OUT_V.VIEW 2011-03-26 ckindler [r191] prepare migration
 ORANETTED.MIGRT_DOWNLOADED_OUT_V.VIEW 2011-03-26 ckindler [r191] prepare migration
 ORANETTED.MIGRT_ID_MAP.TABLE 2011-03-24 ckindler [r189] prepare for migration old logic
 ORANETTED.MIGRT_SEQ.SEQUENCE 2011-03-28 ckindler [r195] small improvments in first time install
 ORANETTED.MIGRT_SEQ_TRG.TRIGGER 2011-03-24 ckindler [r189] prepare for migration old logic
 ORANETTED.MISSED_DL_SCHEDULES_V.VIEW 2011-02-09 ckindler [r150]
 ORANETTED.NETTED_API.PACKAGE_BODY 2011-03-30 ckindler [r201] save downloaded data and use as external table
 ORANETTED.NETTED_API.PACKAGE_SPEC 2011-03-30 ckindler [r201] save downloaded data and use as external table
 ORANETTED.ORANETTED.USER 2011-03-07 ckindler [r161] work on plugin system, plugins resides in an ex...
 ORANETTED.ORANETTED.USER_GRANTS 2011-03-31 ckindler [r204] prepare upgrade process
 ORANETTED.PLUGIN#.PACKAGE_BODY 2011-03-21 ckindler [r178] small bugfix
 ORANETTED.PLUGIN#.PACKAGE_SPEC 2011-03-21 ckindler [r178] small bugfix
 ORANETTED.PLUGIN.TABLE 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.PLUGIN.TABLE_DATA 2011-03-24 ckindler [r189] prepare for migration old logic
 ORANETTED.RETURN_CODE.PACKAGE_SPEC 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SET_VAR.PROCEDURE 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SPLIT.PACKAGE_BODY 2011-03-09 ckindler [r165] built my own html dom
 ORANETTED.SPLIT.PACKAGE_SPEC 2011-03-09 ckindler [r165] built my own html dom
 ORANETTED.SYS_C004350.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004351.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004352.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004353.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004354.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004355.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004356.REF_CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004357.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004358.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004359.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004360.REF_CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004361.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004362.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004363.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004364.REF_CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004365.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004366.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004367.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004368.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004369.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004370.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004382.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004383.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004384.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004385.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004386.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004388.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004389.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004397.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004398.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004399.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004400.REF_CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004650.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004651.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004652.REF_CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.SYS_C004653.CONSTRAINT 2011-02-06 ckindler [r148] improvements in jobs
 ORANETTED.TIMESERIES_REC_T.TYPE 2011-02-09 ckindler [r150]
 ORANETTED.TS_TABLE_T.TYPE 2011-02-09 ckindler [r149]
 ORANETTED.URL#.PACKAGE_BODY 2011-03-29 ckindler [r198] more functions implemented in netted_api
 ORANETTED.URL#.PACKAGE_SPEC 2011-03-29 ckindler [r198] more functions implemented in netted_api
 ORANETTED.URL.TABLE 2011-01-19 ckindler [r22] init
 ORANETTED.URL.TABLE_DATA 2011-03-24 ckindler [r189] prepare for migration old logic
 ORANETTED.URL_HEAD#.PACKAGE_BODY 2011-03-29 ckindler [r198] more functions implemented in netted_api
 ORANETTED.URL_HEAD#.PACKAGE_SPEC 2011-03-29 ckindler [r198] more functions implemented in netted_api
 ORANETTED.URL_HEAD.TABLE 2011-01-19 ckindler [r23] init
 ORANETTED.URL_HEAD.TABLE_DATA 2011-01-19 ckindler [r93] init
 ORANETTED.URL_POST#.PACKAGE_BODY 2011-03-29 ckindler [r198] more functions implemented in netted_api
 ORANETTED.URL_POST#.PACKAGE_SPEC 2011-03-29 ckindler [r198] more functions implemented in netted_api
 ORANETTED.URL_POST.TABLE 2011-01-19 ckindler [r24] init
 ORANETTED.URL_POST.TABLE_DATA 2011-01-19 ckindler [r94] init
 ORANETTED.VARIABLES#.PACKAGE_BODY 2011-03-30 ckindler [r200] save downloaded data and use as external table
 ORANETTED.VARIABLES#.PACKAGE_SPEC 2011-03-30 ckindler [r200] save downloaded data and use as external table
 ORANETTED.VARIABLES.TABLE 2011-01-19 ckindler [r13] init
 ORANETTED.VARIABLES_INFO.PACKAGE_SPEC 2011-03-21 ckindler [r178] small bugfix
 ORANETTED.XML_PARSER.PACKAGE_BODY 2011-03-09 ckindler [r165] built my own html dom
 ORANETTED.XML_PARSER.PACKAGE_SPEC 2011-03-09 ckindler [r165] built my own html dom
 ORANETTED_PLUGIN.ACTION_COMMANDS_V.SYNONYM 2011-04-19 ckindler [r213] added a debug option to action script
 ORANETTED_PLUGIN.COMPILE4DEBUG.PROCEDURE 2011-04-19 ckindler [r217] added a debug option to action script
 ORANETTED_PLUGIN.CONFIG#.SYNONYM 2011-04-26 ckindler [r219]
 ORANETTED_PLUGIN.CONTENT_T.SYNONYM 2011-03-07 ckindler [r161] work on plugin system, plugins resides in an ex...
 ORANETTED_PLUGIN.CONVERT.PACKAGE_BODY 2011-04-19 ckindler [r212]
 ORANETTED_PLUGIN.CONVERT.PACKAGE_SPEC 2011-04-19 ckindler [r212]
 ORANETTED_PLUGIN.HTMLDOM.PACKAGE_BODY 2011-03-28 ckindler [r197]
 ORANETTED_PLUGIN.HTMLDOM.PACKAGE_SPEC 2011-03-10 ckindler [r167] built my own html dom
 ORANETTED_PLUGIN.LOG_ERR.PROCEDURE 2011-03-30 ckindler [r199] save downloaded data and use as external table
 ORANETTED_PLUGIN.MAIL.FUNCTION 2011-04-26 ckindler [r219]
 ORANETTED_PLUGIN.NETTED_API.SYNONYM 2011-03-10 ckindler [r169] small bugfix, added more sample code
 ORANETTED_PLUGIN.ORANETTED_PLUGIN.USER 2011-03-16 ckindler [r174] cleanings
 ORANETTED_PLUGIN.ORANETTED_PLUGIN.USER_GRANTS 2011-04-26 ckindler [r219]
 ORANETTED_PLUGIN.PLSQL.FUNCTION 2011-03-16 ckindler [r174] cleanings
 ORANETTED_PLUGIN.PRINT.FUNCTION 2011-03-23 ckindler [r184] derelease old logic
 ORANETTED_PLUGIN.PRUGE.PACKAGE_BODY 2011-04-19 ckindler [r216] added a debug option to action script
 ORANETTED_PLUGIN.PRUGE.PACKAGE_SPEC 2011-04-19 ckindler [r216] added a debug option to action script
 ORANETTED_PLUGIN.SAVE2ETABLE.FUNCTION 2011-04-05 ckindler [r209]
 ORANETTED_PLUGIN.SAVE2FILE.FUNCTION 2011-03-18 ckindler [r176] added converters
 ORANETTED_PLUGIN.SCOACH.PACKAGE_BODY 2011-03-21 ckindler [r178] small bugfix
 ORANETTED_PLUGIN.SCOACH.PACKAGE_SPEC 2011-03-21 ckindler [r178] small bugfix
 ORANETTED_PLUGIN.SPLIT.SYNONYM 2011-03-30 ckindler [r199] save downloaded data and use as external table
 ORANETTED_PLUGIN.VAR.FUNCTION 2011-04-06 ckindler [r211]
 ORANETTED_PLUGIN.VARIABLES#.SYNONYM 2011-03-10 ckindler [r169] small bugfix, added more sample code
 ORANETTED_PLUGIN.XML_TAG_ATTR.TABLE 2011-03-18 ckindler [r177] added converters
 ORANETTED_PLUGIN.XML_TAG_VAL.TABLE 2011-03-18 ckindler [r177] added converters
 ORANETTED_PLUGIN.XML_TAG_VAL_DEL_TRG.TRIGGER 2011-03-30 ckindler [r202]
 ORANETTED_PLUGIN.XSLT.FUNCTION 2011-03-14 ckindler [r170]
 README.txt 2011-04-06 ckindler [r211]
 ToDo_Ideas.txt 2011-03-07 ckindler [r160]
 disableLOBRetention.sql 2011-03-26 ckindler [r191] prepare migration
 install.sql 2011-04-26 ckindler [r219]
 licence.txt 2011-03-23 ckindler [r179]
 setNetworkACL.sql 2011-02-10 ckindler [r155] work on jobs
 tables.xml 2011-03-31 ckindler [r204] prepare upgrade process
 upgrade.sql 2011-04-19 ckindler [r215]

Read Me

OraNetted is a Oracle Database driven Webscrapper.

Install from source
  log in to sql+ as sysdba and execute install.sql
  SQL>  exec oranetted.first_use; -- you must still by sysdba

Install from Dump
 For easy to use there is a dump in the dist folder. Simply use 
  "impdp" to get your webscrapper running

 SQL> select directory_path from dba_directories where 
      directory_name='DATA_PUMP_DIR';

 #> cp dist/*.dmp <DATA_PUMP_DIR>
 #> impdp sys/***** DIRECTORY=data_pump_dir \
 DUMPFILE=OraNetted.dmp SCHEMAS=oranetted,oranetted_plugin

 log in to sql+ as sysdba and execute procedure first_use
 SQL>  exec oranetted.first_use;

Upgrade:
 To upgrade an existing OraNetted instance without data loss
 use the apache open jpa SchemaTool - this way:
 1st) set the connection string in tools/on.xml to your system
  usually you just need to adapt the SID
 2nd) issue the following commands
 #> java -cp tools/openjpa-all-2.1.0.jar\
  org.apache.openjpa.jdbc.schema.SchemaTool -p tools/on.xml\
  -a refresh tables.xml
 #> sqlplus oranetted/o@orcl @upgrade

Feedback:
 Please let me know what you think about OraNetted by sending an
 email to vorarlberger@gmail.com or posting into the sf forum

Passwords:
 Default users/passwords are ORANETTED/o

Support:
 If you have problems with installation please post at the help
 forum. If you have any suggestion make things easier please post
 also into the forum:    https://sourceforge.net/projects/oranetted/forums/forum/1360972

Quick Start:
Log in to sqlplus using oranetted/o@<sid>
SQL> set serveroutput on
SQL> exec download.url('google2', 'oranetted');

Investigate your database using oranetted tables
 url, action, downloaded
and everything in oranetted_plugin schema


Info:
Dump exported out of a Oracle 10gXE running on a Ubuntu Host
 Ubuntu:
 Description:    Ubuntu 10.10
 Release:        10.10
 Codename:       maverick

Oracle:
 Export: Release 10.2.0.1.0 - Production on ...

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.