servicenow.community.sql
Class Pumper

java.lang.Object
  servicenow.community.sql.Pumper

public class Pumper
extends java.lang.Object

Main class and entry point for the DataPump application. This application uses the "soap" package to read/update the ServiceNow instance and JDBC to write to the SQL database.

Author:

LewisGF

Constructor Summary

Pumper()

Pumper(java.util.Properties props)

Method Summary

boolean	cancelled()
java.sql.Connection	getConnection()
int	getDefaultFrequency()
Instance	getInstance()
JobCollection	getJobs()
static org.apache.log4j.Logger	getLogger(java.lang.Class c, java.lang.String tablename)
java.lang.String	getSchemaName()
void	loadJobSet()
void	loadJobSet(java.lang.String jobsetname)
void	loadScriptFile()
void	loadScriptFile(java.lang.String filename)
static void	main(java.lang.String[] args)
java.util.Properties	properties()
void	setDefaultFrequency(java.lang.Integer freq)
static void	showHelp()

Methods inherited from class java.lang.Object

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

Constructor Detail

Pumper

public Pumper()
       throws java.lang.Exception

Throws:

java.lang.Exception

Pumper

public Pumper(java.util.Properties props)
       throws java.lang.Exception

Throws:

java.lang.Exception

Method Detail

main

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

Throws:

java.lang.Exception

showHelp

public static void showHelp()

getSchemaName

public java.lang.String getSchemaName()

getInstance

public Instance getInstance()

properties

public java.util.Properties properties()

getConnection

public java.sql.Connection getConnection()

getJobs

public JobCollection getJobs()

cancelled

public boolean cancelled()
                  throws java.io.IOException

Throws:

java.io.IOException

setDefaultFrequency

public void setDefaultFrequency(java.lang.Integer freq)

getDefaultFrequency

public int getDefaultFrequency()

loadJobSet

public void loadJobSet(java.lang.String jobsetname)
                throws java.lang.Exception

Throws:

java.lang.Exception

loadJobSet

public void loadJobSet()
                throws java.lang.Exception

Throws:

java.lang.Exception

loadScriptFile

public void loadScriptFile(java.lang.String filename)
                    throws java.lang.Exception

Throws:

java.lang.Exception

loadScriptFile

public void loadScriptFile()
                    throws java.lang.Exception

Throws:

java.lang.Exception

getLogger

public static org.apache.log4j.Logger getLogger(java.lang.Class c,
                                                java.lang.String tablename)