org.xmlBlaster.contrib.dbupdate
Class JdbcShuffler

java.lang.Object
  org.xmlBlaster.contrib.dbupdate.JdbcShuffler

public class JdbcShuffler
extends java.lang.Object

Copy all xb_entries from one database to another.

 Compile: javac JdbcShuffler.java
 

 Run:
 export CLASSPATH=.:$XMLBLASTER_HOME/lib/sqljdbc.jar:$XMLBLASTER_HOME/lib/postgresql.jar
 
 java org.xmlBlaster.contrib.dbupdate.JdbcShuffler <hostname> <from> <to>
 
    <from> and <to> is one of: SQLServer | Postgres | Oracle
 
 Example:
 java org.xmlBlaster.contrib.dbupdate.JdbcShuffler localhost SQLServer Postgres
 

Author:

Marcel Ruff

Nested Class Summary

(package private) class

JdbcShuffler.ConDetail

Field Summary

(package private) static int	BLOB
private java.sql.Connection	conFrom
private java.sql.Connection	conTo
(package private) static int	DATA_ID
private java.lang.String	from
private java.lang.String	hostname
private JdbcShuffler.ConDetail	oracle
java.lang.String	ORACLE
(package private) static int	PERSISTENT
private JdbcShuffler.ConDetail	postgres
java.lang.String	POSTGRES
(package private) static int	PRIO
(package private) static int	QUEUE_NAME
(package private) static int	SIZE_IN_BYTES
private JdbcShuffler.ConDetail	sqlServer
java.lang.String	SQLSERVER
private java.lang.String	to
(package private) static int	TYPE_NAME

Constructor Summary

JdbcShuffler(java.lang.String[] args)

Method Summary

private java.lang.String	getDate()
void	init()
private boolean	isPersistent(java.lang.String persistentAsChar)
static void	main(java.lang.String[] args)
void	shuffle()
void	shutdown()

Methods inherited from class java.lang.Object

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

Field Detail

DATA_ID

static final int DATA_ID

See Also:

Constant Field Values

QUEUE_NAME

static final int QUEUE_NAME

See Also:

Constant Field Values

PRIO

static final int PRIO

See Also:

Constant Field Values

TYPE_NAME

static final int TYPE_NAME

See Also:

Constant Field Values

PERSISTENT

static final int PERSISTENT

See Also:

Constant Field Values

SIZE_IN_BYTES

static final int SIZE_IN_BYTES

See Also:

Constant Field Values

BLOB

static final int BLOB

See Also:

Constant Field Values

SQLSERVER

public final java.lang.String SQLSERVER

See Also:

Constant Field Values

POSTGRES

public final java.lang.String POSTGRES

See Also:

Constant Field Values

ORACLE

public final java.lang.String ORACLE

See Also:

Constant Field Values

hostname

private java.lang.String hostname

from

private java.lang.String from

to

private java.lang.String to

conFrom

private java.sql.Connection conFrom

conTo

private java.sql.Connection conTo

sqlServer

private JdbcShuffler.ConDetail sqlServer

oracle

private JdbcShuffler.ConDetail oracle

postgres

private JdbcShuffler.ConDetail postgres

Constructor Detail

JdbcShuffler

public JdbcShuffler(java.lang.String[] args)

Method Detail

init

public void init()
          throws java.sql.SQLException

Throws:

java.sql.SQLException

shutdown

public void shutdown()
              throws java.sql.SQLException

Throws:

java.sql.SQLException

getDate

private java.lang.String getDate()

shuffle

public void shuffle()
             throws java.sql.SQLException,
                    java.io.IOException

Throws:

java.sql.SQLException

java.io.IOException

isPersistent

private boolean isPersistent(java.lang.String persistentAsChar)

main

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