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