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
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
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
JdbcShuffler
public JdbcShuffler(java.lang.String[] args)
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)
Copyright © 1999-2014 The xmlBlaster.org contributers.