The functionality of the Java and C++ plug-ins differs in a number of ways. You should use the Java edition for performing administrative operations on Adaptive Server 12.5. The C++ version of the plug-in was included in the 12.5 version only to provide access to the Monitor Client GUI.
The Java plug-in contains support for all of the Adaptive Server 12.5.x features, including EJB Server, large page sizes, larger column lengths, Unicode datatypes, and the new Adaptive Server Replicator. The C++ version of the plug-in shipped with Adaptive Server 12.5 does not contain any of these functional enhancements.
Some features in the C++ version of the plug-in are not currently available in the Java version.
Table 7-1 provides a comparison of the main differences between the C++ and Java editions of the Adaptive Server plug-in.
Feature |
C++ |
Java |
|---|---|---|
Runs on all platforms |
No – runs only on Windows platforms. |
Yes |
Can start local server |
Yes – can start an Adaptive Server on the local machine. |
No |
SQL Monitor Client support |
Yes |
No |
CT-Lib interface to servers |
Yes – the C++ edition uses Client-Library, while the Java edition uses jConnect. Therefore, for example, interface parsing and directory services are not ‘native’ for the Java edition and behave differently from the C++ edition. |
No – The current Java version interfaces parser supports only a subset of all interfaces file syntax (for example, uses TLI format on all UNIX platforms). |
JConnect interface to servers |
No |
Yes |
Modeless dialogs |
No |
Yes |
Client side sorting |
No – uses server-side sorting. |
Yes – performs sorts in the client for improved performance. |
SQL history |
Yes |
Planned |
Editing of stored procedures and updating stored procedure definitions |
Yes |
Planned |
DDLGen |
No |
Yes |
Support for 12.5.0.1 features: large columns, multiple page sizes, Unicode datatypes, EJB Server, ASE Replicator |
No |
Yes |
Proxy table support |
Yes |
Yes – improved proxy table support features for version 12.5.0.1 and later. |
Login using LDAP directory services |
No |
Yes – from version 12.5.0.1 and later. |
