ｊConnect5.5をASEで使えるようにする　〜RedHat 6.2〜

ｊConnect5.5をASEで使えるようにする

〜RedHat 6.2〜

０．更新履歴

2002.04.16　新規作成

１．はじめに

　このドキュメントでは，RedHat Linux 6.2上で，jConnect5.5を使う手順を示す．

　実際の環境では，ASE11.9.2.6上で設定を行ったが，ASEの他バージョンや，OSが違っても基本的に利用できるように汎用的にドキュメントを作成した．（つもり）

　なお，このドキュメントでの設定は，DBサーバ，アプリケーションサーバ（クライアント？）共に同じであるが，一部，サーバだけ実施する処理もある．（章のタイトルに書いてある）

２．前提

あらかじめ，JDKが入っていなければならない．
- RedHat LinuxにJDKを入れる

３．jConnect5.5の入手

U.S.のSybaseから，ｊConnectをダウンロードする．
- http://www.sybase.com/download
なお，ダウンロードするためには，ユーザ情報を入力する必要がある．
今回入手したのは，次のようなモジュール．

jConnect5.5	EBF10000が適用されたもの．
jConnect EBF	EBF10106のファイル．

入手する時期によって，多分内容が違うようである．

４．入手ファイルをテンポラリの場所に置いて中身を確認する

sybaseユーザでログインし，テンポラリのディレクトリを作成する．

bash$ cd $SYBASE
bash$ mkdir jCon55
bash$ cd jCon55
bash$

ｊCon55ディレクトリに，前出のサイトで取得したファイルを置く．
そのファイルを確認する．

bash$ ls -la
total 8196
drwxrwxr-x    2 sybase   sybase       4096 Apr 16 16:35 .
drwxrwxr-x   23 sybase   sybase       4096 Apr 16 16:34 ..
-rw-rw-r--    1 sybase   sybase    6124826 Apr 16 16:35 EBF10106.tgz
-rw-rw-r--    1 sybase   sybase      41971 Apr 16 16:35 EBF10106.txt
-rw-rw-r--    1 sybase   sybase    2193608 Apr 16 16:34 jconnect55.zip
bash$

５．jConnect5.5をインストールする

jconnect55.zipを展開する．

bash$ unzip jconnect55.zip
Archive:  jconnect55.zip
   creating: jConnect-5_5/
   creating: jConnect-5_5/classes/
  inflating: jConnect-5_5/classes/Isql.class
  inflating: jConnect-5_5/classes/IsqlApp.class
  inflating: jConnect-5_5/classes/jconn2.jar
   creating: jConnect-5_5/classes/gateway2/
  inflating: jConnect-5_5/classes/gateway2/FixedSession.class
  inflating: jConnect-5_5/classes/gateway2/TDSTunnelServlet.class
  inflating: jConnect-5_5/classes/gateway2/TdsSession.class
  inflating: jConnect-5_5/classes/gateway2/TdsSessionManager.class
   creating: jConnect-5_5/classes/sample2/
  inflating: jConnect-5_5/classes/sample2/Callable.class
  inflating: jConnect-5_5/classes/sample2/CommandLine.class
  inflating: jConnect-5_5/classes/sample2/Ping.class
  inflating: jConnect-5_5/classes/sample2/Prepare.class
  inflating: jConnect-5_5/classes/sample2/SimpleSelect.class
  inflating: jConnect-5_5/classes/sample2/Validate.class
  inflating: jConnect-5_5/classes/sample2/Version.class
  inflating: jConnect-5_5/classes/sample2/Address.class
  inflating: jConnect-5_5/classes/sample2/AddressSubclass.class
  inflating: jConnect-5_5/classes/sample2/AsciiStream.class
  inflating: jConnect-5_5/classes/sample2/AsciiToUniFileInputStream.class
  inflating: jConnect-5_5/classes/sample2/AutoCommit.class
  inflating: jConnect-5_5/classes/sample2/BinaryStream.class
  inflating: jConnect-5_5/classes/sample2/DBMetadata.class
  inflating: jConnect-5_5/classes/sample2/Debugexample.class
  inflating: jConnect-5_5/classes/sample2/DriverMgr.class
  inflating: jConnect-5_5/classes/sample2/Escape.class
  inflating: jConnect-5_5/classes/sample2/EventHandler.class
  inflating: jConnect-5_5/classes/sample2/EventHandler$MyEventHandler.class
  inflating: jConnect-5_5/classes/sample2/Execute.class
  inflating: jConnect-5_5/classes/sample2/ExecuteQuery.class
  inflating: jConnect-5_5/classes/sample2/ExecuteUpdate.class
  inflating: jConnect-5_5/classes/sample2/GetObject.class
  inflating: jConnect-5_5/classes/sample2/JdbcDriver.class
  inflating: jConnect-5_5/classes/sample2/MessageHandler.class
  inflating: jConnect-5_5/classes/sample2/MessageHandler$ConnectionMsgHandler.cl
ass
  inflating: jConnect-5_5/classes/sample2/MessageHandler$StatementMsgHandler.cla
ss
  inflating: jConnect-5_5/classes/sample2/MyCallable.class
  inflating: jConnect-5_5/classes/sample2/MyConnection.class
  inflating: jConnect-5_5/classes/sample2/MyDriver.class
  inflating: jConnect-5_5/classes/sample2/MyPrepare.class
  inflating: jConnect-5_5/classes/sample2/MyResultSet.class
  inflating: jConnect-5_5/classes/sample2/NameBindRPC.class
  inflating: jConnect-5_5/classes/sample2/Printexample.class
  inflating: jConnect-5_5/classes/sample2/RSMetadata.class
  inflating: jConnect-5_5/classes/sample2/Raiserror.class
  inflating: jConnect-5_5/classes/sample2/ReadCursor.class
  inflating: jConnect-5_5/classes/sample2/Sample.class
  inflating: jConnect-5_5/classes/sample2/SetObject.class
  inflating: jConnect-5_5/classes/sample2/SunIoConverter.class
  inflating: jConnect-5_5/classes/sample2/SybSample.class
  inflating: jConnect-5_5/classes/sample2/InfoDialog.class
  inflating: jConnect-5_5/classes/sample2/SybSampleApplet.class
  inflating: jConnect-5_5/classes/sample2/SybTimestamp.class
  inflating: jConnect-5_5/classes/sample2/UnicodeStream.class
  inflating: jConnect-5_5/classes/sample2/UpdateCursor.class
  inflating: jConnect-5_5/classes/sample2/TextPointers.class
  inflating: jConnect-5_5/classes/sample2/ImageFrames.class
  inflating: jConnect-5_5/classes/sample2/DataRow.class
  inflating: jConnect-5_5/classes/sample2/DataRowCache.class
  inflating: jConnect-5_5/classes/sample2/Encrypt.class
  inflating: jConnect-5_5/classes/sample2/ExtendedResultSet.class
  inflating: jConnect-5_5/classes/sample2/HandleObject.class
  inflating: jConnect-5_5/classes/sample2/MySSLSocketFactory.class
  inflating: jConnect-5_5/classes/sample2/SQLValue.class
  inflating: jConnect-5_5/classes/sample2/ScrollableResultSet.class
  inflating: jConnect-5_5/classes/sample2/SimpleRowCache.class
  inflating: jConnect-5_5/classes/sample2/SybEedInfo.class
  inflating: jConnect-5_5/classes/sample2/BatchUpdates.class
  inflating: jConnect-5_5/classes/sample2/ScrollableSample.class
  inflating: jConnect-5_5/classes/sample2/ClassLoaderSample.class
  inflating: jConnect-5_5/classes/sample2/SimpleDataSource.class
  inflating: jConnect-5_5/classes/sample2/SimpleConnectionPool.class
  inflating: jConnect-5_5/classes/sample2/Person.class
  inflating: jConnect-5_5/classes/sample2/Employee.class
  inflating: jConnect-5_5/classes/sample2/PreLoadSample.class
  inflating: jConnect-5_5/classes/sample2/LoaderSample.class
  inflating: jConnect-5_5/classes/sample2/SybPrepExtension.class
   creating: jConnect-5_5/gateway2/
  inflating: jConnect-5_5/gateway2/FixedSession.java
  inflating: jConnect-5_5/gateway2/TDSTunnelServlet.java
   creating: jConnect-5_5/sp/
  inflating: jConnect-5_5/sp/sql_asa.sql
  inflating: jConnect-5_5/sp/sql_server.sql
  inflating: jConnect-5_5/sp/sql_server12.sql
  inflating: jConnect-5_5/sp/sql_server12.5.sql
   creating: jConnect-5_5/tools/
  inflating: jConnect-5_5/tools/decode-tli
  inflating: jConnect-5_5/index.html
  inflating: jConnect-5_5/netimpct.gif
  inflating: jConnect-5_5/version.txt
   creating: jConnect-5_5/devclasses/
  inflating: jConnect-5_5/devclasses/jconn2d.jar
   creating: jConnect-5_5/sample2/
  inflating: jConnect-5_5/sample2/Person.java
  inflating: jConnect-5_5/sample2/Employee.java
  inflating: jConnect-5_5/sample2/LoaderSample.java
  inflating: jConnect-5_5/sample2/PreLoadSample.java
  inflating: jConnect-5_5/sample2/IsqlApp.java
  inflating: jConnect-5_5/sample2/Callable.java
  inflating: jConnect-5_5/sample2/CommandLine.java
  inflating: jConnect-5_5/sample2/Ping.java
  inflating: jConnect-5_5/sample2/Prepare.java
  inflating: jConnect-5_5/sample2/SimpleSelect.java
  inflating: jConnect-5_5/sample2/Validate.java
  inflating: jConnect-5_5/sample2/Version.java
  inflating: jConnect-5_5/sample2/gateway.html
  inflating: jConnect-5_5/sample2/AsciiStream.java
  inflating: jConnect-5_5/sample2/AsciiToUniFileInputStream.java
  inflating: jConnect-5_5/sample2/AutoCommit.java
  inflating: jConnect-5_5/sample2/BinaryStream.java
  inflating: jConnect-5_5/sample2/DBMetadata.java
  inflating: jConnect-5_5/sample2/Debugexample.java
  inflating: jConnect-5_5/sample2/DriverMgr.java
  inflating: jConnect-5_5/sample2/Escape.java
  inflating: jConnect-5_5/sample2/EventHandler.java
  inflating: jConnect-5_5/sample2/Execute.java
  inflating: jConnect-5_5/sample2/ExecuteQuery.java
  inflating: jConnect-5_5/sample2/ExecuteUpdate.java
  inflating: jConnect-5_5/sample2/GetObject.java
  inflating: jConnect-5_5/sample2/Isql.java
  inflating: jConnect-5_5/sample2/JdbcDriver.java
  inflating: jConnect-5_5/sample2/Makefile
  inflating: jConnect-5_5/sample2/MessageHandler.java
  inflating: jConnect-5_5/sample2/MyCallable.java
  inflating: jConnect-5_5/sample2/MyConnection.java
  inflating: jConnect-5_5/sample2/MyDriver.java
  inflating: jConnect-5_5/sample2/MyPrepare.java
  inflating: jConnect-5_5/sample2/MyResultSet.java
  inflating: jConnect-5_5/sample2/NameBindRPC.java
  inflating: jConnect-5_5/sample2/Printexample.java
  inflating: jConnect-5_5/sample2/RSMetadata.java
  inflating: jConnect-5_5/sample2/Raiserror.java
  inflating: jConnect-5_5/sample2/ReadCursor.java
  inflating: jConnect-5_5/sample2/Sample.java
  inflating: jConnect-5_5/sample2/SetObject.java
  inflating: jConnect-5_5/sample2/SunIoConverter.java
  inflating: jConnect-5_5/sample2/SybSample.java
  inflating: jConnect-5_5/sample2/SybSampleApplet.java
  inflating: jConnect-5_5/sample2/SybTimestamp.java
  inflating: jConnect-5_5/sample2/UnicodeStream.java
  inflating: jConnect-5_5/sample2/UpdateCursor.java
  inflating: jConnect-5_5/sample2/index.html
  inflating: jConnect-5_5/sample2/make_nt.bat
  inflating: jConnect-5_5/sample2/pubs2_any.sql
  inflating: jConnect-5_5/sample2/pubs2_sql.sql
  inflating: jConnect-5_5/sample2/TextPointers.java
  inflating: jConnect-5_5/sample2/mb1.jpg
  inflating: jConnect-5_5/sample2/Address.java
  inflating: jConnect-5_5/sample2/AddressSubclass.java
  inflating: jConnect-5_5/sample2/DataRow.java
  inflating: jConnect-5_5/sample2/DataRowCache.java
  inflating: jConnect-5_5/sample2/Encrypt.java
  inflating: jConnect-5_5/sample2/ExtendedResultSet.java
  inflating: jConnect-5_5/sample2/HandleObject.java
  inflating: jConnect-5_5/sample2/MySSLSocketFactory.java
  inflating: jConnect-5_5/sample2/SQLValue.java
  inflating: jConnect-5_5/sample2/ScrollableResultSet.java
  inflating: jConnect-5_5/sample2/SimpleRowCache.java
  inflating: jConnect-5_5/sample2/SybEedInfo.java
  inflating: jConnect-5_5/sample2/BatchUpdates.java
  inflating: jConnect-5_5/sample2/ScrollableSample.java
  inflating: jConnect-5_5/sample2/ClassLoaderSample.java
  inflating: jConnect-5_5/sample2/SimpleDataSource.java
  inflating: jConnect-5_5/sample2/SimpleConnectionPool.java
  inflating: jConnect-5_5/sample2/SybPrepExtension.java
   creating: jConnect-5_5/docs/
   creating: jConnect-5_5/docs/en/
   creating: jConnect-5_5/docs/en/javadocs/
  inflating: jConnect-5_5/docs/en/javadocs/overview-tree.html
  inflating: jConnect-5_5/docs/en/javadocs/index-all.html
  inflating: jConnect-5_5/docs/en/javadocs/deprecated-list.html
  inflating: jConnect-5_5/docs/en/javadocs/allclasses-frame.html
  inflating: jConnect-5_5/docs/en/javadocs/index.html
  inflating: jConnect-5_5/docs/en/javadocs/packages.html
   creating: jConnect-5_5/docs/en/javadocs/com/
   creating: jConnect-5_5/docs/en/javadocs/com/sybase/
   creating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/package-summary.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/package-tree.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/package-frame.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/Capture.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/CharsetConverter.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/Debug.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/DynamicClassLoader.htm
l
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/EedInfo.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/SybCallableStatement.h
tml
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/SybConnection.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/SybCursorResultSet.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/SybDataSource.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/SybDriver.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/SybEventHandler.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/SybMessageHandler.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/SybPreparedStatement.ht
ml
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/SybResultSet.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/SybSocketFactory.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/SybStatement.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/TextPointer.html
  inflating: jConnect-5_5/docs/en/javadocs/serialized-form.html
 extracting: jConnect-5_5/docs/en/javadocs/package-list
  inflating: jConnect-5_5/docs/en/javadocs/help-doc.html
  inflating: jConnect-5_5/docs/en/javadocs/stylesheet.css
  inflating: jConnect-5_5/classes/jTDS2.jar
bash$

出来たファイルを確認する．

bash$ ls -la
total 8200
drwxrwxr-x    3 sybase   sybase       4096 Apr 16 17:04 .
drwxrwxr-x   23 sybase   sybase       4096 Apr 16 16:34 ..
-rw-rw-r--    1 sybase   sybase    6124826 Apr 16 16:35 EBF10106.tgz
-rw-rw-r--    1 sybase   sybase      41971 Apr 16 16:35 EBF10106.txt
drwxrwxr-x    9 sybase   sybase       4096 Jan  7 15:05 jConnect-5_5
-rw-rw-r--    1 sybase   sybase    2193608 Apr 16 16:34 jconnect55.zip
bash$

場所を移動しておく．
- ASE12等を見ていると，jConnectのファイルは，$SYBASE/jConnectに置かれるようなので，それにならう．

bash$ mv jConnect-5_5 $SYBASE/.
bash$

６．EBF10106を適用する

EBF10106も展開してみる．

bash$ ls -la
total 8196
drwxrwxr-x    2 sybase   sybase       4096 Apr 16 17:06 .
drwxrwxr-x   24 sybase   sybase       4096 Apr 16 17:06 ..
-rw-rw-r--    1 sybase   sybase    6124826 Apr 16 16:35 EBF10106.tgz
-rw-rw-r--    1 sybase   sybase      41971 Apr 16 16:35 EBF10106.txt
-rw-rw-r--    1 sybase   sybase    2193608 Apr 16 16:34 jconnect55.zip
bash$ gunzip -d EBF10106.tgz
bash$ tar xvf EBF10106.tar
ebf10106/
ebf10106/jconnect45.zip
ebf10106/jconnect55.zip
ebf10106/ribo.zip
ebf10106/Cover.ROLL.10106
bash$

作成されたebf10106ディレクトリを確認してみる．

bash$ ls -la
total 8348
drwxrwxr-x    3 sybase   sybase       4096 Apr 16 17:10 .
drwxrwxr-x   24 sybase   sybase       4096 Apr 16 17:06 ..
-rw-rw-r--    1 sybase   sybase    6277120 Apr 16 16:35 EBF10106.tar
-rw-rw-r--    1 sybase   sybase      41971 Apr 16 16:35 EBF10106.txt
drwxr-xr-x    2 sybase   sybase       4096 Mar  5 08:03 ebf10106
-rw-rw-r--    1 sybase   sybase    2193608 Apr 16 16:34 jconnect55.zip
bash$ cd ebf10106/
bash$ ls
Cover.ROLL.10106  jconnect45.zip  jconnect55.zip  ribo.zip
bash$

またjconnect55.zipがある！
ファイルを展開する．

bash$ unzip jconnect55.zip
Archive:  jconnect55.zip
   creating: jConnect-5_5/
   creating: jConnect-5_5/classes/
  inflating: jConnect-5_5/classes/Isql.class
  inflating: jConnect-5_5/classes/IsqlApp.class
  inflating: jConnect-5_5/classes/jconn2.jar
  inflating: jConnect-5_5/classes/jTDS2.jar
   creating: jConnect-5_5/classes/gateway2/
  inflating: jConnect-5_5/classes/gateway2/FixedSession.class
  inflating: jConnect-5_5/classes/gateway2/TDSTunnelServlet.class
  inflating: jConnect-5_5/classes/gateway2/TdsSession.class
  inflating: jConnect-5_5/classes/gateway2/TdsSessionManager.class
   creating: jConnect-5_5/classes/sample2/
  inflating: jConnect-5_5/classes/sample2/Callable.class
  inflating: jConnect-5_5/classes/sample2/CommandLine.class
  inflating: jConnect-5_5/classes/sample2/Ping.class
  inflating: jConnect-5_5/classes/sample2/Prepare.class
  inflating: jConnect-5_5/classes/sample2/SimpleSelect.class
  inflating: jConnect-5_5/classes/sample2/Validate.class
  inflating: jConnect-5_5/classes/sample2/Version.class
  inflating: jConnect-5_5/classes/sample2/Address.class
  inflating: jConnect-5_5/classes/sample2/AddressSubclass.class
  inflating: jConnect-5_5/classes/sample2/AsciiStream.class
  inflating: jConnect-5_5/classes/sample2/AsciiToUniFileInputStream.class
  inflating: jConnect-5_5/classes/sample2/AutoCommit.class
  inflating: jConnect-5_5/classes/sample2/BinaryStream.class
  inflating: jConnect-5_5/classes/sample2/DBMetadata.class
  inflating: jConnect-5_5/classes/sample2/Debugexample.class
  inflating: jConnect-5_5/classes/sample2/DriverMgr.class
  inflating: jConnect-5_5/classes/sample2/Escape.class
  inflating: jConnect-5_5/classes/sample2/EventHandler.class
  inflating: jConnect-5_5/classes/sample2/EventHandler$MyEventHandler.class
  inflating: jConnect-5_5/classes/sample2/Execute.class
  inflating: jConnect-5_5/classes/sample2/ExecuteQuery.class
  inflating: jConnect-5_5/classes/sample2/ExecuteUpdate.class
  inflating: jConnect-5_5/classes/sample2/GetObject.class
  inflating: jConnect-5_5/classes/sample2/JdbcDriver.class
  inflating: jConnect-5_5/classes/sample2/MessageHandler.class
  inflating: jConnect-5_5/classes/sample2/MessageHandler$ConnectionMsgHandler.class
  inflating: jConnect-5_5/classes/sample2/MessageHandler$StatementMsgHandler.class
  inflating: jConnect-5_5/classes/sample2/MyCallable.class
  inflating: jConnect-5_5/classes/sample2/MyConnection.class
  inflating: jConnect-5_5/classes/sample2/MyDriver.class
  inflating: jConnect-5_5/classes/sample2/MyPrepare.class
  inflating: jConnect-5_5/classes/sample2/MyResultSet.class
  inflating: jConnect-5_5/classes/sample2/NameBindRPC.class
  inflating: jConnect-5_5/classes/sample2/Printexample.class
  inflating: jConnect-5_5/classes/sample2/RSMetadata.class
  inflating: jConnect-5_5/classes/sample2/Raiserror.class
  inflating: jConnect-5_5/classes/sample2/ReadCursor.class
  inflating: jConnect-5_5/classes/sample2/Sample.class
  inflating: jConnect-5_5/classes/sample2/SetObject.class
  inflating: jConnect-5_5/classes/sample2/SunIoConverter.class
  inflating: jConnect-5_5/classes/sample2/SybSample.class
  inflating: jConnect-5_5/classes/sample2/InfoDialog.class
  inflating: jConnect-5_5/classes/sample2/SybSampleApplet.class
  inflating: jConnect-5_5/classes/sample2/SybTimestamp.class
  inflating: jConnect-5_5/classes/sample2/UnicodeStream.class
  inflating: jConnect-5_5/classes/sample2/UpdateCursor.class
  inflating: jConnect-5_5/classes/sample2/TextPointers.class
  inflating: jConnect-5_5/classes/sample2/ImageFrames.class
  inflating: jConnect-5_5/classes/sample2/DataRow.class
  inflating: jConnect-5_5/classes/sample2/DataRowCache.class
  inflating: jConnect-5_5/classes/sample2/Encrypt.class
  inflating: jConnect-5_5/classes/sample2/ExtendedResultSet.class
  inflating: jConnect-5_5/classes/sample2/HandleObject.class
  inflating: jConnect-5_5/classes/sample2/MySSLSocketFactory.class
  inflating: jConnect-5_5/classes/sample2/SQLValue.class
  inflating: jConnect-5_5/classes/sample2/ScrollableResultSet.class
  inflating: jConnect-5_5/classes/sample2/SimpleRowCache.class
  inflating: jConnect-5_5/classes/sample2/SybEedInfo.class
  inflating: jConnect-5_5/classes/sample2/BatchUpdates.class
  inflating: jConnect-5_5/classes/sample2/ScrollableSample.class
  inflating: jConnect-5_5/classes/sample2/ClassLoaderSample.class
  inflating: jConnect-5_5/classes/sample2/SimpleDataSource.class
  inflating: jConnect-5_5/classes/sample2/SimpleConnectionPool.class
  inflating: jConnect-5_5/classes/sample2/Person.class
  inflating: jConnect-5_5/classes/sample2/Employee.class
  inflating: jConnect-5_5/classes/sample2/PreLoadSample.class
  inflating: jConnect-5_5/classes/sample2/LoaderSample.class
  inflating: jConnect-5_5/classes/sample2/SybPrepExtension.class
   creating: jConnect-5_5/gateway2/
  inflating: jConnect-5_5/gateway2/FixedSession.java
  inflating: jConnect-5_5/gateway2/TDSTunnelServlet.java
   creating: jConnect-5_5/sp/
  inflating: jConnect-5_5/sp/sql_asa.sql
  inflating: jConnect-5_5/sp/sql_server.sql
  inflating: jConnect-5_5/sp/sql_server12.sql
  inflating: jConnect-5_5/sp/sql_server12.5.sql
   creating: jConnect-5_5/tools/
  inflating: jConnect-5_5/tools/decode-tli
  inflating: jConnect-5_5/index.html
  inflating: jConnect-5_5/netimpct.gif
  inflating: jConnect-5_5/version.txt
   creating: jConnect-5_5/devclasses/
  inflating: jConnect-5_5/devclasses/jconn2d.jar
  inflating: jConnect-5_5/devclasses/jTDS2d.jar
   creating: jConnect-5_5/sample2/
  inflating: jConnect-5_5/sample2/Person.java
  inflating: jConnect-5_5/sample2/Employee.java
  inflating: jConnect-5_5/sample2/LoaderSample.java
  inflating: jConnect-5_5/sample2/PreLoadSample.java
  inflating: jConnect-5_5/sample2/IsqlApp.java
  inflating: jConnect-5_5/sample2/Callable.java
  inflating: jConnect-5_5/sample2/CommandLine.java
  inflating: jConnect-5_5/sample2/Ping.java
  inflating: jConnect-5_5/sample2/Prepare.java
  inflating: jConnect-5_5/sample2/SimpleSelect.java
  inflating: jConnect-5_5/sample2/Validate.java
  inflating: jConnect-5_5/sample2/Version.java
  inflating: jConnect-5_5/sample2/gateway.html
  inflating: jConnect-5_5/sample2/AsciiStream.java
  inflating: jConnect-5_5/sample2/AsciiToUniFileInputStream.java
  inflating: jConnect-5_5/sample2/AutoCommit.java
  inflating: jConnect-5_5/sample2/BinaryStream.java
  inflating: jConnect-5_5/sample2/DBMetadata.java
  inflating: jConnect-5_5/sample2/Debugexample.java
  inflating: jConnect-5_5/sample2/DriverMgr.java
  inflating: jConnect-5_5/sample2/Escape.java
  inflating: jConnect-5_5/sample2/EventHandler.java
  inflating: jConnect-5_5/sample2/Execute.java
  inflating: jConnect-5_5/sample2/ExecuteQuery.java
  inflating: jConnect-5_5/sample2/ExecuteUpdate.java
  inflating: jConnect-5_5/sample2/GetObject.java
  inflating: jConnect-5_5/sample2/Isql.java
  inflating: jConnect-5_5/sample2/JdbcDriver.java
  inflating: jConnect-5_5/sample2/Makefile
  inflating: jConnect-5_5/sample2/MessageHandler.java
  inflating: jConnect-5_5/sample2/MyCallable.java
  inflating: jConnect-5_5/sample2/MyConnection.java
  inflating: jConnect-5_5/sample2/MyDriver.java
  inflating: jConnect-5_5/sample2/MyPrepare.java
  inflating: jConnect-5_5/sample2/MyResultSet.java
  inflating: jConnect-5_5/sample2/NameBindRPC.java
  inflating: jConnect-5_5/sample2/Printexample.java
  inflating: jConnect-5_5/sample2/RSMetadata.java
  inflating: jConnect-5_5/sample2/Raiserror.java
  inflating: jConnect-5_5/sample2/ReadCursor.java
  inflating: jConnect-5_5/sample2/Sample.java
  inflating: jConnect-5_5/sample2/SetObject.java
  inflating: jConnect-5_5/sample2/SunIoConverter.java
  inflating: jConnect-5_5/sample2/SybSample.java
  inflating: jConnect-5_5/sample2/SybSampleApplet.java
  inflating: jConnect-5_5/sample2/SybTimestamp.java
  inflating: jConnect-5_5/sample2/UnicodeStream.java
  inflating: jConnect-5_5/sample2/UpdateCursor.java
  inflating: jConnect-5_5/sample2/index.html
  inflating: jConnect-5_5/sample2/make_nt.bat
  inflating: jConnect-5_5/sample2/pubs2_any.sql
  inflating: jConnect-5_5/sample2/pubs2_sql.sql
  inflating: jConnect-5_5/sample2/TextPointers.java
  inflating: jConnect-5_5/sample2/mb1.jpg
  inflating: jConnect-5_5/sample2/Address.java
  inflating: jConnect-5_5/sample2/AddressSubclass.java
  inflating: jConnect-5_5/sample2/DataRow.java
  inflating: jConnect-5_5/sample2/DataRowCache.java
  inflating: jConnect-5_5/sample2/Encrypt.java
  inflating: jConnect-5_5/sample2/ExtendedResultSet.java
  inflating: jConnect-5_5/sample2/HandleObject.java
  inflating: jConnect-5_5/sample2/MySSLSocketFactory.java
  inflating: jConnect-5_5/sample2/SQLValue.java
  inflating: jConnect-5_5/sample2/ScrollableResultSet.java
  inflating: jConnect-5_5/sample2/SimpleRowCache.java
  inflating: jConnect-5_5/sample2/SybEedInfo.java
  inflating: jConnect-5_5/sample2/BatchUpdates.java
  inflating: jConnect-5_5/sample2/ScrollableSample.java
  inflating: jConnect-5_5/sample2/ClassLoaderSample.java
  inflating: jConnect-5_5/sample2/SimpleDataSource.java
  inflating: jConnect-5_5/sample2/SimpleConnectionPool.java
  inflating: jConnect-5_5/sample2/SybPrepExtension.java
   creating: jConnect-5_5/docs/
   creating: jConnect-5_5/docs/en/
   creating: jConnect-5_5/docs/en/javadocs/
  inflating: jConnect-5_5/docs/en/javadocs/overview-tree.html
  inflating: jConnect-5_5/docs/en/javadocs/index-all.html
  inflating: jConnect-5_5/docs/en/javadocs/deprecated-list.html
  inflating: jConnect-5_5/docs/en/javadocs/allclasses-frame.html
  inflating: jConnect-5_5/docs/en/javadocs/index.html
  inflating: jConnect-5_5/docs/en/javadocs/packages.html
   creating: jConnect-5_5/docs/en/javadocs/com/
   creating: jConnect-5_5/docs/en/javadocs/com/sybase/
   creating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/package-summary.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/package-tree.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/package-frame.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/Capture.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/CharsetConverter.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/Debug.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/DynamicClassLoader.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/EedInfo.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/SybCallableStatement.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/SybConnection.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/SybCursorResultSet.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/SybDataSource.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/SybDriver.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/SybEventHandler.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/SybMessageHandler.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/SybPreparedStatement.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/SybResultSet.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/SybSocketFactory.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/SybStatement.html
  inflating: jConnect-5_5/docs/en/javadocs/com/sybase/jdbcx/TextPointer.html
  inflating: jConnect-5_5/docs/en/javadocs/serialized-form.html
 extracting: jConnect-5_5/docs/en/javadocs/package-list
  inflating: jConnect-5_5/docs/en/javadocs/help-doc.html
  inflating: jConnect-5_5/docs/en/javadocs/stylesheet.css
bash$

インストーラもついてないみたいで，何が新しくなったかわからない．
よって，更新された分だけ複写する．

bash$ cp -R -v -u jConnect-5_5 $SYBASE/jConnect-5_5
jConnect-5_5 -> /opt/sybase-11.9.2/jConnect-5_5/jConnect-5_5
jConnect-5_5/classes -> /opt/sybase-11.9.2/jConnect-5_5/jConnect-5_5/classes
jConnect-5_5/classes/Isql.class -> /opt/sybase-11.9.2/jConnect-5_5/jConnect-5_5/clas
ses/Isql.class

〜略〜

jConnect-5_5/docs/en/javadocs/package-list -> /opt/sybase-11.9.2/jConnect-5_5/jConne
ct-5_5/docs/en/javadocs/package-list
jConnect-5_5/docs/en/javadocs/help-doc.html -> /opt/sybase-11.9.2/jConnect-5_5/jConn
ect-5_5/docs/en/javadocs/help-doc.html
jConnect-5_5/docs/en/javadocs/stylesheet.css -> /opt/sybase-11.9.2/jConnect-5_5/jCon
nect-5_5/docs/en/javadocs/stylesheet.css
bash$

幾つかのファイルがコピーされた事が確認できた．

７．ASEサーバのみの作業

ASEにjConnectで接続するためには，特別なテーブルを作成しておく必要がある．
- 詳細は，「SybaseASE11.0.0.3#ESD6でｊConnect5.2の設定」を参照．
jConnectをインストールすると，サーバ側で必要なテーブル等を作成するためのスクリプトが格納されており，ASEのバージョンによってそのスクリプトを実行すればよい．
まず，スクリプトを確認する．

bash$ cd $SYBASE/jConnect-5_5/sp
bash$ ls -la
total 848
drwxrwxr-x    2 sybase   sybase       4096 Jan  7 15:05 .
drwxrwxr-x   10 sybase   sybase       4096 Apr 16 17:21 ..
-rw-rw-r--    1 sybase   sybase     111843 Nov  6 07:47 sql_asa.sql
-rw-rw-r--    1 sybase   sybase     237344 Dec 11 06:55 sql_server.sql
-rw-rw-r--    1 sybase   sybase     244123 Dec 13 16:46 sql_server12.5.sql
-rw-rw-r--    1 sybase   sybase     242831 Dec 13 16:46 sql_server12.sql
bash$

ASE11.xは，sql_server.sqlを実行すればよい．
以下に，実行例を示す．

bash$ isql -Usa -P -Spoweredge -isql_server.sql -o$SYBASE/database/log/jcon.log
bash$ cat $SYBASE/database/log/jcon.log
Msg 2401, Level 11, State 2:
Line 1:
Character set conversion is not available between client character set 'iso_1'
and server character set 'sjis'.
No conversions will be done.
 Parameter Name                 Default     Memory Used Config Value
         Run Value
 ------------------------------ ----------- ----------- ------------
        -----------
 allow updates to system tables           0           0           1
                   1
(1 row affected)
Configuration option changed. The SQL Server need not be rebooted since the
option is dynamic.
(return status = 0)
(1 row affected)

〜略〜

(1 row affected)
(1 row affected)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(1 row affected)

〜略〜

(1 row affected)
(1 row affected)
(1 row affected)
(return status = 0)
(1 row affected)

〜略〜

(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
(return status = 0)
 Parameter Name                 Default     Memory Used Config Value
         Run Value
 ------------------------------ ----------- ----------- ------------
        -----------
 allow updates to system tables           0           0           0
                   0

(1 row affected)
Configuration option changed. The SQL Server need not be rebooted since the
option is dynamic.
(return status = 0)
bash$

ログの中の，return status が全て0になっているか確認する．

８．環境変数の設定

.profileファイルに，次のようにjConnect用の設定を行う．

#
# Never run any DBA or SA under for sybase as root
#
if [ `id -u` -eq 0 ]; then
    echo "This account should not be ran with uid = 0"
    exit 1
fi

# Have SYBASE set to the correct location
# SYBASE=`pwd`                  ; export SYBASE
#export SYBASE=`rpm -q --queryformat '%{installprefix}' sybase-common`
export SYBASE=/opt/sybase-11.9.2

export SYBPLATFORM="linux"
export LD_LIBRARY_PATH="$SYBASE/lib"
export LC_ALL="default"
export PATH="$SYBASE/bin:$PATH:.:$SYBASE/install"

#jConnect Setting
export JDBC_HOME="$SYBASE/jConnect-5_5"
export CLASSPATH="$CLASSPATH:$JDBC_HOME/classes:$JDBC_HOME/classes/jconn2.jar"
export JAVA_HOME="/opt/jdk1.2.2"
export PATH="$PATH:$JAVA_HOME/bin"

unset LANG

if [ ! "${PAGER}" ]; then

変更内容を反映させ，その内容を確認する．

bash$ . .profile
bash$ env | grep JAVA
JAVA_HOME=/opt/jdk1.2.2
bash$ env | grep JDBC
JDBC_HOME=/opt/sybase-11.9.2/jConnect-5_5
bash$ env | grep PATH
LD_LIBRARY_PATH=/opt/sybase-11.9.2/lib
CLASSPATH=:/opt/sybase-11.9.2/jConnect-5_5/classes:/opt/sybase-11.9.2/jConnect-5_5/cl
asses/jconn2.jar
PATH=/opt/sybase-11.9.2/bin:/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/X11R6/bin:
.:/opt/sybase-11.9.2/install:/opt/jdk1.2.2/bin
bash$

Java版ISQLで接続してみる．

bash$ cd $JDBC_HOME/sample2
bash$ ls -la Isql*
-r--r--r--    1 sybase   sybase      14615 Jun 11  2000 Isql.java
-r--r--r--    1 sybase   sybase      27586 Oct  5  2001 IsqlApp.java
bash$ java IsqlApp -Usa -P -S jdbc:sybase:Tds:10.0.200.28:5000
Enter a query:
1 > select @@version

------------------ Result set 1 -----------------------

Columns:
[ 1]    Adaptive Server Enterprise/11.9.2.6/1287/P/SWR 10032 ROLLUP/Linux Intel/Linux
 2.2.5-15 i586/OPT/Mon Mar 11 23:46:34 2002
1 rows Affected.

Enter a query:
1 > quit
bash$

つながった．