SQLException [DONE]

[Migrated From Jforum.net]

Does someone else have a

java.sql.SQLException: Unknown type '9 in column 0 of 49 in binary-encoded result set.

when listing the forum index?!?

I got the CVS head and th RC3 and both are throwing it at net.jforum.drivers.mysql.UserModel.selectById(UserModel.java:74)

Any idea?

Tomcat 5.0.19 on Windows XP Professional ops:
J2SDK 1.4.2_03
[originally posted on jforum.net by smota]

[Migrated From Jforum.net]

Maybe an old MySQL version or an old MySQL Connector/J version? I don't have this.
[originally posted on jforum.net by Daniil]

[Migrated From Jforum.net]

smota wrote:Does someone else have a

java.sql.SQLException: Unknown type '9 in column 0 of 49 in binary-encoded result set.

when listing the forum index?!?

I got the CVS head and th RC3 and both are throwing it at net.jforum.drivers.mysql.UserModel.selectById(UserModel.java:74)

Any idea?

Tomcat 5.0.19 on Windows XP Professional ops:
J2SDK 1.4.2_03

HI Samuel,

which mysql version do you have?

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Sorry, forgot this detail :lol:

mySQL Database Server 4.1.1a-alpha-nt
mysql-connector-java-3.0.11-alpha (packed with jforum RC11)



Just updated the connector to the stable version and both (cvs head and rc3) are working.

thanks
[originally posted on jforum.net by smota]

[Migrated From Jforum.net]

Really? hm, then I will drop the alpha from the cvs.

I have mysql 4.0.x here, but another user related some bugs when using mysql 4.1.x :?

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

I'm using

[dan@shinestar ~]$ rpm -q MySQL-Max
MySQL-Max-4.0.18-1mdk

Haven't seen this. Using mysql-connector-java-3.0.10-stable-bin.jar.

[originally posted on jforum.net by Daniil]

[Migrated From Jforum.net]

I changed the connector/j driver to the stable one. Hope these sql problems stop now.

Rafael
[originally posted on jforum.net by Rafael Steil]