de.mvcsys.rsql
Class RsqlConnection

java.lang.Object
  |
  +--de.mvcsys.renscribe.Host
        |
        +--de.mvcsys.rsql.RsqlConnection

public class RsqlConnection

extends Host

Verbindung zum RSQLSRV-Prozess und Ausführen der Kommandos

Field Summary

int	sqlcode Der letzte SQLCODE

Fields inherited from class de.mvcsys.renscribe.Host

DEFINES_KEY_ATTR, DEFINES_KEY_CLASS, DEFINES_KEY_NAME, DEFINES_KEY_VALUE, EBADF, EINVAL, ENCODING, END_OF_FILE, ERR_CONNECT, ERR_DUPLICATE_KEY, ERR_GUARDIAN, ERR_IN_USE, ERR_LOGIN, ERR_MAX, ERR_NOT_FOUND, ERR_PROTOCOL, errno, errorMsg, EXCEPTION, hostName, NOT_OK, OK, OPEN_BUFFERED, OPEN_BUFFERED_INPUT, OPEN_BUFFERED_OUTPUT, OPEN_EXCLUSIVE, OPEN_FORCE_UPDATE, OPEN_NOWAIT, OPEN_SHARED, OPEN_STREAM, port, READ_LOCK, READ_NOLOCK, RENSCRIBE_PORT, SEEK_ABSOLUTE, SEEK_APPROXIMATE, SEEK_END, SEEK_EXACT, SEEK_GENERIC, SEEK_LOCK, SEEK_MASK, SEEK_RELATIVE, SEEK_REVERSE, SEEK_SKIP, throwException, TT_BEGIN, TT_COMMIT, TT_NONE, TT_ROLLBACK, TYPE_EDIT, TYPE_ENSCRIBE, TYPE_UNSTRUCTURED, WRITE_NOUNLOCK, WRITE_UNLOCK

Constructor Summary

RsqlConnection(String hostName, int port, String user, String password, boolean trace)
Konstruktor.

RsqlConnection(String hostName, int port, String user, String password, PrintWriter traceWriter)
Konstruktor.

RsqlConnection(String hostName, String user, String password, boolean trace)
Konstruktor.

RsqlConnection(String hostName, String user, String password, PrintWriter traceWriter)
Konstruktor.

Method Summary

void	beginWork() BEGIN WORK
void	commitWork() COMMIT WORK
void	disconnect() Ressourcen-Freigabe, Kommando DISCONNECT und Verbindungsabbau
int	execImmediate(String sqlCommand) EXECUTE IMMEDIATE
void	finalize() Finalizer gibt Resourcen frei und macht Disconnect
RsqlCursor	findCursor(String name) Suche einen Cursor
RsqlStatement	findStatement(String name) Suche ein Statement
protected String	getError() Hole Fehlertext
protected String	getSystemCatalog(String node) Hole System-Katalog
RsqlStatement	prepareStatement(String name, String statement) PREPARE
void	releaseAll() Ressourcen-Freigabe
void	rollbackWork() ROLLBACK WORK

Methods inherited from class de.mvcsys.renscribe.Host

checkTransaction, closeAll, comment, connect, contime, create, flushAll, getResult, info, info, isTransaction, loadDefines, main, makeString, open, purge, returnNotOk, returnNull, setDebug, setThrowException, setTrace, setTrace, startLog, startLog, stopLog, strerror, system, transact, volume, xComputeIoOffset, xDoExtIo, xGetByte, xGetInt, xGetIoBuffer, xGetShort, xGetString, xGetString, xGetString, xGetSubResult, xResetParameters, xSetByte, xSetBytes, xSetInt, xSetShort, xSetString, xSetSubCommand

Methods inherited from class java.lang.Object

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

Field Detail

sqlcode

public int sqlcode

Der letzte SQLCODE

Constructor Detail

RsqlConnection

public RsqlConnection(String hostName,
                      int port,
                      String user,
                      String password,
                      boolean trace)
               throws UnknownHostException,
                      SocketException,
                      IOException,
                      RsqlException

Konstruktor. Baut Verbindung auf.

Parameters:

hostName - Hostname

port - TCP/IP-Port auf dem RSQLSRV oder ENSERV installiert ist

user - Guardian-Benutzer

password - Guardian-Passwort

trace - Trace einschalten

RsqlConnection

public RsqlConnection(String hostName,
                      int port,
                      String user,
                      String password,
                      PrintWriter traceWriter)
               throws UnknownHostException,
                      SocketException,
                      IOException,
                      RsqlException

Konstruktor. Baut Verbindung auf.

Parameters:

hostName - Hostname

port - TCP/IP-Port auf dem RSQLSRV oder ENSERV installiert ist

user - Guardian-Benutzer

password - Guardian-Passwort

traceWriter - Trace in diesen Writer

RsqlConnection

public RsqlConnection(String hostName,
                      String user,
                      String password,
                      boolean trace)
               throws UnknownHostException,
                      SocketException,
                      IOException,
                      RsqlException

Konstruktor. Baut Verbindung auf.

Parameters:

hostName - Hostname[:Port]

user - Guardian-Benutzer

password - Guardian-Passwort

trace - Trace einschalten

RsqlConnection

public RsqlConnection(String hostName,
                      String user,
                      String password,
                      PrintWriter traceWriter)
               throws UnknownHostException,
                      SocketException,
                      IOException,
                      RsqlException

Konstruktor. Baut Verbindung auf.

Parameters:

hostName - Hostname[:Port]

user - Guardian-Benutzer

password - Guardian-Passwort

traceWriter - Trace in diesen Writer

Method Detail

beginWork

public void beginWork()
               throws IOException,
                      RsqlException

BEGIN WORK

commitWork

public void commitWork()
                throws IOException,
                       RsqlException

COMMIT WORK

disconnect

public void disconnect()
                throws IOException

Ressourcen-Freigabe, Kommando DISCONNECT und Verbindungsabbau

Overrides:

disconnect in class Host

execImmediate

public int execImmediate(String sqlCommand)
                  throws IOException,
                         RsqlException

EXECUTE IMMEDIATE

Parameters:

sqlCommand - SQL-Befehl

Returns:

Anzahl der betroffenen Rows

finalize

public void finalize()

Finalizer gibt Resourcen frei und macht Disconnect

Overrides:

finalize in class Object

findCursor

public RsqlCursor findCursor(String name)

Suche einen Cursor

Parameters:

name - Name des Cursors

Returns:

das Cursor oder null

findStatement

public RsqlStatement findStatement(String name)

Suche ein Statement

Parameters:

name - Name des SQL-Statement

Returns:

das Statement oder null

getError

protected String getError()
                   throws IOException,
                          RsqlException

Hole Fehlertext

getSystemCatalog

protected String getSystemCatalog(String node)
                           throws IOException,
                                  RsqlException

Hole System-Katalog

prepareStatement

public RsqlStatement prepareStatement(String name,
                                      String statement)
                               throws IOException,
                                      RsqlException

PREPARE

Parameters:

name - Name des SQL-Statement

statement - SQL-Statement als Text

Returns:

das präparierte Statement

releaseAll

public void releaseAll()

Ressourcen-Freigabe

Overrides:

releaseAll in class Host

rollbackWork

public void rollbackWork()
                  throws IOException,
                         RsqlException

ROLLBACK WORK