Apache Derby Tools 10.17.1.0 · org.apache.derby.tools.ij

ij is Derby's interactive JDBC scripting tool. It is a simple utility for running scripts against a Derby database. You can also use it interactively to run ad hoc queries. ij provides several commands for ease in accessing a variety of JDBC features.

To run from the command line enter the following:

java [options] org.apache.derby.tools.ij [arguments]

ij is can also be used with any database server that supports a JDBC driver.

Access	Constructor and Description
private	ij()

Method Summary

Modifier and Type	Method and Description
public static String	getArg(String param, String[] args)
public static void	getPropertyArg(String[] args)
public static void	main(String[] args)
public static int	Returns: Number of SQLExceptions thrown during the execution, -1 if not known. runScript(Connection Connection to be used as the script's default connection. conn, InputStream InputStream for the script. sqlIn, String Encoding of the script. inputEncoding, OutputStream OutputStream for the script's output sqlOut, String Output encoding to use. outputEncoding) Run a SQL script from an InputStream and write the resulting output to the provided PrintStream.
public static int	Returns: Number of SQLExceptions thrown during the execution, -1 if not known. runScript(Connection Connection to be used as the script's default connection. conn, InputStream InputStream for the script. sqlIn, String Encoding of the script. inputEncoding, OutputStream OutputStream for the script's output sqlOut, String Output encoding to use. outputEncoding, boolean Whether to use the system properties. loadSystemProperties) Run a SQL script from an InputStream and write the resulting output to the provided PrintStream.
public static Connection	startJBMS()

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Constructor Detail

ij	back to summary
private ij()

Method Detail

getArg	back to summary
public static String getArg(String param, String[] args)

getPropertyArg	back to summary
public static void getPropertyArg(String[] args) throws IOException

main	back to summary
public static void main(String[] args) throws IOException Exceptions IOException: thrown if cannot access input or output files.

runScript	back to summary
public static int runScript(Connection conn, InputStream sqlIn, String inputEncoding, OutputStream sqlOut, String outputEncoding) throws UnsupportedEncodingException Run a SQL script from an InputStream and write the resulting output to the provided PrintStream. SQL commands are separated by a semi-colon ';' character. Parameters conn:Connection Connection to be used as the script's default connection. sqlIn:InputStream InputStream for the script. inputEncoding:String Encoding of the script. sqlOut:OutputStream OutputStream for the script's output outputEncoding:String Output encoding to use. Returns:int Number of SQLExceptions thrown during the execution, -1 if not known.

runScript

back to summary

public static int runScript(Connection conn, InputStream sqlIn, String inputEncoding, OutputStream sqlOut, String outputEncoding) throws UnsupportedEncodingException

Run a SQL script from an InputStream and write the resulting output to the provided PrintStream. SQL commands are separated by a semi-colon ';' character.

Parameters

conn:Connection: Connection to be used as the script's default connection.
sqlIn:InputStream: InputStream for the script.
inputEncoding:String: Encoding of the script.
sqlOut:OutputStream: OutputStream for the script's output
outputEncoding:String: Output encoding to use.

Returns:int

Number of SQLExceptions thrown during the execution, -1 if not known.

runScript	back to summary
public static int runScript(Connection conn, InputStream sqlIn, String inputEncoding, OutputStream sqlOut, String outputEncoding, boolean loadSystemProperties) throws UnsupportedEncodingException Run a SQL script from an InputStream and write the resulting output to the provided PrintStream. SQL commands are separated by a semi-colon ';' character. Parameters conn:Connection Connection to be used as the script's default connection. sqlIn:InputStream InputStream for the script. inputEncoding:String Encoding of the script. sqlOut:OutputStream OutputStream for the script's output outputEncoding:String Output encoding to use. loadSystemProperties:boolean Whether to use the system properties. Returns:int Number of SQLExceptions thrown during the execution, -1 if not known.