weblogic.jdbcx.sqlserver.SQLServerDataSource
weblogic.jdbc.sqlserver.SQLServerDriver
) in
instance_name
is an escape character.server_name
is the IP address or hostname of the server.instance_name
is the name of the instance to which you want to connect on the server.Property | Description |
---|---|
AlwaysReportTriggerResults OPTIONAL | {true | false}. Determines how the driver reports results generated by database triggers (procedures that are stored in the database and executed, or fired, when a table is modified). If set to true, the driver returns all results, including results generated by triggers. Multiple trigger results are returned one at a time. Use the Statement.getMoreResults method to retrieve individual trigger results. Warnings and errors are reported in the results as they are encountered. If set to false, the driver does not report trigger results if the statement is a single Insert, Update, or Delete statement. In this case, the only result that is returned is the update count generated by the statement that was executed (if errors do not occur). Although trigger results are ignored, any errors generated by the trigger are reported. Any warnings generated by the trigger are enqueued. If errors are reported, the update count is not reported. The default is false. |
CodePageOverride OPTIONAL | Specifies the code page the driver uses when converting character data. The specified code page overrides the default database code page. All character data retrieved from or written to the database is converted using the specified code page. The value must be a string containing the name of a valid code page supported by your Java Virtual Machine, for example, CodePageOverride=CP950. If a value is set for the CodePageOverride property and the SendStringParametersAsUnicode property is set to true, the driver ignores the SendStringParametersAsUnicode property and generates a warning. The driver always sends parameters using the code page specified by CodePageOverride if this property is specified. |
ConnectionRetryCount OPTIONAL | The number of times the driver retries connections to a database server until a successful connection is established. Valid values are 0 and any positive integer. If set to 0, the driver does not retry a connection to the list of database servers if a connection is not established on the driver's first pass through the list. The default is 0. |
ConnectionRetryDelay OPTIONAL | The number of seconds the driver waits before retrying connection attempts when ConnectionRetryCount is set to a positive integer. The default is 3. |
DatabaseName OPTIONAL | The name of the database to which you want to connect. |
HostProcess OPTIONAL | The process ID of the application connecting to Microsoft SQL Server. The value of this property appears in the hostprocess column of the master.dbo.sysprocesses table and may be useful for database administration purposes. The default is 0. |
InsensitiveResultSetBufferSize OPTIONAL | {-1 | 0 | x}. Determines the amount of memory used by the driver to cache insensitive result set data. It must have one of the following values: If set to -1, the driver caches all insensitive result set data in memory. If the size of the result set exceeds available memory, an OutOfMemoryException is generated. Because the need to write result set data to disk is eliminated, the driver processes the data more efficiently. If set to 0, the driver caches all insensitive result set data in memory, up to a maximum of 2 GB. If the size of the result set data exceeds available memory, the driver pages the result set data to disk. Because result set data may be written to disk, the driver may have to reformat the data to write it correctly to disk. If set to x, where x is a positive integer, the driver caches all insensitive result set data in memory, using this value to set the size (in KB) of the memory buffer for caching insensitive result set data. If the size of the result set data exceeds the buffer size, the driver pages the result set data to disk. Because the result set data may be written to disk, the driver may have to reformat the data to write it correctly to disk. Specifying a buffer size that is a power of 2 results in more efficient memory use. The default is 2048 (KB). |
NetAddress OPTIONAL | The Media Access Control (MAC) address of the network interface card of the application connecting to Microsoft SQL Server. The value of this property appears in the net_address column of the master.dbo.sysprocesses table and may be useful for database administration purposes. The default is 000000000000. |
Password | A case-insensitive password used to connect to your Microsoft SQL Server database. |
PortNumber OPTIONAL | The TCP port of the primary database server that is listening for connections to the Microsoft SQL Server database. The default is 1433. |
ProgramName OPTIONAL | The name of the application connecting to Microsoft SQL Server. The value of this property appears in the program_name column of the master.dbo.sysprocesses table and may be useful for database administration purposes. The default is an empty string. |
SelectMethod OPTIONAL | {direct | cursor}. A hint to the driver that determines whether the driver requests a database cursor for Select statements. Performance and behavior of the driver are affected by this property, which is defined as a hint because the driver may not always be able to satisfy the requested method.
The default is Direct. |
SendStringParametersAsUnicode OPTIONAL | {true | false}. Determines whether string parameters are sent to the Microsoft SQL Server database in Unicode or in the default character encoding of the database. If set to true, string parameters are sent to Microsoft SQL Server in Unicode. If set to false, string parameters are sent in the default encoding, which can improve performance because the server does not need to convert Unicode characters to the default encoding. You should, however, use default encoding only if the parameter string data you specify is the same as the default encoding of the database. The default is true. If a value is specified for the CodePageOverride property and this property is set to true, this property is ignored and a warning is generated. |
ServerName | Specifies either the IP address or the server name (if your network supports named servers) of the primary database server. For example, 122.23.15.12 or SQLServerServer. To connect to a named instance, specify server_name
instance_name for this property, where server_name is the IP address and instance_name is the name of the instance to which you want to connect on the specified server. |
User | The case-insensitive user name used to connect to your Microsoft SQL Server database. |
UseServerSideUpdatableCursors | {true | false}. Determines whether the driver uses server-side cursors when an updatable result set is requested. If set to true, server-side updatable cursors are created when an updatable result set is requested. If set to false, the default updatable result set functionality is used. The default is false. See Server-Side Updatable Cursors for more information about using server-side updatable cursors. |
WSID OPTIONAL | The workstation ID, which typically is the network name of the computer on which the application resides. If specified, this value is stored in the hostname column of the master.dbo.sysprocesses table and can be returned by sp_who and the Transact-SQL HOST_NAME function. The value can be useful for database administration purposes. The default is an empty string. |
XATransactionGroup OPTIONAL | The transaction group ID that identifies any transactions initiated by the connection. This ID can be used for distributed transaction cleanup purposes. |
SQL Server Data Type | JDBC Data Type |
---|---|
binary | BINARY |
bit | BIT |
char | CHAR |
datetime | TIMESTAMP |
DECIMAL | |
decimal() identity | DECIMAL |
float | FLOAT |
image | LONGVARBINARY |
int | INTEGER |
int identity | INTEGER |
money | DECIMAL |
nchar | CHAR |
ntext | LONGVARCHAR |
numeric | NUMERIC |
numeric() identity | NUMERIC |
nvarchar | VARCHAR |
real | REAL |
smalldatetime | TIMESTAMP |
smallint | SMALLINT |
smallint identity | SMALLINT |
smallmoney | DECIMAL |
sysname | VARCHAR |
text | LONGVARCHAR |
timestamp | BINARY |
tinyint | TINYINT |
tinyint identity | TINYINT |
uniqueidentifier | CHAR |
varbinary | VARBINARY |
varchar | VARCHAR |
SQL Server Data Type | JDBC Data Type |
---|---|
bigint | BIGINT |
bigint identity | BIGINT |
sql_variant | VARCHAR |
UseServerSideUpdatableCursors
property.UseServerSideUpdatableCursors
property is set to true and a scroll-insensitive updatable result set is requested, the driver downgrades the request to a scroll-insensitive read-only result set. Similarly, when a scroll-sensitive updatable result set is requested and the table does not contain a primary key, the driver downgrades the request to a scroll-sensitive read-only result set. In either case, a warning is generated.sqljdbc.dll
and instjdbc.sql
files from the WL_HOME
serverlib
directory to the SQL_Server_Root
/bin
directory of the MS SQL Server database server, where WL_HOME
is the directory in which WebLogic server is installed, typically c:beaweblogic81
.sqljdbc.dll
file. Therefore the sqljdbc.dll
file needs to be anywhere on the global PATH or on the application-specific path. For the application-specific path, place the sqljdbc.dll
file into the <drive>:Program FilesMicrosoft SQL ServerMSSQL$<Instance 1 Name>Binn
directory for each instance.instjdbc.sql
script. The system administrator should back up the master database before running instjdbc.sql
.instjdbc.sql
:instjdbc.sql
. (You copied this script to the SQL_Server_Root
/bin
directory in step 1.)instjdbc.sql
script generates many messages. In general, these messages can be ignored; however, the system administrator should scan the output for any messages that may indicate an execution error. The last message should indicate that instjdbc.sql
ran successfully. The script fails when there is insufficient space available in the master database to store the JDBC XA procedures or to log changes to existing procedures.INSERT INTO foo VALUES (?, ?, ?)
INSERT INTO foo (col1, col2, col3) VALUES (?, ?, ?)
UPDATE foo SET col1=?, col2=?, col3=? WHERE col1
operator
? [{AND | OR} col2
operator
?]
operator
is any of the following SQL operators: =
, <
, >
, <=
, >=
, and <>
.Statement.execute
and Statement.executeUpdate
methods to inform the driver to return the values of auto-generated keys: Statement.execute (String sql, int autoGeneratedKeys)
Statement.executeUpdate (String sql, int autoGeneratedKeys)
Connection.prepareStatement
method to inform the driver to return the values of auto-generated keys:Connection.prepareStatement (String sql, int autoGeneratedKeys)
Statement.getGeneratedKeys ()
method.