Hello Sven,
JDBC requires that :
------------------------------------------------------------------------------------------------------------------
public ResultSet executeQuery()
throws SQLException
Executes the SQL query in this PreparedStatement object and returns the ResultSet object
generated by the query.
Returns:
a ResultSet object that contains the data produced by the query; never null
Throws:
SQLException - if a database access error occurs or the SQL statement does not return a
ResultSet object
------------------------------------------------------------------------------------------------------------------
Which simply means that you cannot execute SQL statements which don't return a result set
using 'executeQuery'.
(and vice versa 'executeUpdate' for queries). If in doubt, use 'execute' and query later
with 'getResultSet' or
'getUpdateCount'.
Regards
Alexander Schröder
SAP DB, SAP Labs Berlin
> -----Original Message-----
> From: news [mailto:news@stripped]On Behalf Of Sven Köhler
> Sent: Monday, February 02, 2004 5:15 PM
> To: maxdb@stripped
> Subject: Re: what does "SQL statement would generate a row
> count" mean?
>
>
> > I get the following exception.
> >
> > com.sap.dbtech.jdbc.exceptions.SQLExceptionSapDB: SQL
> statement would
> > generate a row count.
>
> Well, i executed the wrong query, now it works, but the message still
> has no meaning to me.
>
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
> http://lists.mysql.com/maxdb?unsub=1
>
