Upgrading databases for jConnect for Jdbc

CHAPTER 1 Installing PowerBuilder Enterprise

Upgrading databases for jConnect for JDBC

If you plan to use any of the products in PowerBuilder Enterprise with SQL Anywhere or Adaptive Server® Enterprise databases, including databases that were previously prepared for jConnect™ for JDBC™ 4.x, you need to prepare the databases for jConnect 5.5 by installing additional tables and stored procedures. You must repeat the following steps for every SQL Anywhere or Adaptive Server Enterprise database that you want to prepare for jConnect.

❖To prepare a SQL Anywhere or Adaptive Server database for jConnect 5.5:

1 Start Interactive SQL and connect to your database.

2Select File>Open and locate the appropriate SQL file stored in the jConnect-5_5\spfolder.

jConnect is installed in the Sybase\Shared folder. Use sql_SA.sql for SQL Anywhere, sql_server12.5.sql for Adaptive Server version 12.5 or later, sql_server12.sql for Adaptive Server version 12, or sql_server.sql for earlier versions of Adaptive Server.

3Click the Execute button.

Installing the PBVM in EAServer or the Application Server Plug-in

If you plan to deploy PowerBuilder 11.5 components to EAServer or to the PowerBuilder Application Server Plug-in running in a third party application server, a set of PowerBuilder 11.5 runtime files called the PowerBuilder virtual machine (PBVM) must be installed on the same computer as EAServer or the plug-in. The PBVM setup program, available in the PBVM directory on the DVD, installs the required files.

Installing HTMLGenerator115 and PBDebugBroker115

For EAServer 5.x, the PBVM setup program also installs the PowerBuilder

11.5version of the Web DataWindow server component (HTMLGenerator115) and the PBDebugBroker115 component that are required for remote debugging. Although the setup program copies these components to EAServer 6.x servers or to the Application Server Plug-in, the copied components do not work properly. However, you can use the EAServer setup program to install these components with the 6.2 version of EAServer.

Installation Guide