Hi,
I have a table in mysql (located at an ISP). I connected to this table, no problem.
I can see in Servoy the data. When I start scrolling through the data I get an error: Could not load record. Details state: java.sql.SQLExeption (3 times). When I insist I CAN scroll a bit further (I get until recordnr 80) when trying maybe 10 times.
What could be wrong or better what could be done about it?
Mailed to Maarten Tue 9/6
Heard nothing since. Hey, we all need a break so now and then
Still having the same problem
using mysql 4.020a-nt-max
servoy 2.04
running on localhost
driver: com.mysql.jdbc.Driver
driver file in servoy/drivers/ : mysql-connector-java-3.0.14-production-bin.jar
the problem seems to be limited to UNSIGNED integers. I altered table and changed the unsigned options for postcode and presto, servoy identified it as an integer
This is becoming a PITA
THX for any insights
this is a bug of the 3.0.14 driver of mysql
3.0.11 doesnt have this problem
thx johan
reverting to 3.0.11
well I would if I could.
Anybody knows where to download the 3.0.11 jar. Didn’t find it on mysql.com
thx
reply from mysql:
Thanks for your bug report, this will be in 3.0.15 (you can grab a
snapshot build after 00:00 GMT this evening from
http://downloads.mysql.com/snapshots.php).
THX, for now I stick to 3.0.11
