Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I'm getting frustrated over a problem which I really underestimated.
Hopefully I was just stupid an someone can help... 😃
Right now I am reading a lot of files an really don't want to generate all tables on my own. So in the beginnig I tried the built-in feature of the MySQLOut "create table if not exists". It somhow failed after a certain ammount of tables. I have no idea why. The exception said simply "table xyz does not exist" which is correct. But it wasn't created.
Any way then I tried to create them before the actual data load.
I wrote the Query and checked it through the MySQL Console where it works perfektly.
BUT the tMySQL is somehow stubburn and won't create the table.
Here's my query:
And here is what Talend comes up with....
I really don't get it and I've been trying for at least 2 hours now
.
I tried several combinations of creating a table but non worked for me.
I'm getting frustrated over a problem which I really underestimated.
Hopefully I was just stupid an someone can help... 😃
Right now I am reading a lot of files an really don't want to generate all tables on my own. So in the beginnig I tried the built-in feature of the MySQLOut "create table if not exists". It somhow failed after a certain ammount of tables. I have no idea why. The exception said simply "table xyz does not exist" which is correct. But it wasn't created.
Any way then I tried to create them before the actual data load.
I wrote the Query and checked it through the MySQL Console where it works perfektly.
BUT the tMySQL is somehow stubburn and won't create the table.
Here's my query:
DROP TABLE IF EXISTS br189071noid;
CREATE TABLE br189071noid (
ID int(9) NOT NULL AUTO_INCREMENT,
My_time DATETIME DEFAULT NULL,
Magnetventil_SA1_anst_ int(1) default NULL,
Magnetventil_SA2_anst_ int(1) default NULL,
Magnetventil_SA3_anst_ int(1) default NULL,
Magnetventil_SA4_anst_ int(1) default NULL,
Hauptschalter_DC_ist_EIN int(1) default NULL,
Systemtre__in_AC_Stellung int(1) default NULL,
AC_Netzspannung__eig_ZSG_ int(2) default NULL,
DC_Netzspannung__direkt_ int(4) default NULL,
HBU1__Eingangsspannung int(4) default NULL,
HBU1__ZK_Spannung int(5) default NULL,
HBU2__Eingangsspannung int(4) default NULL,
HBU2__ZK_Spannung int(5) default NULL,
n_Ist_Achse_1__K_Micro_ int(5) default NULL,
PRIMARY KEY (ID) );
And here is what Talend comes up with....
Starte Job test1 am 16:33 30/12/2016.
connecting to socket on port 3804
connected
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE br189071noid (
ID int(9) NOT NULL AUTO_INCREMENT,
My_time DATETIM' at line 2
disconnected
Job test1 endet am 16:33 30/12/2016.
I really don't get it and I've been trying for at least 2 hours now
.
I tried several combinations of creating a table but non worked for me.
