Обсуждение: executeQuery returns postgresql.stat.result

Hi,
When I try
        try
        {
            sql="select * from \"qryMonthsYears\"";
            java.sql.ResultSet
resultset=getQuery(sql,connection.createStatement());
        }
        catch(java.sql.SQLException fout)
        {
            java.sql.SQLException foutje=fout.getNextException();
            out.println("<br>SQL fout: "+fout.getMessage());
            while(foutje!=null)
            {
                out.print("<br>Ingebedde fout: "+foutje.getMessage());
                foutje=fout.getNextException();
            }
        }

I get the following exception when I try this:
 Batch entry 0 select * from "qryMonthsYears"; was aborted. Call
getNextException() to see the cause.
When I call getNextException(), I get the following result:
postgresql.stat.result
and stays in the loop.
Here is the code for the method getQuery:
        ResultSet resultset;
        if(strstatement.startsWith("SELECT"))
        {
            resultset=statement.executeQuery(strstatement);
            if(resultset==null)
                throw new SQLException("Resultset is null at getQuery().");
            if(resultset.getWarnings()==null)
                return resultset;
            else
            {
                String errmessage="";
                while(resultset.getWarnings().getErrorCode()!=0)
                {
                    errmessage+=resultset.getWarnings().getMessage()+"\n";
                    resultset.getWarnings().getNextException();
                }
                throw new SQLException("SQL Fout getQuery(): "+errmessage);
            }
        }
        else
        {
            connection.setAutoCommit(false);
            String [] sql=strstatement.split(";");
            for(int teller=0;teller<sql.length;teller++)
                statement.addBatch(sql[teller]+";");
            statement.executeBatch();
            connection.commit();
            connection.setAutoCommit(true);
            return null;
        }

Please help!

Nico.

On Sun, 1 May 2005, Nico wrote:

>             sql="select * from \"qryMonthsYears\"";
>...
>         if(strstatement.startsWith("SELECT"))
>...
>         else
>         {
>             connection.setAutoCommit(false);
>             String [] sql=strstatement.split(";");
>             for(int teller=0;teller<sql.length;teller++)
>                 statement.addBatch(sql[teller]+";");
>             statement.executeBatch();

Your own parsing logic is busted and is trying to execute a select in a
batch statement, which is not legal.

Kris Jurka

The batch statement is ONLY used in case of an update, insert or delete
command.
When a select command is used, there is no batch used, as you can see in my
code.

Nico.

"Kris Jurka" <books@ejurka.com> schreef in bericht
news:Pine.BSO.4.56.0505011230450.1107@leary.csoft.net...
>
>
> On Sun, 1 May 2005, Nico wrote:
>
>>             sql="select * from \"qryMonthsYears\"";
>>...
>>         if(strstatement.startsWith("SELECT"))
>>...
>>         else
>>         {
>>             connection.setAutoCommit(false);
>>             String [] sql=strstatement.split(";");
>>             for(int teller=0;teller<sql.length;teller++)
>>                 statement.addBatch(sql[teller]+";");
>>             statement.executeBatch();
>
> Your own parsing logic is busted and is trying to execute a select in a
> batch statement, which is not legal.
>
> Kris Jurka
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo@postgresql.org so that your
>      message can get through to the mailing list cleanly
>

On Sun, 1 May 2005, Nico wrote:

> The batch statement is ONLY used in case of an update, insert or delete
> command. When a select command is used, there is no batch used, as you
> can see in my code.

No, I can't see that.  You have a case mismatch between your sql and your
test.  A simple examination of the stacktrace from this error would
clearly show the wrong code being called.

Kris Jurka

I noticed it. Because the exception was captured, it didn't show a
stacktrace.
I solved it and it works fine now. Thanks.

Nico.

"Kris Jurka" <books@ejurka.com> schreef in bericht
news:Pine.BSO.4.56.0505011302210.22827@leary.csoft.net...
>
>
> On Sun, 1 May 2005, Nico wrote:
>
>> The batch statement is ONLY used in case of an update, insert or delete
>> command. When a select command is used, there is no batch used, as you
>> can see in my code.
>
> No, I can't see that.  You have a case mismatch between your sql and your
> test.  A simple examination of the stacktrace from this error would
> clearly show the wrong code being called.
>
> Kris Jurka
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>