Java Doc for SyncSchema.java in  » J2EE » Jaffa » org » jaffa » tools » database » Java Source Code / Java DocumentationJava Source Code and Java Documentation

This is an example of how it can be used

 try {
 SyncSchema s = new SyncSchema();
 s.setSourceDriverString("oracle.jdbc.driver.OracleDriver");
 s.setSourceConnection("jdbc:oracle:thin:@xxx.com:1521:source");
 s.setSourceUser("source");
 s.setSourcePassword("test");
 s.setSourceSchema("MySchema");
 s.setTargetDriverString("oracle.jdbc.driver.OracleDriver");
 s.setTargetConnection("jdbc:oracle:thin:@xxx.com:1521:target");
 s.setTargetUser("target");
 s.setTargetPassword("test");
 s.setTargetSchema("MySchema");
 s.setTableFilter("A%");
 s.process();
 Collection l = s.getTables();
 for(Iterator i = l.iterator(); i.hasNext(); ) {
 SyncSchema.Table t = (SyncSchema.Table) i.next();
 System.out.println("Schema:" + t.getSchema() + ", Table:" + t.getName() + " (" + t.getType() + ") [" + SyncSchema.getSyncName(t.getSyncStatus()) + "]");
 if(t.getFields() != null && t.getSyncStatus() == SyncSchema.TABLE_CHANGED ) {
 for(Iterator i2 = t.getFields().values().iterator(); i2.hasNext(); ) {
 SyncSchema.Field f = (SyncSchema.Field) i2.next();
 if(f.getSyncStatus() != SyncSchema.FIELD_SAME)
 System.out.println("    " + f.getSeq() + "." + f.getName() + " [" + SyncSchema.getSyncName(f.getSyncStatus()) + "] - " + f.getChanges() );
 }
 }
 }
 } catch (Exception e) {
 e.printStackTrace();
 }