Connect-Star for JDBC - Revision history

Ekern: Ekern moved page Connect* for JDBC to Connect-Star for JDBC

2024-03-27T17:51:12Z

Ekern moved page Connect* for JDBC to Connect-Star for JDBC

← Older revision	Revision as of 17:51, 27 March 2024
(No difference)

Ekern at 17:50, 27 March 2024

2024-03-27T17:50:55Z

← Older revision		Revision as of 17:50, 27 March 2024
Line 1:		Line 1:
	{{DISPLAYTITLE: Connect~~<span class="superstar">★</span>~~ for JDBC}}		{{DISPLAYTITLE: Connect-Star for JDBC}}
	==Overview==		==Overview==
	Connect~~<span class="superstar">★</span>~~ for JDBC is a type 4 Java driver for the Java environment.		Connect-Star for JDBC is a type 4 Java driver for the Java environment.

	Connect~~<span class="superstar">★</span>~~ for JDBC supports Connect~~<span class="superstar">★</span>~~ functionality to access Model 204. It includes all SQL and RCL statement syntax.		Connect-Star for JDBC supports Connect-Star functionality to access Model 204. It includes all SQL and RCL statement syntax.

	See [[Model 204 documentation]] for related Model 204 documentation.		See [[Model 204 documentation]] for related Model 204 documentation.

	==Connect~~<span class="superstar">★</span>~~ for JDBC environment setup==		==Connect-Star for JDBC environment setup==

	===Limitations and specifications===		===Limitations and specifications===

	====Limitations====		====Limitations====
	A complete listing of the Connect~~<span class="superstar">★</span>~~ for JDBC limitations is provided in the Help File on the API, which you can access from the Start menu with your Connect Star for Model 204 JDBC application.		A complete listing of the Connect-Star for JDBC limitations is provided in the Help File on the API, which you can access from the Start menu with your Connect Star for Model 204 JDBC application.

	====JDBC API specifications====		====JDBC API specifications====
Line 18:		Line 18:

	===Platforms tested===		===Platforms tested===
	The following platforms have been tested successfully for connectivity with Model 204 using Connect~~<span class="superstar">★</span>~~ for JDBC:		The following platforms have been tested successfully for connectivity with Model 204 using Connect-Star for JDBC:
	<ul>		<ul>
	<li>Microsoft<sup>®</sup> Windows<sup>®</sup> 7, Windows 8.1, and Windows 10</li>		<li>Microsoft<sup>®</sup> Windows<sup>®</sup> 7, Windows 8.1, and Windows 10</li>
Line 27:		Line 27:

	===Environment requirements===		===Environment requirements===
	Before you install Connect~~<span class="superstar">★</span>~~ for JDBC you must have the following installed in your working environment:		Before you install Connect-Star for JDBC you must have the following installed in your working environment:
	<ul>		<ul>
	<li>Java Runtime 32-bit JRE (minimum version 1.6)</li>		<li>Java Runtime 32-bit JRE (minimum version 1.6)</li>
Line 33:		Line 33:
	</ul>		</ul>

	===<b id="remove Connect* JDBC"></b>Removing a previous version of Connect~~<span class="superstar">★</span>~~ for JDBC===		===<b id="remove Connect* JDBC"></b>Removing a previous version of Connect-Star for JDBC===
	To remove a previous version of Connect~~<span class="superstar">★</span>~~ for JDBC, do the following:		To remove a previous version of Connect-Star for JDBC, do the following:
	<ol>		<ol>
	<li>Go to the Control Panel > Add/Remove Programs.</li>		<li>Go to the Control Panel > Add/Remove Programs.</li>
Line 41:		Line 41:
	</ol>		</ol>

	==Installing Connect~~<span class="superstar">★</span>~~ for JDBC==		==Installing Connect-Star for JDBC==
	<ol>		<ol>
	<li>Ensure that you have fulfilled the preinstallation requirements as described in [[Connect* installation requirements#Preparing to install\|Preparing to install]].</li>		<li>Ensure that you have fulfilled the preinstallation requirements as described in [[Connect* installation requirements#Preparing to install\|Preparing to install]].</li>
Line 47:		Line 47:
	<li>Click the <b>Download client (workstation) files</b> link to go to the [https://m204.rocketsoftware.com/maint/cllist Client files for Rocket Software page]. </li>		<li>Click the <b>Download client (workstation) files</b> link to go to the [https://m204.rocketsoftware.com/maint/cllist Client files for Rocket Software page]. </li>

	<li>The Connect~~<span class="superstar">★</span>~~ drivers are available in zip format. Click the <b>Download ZIP file</b> link for the Connect~~<span class="superstar">★</span>~~ drivers.</li>		<li>The Connect-Star drivers are available in zip format. Click the <b>Download ZIP file</b> link for the Connect-Star drivers.</li>
	<li>		<li>
	Click <b>Save as</b> to save the cstar.zip file in your preferred directory. (You will later be prompted for the directory where you want to actually install Connect~~<span class="superstar">★</span>~~.)		Click <b>Save as</b> to save the cstar.zip file in your preferred directory. (You will later be prompted for the directory where you want to actually install Connect-Star.)
	</li>		</li>
	<li>		<li>
Line 195:		Line 195:
	<p class="figure">[[File:CStar_4-1_JDBC_DB_con.jpg]] </p>		<p class="figure">[[File:CStar_4-1_JDBC_DB_con.jpg]] </p>

	==Connect~~<span class="superstar">★</span>~~ for JDBC Compilation and Execution==		==Connect-Star for JDBC Compilation and Execution==

	===Execution prerequisite===		===Execution prerequisite===

	Before executing an SQL statement, check with your Connect~~<span class="superstar">★</span>~~ administrator to make sure that either the demonstration database is installed and has been defined to the SQL catalog file, CCACAT, or you have other available tables defined in CCACAT. (See [[Connect* to Model 204 connection#SQL catalog population\|SQL catalog population]].)		Before executing an SQL statement, check with your Connect-Star administrator to make sure that either the demonstration database is installed and has been defined to the SQL catalog file, CCACAT, or you have other available tables defined in CCACAT. (See [[Connect* to Model 204 connection#SQL catalog population\|SQL catalog population]].)

	===Online help===		===Online help===

	Connect~~<span class="superstar">★</span>~~ for JDBC includes a Help File that provides complete documentation of the J204 JDBC driver classes. To access the Help File, open Connect~~<span class="superstar">★</span>~~ for JDBC from the Start menu.		Connect-Star for JDBC includes a Help File that provides complete documentation of the J204 JDBC driver classes. To access the Help File, open Connect-Star for JDBC from the Start menu.

	===RCL and JDBC===		===RCL and JDBC===

	Java CallableStatements provide a means of calling stored procedures. Model 204 SQL does not support stored procedures; therefore, Connect~~<span class="superstar">★</span>~~ for JDBC does not implement the CallableStatement interface.		Java CallableStatements provide a means of calling stored procedures. Model 204 SQL does not support stored procedures; therefore, Connect-Star for JDBC does not implement the CallableStatement interface.

	Calling any CallableStatement method will result in an Unsupported Method SQLException.		Calling any CallableStatement method will result in an Unsupported Method SQLException.
Line 223:		Line 223:
	===BLOB and CLOB support===		===BLOB and CLOB support===

	Connect~~<span class="superstar">★</span>~~ for JDBC supports Model 204 BLOB and CLOB data types in SQL update and retrieval statements.		Connect-Star for JDBC supports Model 204 BLOB and CLOB data types in SQL update and retrieval statements.

	Use the following ResultSet methods to retrieve large object column data after SELECT statement execution.		Use the following ResultSet methods to retrieve large object column data after SELECT statement execution.
Line 278:		Line 278:
	==Connection pooling==		==Connection pooling==

	Connect~~<span class="superstar">★</span>~~ version 7.5 and higher for JDBC offers a "connection pooling" class to interface with other pooling infrastructures provided by pooling packages and web application servers. This new feature allows for a pool of connections that remain active and open during execution of an SQL and RCL (SOUL) statement.		Connect-Star version 7.5 and higher for JDBC offers a "connection pooling" class to interface with other pooling infrastructures provided by pooling packages and web application servers. This new feature allows for a pool of connections that remain active and open during execution of an SQL and RCL (SOUL) statement.

	Using connection pooling helps eliminate the overhead of creating initial connections from scratch or trying to manage each connection using the JDBC API.		Using connection pooling helps eliminate the overhead of creating initial connections from scratch or trying to manage each connection using the JDBC API.
Line 284:		Line 284:
	Each Connection Pool can create a pool of active connections maintainable throughout the connection cycle of the pooling service.		Each Connection Pool can create a pool of active connections maintainable throughout the connection cycle of the pooling service.

	Connect~~<span class="superstar">★</span>~~ version 7.5 and higher for JDBC has been tested with the JNDI, Apache DBCP<sup>TM</sup>, BoneCP, and C3PO pooling packages.		Connect-Star version 7.5 and higher for JDBC has been tested with the JNDI, Apache DBCP<sup>TM</sup>, BoneCP, and C3PO pooling packages.

	===Connection pooling example===		===Connection pooling example===

JAL: restore ★

2017-08-11T18:26:13Z

restore <span class="superstar">★</span>

← Older revision		Revision as of 18:26, 11 August 2017
Line 7:		Line 7:
	See [[Model 204 documentation]] for related Model 204 documentation.		See [[Model 204 documentation]] for related Model 204 documentation.

	==Connect<~~sup~~>★</~~sup~~> for JDBC environment setup==		==Connect<span class="superstar">★</span> for JDBC environment setup==

	===Limitations and specifications===		===Limitations and specifications===
Line 32:		Line 32:
	<li>Model 204 Online, version 7.4 or higher with TCP/IP and SQL. </li>		<li>Model 204 Online, version 7.4 or higher with TCP/IP and SQL. </li>
	</ul>		</ul>
	~~<div id="remove Connect* JDBC"></div>~~

	===Removing a previous version of Connect<~~sup~~>★</~~sup~~> for JDBC===		===<b id="remove Connect* JDBC"></b>Removing a previous version of Connect<span class="superstar">★</span> for JDBC===
	~~<!-- Note: div above -->~~
	To remove a previous version of Connect<span class="superstar">★</span> for JDBC, do the following:		To remove a previous version of Connect<span class="superstar">★</span> for JDBC, do the following:
	<ol>		<ol>
Line 43:		Line 41:
	</ol>		</ol>

	==Installing Connect<~~sup~~>★</~~sup~~> for JDBC==		==Installing Connect<span class="superstar">★</span> for JDBC==
	<ol>		<ol>
	<li>Ensure that you have fulfilled the preinstallation requirements as described in [[Connect* installation requirements#Preparing to install\|Preparing to install]].</li>		<li>Ensure that you have fulfilled the preinstallation requirements as described in [[Connect* installation requirements#Preparing to install\|Preparing to install]].</li>
	<li>With your [[Rocket M204 user ID]] and password handy, go to the [https://model204.rocketsoftware.com Rocket M204 Customer Care page].</li>		<li>With your [[Rocket M204 user ID]] and password handy, go to the [https://model204.rocketsoftware.com Rocket M204 Customer Care page].</li>
	<li>Click the <b>Download client (workstation) files</b> link to go to the [https://m204.rocketsoftware.com/maint/cllist Client files for Rocket Software page]. </li>		<li>Click the <b>Download client (workstation) files</b> link to go to the [https://m204.rocketsoftware.com/maint/cllist Client files for Rocket Software page]. </li>
	<li>
	The Connect<span class="superstar">★</span> drivers are available in zip format. Click the <b>Download ZIP file</b> link for the Connect<span class="superstar">★</span> drivers.</li>		<li>The Connect<span class="superstar">★</span> drivers are available in zip format. Click the <b>Download ZIP file</b> link for the Connect<span class="superstar">★</span> drivers.</li>
	<li>		<li>
	Click <b>Save as</b> to save the cstar.zip file in your preferred directory. (You will later be prompted for the directory where you want to actually install Connect<span class="superstar">★</span>.)		Click <b>Save as</b> to save the cstar.zip file in your preferred directory. (You will later be prompted for the directory where you want to actually install Connect<span class="superstar">★</span>.)
Line 135:		Line 133:
	<th>Specifies</th>		<th>Specifies</th>
	</tr>		</tr>

	<tr>		<tr>
	<td>RC, the default</td>		<td>RC, the default</td>
	<td>Read Committed (cursor stability)</td>		<td>Read Committed (cursor stability)</td>
	</tr>		</tr>

	<tr>		<tr>
	<td>RU</td>		<td>RU</td>
	<td>Read Uncommitted (dirty read)</td>		<td>Read Uncommitted (dirty read)</td>
	</tr>		</tr>

	<tr>		<tr>
	<td>SR</td>		<td>SR</td>
Line 150:		Line 151:
	<p>Properties key: isolation level</p>		<p>Properties key: isolation level</p>
	</li>		</li>

	<li>		<li>
	The <var>trace</var> parameter controls logging. The <var class="term">trace_option</var> is one of the following:		The <var>trace</var> parameter controls logging. The <var class="term">trace_option</var> is one of the following:
Line 193:		Line 195:
	<p class="figure">[[File:CStar_4-1_JDBC_DB_con.jpg]] </p>		<p class="figure">[[File:CStar_4-1_JDBC_DB_con.jpg]] </p>

	==Connect<~~sup~~>★</~~sup~~> for JDBC Compilation and Execution==		==Connect<span class="superstar">★</span> for JDBC Compilation and Execution==

	===Execution prerequisite===		===Execution prerequisite===

ELowell: /* Limitations */

2017-01-31T01:22:21Z

Limitations

← Older revision		Revision as of 01:22, 31 January 2017
Line 12:		Line 12:

	====Limitations====		====Limitations====
	A complete listing of the Connect<span class="superstar">★</span> for JDBC limitations is provided in the Connect Star for Model 204 ~~program group under the~~ JDBC ~~> J204 API~~.		A complete listing of the Connect<span class="superstar">★</span> for JDBC limitations is provided in the Help File on the API, which you can access from the Start menu with your Connect Star for Model 204 JDBC application.

	====JDBC API specifications====		====JDBC API specifications====

ELowell: /* Verifying your JDBC connection */

2017-01-31T01:05:03Z

Verifying your JDBC connection

← Older revision		Revision as of 01:05, 31 January 2017
Line 187:		Line 187:
	<ol>		<ol>
	<li>		<li>
	~~Navigate~~ to ~~Start > All Programs >~~ Connect Star for Model 204 > JDBC > Database Connector for JDBC.</li>		From the Start menu, navigate to the Connect Star for Model 204 JDBC application and open the Database Connector for JDBC.</li>
	<li>		<li>
	Complete the Connection Information screen and click the Test Connection button.</li>		Complete the Connection Information screen and click the Test Connection button.</li>

ELowell: /* Installing Connect★ for JDBC */

2017-01-31T01:00:16Z

Installing Connect★ for JDBC

← Older revision		Revision as of 01:00, 31 January 2017
Line 46:		Line 46:
	<ol>		<ol>
	<li>Ensure that you have fulfilled the preinstallation requirements as described in [[Connect* installation requirements#Preparing to install\|Preparing to install]].</li>		<li>Ensure that you have fulfilled the preinstallation requirements as described in [[Connect* installation requirements#Preparing to install\|Preparing to install]].</li>
	<li>~~Using~~ your [[Rocket M204 user ID]] and password, ~~log in~~ to the [https://model204.rocketsoftware.com Rocket M204 Customer Care page].</li>		<li>With your [[Rocket M204 user ID]] and password handy, go to the [https://model204.rocketsoftware.com Rocket M204 Customer Care page].</li>
	<li>Click the <b>Download client (workstation) files</b> link to go to the [https://m204.rocketsoftware.com/maint/cllist Client files for Rocket Software page]. </li>		<li>Click the <b>Download client (workstation) files</b> link to go to the [https://m204.rocketsoftware.com/maint/cllist Client files for Rocket Software page]. </li>
	<li>		<li>

ELowell: /* Environment requirements */

2017-01-20T19:46:05Z

Environment requirements

← Older revision		Revision as of 19:46, 20 January 2017
Line 29:		Line 29:
	Before you install Connect<span class="superstar">★</span> for JDBC you must have the following installed in your working environment:		Before you install Connect<span class="superstar">★</span> for JDBC you must have the following installed in your working environment:
	<ul>		<ul>
	<li>Java ~~SE Development Kit~~ (~~JDK~~) ~~7.0 or higher.~~ </li>		<li>Java Runtime 32-bit JRE (minimum version 1.6)</li>
	<li>Model 204 Online, version 7.4 or higher with TCP/IP and SQL. </li>		<li>Model 204 Online, version 7.4 or higher with TCP/IP and SQL. </li>
	</ul>		</ul>

ELowell at 20:45, 19 January 2017

2017-01-19T20:45:31Z

← Older revision		Revision as of 20:45, 19 January 2017
Line 49:		Line 49:
	<li>Click the <b>Download client (workstation) files</b> link to go to the [https://m204.rocketsoftware.com/maint/cllist Client files for Rocket Software page]. </li>		<li>Click the <b>Download client (workstation) files</b> link to go to the [https://m204.rocketsoftware.com/maint/cllist Client files for Rocket Software page]. </li>
	<li>		<li>
	The Connect* drivers are available in zip format. Click the <b>Download ZIP file</b> link for the Connect* drivers.</li>		The Connect<span class="superstar">★</span> drivers are available in zip format. Click the <b>Download ZIP file</b> link for the Connect<span class="superstar">★</span> drivers.</li>
	<li>		<li>
	Click <b>Save as</b> to save the cstar.zip file in your preferred directory. (You will later be prompted for the directory where you want to actually install Connect*.)		Click <b>Save as</b> to save the cstar.zip file in your preferred directory. (You will later be prompted for the directory where you want to actually install Connect<span class="superstar">★</span>.)
	</li>		</li>
	<li>		<li>

ELowell: /* Online help */

2017-01-18T23:47:11Z

Online help

← Older revision		Revision as of 23:47, 18 January 2017
Line 201:		Line 201:
	===Online help===		===Online help===

	Connect<span class="superstar">★</span> for JDBC includes ~~HTML help files~~ that ~~provide~~ complete documentation of the J204 JDBC driver. ~~For detailed documentation~~, ~~browse~~ the ~~index.html file in the \javadoc directory where the driver is installed~~.		Connect<span class="superstar">★</span> for JDBC includes a Help File that provides complete documentation of the J204 JDBC driver classes. To access the Help File, open Connect<span class="superstar">★</span> for JDBC from the Start menu.

	===RCL and JDBC===		===RCL and JDBC===

ELowell: /* Connection pooling example */

2017-01-18T23:37:20Z

Connection pooling example

← Older revision		Revision as of 23:37, 18 January 2017
Line 286:		Line 286:
	===Connection pooling example===		===Connection pooling example===

	Below is an example of pooling connections using the [http://commons.apache.org/proper/commons-dbcp/ Apache Commons DBCP<sup>TM</sup>] component. ~~<br />There are other examples provided in the install directory of Connect<span class="superstar">★</span> for JDBC:~~		Below is an example of pooling connections using the [http://commons.apache.org/proper/commons-dbcp/ Apache Commons DBCP<sup>TM</sup>] component.
	<p class="code"><nowiki>/**		<p class="code"><nowiki>/**
	* Example: Pooling Connection program using Apache DBCP (Database Connection		* Example: Pooling Connection program using Apache DBCP (Database Connection