From derby-user-return-10989-apmail-db-derby-user-archive=db.apache.org@db.apache.org Mon May 18 12:23:09 2009 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 53636 invoked from network); 18 May 2009 12:23:08 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 18 May 2009 12:23:08 -0000 Received: (qmail 7137 invoked by uid 500); 18 May 2009 12:23:08 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 7075 invoked by uid 500); 18 May 2009 12:23:07 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 7067 invoked by uid 99); 18 May 2009 12:23:07 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 18 May 2009 12:23:07 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 18 May 2009 12:22:57 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1M61rY-0000k8-KV for derby-user@db.apache.org; Mon, 18 May 2009 05:22:36 -0700 Message-ID: <23595863.post@talk.nabble.com> Date: Mon, 18 May 2009 05:22:36 -0700 (PDT) From: dacia To: derby-user@db.apache.org Subject: Problems create SQL Function MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: axel.tischer@gmx.de X-Virus-Checked: Checked by ClamAV on apache.org Hi there I try to create some SQL function, but I stuck: [code] create function getDate(timeNumber bigint) returns date > language java external name > 'java.util.Date(time)' > parameter style java no sql; 0 rows inserted/updated/deleted [/code] now: [code] ij> values getDate(1234566712345667789); ERROR 42X51: The class 'java.util' does not exist or is inaccessible. This can happen if the class is not public. ERROR XJ001: Java exception: 'java.util: java.lang.ClassNotFoundException'. [/code] What is wrong ? Thanx -- View this message in context: http://www.nabble.com/Problems-create-SQL-Function-tp23595863p23595863.html Sent from the Apache Derby Users mailing list archive at Nabble.com.