• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

SQLException [DONE]

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'm using

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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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]
 
I've never won anything before. Not even a tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic