Chapter 4. Use the embed package

Use the embbed package in my program    

Use the embbed package in Oracle database

Use the embbed package in my program
   
   You can use our package in your program to execute export operation. We have public the method for execute export operation. The follows method you can used.
 
/**export table data in Oracle database to Visual Foxpro 10 Table
 *@param schemaName assign the source data table's schema, null means that table is owned by current user
 *@param tableName assign the source table name
 *@param targetDirectory assign the destination directory, in general, you want to export table data to a file, so this parameter name is  targetDirectory, but in fact, you can assign any legal jdbc url not contains the prefix part(jdbc:dbf:/), so, c:/tmp,  c:/tmp/xx.zip, ////192.168.10.2/sharedir, //domain.com:3099/c:/data all can assigned to this parameter,  more about this information, please see the document
 *@param targetTableName assign the destination table name which you want to exported to it
 *@param targetConnProps  assign the destinition conntion properties, please split multi properties by ';' ,for example, username=abc;password=abc
 */
 public static void exportTableToFoxpro10(String schemaName, String tableName, String targetDirectory, String targetTableName, String targetConnProps)
 
 /**export table data to Visual Foxpro 9 Table*/
 public static void exportTableToFoxpro9(String schemaName, String tableName, String targetDirectory, String targetTableName, String targetConnProps) 
 
 /**export table data to Visual Foxpro 8 Table  */
 public static void exportTableToFoxpro8(String schemaName, String tableName, String targetDirectory, String targetTableName, String targetConnProps)
 
 /**export table data to Visual Foxpro 7 Table */
 public static void exportTableToFoxpro7(String schemaName, String tableName, String targetDirectory, String targetTableName, String targetConnProps)
 
 /**export table data to Visual Foxpro 5 Table  */
 public static void exportTableToFoxpro5(String schemaName, String tableName, String targetDirectory, String targetTableName,String targetConnProps)
 
 /**export table data to Visual Foxpro 3 Table  */
 public static void exportTableToFoxpro3(String schemaName, String tableName, String targetDirectory, String targetTableName, String targetConnProps)
 
 /**export table data to Visual Foxpro Table  */
 public static void exportTableToFoxpro(String schemaName, String tableName, String targetDirectory, String targetTableName, String targetConnProps)
 
 /**export table data to DBase2000 Table */
 public static void exportTableToDBase2000(String schemaName, String tableName, String targetDirectory,String targetTableName, String targetConnProps)
 
 /**export table data to DBase5 Table */
 public static void exportTableToDBase5(String schemaName, String tableName, String targetDirectory,String targetTableName, String targetConnProps) 
 
 /**export table data to DBase4 Table */
 public static void exportTableToDBase4(String schemaName, String tableName, String targetDirectory,String targetTableName, String targetConnProps)
 
  /**export table data to DBase3 Table */
 public static void exportTableToDBase3(String schemaName, String tableName, String targetDirectory,String targetTableName, String targetConnProps)
 
 /**export table data to DBase2 Table */
 public static void exportTableToDBase2(String schemaName, String tableName, String targetDirectory, String targetTableName,String targetConnProps)
 
 /**export table data to Foxbase Table */
public static void exportTableToFoxbase(String schemaName, String tableName, String targetDirectory, String targetTableName,String targetConnProps)
 
 
/**export SQL query result to Visual Foxpro 10 Table
 *@param querySql assign the SQL query sentence
 *@param targetDirectory assign the destination directory, in general, you want to export table data to a file, so this parameter name is  targetDirectory, but in fact, you can assign any legal jdbc url not contains the prefix part(jdbc:dbf:/), so, c:/tmp,  c:/tmp/xx.zip, ////192.168.10.2/sharedir all can assigned to this parameter, more about this information, please see the document
 *@param targetTableName     assign the destination table name which you want to exported to it
 *@param targetConnProps  assign the conntion properties for build destination database connectiion, please split multi properties by ';' ,for example, username=abc;password=abc
 */
 public static void exportQueryToFoxpro10(String querySQL, String targetDirectory, String targetTableName, String targetConnProps)
 
 /**export SQL query result to Visual Foxpro 9 Table*/
 public static void exportQueryToFoxpro9(String querySQL, String targetDirectory, String targetTableName, String targetConnProps) 
 
 /**export SQL query result to Visual Foxpro 8 Table  */
 public static void exportQueryToFoxpro8(String querySQL, String targetDirectory, String targetTableName, String targetConnProps)
 
 /**export SQL query result to Visual Foxpro 7 Table */
 public static void exportQueryToFoxpro7(String querySQL, String targetDirectory, String targetTableName, String targetConnProps)
 
 /**export SQL query result to Visual Foxpro 5 Table  */
 public static void exportQueryToFoxpro5(String querySQL, String targetDirectory, String targetTableName,String targetConnProps)
 
 /**export SQL query result to Visual Foxpro 3 Table  */
 public static void exportQueryToFoxpro3(String querySQL, String targetDirectory, String targetTableName, String targetConnProps)
 
 /**export SQL query result to Visual Foxpro Table  */
 public static void exportQueryToFoxpro(String querySQL, String targetDirectory, String targetTableName, String targetConnProps)
 
 /**export SQL query result to DBase2000 Table */
 public static void exportQueryToDBase2000(String querySQL, String targetDirectory,String targetTableName, String targetConnProps)
 
 /**export SQL query result to DBase5 Table */
 public static void exportQueryToDBase5(String querySQL, String targetDirectory,String targetTableName, String targetConnProps)
 
 /**export SQL query result to DBase4 Table */
 public static void exportQueryToDBase4(String querySQL, String targetDirectory,String targetTableName, String targetConnProps)
 
  /**export SQL query result to DBase3 Table */
 public static void exportQueryToDBase3(String querySQL, String targetDirectory,String targetTableName, String targetConnProps)
 
 /**export SQL query result to DBase2 Table */
 public static void exportQueryToDBase2(String querySQL, String targetDirectory, String targetTableName,String targetConnProps)
 
 /**export SQL query result to Foxbase Table */
public static void exportQueryToFoxbase(String querySQL, String targetDirectory, String targetTableName,String targetConnProps)
 
 
You should supply a Oracle database connection , and then call the method. We will release this connection after complete a export operation for we want to avoid holding a reference to the connection . So, if you want continue execute other export operation, you should recall the setConnection method, for example, this code execute two operations.

com.hxtt.data.export.advance.ConnectionGetter.setConnection(yourConnection);
com.hxtt.data.export.advance.Oracle2DBF.exportTableToFoxbase(null,"ATABLE","c:/tmp","BTABLE",null);


com.hxtt.data.export.advance.ConnectionGetter.setConnection(yourConnection);
com.hxtt.data.export.advance.Oracle2DBF.exportQueryToFoxbase("select * from ATABLE a, BTABLE b WHERE a.id=b.id","c:/tmp","NEWTABLE",null);






>


   
   
  If you think our product is very good and want contains it to your products, please contact webmaster@hxtt.com for more detail information.
   
 
Use the embbed package in Oracle database
 
 
  

In general , the user who can connect to Oracle database have most of privilege to load our embed package to Oracle database.

    You can use the follows command to load package in windows command or linux shell.

      loadjava -resolve -synonym -verbose -user username/password@oracleSID EMBOracle2DBF_WithDrv.jar

   If errors happened when execute this command , please see here.

   After have load this package to Oracle database, you can create a JAVA procedure to execute the export operation, the follows SQL show how to create a java procedure.

   procedure exportTableToFoxpro10(
    sourceschemaname in varchar2,
    tableorviewname varchar2,
    targetdirectory in varchar2,
    targettablename in varchar2,
    targetconnprops in varchar2
  )
    as language java name 'com.hxtt.data.export.advance.Oracle2DBF.exportTableToFoxpro10(
    java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String)';
  

   You can create other procedure for the other public method. All public method please see here.

   Then you call this procedure like call other procedure to execute export operation.

   You can see the faq if errors happen, or contact us by email, or here to submit your question.

 

   
   

 

 

   

 

 




Copyright © 2006 Heng Xing Tian Tai Lab of Xi'an City | All Rights Reserved. |