: Class Connection

Overview

Package

Class

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: INNER | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

jasp.adodb
Class Connection

java.lang.Object
  |
  +--jasp.adodb.Connection

public class Connection
extends java.lang.Object

This class is compatible with Microsoft's ADODB.CONNECTOIN object. For more usage information, please refer to Microsoft's documention.
A Connection object represents a unique session with a RDBMS. In the case of a client/server database system, it may be equivalent to an actual network connection to the server. Depending on the functionality supported by the JDBC Driver, some collections, methods, or properties of a Connection object may not be available.

Connection allows you to access database through JDBC Driver. Use the following syntax to set the ConnectionString.

1. If you use the JDBC driver:

Driver=drivername;URL={JDBC url};UserID=userid;Password=password; URL - a database url of the form jdbc:subprotocol:subname
UserID - the database user on whose behalf the connection is being made
Password - the password of the user.

For example: If you use Oracle JDBC driver, you can change your asp connection string as following codes:
<%
Dim DBConn
Dim strCnxn
strCnxn = "Driver=oracle.jdbc.driver.OracleDriver;" &_
"URL = {jdbc:oracle:thin:@OracleSvr:ORCL};" &_
"UserID = SCOTT;Password=TIGER;"
Set DBConn = Server.CreateObject("ADODB.Connection")
DBConn.Open strCnxn
%>

2. Set Connection properties to connect database

For example:
<%
Dim DBConn
Set DBConn = Server.CreateObject("ADODB.Connection")
Conn.Provider = "org.gjt.mm.mysql.Driver"
Conn.UserName = "root"
Conn.Password = "secret"
Conn.ConnectURL = "jdbc:mysql://mySQLSvr:3306/test"
Conn.Open
%>

3. Using JDBC-ODBC bridge

If you use JDBC-ODBC bridge driver to access database:
DSN=Data Source Name;UID=userid;PWD=password
Note: You must set the JDBC driver to the CLASSPATH. J-ASP ADO only supports the JDBC2.0 or later. If you are using the JDBC1.x driver, J-ASP ADO will be not functional.

Constructor Summary

Connection()
          Creates a Connection Object.

Method Summary

void AssignProps()
          Assign all properties of the Connection.

int BeginTrans()
          Begins a new transaction.

void Cancel()
          Terminates execution of an asynchronous Open method.

void Close()
          Close the Connection session with database also close any active Recordset object associated with the connection.A Command object associated with the Connection object you are closing will persist, but it will no longer be associated with a Connection object; that is, its ActiveConnection property will be set to Nothing.

void CommitTrans()
          Saves changes made within an open transaction on the connection and ends the transaction.

Recordset Execute(java.lang.String CommandText)
          Returns a Recordset object with the specific CommandText, the CommandText maybe a SQL statement,stored procedure etc.

Recordset Execute(java.lang.String CommandText, variant AffectedCount)
          Returns a Recordset object with the specific CommandText and return the Affected records number, the CommandText maybe a SQL statement,stored procedure etc.

Recordset Execute(java.lang.String CommandText, variant AffectedCount, int Option)
          Returns a Recordset object with the specific CommandText and return the Affected records number, the CommandText maybe a SQL statement,stored procedure etc.

int getAttributes()
          Returns one or more characteristics.

int getCommandTimeout()
          Returns how long to wait while executing a command before terminating the attempt and generating an error.

java.lang.String getConnectionString()
          Returns the information used to establish a connection to a data source.

int getConnectionTimeout()
          Returns the value of ConnectionTimeout with current object's

java.lang.String getConnectURL()
          Returns the url of the connection.

int getCursorLocation()
          Returns the location of cursor engine.

java.lang.String getDefaultDatabase()
          Returns a string value that evaluates to the name of a database available from the provider.

Errors getErrors()
          Returns the Errors collection

Error getErrors(int i)
          Gets an Error from the Errors Collection.

Error getErrors(java.lang.String i)


int getIsolationLevel()
          Returns the level of isolation for a Connection object.

int getMode()
          Returns the available permissions for modifying data in a Connection.

int getObjectState()
          Returns the objectstate of the Connection.

java.lang.String getPassword()
          Returns the Password of the user name.

Properties getProperties()
          Returns the properties collection of the Connection.

java.lang.String getProvider()
          Returns the name of the Jdbc driver.

int getState()
          Returns states of all applicable objects, open or closed.

java.lang.String getUserName()
          Returns the user name for conecting database

java.lang.String getVersion()
          Returns the currect the version of the ADODB.

void Open()
          Opens a connection to a data source.

void Open(java.lang.String connectStr)
          Opens a connection to a data source.

void Open(java.lang.String connectStr, java.lang.String UserID)
          Opens a connection to a data source.

void Open(java.lang.String connectStr, java.lang.String UserID, java.lang.String Password)
          Opens a connection to a data source.

void Open(java.lang.String connectStr, java.lang.String UserID, java.lang.String Password, int Option)
          Opens a connection to a data source.

void Open(java.lang.String connectStr, variant UserID, java.lang.String Password)
          Opens a connection to a data source.

void Open(variant connectStr, java.lang.String UserID, java.lang.String Password, int Option)
          Opens a connection to a data source.

void Open(variant connectStr, variant UserID, java.lang.String Password, int Option)
          Opens a connection to a data source.

void Open(variant connectStr, variant UserID, variant Password, int Option)
          Opens a connection to a data source.

Recordset OpenSchema(int QueryType)
          Returns a Recordset object that Obtains database schema information from the provider.

Recordset OpenSchema(int QueryType, variant Criteria)
          Returns a Recordset object that Obtains database schema information from the provider.

Recordset OpenSchema(int QueryType, variant Criteria, java.lang.Object SchemaID)
          Returns a Recordset object that Obtains database schema information from the provider.

Property Properties(int index)
          Gets a property with specific index from Properties collection

Property Properties(java.lang.String name)
          Returns the Property object with specific name from Properties collection

Property Properties(variant var)
          Gets a property from the Properties collection.

void RollbackTrans()
          Reverses any changes made within an open transaction and ends the transaction if the Attributes property is set to adXactAbortRetaining, it automatically starts a new transaction after a RollbackTrans call

void setAttributes(int attrib)
          Indicates one or more characteristics of an object.

void setCommandTimeout(int cmdtimeout)
          Sets the CommandTimeout property value

void setConnectionString(java.lang.String connectStr)
          Sets the information for establish a connection

Note: the connection must be following format:
Using jdbc-odbc bridge:
"DSN=Data Source Name;UID=userid;PWD=password" Using JDBC Drivers:
"Driver=drivername;URL={JDBC url};UserID=userid;Password=password;"

void setConnectionTimeout(int timeout)
          Sets the ConnectionTimeout's value for the currect object.

void setConnectURL(java.lang.String url)
          Sets the url of the Connection

void setCursorLocation(int cursorlocation)
          Sets the location of the cursor engine.

void setDefaultDatabase(java.lang.String db)
          Sets a string value the evaluates to the name of a database avaliable from the provider.

void setIsolationLevel(int islevel)
          Sets the level of isolation for a Connection object.

void setMode(int mode)
          Sets the available permissions for connection.

void setPassword(java.lang.String password)
          Sets the password of the username.

void setProvider(java.lang.String provider)
          Sets the name of jdbc driver.

void setUserName(java.lang.String username)
          Set the user name for conecting database.

java.lang.String toString()


Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

Connection

public Connection()

Creates a Connection Object.

Method Detail

getVersion

public java.lang.String getVersion()
                            throws java.lang.Exception

Returns the currect the version of the ADODB.

setConnectURL

public void setConnectURL(java.lang.String url)
                   throws java.lang.Exception

Sets the url of the Connection

Parameters:: url - the url of JDBC Driver for connecting database.

getConnectURL

public java.lang.String getConnectURL()

Returns the url of the connection.

setUserName

public void setUserName(java.lang.String username)
                 throws java.lang.Exception

Set the user name for conecting database.

getUserName

public java.lang.String getUserName()

Returns the user name for conecting database

getPassword

public java.lang.String getPassword()

Returns the Password of the user name.

setPassword

public void setPassword(java.lang.String password)
                 throws java.lang.Exception

Sets the password of the username.

getDefaultDatabase

public java.lang.String getDefaultDatabase()
                                    throws java.lang.Exception

Returns a string value that evaluates to the name of a database available from the provider.

setDefaultDatabase

public void setDefaultDatabase(java.lang.String db)
                        throws java.lang.Exception

Sets a string value the evaluates to the name of a database avaliable from the provider.

getConnectionTimeout

public int getConnectionTimeout()

Returns the value of ConnectionTimeout with current object's

setConnectionTimeout

public void setConnectionTimeout(int timeout)
                          throws java.lang.Exception

Sets the ConnectionTimeout's value for the currect object.

getState

public int getState()

Returns states of all applicable objects, open or closed. the state can be one of following constants.

adStateClosed default. Indicates the object is closed.
adStateOpen Indicates that the object is open.
adStateConnection Indicates that the Recordset object is connecting.
adStateExecuting Indicates that the Recordset object is executing a command.
adStateFetching Indicates that the rows of the Recordset object are being fetched.

getMode

public int getMode()

Returns the available permissions for modifying data in a Connection. the Mode can be one of the following constants.

adModeUnknown Default. Indicates that the permissions have not yet been set or cannot be determined.
adModeRead Indicates read-only permissions.
adModeWrite Indicates write-only permissions.
adModeReadWrite Indicates read/write permissions.
adModeShareDenyRead Prevents others from opening connection with read permissions.
adModeShareDenyWrite Prevents others from opening connection with write permissions
adModeShareExclusive Prevents others from opening connection.
adModeShareDenyNone Prevents others from opening connection with any permissions.
adModeRecursive

setMode

public void setMode(int mode)
             throws java.lang.Exception

Sets the available permissions for connection.

getProvider

public java.lang.String getProvider()

Returns the name of the Jdbc driver.

setProvider

public void setProvider(java.lang.String provider)
                 throws java.lang.Exception

Sets the name of jdbc driver.

getAttributes

public int getAttributes()

Returns one or more characteristics.

adXactCommitRetaining Performs retaining commits��that is, calling CommitTrans automatically starts a new transaction.
adXactAbortRetaining Performs retaining aborts��that is, calling RollbackTrans automatically starts a new transaction.

setAttributes

public void setAttributes(int attrib)

Indicates one or more characteristics of an object.

getCursorLocation

public int getCursorLocation()

Returns the location of cursor engine.

adUseClient Uses client-side cursors supplied by a local cursor library.
adUseServer Default, Uses data-provider�C or driver-supplied cursors. These cursors are sometimes very flexible and allow for additional sensitivity to changes others make to the data source

setCursorLocation

public void setCursorLocation(int cursorlocation)
                       throws java.lang.Exception

Sets the location of the cursor engine. It's Read/Write on a Connection.

getCommandTimeout

public int getCommandTimeout()

Returns how long to wait while executing a command before terminating the attempt and generating an error.

setCommandTimeout

public void setCommandTimeout(int cmdtimeout)

Sets the CommandTimeout property value

getConnectionString

public java.lang.String getConnectionString()

Returns the information used to establish a connection to a data source.

setConnectionString

public void setConnectionString(java.lang.String connectStr)
                         throws java.lang.Exception

Sets the information for establish a connection

Note: the connection must be following format:

Using jdbc-odbc bridge:
"DSN=Data Source Name;UID=userid;PWD=password"
Using JDBC Drivers:
"Driver=drivername;URL={JDBC url};UserID=userid;Password=password;"

Parameters:: connectStr - a string value

getIsolationLevel

public int getIsolationLevel()

Returns the level of isolation for a Connection object.

adXactUnspecified Indicates that the provider is using a different IsolationLevel than specified, but that the level cannot be determined.

adXactChaos Default. Indicates that you cannot overwrite pending changes from more highly isolated transactions.

adXactBrowse Indicates that from one transaction you can view uncommitted changes in other transactions.

adXactReadUncommitted Same as adXactBrowse.

adXactCursorStability Default. Indicates that from one transaction you can view changes in other transactions only after they've been committed.

adXactReadCommitted Same as adXactCursorStability.

adXactRepeatableRead Indicates that from one transaction you cannot see changes made in other transactions, but that requerying can bring new recordsets.

adXactIsolated Indicates that transactions are conducted in isolation of other transactions

adXactSerializable Same as adXactIsolated

setIsolationLevel

public void setIsolationLevel(int islevel)

Sets the level of isolation for a Connection object.

getProperties

public Properties getProperties()
                         throws java.lang.Exception

Returns the properties collection of the Connection.

getObjectState

public int getObjectState()

Returns the objectstate of the Connection.

AssignProps

public void AssignProps()
                 throws java.lang.Exception

Assign all properties of the Connection.

Properties

public Property Properties(variant var)
                    throws java.lang.Exception

Gets a property from the Properties collection.

Parameters:: var - the name or index of the property.
Returns:: a Property value.

Properties

public Property Properties(int index)
                    throws java.lang.Exception

Gets a property with specific index from Properties collection

Parameters:: index - the index of the property.
Returns:: a Property value

Properties

public Property Properties(java.lang.String name)
                    throws java.lang.Exception

Returns the Property object with specific name from Properties collection

Parameters:: name - the name of the property.
Returns:: a Property value

getErrors

public Errors getErrors()

Returns the Errors collection

getErrors

public Error getErrors(int i)
                throws java.lang.Exception

Gets an Error from the Errors Collection.

Parameters:: i - the index of the error.
Returns:: an error.

getErrors

public Error getErrors(java.lang.String i)
                throws java.lang.Exception

OpenSchema

public Recordset OpenSchema(int QueryType)
                     throws java.lang.Exception

Returns a Recordset object that Obtains database schema information from the provider.

Parameters:: QueryType - The type of schema query to run.
Returns:: a Recordset object that contains schema information.

OpenSchema

public Recordset OpenSchema(int QueryType,
                            variant Criteria,
                            java.lang.Object SchemaID)
                     throws java.lang.Exception

Returns a Recordset object that Obtains database schema information from the provider.

Parameters:: QueryType - The type of schema query to run.; Criteria - An array of query constraints for each QueryType option.; SchemaID - The GUID for a provider-schema schema query not defined by the OLE DB specification.(Don't use it in J-ASP).
Returns:: a Recordset object that contains schema information.

OpenSchema

public Recordset OpenSchema(int QueryType,
                            variant Criteria)
                     throws java.lang.Exception

Returns a Recordset object that Obtains database schema information from the provider.

Parameters:: QueryType - The type of schema query to run.; Criteria - An array of query constraints for each QueryType option.
Returns:: a Recordset object that contains schema information.

Close

public void Close()
           throws java.lang.Exception

Close the Connection session with database also close any active Recordset object associated with the connection.A Command object associated with the Connection object you are closing will persist, but it will no longer be associated with a Connection object; that is, its ActiveConnection property will be set to Nothing. Also, the Command object's Parameters collection will be cleared of any provider-defined parameters.

Execute

public Recordset Execute(java.lang.String CommandText)
                  throws java.lang.Exception

Returns a Recordset object with the specific CommandText, the CommandText maybe a SQL statement,stored procedure etc.

Parameters:: CommandText - A String containing the SQL statement, table name, stored procedure, or provider-specific text to execute
Returns:: a Recordset object.

Execute

public Recordset Execute(java.lang.String CommandText,
                         variant AffectedCount)
                  throws java.lang.Exception

Returns a Recordset object with the specific CommandText and return the Affected records number, the CommandText maybe a SQL statement,stored procedure etc.

Parameters:: CommandText - A String containing the SQL statement, table name, stored procedure, or provider-specific text to execute; AffectedCount - the provider returns the number of records that the operation affected.
Returns:: a Recordset object.

Execute

public Recordset Execute(java.lang.String CommandText,
                         variant AffectedCount,
                         int Option)
                  throws java.lang.Exception

Returns a Recordset object with the specific CommandText and return the Affected records number, the CommandText maybe a SQL statement,stored procedure etc.

Parameters:: CommandText - A String containing the SQL statement, table name, stored procedure, or provider-specific text to execute; AffectedCount - the provider returns the number of records that the operation affected.; Option - An integer value that indicates how the provider should evaluate the CommandText argument.
Returns:: a Recordset object.