I have been developing a solution using the standard developer installation just fine. We are trying to move to a common repository on a remote MySql Server.
I have downloaded the new jdbc driver from mysql’s site and configured the repository server to use com.mysql.jdbc.Driver
We got it to connect, but when the solution appears, all of the data is blank.
I look at the Dataproviders menu, and I see almost all of my smallint fields are showing up as type “unknown” These fields are always Unsigned
relations say there are key type mismatches.
The solution works 100% same server when developer is run locally.
Any ideas?
I can confirm this. I have the same driver & the same problem. Any integer that is defined as UNSIGNED get’s a type unknown in SERVOY. No problem in Aqua Data Studio.
wgknowles:
I look at the Dataproviders menu, and I see almost all of my smallint fields are showing up as type “unknown” These fields are always Unsigned
relations say there are key type mismatches.
The solution works 100% same server when developer is run locally.
Any ideas?
I am also seeing the key-type mismatch error with the newer drivers., but I am using a local repository. Moreover, even with the old drivers, Servoy is not detecting (or displaying) the length of any integer fields. But at least there’s no key-type mismatch error. ![:)]( "Smile")
Using v2.03 on Mac OS X 10.3.4.
-Peter
Can we get some feedback on this?
i just tested this on my windows machine:
Opened Mysql Control center, added a smallint column to a table. Then checked “unsigned” saved the table. Started servoy and it just sees that one as an Integer.
i don’t see unknown.
Do you guys do something different?
what versions of mysql and the driver do you guys exactly use?
mysql Ver 12.22 Distrib 4.0.17, for pc-linux-gnu (i686)
innodb tables
mysql drivers: 3.0.14-production
com.mysql.jdbc.Driver
The older drivers give an error: Repository must support transactions, so this is pretty important for us to get working asap. We don’t want the overhead of using sybase db in addition to our mysql daemon.
mysql drivers: 3.0.14-production
com.mysql.jdbc.Driver
db runs at an ISP
no innodb
db created with phpmyadmin
when needed i can send you (privately) the connection params
i need to be able to reproduce it.
So an connection to a mysql db or a create statement of a table that shows it would be nice.
this is a bug of mysql with the latest driver
go back to 3.0.11 to fix it.
http://bugs.mysql.com/bug.php?id=4138