«

my Mysql is 5.0.18

In database "test" I created a procedure:

mysql> delimiter //
mysql> create procedure demoSp(IN inputParam VARCHAR(255),INOUT
inOutParam INT)
-> begin
-> declare z INT;
-> set z=inOutParam + 1;
-> set inOutParam = z;
-> select inputParam;
-> select CONCAT('dfjd',inputParam);
-> end//

just add 1 to the IN/OUT param and select some stuff.
In fact this code is from the Mysql connector/J 's doc

In java code I wrote:

CallableStatement cStmt = con.prepareCall("{call demoSp(?,?)}");
cStmt.registerOutParameter(2, Types.INTEGER);
cStmt.setString("inputParam", "abc");
cStmt.setInt("inOutParam",2);

boolean had = cStmt.execute();
while (had) {
ResultSet rs = cStmt.getResultSet();
while (rs.next())
System.out.println(rs.getString(1));
had=cStmt.getMoreResults();
}
System.out.println(cStmt.getInt("inOutParam"));
con.close();

-----------------------------------
but the result is an error says "Out of range value adjusted for
column 'inOutParam' at row 1"
so I go on the net and search something says that I can solve this by
edit the my.ini, just remove the "STRICT_TRANS_TABLES" from the sql-
mode option and restart the db server.

I did this ,and the result give me:


abc
dfjdabc
1


no matter how I change the value of the "inOutParam", it just return
"1".

By accident , I just replace the line "

cStmt.setInt("inOutParam",2);

to

cStmt.setInt(1,2);

the result changes to be this:

2
dfjd2
3


My default charset is set to UTF-8

my connector/J version is 3.1.0
my jdk version 1.5.0

Is this a bug or did I miss something???

Hi,

You can upgrade to the latest connector version which hopefully should
fix this.

There's a bug report here:
http://bugs.mysql.com/bug.php?id=15464

On Feb 11, 1:15 am, "lightning" <huang.lightn...@gmail.com> wrote:
> my Mysql is 5.0.18
>
> In database "test" I created a procedure:
>
> mysql> delimiter //
> mysql> create procedure demoSp(IN inputParam VARCHAR(255),INOUT
> inOutParam INT)
> -> begin
> -> declare z INT;
> -> set z=inOutParam + 1;
> -> set inOutParam = z;
> -> select inputParam;
> -> select CONCAT('dfjd',inputParam);
> -> end//
>
> just add 1 to the IN/OUT param and select some stuff.
> In fact this code is from the Mysql connector/J 's doc
>
> In java code I wrote:
>
> CallableStatement cStmt = con.prepareCall("{call demoSp(?,?)}");
> cStmt.registerOutParameter(2, Types.INTEGER);
> cStmt.setString("inputParam", "abc");
> cStmt.setInt("inOutParam",2);
>
> boolean had = cStmt.execute();
> while (had) {
> ResultSet rs = cStmt.getResultSet();
> while (rs.next())
> System.out.println(rs.getString(1));
> had=cStmt.getMoreResults();}
>
> System.out.println(cStmt.getInt("inOutParam"));
> con.close();
>
> -----------------------------------
> but the result is an error says "Out of range value adjusted for
> column 'inOutParam' at row 1"
> so I go on the net and search something says that I can solve this by
> edit the my.ini, just remove the "STRICT_TRANS_TABLES" from the sql-
> mode option and restart the db server.
>
> I did this ,and the result give me:
>
> abc
> dfjdabc
> 1
>
> no matter how I change the value of the "inOutParam", it just return
> "1".
>
> By accident , I just replace the line "
>
> cStmt.setInt("inOutParam",2);
>
> to
>
> cStmt.setInt(1,2);
>
> the result changes to be this:
>
> 2
> dfjd2
> 3
>
> My default charset is set to UTF-8
>
> my connector/J version is 3.1.0
> my jdk version 1.5.0
>
> Is this a bug or did I miss something???