JComponents1600.jar not found running dbisql on Sybase 16

[Former Member]

After building a limited Sybase 16.0.0.1761 deployment with FIPS, ODBC and ISQL, when we call dbisql it will not run but reports the error "This file could not be found: JComponents1600.jar"

[Former Member]

The files required for deployment of the Java base DBISQL Admin tool are documented in Step 2 of the section on "Administration tool deployment on Windows" [1] and of all the files listed under our ".Java" directory only "JavaJComponents1600.jar" seems to be missing from said MSI.

I will report this shortly so it can be addressed in a future Service Pack (EBF).

In the meantime, I will investigate to see if another combination will work in the mean time.

[Former Member]

This has been reported to Product Engineering under the tracking# 760153.

This appears to be an oversight. JComponents1600.jar is required to Sybase Central, as well as DBIsql, DBConsole, and the MobiLink Profiler but is currently only included when Sybase Central is selected.

Currently you options for workarounds would included: - manually adding/copying that component (it seems to be the only req'd one missing from the Java directory) - include Sybase Central in your MSI - somehow modify the produced .MSI / .MSM or custom installer to include it (if you are building a custom installer this may be easier to do)

[jeff_albion]

In addition to Nick's notes, you can also manually edit the %SQLANY16%\\Deployment\\master.xml file immediately to include this component reference:

1. Find the line:

   <feature id="ISQL64" deploy64="true" name="ISQL (64-bit)" name_de="ISQL (64 Bit)" name_fr="ISQL (64 bits)" name_ja="ISQL (64 ビット)" name_zh="ISQL (64 位)">

2. Add the following line right below it:

   <include id="JComponents" />
   

3. Find the line:

   <feature id="MLPROF64" deploy64="true" name="MobiLink Profiler (64-bit)" name_de="MobiLink-Profiler (64 Bit)" name_fr="Profileur MobiLink (64 bits)" name_ja="Mobile Link プロファイラ (64 ビット)" name_zh="MobiLink 分析器(64 位)">

4. Add the following line right below it:

   <include id="JComponents" />

5. Find the line:

   <feature id="SACON64" deploy64="true" name="SQL Anywhere Console (64-bit)" name_de="SQL Anywhere-Konsole (64 Bit)" name_fr="Console SQL Anywhere (64 bits)" name_ja="SQL Anywhere コンソール (64 ビット)" name_zh="SQL Anywhere 控制台（64 位）">

6. Add the following line right below it:

   <include id="JComponents" />

7. Find the line:

   <feature id="ISQL" name="ISQL (32-bit)" name_de="ISQL (32 Bit)" name_fr="ISQL (32 bits)" name_ja="ISQL (32 ビット)" name_zh="ISQL (32 位)">

8. Add the following line right below it:

   <include id="JComponents" />

9. Find the line:

   <feature id="MLPROF" name="MobiLink Profiler (32-bit)" name_de="MobiLink-Profiler (32 Bit)" name_fr="Profileur MobiLink (32 bits)" name_ja="Mobile Link プロファイラ (32 ビット)" name_zh="MobiLink 分析器(32 位)">

10. Add the following text right below it:

    <include id="JComponents" />

11. Find the line:

    <feature id="SACON" name="SQL Anywhere Console (32-bit)" name_de="SQL Anywhere-Konsole (32 Bit)" name_fr="Console SQL Anywhere (32 bits)" name_ja="SQL Anywhere コンソール (32 ビット)" name_zh="SQL Anywhere 控制台（32 位）">

12. Add the following text right below it:

    <include id="JComponents" />