Package ch.pschatzmann.edgar.dataload

Class DownloadProcessorJDBC

java.lang.Object

ch.pschatzmann.edgar.dataload.DownloadProcessorJDBC

All Implemented Interfaces:

IProcess

public class DownloadProcessorJDBC
extends java.lang.Object
implements IProcess

Main program which downloads loads the information from Edgar into the file system and stores the numeric values in a jdbc database with the following fields: date*; identifier*; companyName; parameterName*; segment*; numberOfMonths*; label; dateLabel; file; form; contextRef; sicCode; incorpration; location; id; tradingSymbol; value; segmentDimension; sicDescription; unitRef; decimals

Author:

pschatzmann

Constructor Summary

Constructors

Constructor	Description
DownloadProcessorJDBC()

Method Summary

Modifier and Type	Method	Description
void	close()
void	loadToDatabase(java.net.URL currentURL)
void	loadToDatabase(java.net.URL currentURL, boolean reload)
static void	main(java.lang.String[] args)
void	process()
void	process(FeedInfoRecord info)	Main processing
void	saveCompany(XBRL xbrl)
void	saveCompanyInDB(XBRL xbrl)
void	saveXBRL(XBRL xbrl)
void	setDestinationFolder(java.lang.String folder)

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DownloadProcessorJDBC

public DownloadProcessorJDBC()
                      throws java.io.IOException,
                             java.util.concurrent.TimeoutException,
                             java.lang.ClassNotFoundException,
                             java.sql.SQLException,
                             java.lang.InterruptedException,
                             java.text.ParseException

Throws:

java.io.IOException

java.util.concurrent.TimeoutException

java.lang.ClassNotFoundException

java.sql.SQLException

java.lang.InterruptedException

java.text.ParseException

Method Detail

main

public static void main(java.lang.String[] args)

process

public void process()
             throws java.lang.Exception

Specified by:

process in interface IProcess

Throws:

java.lang.Exception

process

public void process(FeedInfoRecord info)
             throws XBRLException,
                    NoNewDataException,
                    java.sql.SQLException

Main processing

Parameters:

info -

Throws:

XBRLException

NoNewDataException

java.sql.SQLException

loadToDatabase

public void loadToDatabase(java.net.URL currentURL)
                    throws org.xml.sax.SAXException,
                           java.io.IOException,
                           javax.xml.parsers.ParserConfigurationException,
                           java.sql.SQLException,
                           java.text.ParseException,
                           java.lang.ClassNotFoundException,
                           com.rometools.rome.io.FeedException,
                           DataException

Throws:

org.xml.sax.SAXException

java.io.IOException

javax.xml.parsers.ParserConfigurationException

java.sql.SQLException

java.text.ParseException

java.lang.ClassNotFoundException

com.rometools.rome.io.FeedException

DataException

loadToDatabase

public void loadToDatabase(java.net.URL currentURL,
                           boolean reload)
                    throws org.xml.sax.SAXException,
                           java.io.IOException,
                           javax.xml.parsers.ParserConfigurationException,
                           java.sql.SQLException,
                           java.text.ParseException,
                           java.lang.ClassNotFoundException,
                           com.rometools.rome.io.FeedException,
                           DataException

Throws:

org.xml.sax.SAXException

java.io.IOException

javax.xml.parsers.ParserConfigurationException

java.sql.SQLException

java.text.ParseException

java.lang.ClassNotFoundException

com.rometools.rome.io.FeedException

DataException

saveXBRL

public void saveXBRL(XBRL xbrl)
              throws java.sql.SQLException,
                     java.text.ParseException,
                     java.lang.ClassNotFoundException

Throws:

java.sql.SQLException

java.text.ParseException

java.lang.ClassNotFoundException

saveCompany

public void saveCompany(XBRL xbrl)
                 throws java.sql.SQLException,
                        java.text.ParseException,
                        java.lang.ClassNotFoundException,
                        java.net.MalformedURLException,
                        java.io.IOException,
                        com.rometools.rome.io.FeedException,
                        DataException

Throws:

java.sql.SQLException

java.text.ParseException

java.lang.ClassNotFoundException

java.net.MalformedURLException

java.io.IOException

com.rometools.rome.io.FeedException

DataException

saveCompanyInDB

public void saveCompanyInDB(XBRL xbrl)
                     throws java.sql.SQLException,
                            java.text.ParseException,
                            java.lang.ClassNotFoundException

Throws:

java.sql.SQLException

java.text.ParseException

java.lang.ClassNotFoundException

setDestinationFolder

public void setDestinationFolder(java.lang.String folder)

close

public void close()
           throws XBRLException

Throws:

XBRLException