![]() |
Accessing Cloudconnector from a Client
|
|
Using Cloudconnector ClientsCloudconnector supplies a tailored JDBC driver and database connection URL for use by clients. To access the Cloudconnector server, the client must specify the JDBC Driver and the database connection URL.
NOTE: The Cloudscape Developer's Guide documents the database connection URL for using Cloudscape as an embedded database. Specifying the Client JDBC DriverDepending on whether you are connecting programmatically or from a Cloudscape tool, use one of the following to specify the JDBC driver: ProgrammaticallyIn client code, specify the client JDBC driver for connecting to a Cloudscape server: Class.forName("COM.cloudscape.core.WebLogicDriver").newInstance(); From ij or CloudviewIf using ij or Cloudview, specify the drivers system property when starting up the tool. For example: java -Djdbc.drivers=COM.cloudscape.core.WebLogicDriver COM.cloudscape.tools.cview java -Djdbc.drivers=COM.cloudscape.core.WebLogicDriver COM.cloudscape.tools.ij Specifying the Database Connection URLAfter you have specified the JDBC driver, you connect to the database using a database connection URL. A Cloudscape client to Cloudconnector uses the following database connection URL: jdbc:cloudscape:weblogic[- ssl]:[ //hostname:portnum/] (All of this is one string; the new lines above just make the URL readable.)
Example URLsHere are some example database connection URLs for Cloudscape clients:
NOTE: Typically, client applications should not use the ;shutdown=true form of the database connection URL in client/server environments. The system administrator should use the provided utility to shut down Cloudconnector. See Shutting Down Cloudconnector. Setting Session-Level WebLogic Properties on the URLWebLogic properties can be set durably for a system using the weblogic.properties file. The weblogic.properties file is discussed in the Setting Cloudconnector Properties section of chapter 7. This section discusses temporary, session-level WebLogic properties, which are specified by including them in the client database connection URL. Setting WebLogic properties on a connection URL makes them valid only for the duration of the current connection. The following sections describe two properties you might want to set for a client session: Turning off Prefetching and CachingTo improve performance, Cloudconnector provides server-side prefetching and client-side caching of rows. However, prefetching and caching can cause the following behavior:
If you need more control over result set behavior or want to use the positioned update and delete statements (cursors), set the following property value, which disables both prefetching and caching: weblogic.t3.cacheRows=0 Turning off the Parameter CacheIf you issue PreparedStatement clearParameters requests and need to ensure that statements are not executed until all parameters are reset, set the following property value: |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |