Mailing List Archive


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

Date: Tue, 22 Apr 1997 11:37:07 -0400 (EDT)
From: Art Matheny <matheny@usf.edu>
Subject: [mSQL] MsqlJava-1.2.1 Spurious Exception
Message-Id: <Pine.GSO.3.96.970422110709.4127D-100000@curiac>

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.

I am stumped. Can anyone suggest a course of action?

Version Details :-

        msqladmin version 2.0 Beta 6
        mSQL server version 2.0 Beta 6
        mSQL protocol version 22
        mSQL connection Localhost via UNIX socket
        Target platform Solaris-2.5-Sparc

Configuration Details :-

        Default config file /opt/cyber/apps/msql2/msql.conf
        TCP socket 4334
        UNIX socket /tmp/msql2.sock
        mSQL user msql2
        Admin user msql2
        Install directory /opt/cyber/apps/msql2
        PID file location /opt/cyber/apps/msql2/msql2d.pid

Code snipet:
   public void PurgeKeywords (int page_id)
      throws MsqlException {

      String query =
         "delete from keywords where page_id = "
         + page_id;
      System.out.println (" " + query);
      MsqlResult msql_result = Query (query);
   } 

--
-- 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!