PDA

View Full Version : MySQL Repository



robimarcotullio
06-30-2010, 06:27 AM
Hi,
i've a problem with MySQL connection. If i select database type MySQL the test connection is correct but if save the connection and reopen it the database type MySQL is changed to Oracle. What's happen?

I've set the fields code and description of table R_DATABASE_TYPE. So it's OK but if export and import the same repository into the other DB the table R_DATABASE_TYPE is changed. When and where are data created in this table?

Thanks in advance.

Bye,
R

berdan
07-02-2010, 05:21 AM
I've encountered the same problem... :(
Any ideas?

Thx in advance

MattCasters
07-02-2010, 06:13 AM
No idea, not even about what version you're using, nothing.

berdan
07-02-2010, 06:53 AM
No idea, not even about what version you're using, nothing.

Sorry, I forgot to write it.

I'm using PDI 3.2.0 on Windows 7

robimarcotullio
07-02-2010, 08:34 AM
PDI 3.2.0 but the problem is also in the old versions ...

I've resolved the problem with this update:

update r_database_type set code='MySQL', description='MYSQL' where id_database_type=10;

When I create a new repository there is not a record with MySQL code in above table.

Bye,
R