DataDeploy group element's table attribute causing UPPERCASE table names

OpenDeploy 6.1
Solaris 2.9
MySQL 5.0.15
MySQL Connector/J 3.1.11

Something very odd is happening. We have a simple deployment that takes a DCR and dumps its contents into the database. We have a series of containers inside the DCR that all need to be deployed into the same table. To accomplish this we have various groups defined

For example:
[html]

[/html]

However, what ends up happening is that DD somehow is ignoring the table setting and choosing to insert/update/delete into a table called TS_ACCOMMODATIONS.

I filed a support case and got back the answer that MySQL 5 is not supported (thus my other post). I am going to try this on a MySQL 4 instance to see if I can replicate the issue.

Has anyone else seen this before?

Find more posts tagged with

Comments

iwovGraduate

What exactly is the issue here? Based on you config, DD will dump everything into a single table - TS_ACCOMMODATIONS. Where you expecting DD to use lowercase table names?

Bill Klish

Yes I was expecting DD to create the table just as I have it named in the config (ts_accommodations vs. TS_ACCOMMODATIONS).

I tested this on MySQL 4 and MySQL 5 (on windows instead of solaris) and it creates the table as ts_accommodations, which is very odd.

Guess it is time to go back to support on this one.

TestReport.rptdesign

Bill Klish

Actually I just found out the answer to this:

http://dev.mysql.com/doc/refman/5.0/en/name-case-sensitivity.html

Apparently the default on windows is to store lowercase, while the default for unix is to store in uppercase.

This doesn't explain the problem that is happening though. If I do not specify the table attribute, but rather just group="ts_accommodations" the table gets created correctly as ts_accommodations. Something about that parameter is causing the uppercase table SQL to be output, but oddly the fields are specified in the correct case.

DD log file snippet:


CREATE TABLE TS_ACCOMMODATIONS(
service_level VARCHAR(20)  NOT NULL ,
dcr_id INT(10)  NOT NULL ,
description TEXT  NULL ,
mage VARCHAR(255)  NULL ,
image_alt VARCHAR(150)  NULL ,
options TEXT  NULL  ,  
CONSTRAINT TS_ACCOMMODATIONS_key PRIMARY KEY(service_level,dcr_id))