Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: neutral (nike.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=ymail.com;
  h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
  b=VJDKRNwByOGn/uybUKiJgA2z/CXz5WMDNsyb5YAq7uD+TSyttVsFFFmZY1qW8j4FYAvqMBCEb2kIB2/lCoHjBDSmNsgAyQQWbPO3aDcSLjzbJ58h32GFF0pZ2YvCRMdAuJOncVu3amnDypAuk49lVXQ/QfJrI2R2l2blnZ6u2Uc=;
Message-ID: <936976.9821.qm@web59502.mail.ac4.yahoo.com>
Date: Sat, 2 Oct 2010 02:54:39 -0700 (PDT)
From: Dinesh Bajaj <dinesh.bajaj@ymail.com>
Subject: Error in creating database schema on the fly using ij
To: Derby Mailing List <derby-user@db.apache.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-694696183-1286013279=:9821"

--0-694696183-1286013279=:9821
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi All,

I am using Derby 10.6.1.0=A0 and am calling ij from my java application to =
create a database schema on the fly.

The database contains a jar file and the error reported concerns this jar f=
ile.

The .sql file read by ij contains this command:

CALL SQLJ.INSTALL_JAR('file:DERBYROUTINES.jar.G1286008959877', '"schemaname=
"."DERBYROUTINES"', 0);

ij doesn't throw any error while executing this line and shows the output a=
s:
"0 rows inserted/updated/deleted". As a result of executing the line a jar =
file named DERBYROUTINES.jar.G1286010997266 is added under the folder dbnam=
e\jar\schemaname\.

The problem occurs when ij is executing a DDL statement for creating a trig=
ger that calls the function defined in the jar file. It then reports the er=
ror:

"ERROR 42X51: The class 'accountant.DerbyMethods' does not exist or is inac=
cessible. This can happen if the class is not public.
ERROR XJ001: Java exception: 'accountant.DerbyMethods: java.lang.ClassNotFo=
undException'."

I am perplexed when the jar has been added to the database, why it is still=
 not able to recognize the class defined in the jar file?

Please suggest some solution for the problem.

Regards,
Dinesh


=0A=0A
--0-694696183-1286013279=:9821
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<table cellspacing=3D"0" cellpadding=3D"0" border=3D"0" ><tr><td valign=3D"=
top" style=3D"font: inherit;">Hi All,<br><br>I am using Derby 10.6.1.0&nbsp=
; and am calling ij from my java application to create a database schema on=
 the fly.<br><br>The database contains a jar file and the error reported co=
ncerns this jar file.<br><br>The .sql file read by ij contains this command=
:<br><br>CALL SQLJ.INSTALL_JAR('file:DERBYROUTINES.jar.G1286008959877', '"s=
chemaname"."DERBYROUTINES"', 0);<br><br>ij doesn't throw any error while ex=
ecuting this line and shows the output as:<br>"0 rows inserted/updated/dele=
ted". As a result of executing the line a jar file named <a>DERBYROUTINES.j=
ar.G1286010997266</a> is added under the folder dbname\jar\schemaname\.<br>=
<br>The problem occurs when ij is executing a DDL statement for creating a =
trigger that calls the function defined in the jar file. It then reports th=
e error:<br><br>"ERROR 42X51: The class 'accountant.DerbyMethods' does not
 exist or is inaccessible. This can happen if the class is not public.<br>E=
RROR XJ001: Java exception: 'accountant.DerbyMethods: java.lang.ClassNotFou=
ndException'."<br><br>I am perplexed when the jar has been added to the dat=
abase, why it is still not able to recognize the class defined in the jar f=
ile?<br><br>Please suggest some solution for the problem.<br><br>Regards,<b=
r>Dinesh<br><br><br></td></tr></table><br>
--0-694696183-1286013279=:9821--