Java Error on Data Import from file

Permanently deleted user

创建于 2017年07月17日 11:20

Hi,

I've got a problem with datagrip when I want to import Data into a Table (Only that table, all the other ones are working).

The Database is a MSQL DB running on Microsoft Azure. Whenever I want to Import the Data I get this error message:

Any Ideas why this is happening and how I can fix it?

Best Regards

David

3 条评论

vasily chernov

创建于 2017年07月21日 13:55

Hi,

Could you specify your driver version, DataGrip version and sample DDL and file you're trying to import?

How do you import data to table?

Thank you.

Permanently deleted user

创建于 2017年07月24日 07:06

Hey Vasily,

I am running DataGrip 2017.1.4 with the Microsoft JDBC Driver for SQL Server.

The DDL looks like this:

create table Kunden
(
 KundenID int identity
  primary key,
 Anrede varchar(15),
 Titel varchar(15),
 Vorname varchar(20),
 Nachname varchar(20),
 Festnetz varchar(25),
 Mobil varchar(25),
 Mail varchar(50),
 KundenAnschriftID int not null
  constraint KundenAnschriftID
   references AnschriftKunde
)
go

create unique index Personen_KundenID_uindex
 on Kunden (KundenID)
go

The File Looks like this:

30;Mr;Prof.;John;Doe;0987654321;0123456789;john.doe@contoso.de;30

Thank you for your help!

Best Regards

David Heinrichs

vasily chernov

创建于 2017年07月24日 13:57

Hi David Heinrichs,

I've reproduced the problem.

Thank you.

请先登录再写评论。