org.compiere.db
Class Convert

java.lang.Object
  org.compiere.db.Convert

public class Convert
extends Object

Convert SQL to Target DB

Version:

$Id: Convert.java,v 1.3 2006/07/30 00:55:04 jjanke Exp $

Author:

Jorg Janke, Victor Perez

Field Summary

static int

REGEX_FLAGS RegEx: insensitive and dot to include line end characters

Constructor Summary

Convert(String type)
Cosntructor

Method Summary

String[]	convert(String sqlStatements) Convert SQL Statement (stops at first error).
String	convertAll(String sqlStatements) Convert SQL Statement (stops at first error).
boolean	execute(String sqlStatements, Connection conn) Execute SQL Statement (stops at first error).
String	getConversionError() Return last conversion error or null.
Exception	getException() Return last execution exception
boolean	hasError() Returns true if a conversion or execution error had occured.
boolean	isOracle() Is Oracle DB
protected String	removeComments(String statement) Clean up Statement.
void	setVerbose(boolean verbose) Set Verbose

Methods inherited from class java.lang.Object

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

Field Detail

REGEX_FLAGS

public static final int REGEX_FLAGS

RegEx: insensitive and dot to include line end characters

See Also:

Constant Field Values

Constructor Detail

Convert

public Convert(String type)

Cosntructor

Parameters:

type - Database.DB_

Method Detail

setVerbose

public void setVerbose(boolean verbose)

Set Verbose

Parameters:

verbose -

isOracle

public boolean isOracle()

Is Oracle DB

Returns:

true if connection is Oracle DB

execute

public boolean execute(String sqlStatements,
                       Connection conn)

Execute SQL Statement (stops at first error). If an error occured hadError() returns true. You can get details via getConversionError() or getException()

Parameters:

sqlStatements -

conn - connection

Returns:

true if success

Throws:

IllegalStateException - if no connection

getException

public Exception getException()

Return last execution exception

Returns:

execution exception

hasError

public boolean hasError()

Returns true if a conversion or execution error had occured. Get more details via getConversionError() or getException()

Returns:

true if error had occured

convertAll

public String convertAll(String sqlStatements)

Convert SQL Statement (stops at first error). Statements are delimited by / If an error occured hadError() returns true. You can get details via getConversionError()

Parameters:

sqlStatements -

Returns:

converted statement as a string

convert

public String[] convert(String sqlStatements)

Convert SQL Statement (stops at first error). If an error occured hadError() returns true. You can get details via getConversionError()

Parameters:

sqlStatements -

Returns:

Array of converted Statements

getConversionError

public String getConversionError()

Return last conversion error or null.

Returns:

lst conversion error

removeComments

protected String removeComments(String statement)

Clean up Statement. Remove all comments and while spaces Database specific functionality can me tagged as follows:

        /*ORACLE>*/
      Oracle Specific Statement
        /*<ORACLE*/
        /*POSTGRESQL>
      PostgreSQL Specicic Statements
        <POSTGRESQL*/
  

Parameters:

statement -

Returns:

sql statement