com.firstworks.sqlrelay
Class SQLRConnection

java.lang.Object
  extended bycom.firstworks.sqlrelay.SQLRConnection

public class SQLRConnection
extends java.lang.Object


Field Summary
 int connection
          connection is used internally, it's just public to make the JNI wrapper work faster.
 
Constructor Summary
SQLRConnection(java.lang.String server, int port, java.lang.String socket, java.lang.String user, java.lang.String password, int retrytime, int tries)
          Initiates a connection to "server" on "port" or to the unix "socket" on the local machine and authenticates with "user" and "password".
 
Method Summary
 int autoCommitOff()
          Instructs the database to wait for the client to tell it when to commit.
 int autoCommitOn()
          Instructs the database to perform a commit after every successful query.
 int commit()
          Issues a commit.
 void debugOff()
          Turns debugging off.
 void debugOn()
          Causes verbose debugging information to be sent to standard output.
 void delete()
          Disconnects and ends the session if it hasn't been ended already.
 int endSession()
          Ends the session.
 int getConnectionPort()
          Returns the inet port that the connection is communicating over.
 java.lang.String getConnectionSocket()
          Returns the unix socket that the connection is communicating over.
 int getDebug()
          Returns 0 if debugging is off and 1 if debugging is on.
 java.lang.String identify()
          Returns the type of database: oracle7, oracle8, postgresql, mysql, etc.
 int ping()
          Returns 1 if the database is up and 0 if it's down.
 int resumeSession(int port, java.lang.String socket)
          Resumes a session previously left open using suspendSession().
 int rollback()
          Issues a rollback.
 int suspendSession()
          Disconnects this connection from the current session but leaves the session open so that another connection can connect to it using resumeSession().
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

connection

public int connection
connection is used internally, it's just public to make the JNI wrapper work faster.

Constructor Detail

SQLRConnection

public SQLRConnection(java.lang.String server,
                      int port,
                      java.lang.String socket,
                      java.lang.String user,
                      java.lang.String password,
                      int retrytime,
                      int tries)
Initiates a connection to "server" on "port" or to the unix "socket" on the local machine and authenticates with "user" and "password". Failed connections will be retried for "tries" times on interval "retrytime". If "tries" is 0 then retries will continue forever. If "retrytime" is 0 then retries will be attempted on a default interval. If the "socket" parameter is neither NULL nor "" then an attempt will be made to connect through it before attempting to connect to "server" on "port". If it is NULL or "" then no attempt will be made to connect through the socket.

Method Detail

delete

public void delete()
Disconnects and ends the session if it hasn't been ended already.


endSession

public int endSession()
Ends the session.


suspendSession

public int suspendSession()
Disconnects this connection from the current session but leaves the session open so that another connection can connect to it using resumeSession().


getConnectionPort

public int getConnectionPort()
Returns the inet port that the connection is communicating over. This parameter may be passed to another connection for use in the resumeSession() method.


getConnectionSocket

public java.lang.String getConnectionSocket()
Returns the unix socket that the connection is communicating over. This parameter may be passed to another connection for use in the resumeSession() method.


resumeSession

public int resumeSession(int port,
                         java.lang.String socket)
Resumes a session previously left open using suspendSession(). Returns 1 on success and 0 on failure.


ping

public int ping()
Returns 1 if the database is up and 0 if it's down.


identify

public java.lang.String identify()
Returns the type of database: oracle7, oracle8, postgresql, mysql, etc.


autoCommitOn

public int autoCommitOn()
Instructs the database to perform a commit after every successful query.


autoCommitOff

public int autoCommitOff()
Instructs the database to wait for the client to tell it when to commit.


commit

public int commit()
Issues a commit. Returns 1 if the commit succeeded, 0 if it failed and -1 if an error occurred.


rollback

public int rollback()
Issues a rollback. Returns 1 if the rollback succeeded, 0 if it failed and -1 if an error occurred.


debugOn

public void debugOn()
Causes verbose debugging information to be sent to standard output. Another way to do this is to start a query with "-- debug\n".


debugOff

public void debugOff()
Turns debugging off.


getDebug

public int getDebug()
Returns 0 if debugging is off and 1 if debugging is on.