|
/**export dbf table data to Oracle database |
*@param sourceUrl |
assign the DBF file directory location, in general, you want to export table data from a DBF file. 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 sourceTableName |
assign the source table name |
*@param targetSchemaName |
assign the destination schema, it null, export to the current user |
*@param targetTableName |
assign the destination table name which you want to exported to it |
*@param sourceConnPar |
assign the conntion properties, please split multi properties by ';' ,for example, username=abc;password=abc |
*/ |
|
public static void exportTable(String sourceUrl, String sourceTableName, String targetSchemaName, String targetTableName,String sourceConnPar) |
|
|
/**export SQL query result to Oracle database |
*@param sourceUrl |
assign the DBF file directory location, in general, you want to export table data from a DBF file.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 querySQL |
assign the query SQL |
*@param targetSchemaName |
assign the destination schema, it null, export to the current user |
*@param targetTableName |
assign the destination table name which you want to exported to it |
*@param sourceConnPar |
assign the conntion properties, please split multi properties by ';' ,for example, username=abc;password=abc |
*/ |
|
public static void exportQuery(String sourceUrl, String query, String targetSchemaName, String targetTableName, String sourceConnPar) |
|
|
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.DBF2Oracle.exportTable("c:/tmp","ATABLE",null,"BTABLE",null);
com.hxtt.data.export.advance.ConnectionGetter.setConnection(yourConnection);
com.hxtt.data.export.advance.DBF2Oracle.exportQuery("c:/tmp","select * from atable a, btable b where a.id=b.id",null,"BTABLE",null); |
>
|
|
|
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 EMBDBF2Oracle_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 exportTable(
sourceschemaname in varchar2,
tableorviewname varchar2,
targetdirectory in varchar2,
targettablename in varchar2,
targetconnprops in varchar2
)
as language java name 'com.hxtt.data.export.advance.DBF2Oracle.exportTable(
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.
|
|
|
|