rc8 bugs

Classic Servoy
1

I use lowercaseTitleCase for naming tables in mySQL. Servoy seems to always display them in lower case. This has not been a huge problem in the past but since the rc8 update I can no longer edit tables using the edit data providers feature unless it happens to be in all lowercase.

Along this same line, when I exported my solution to upload to my server I got an error on a table I had just modified

om.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: Table ‘bc.troubleticket’ doesn’t exist

The table name does exist but is “troubleTicket” not “troubleticket”.

2

mySql really seems to be the only database that makes a case difference in table names… Even worse, they don’t do that for columns. I was really amazed when I fist noticed that. Sorry, nothing about your problem…

3

If I need to rename all my tables to lowercase, I can do that, but what effect will this have on my Servoy solution (if I only change the name to lower case)? If none, then it is not a big deal. If I have to make tons of code modifications in Servoy, then problem.

4

I did try to rename troubleTicket table (since it has minimal code) and it seemed to work W/O code modification.

I would still like the dev team to chime in on this one and confirm whether or not I should rename all my tables (and it not effect my code) or if they plan on correcting the issue.

Thanks in advance.

5

I’m also seeing this, or a similar, issue with rc8 (Linux, java 1.5, mysql 4.0, mysql-connector-java-3.0.16-ga-bin.jar).

It that tablenames are read and folded into lower-case but that comparisons are still case-sensitive :-(

I’m not sure if it will provide any operations challenges (sorry, I don’t use Servoy for db changes) but it does nothing to make me comfortable.

Thanks,
Neale.

6

ApeWare:
…I would still like the dev team to chime in on this one and confirm whether or not I should rename all my tables (and it not effect my code) or if they plan on correcting the issue…

It was indeed a bug in the dataproviderdialog (not using the SQL name), will be corrected in Servoy 2.2 final