Java Error on Data Import from file

Avatar
Permanently deleted user
Created

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

Votes

0

Share

3 comments
Avatar
vasily chernov
Created

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.

1
Avatar
Permanently deleted user
Created

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

0
Avatar
vasily chernov
Created

Hi David Heinrichs,

I've reproduced the problem.

Thank you.

0

Please sign in to leave a comment.