Received: from fancy.ocn.ne.jp (fancy.ocn.ne.jp [210.190.142.52])
	by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2T7wbU08453
	for <pgsql-interfaces@postgresql.org>;
	Thu, 29 Mar 2001 02:58:37 -0500 (EST)
	(envelope-from hkasa@fancy.ocn.ne.jp)
Received: from fancy.ocn.ne.jp (q39-dn02sasebo.nagasaki.ocn.ne.jp
	[211.17.41.40])
	by fancy.ocn.ne.jp (8.9.1a/OCN/) with ESMTP id QAA09676
	for <pgsql-interfaces@postgresql.org>;
	Thu, 29 Mar 2001 16:58:33 +0900 (JST)
Message-ID: <3AC2E8D2.8B4EA35C@fancy.ocn.ne.jp>
Date: Thu, 29 Mar 2001 16:48:34 +0900
From: "NSB)Hiroshi Kasamatsu" <hkasa@fancy.ocn.ne.jp>
X-Mailer: Mozilla 4.73 [ja] (Win98; U)
X-Accept-Language: ja
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: JDBC connection by crontab
Content-Type: text/plain; charset=iso-2022-jp
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200103/205
X-Sequence-Number: 1367

I am sorry that this is a specific problem because of its language.

I am testing periodic insertion into PostgreSQL table by cron.

First of all,I wrote kasa.sh.

PATH=$PATH:/usr/local/jdk1.3/bin:/usr/local/pgsql/bin
CLASSPAHT=.:/usr/local/lib/postgresql.jar:/home/postgres
export PATH CLASSPATH
/usr/local/jdk1.3/bin/java crontest

,where crontest is a java application.

Next,I edited cron using crontab -e.

0 4 * * * /bin/sh kasa.sh

The result was good except for insertion of japanese language.

Please tell me how japanese can be inserted into text column.

Thanks in advance.

Hiroshi Kasamatsu