This topic provides:
To create a Microsft SQL JDBC (i-net Driver) database service endpoint:
Access the Service
Endpoints | Add Service Endpoint | Edit Service Endpoint endpoint_name
page for the SQL Database type and MsSQL JDBC (i-net Driver) subtype.
For access instructions, see Creating
a Service Endpoint.
Enter the properties for the service endpoint:
Host - The host server where the database application resides.
Port - The port number where the database will be listening.
Database - The name of the database that will be created.
Use Cursors always - Check this option if you want to enable the useCursorsAlways property of the driver.
User - The administrator name that will be created to access the database.
Password - The user's password to access the database.
Configure the following Runtime options for the service endpoint or accept the defaults:
Maximum Pool Size - Enter the maximum number of connections that the pool can allocate. The pool will never create more connections than this limit imposes. The default is 10.
Connection Idle Time (Mins) - Enter the amount of time the database connection can remain idle before the connection will be dropped. The default is 5 minutes.
Maximum Opened Cursors - Enter the maximum number of opened cursors allowed on the database. The default is 50. This value is related to the maximum pool size. The number of cursors is divided in between the number of maximum pool size and each connection will manage that number of cursors. For example, if you have 500 maximum opened cursors and the maximum pool size is 50, each connection can have a maximum of 10 opened cursors.
Click Save.
Note: Default values may not be appropriate for your database. You should review and override with values suitable for the database.
If you get the exception below, uncheck the Use Cursors Always property.
ClassCastException and SQLException: No result sets were produced by 'SELECT...':