List:MySQL and Java« Previous MessageNext Message »
From:Mark Matthews Date:May 30 2003 6:32pm
Subject:Re: PreparedStatement gives always empty Resultset
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Helmut Leininger wrote:
> Hi,
>
> During tests I have found additional information. It has for sure
> something to do with MySQL 4.1 and Server-Prepared Statements.
> If "useServerPrepStmts=false" is specified in the connection string, the
> problem disappears.
>
> NB:
> This shows also, that the information in the README is wrong which says
> that the default value for  useServerPrepStmts is  "false".
>
> Regards
>
>
>
>

You don't say exactly what version of Connector/J 3.1 you are using...Is
it 3.1.0 or a nightly build? 3.1.0 can only do DML on prepared
statements (It's in the CHANGELOG)....nightly builds support _full_
PreparedStatement usage.

	-Mark

- --
For technical support contracts, visit https://order.mysql.com/?ref=mmma

    __  ___     ___ ____  __
   /  |/  /_ __/ __/ __ \/ /  Mark Matthews <mark@stripped>
  / /|_/ / // /\ \/ /_/ / /__ MySQL AB, SW Dev. Manager - J2EE/Windows
 /_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
        <___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+14eTtvXNTca6JD8RAshQAJ4i75CNI3OXsDjgq4JoXq/YTHQvRwCfSaLV
OypcnclYDOiIlj/9YuS1Gh8=
=tZFx
-----END PGP SIGNATURE-----

Thread
PreparedStatement gives always empty ResultsetHelmut Leininger21 May
  • Frist time with jdbcBruno Pereira21 May
    • Frist time with jdbcBruno Pereira22 May
      • Re: Frist time with jdbccolbey22 May
        • Re: Frist time with jdbcAdam Hardy22 May
          • RE: Frist time with jdbcBruno Pereira23 May
RE: PreparedStatement gives always empty ResultsetJohn Beveridge21 May
RE: Frist time with jdbcSteve Forsyth23 May
RE: PreparedStatement gives always empty ResultsetHelmut Leininger29 May
  • how to extract a new autoindex after inserting with a CachedRowSet (possible bug)dr.ahab29 May
RE: PreparedStatement gives always empty ResultsetHelmut Leininger30 May
  • Re: PreparedStatement gives always empty ResultsetMark Matthews30 May
    • Re: PreparedStatement gives always empty ResultsetAdam Hardy31 May
      • Re: PreparedStatement gives always empty ResultsetMark Matthews31 May
  • No read confirmation requests, please (was RE: PreparedStatement gives always empty Resultset)Shankar Unni30 May
    • Re: No read confirmation requests, please (was RE: PreparedStatement gives always empty Resultset)Jim Winstead1 Jun
Re: PreparedStatement gives always empty ResultsetHelmut Leininger31 May