Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 64598 invoked from network); 15 Feb 2006 14:37:05 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 15 Feb 2006 14:37:05 -0000 Received: (qmail 8818 invoked by uid 500); 15 Feb 2006 14:37:01 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 8346 invoked by uid 500); 15 Feb 2006 14:36:57 -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 Delivered-To: moderator for derby-user@db.apache.org Received: (qmail 93293 invoked by uid 99); 15 Feb 2006 11:39:43 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_MESSAGE,UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) To: derby-user@db.apache.org Subject: UserUtility MIME-Version: 1.0 X-Mailer: Lotus Notes Release 6.5.1 January 21, 2004 From: Stephen-D Mainstone Message-ID: Date: Wed, 15 Feb 2006 11:39:15 +0000 X-MIMETrack: Serialize by Router on sdbo1003/DMGUK/DeuBaInt/DeuBa(Release 6.5.4 HF129|May 12, 2005) at 15/02/2006 11:39:19, Serialize complete at 15/02/2006 11:39:19 Content-Type: multipart/alternative; boundary="=_alternative 004004DB80257116_=" X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multipart message in MIME format. --=_alternative 004004DB80257116_= Content-Type: text/plain; charset="US-ASCII" I am trying to use the UserUtility class to add permissions for a given user. However, when I attempt to execute the code, I receive the following error: org.apache.derby.client.am.SqlException: The class 'UserUtility' does not exist or is inaccessible. This can happen if the class is not public. SQLSTATE: XJ001: Java exception: 'UserUtility: java.lang.ClassNotFoundException'. Here is the code snippet I am executing: public void test() throws Exception { ClientDataSource dataSource = new ClientDataSource(); dataSource.setServerName("localhost"); dataSource.setPortNumber(1527); dataSource.setDatabaseName("TEST_D1;create=true"); Statement s = dataSource.getConnection().createStatement(); s.executeUpdate("Call UserUtility::add('mary', 'READ_ACCESS_PERMISSION')"); } I have checked that the derby.jar is set on the classpath on the server (my localhost) but can see no other reason why the UserUtility class cannot be found and I have verified that the class is public in the derby.jar file. I am using version 10.1.2.1 of Derby in a client/server capacity. Can you help please? Thanks in anticipation. Steve Stephen Mainstone GES IT Deutsche Bank [/] London Phone: + 44 (0) 20 7545 8920 stephen-d.mainstone@db.com --- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. --=_alternative 004004DB80257116_= Content-Type: text/html; charset="US-ASCII"
I am trying to use the UserUtility class to add permissions for a given user. However, when I attempt to execute the code, I receive the following error:

org.apache.derby.client.am.SqlException: The class 'UserUtility' does not exist or is inaccessible. This can happen if the class is not public. SQLSTATE: XJ001: Java exception: 'UserUtility: java.lang.ClassNotFoundException'.

Here is the code snippet I am executing:

public void test() throws Exception
{
ClientDataSource dataSource = new ClientDataSource();
dataSource.setServerName("localhost");
dataSource.setPortNumber(1527);
dataSource.setDatabaseName("TEST_D1;create=true");

Statement s = dataSource.getConnection().createStatement();
s.executeUpdate("Call UserUtility::add('mary', 'READ_ACCESS_PERMISSION')");
}

I have checked that the derby.jar is set on the classpath on the server (my localhost) but can see no other reason why the UserUtility class cannot be found and I have verified that the class is public in the derby.jar file. I am using version 10.1.2.1 of Derby in a client/server capacity.

Can you help please?

Thanks in anticipation.

Steve

Stephen Mainstone
GES IT
Deutsche Bank [/] London
Phone: + 44 (0) 20 7545 8920
stephen-d.mainstone@db.com
---

This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.
--=_alternative 004004DB80257116_=--