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:[EMAIL PROTECTED] Behalf Of Sven K�hler
> Sent: Monday, February 02, 2004 5:15 PM
> To: [EMAIL PROTECTED]
> 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/[EMAIL PROTECTED]
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
