Mailing List Archive


Back to the month index Back to the list index
Art Matheny (matheny@usf.edu)
Tue, 22 Apr 1997 18:08:55 -0400 (EDT) 

Date: Tue, 22 Apr 1997 18:08:55 -0400 (EDT)
From: Art Matheny <matheny@usf.edu>
Subject: Re: [mSQL] MsqlJava-1.2.1 Spurious Exception
Message-Id: <Pine.GSO.3.96.970422180649.4479B-100000@curiac>

On Tue, 22 Apr 1997, Cary Collett wrote:

> This is just a shot in the dark but is the script running as the same UID
> as you when you're running msql?

Yes.

> This could just be a simple permissions problem.

That does not appear to be the problem because the same Java program
successfully performed an update just prior to crashing on the delete.

> >
> > Can anyone explain why I am getting an Msql.Query exception for a simple
> > query that should not be any problem:
> >
> > msql.MsqlException: Msql.Query:
> >
> > at msql.Msql.Query(Msql.java:285)
> >
> >
> > My program prints the query just before it calls Query, so I can confirm
> > the the query is the following:
> >
> > delete from keywords where page_id = 1
> >
> >
> > I can execute that query in msql without any problem:
> >
> > mSQL > delete from keywords where page_id = 1\g
> >
> > Query OK. 0 row(s) modified or retrieved.
> >
> >
> > My program works with mSQL 1.0.16 and MsqlJava 1.1.1, but I am trying to
> > upgrade to mSQL 2.0-B6 and MsqlJava 1.2.1.
> >
> --------------------------------------------------------------------------
> To remove yourself from the Mini SQL mailing list send a message containing
> "unsubscribe" to > "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
> "info msql-list" to majordomo@bunyip.com for info on monthly archives of
> the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!
> 

--
-- Art Matheny          LIB 612       813-974-1795      FAX: 813-974-1799
-- Academic Computing   University of South Florida     Tampa, FL 33620
-- matheny@usf.edu      http://curiac.acomp.usf.edu/nic/

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com.  Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!