New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL Server: error line number/position #4816

Closed
novusnick opened this Issue Dec 17, 2018 · 5 comments

Comments

Projects
None yet
3 participants
@novusnick
Copy link

novusnick commented Dec 17, 2018

To whom it may concern,
Could the line number of the sql error be added to the error output? In my query, I'm including the database name for all the tables and the error output shows that I have an error near the database name, but since each of the columns have the database name, it's too generic an error message without the line number. Thank you for all your help with this

@serge-rider

This comment has been minimized.

Copy link
Member

serge-rider commented Dec 20, 2018

If database driver supports error position detection then DHBeaver shows it (at least for MySQL, PostgreSQL, Oracle and some other).
What is your database?

@novusnick

This comment has been minimized.

Copy link
Author

novusnick commented Dec 20, 2018

I'm using SQL Server with the Microsoft driver

@serge-rider serge-rider added this to the 5.3.3 milestone Dec 21, 2018

@serge-rider

This comment has been minimized.

Copy link
Member

serge-rider commented Dec 21, 2018

Unfortunately SQL Server doesn't support this at the moment.
I've created a FR (Microsoft/mssql-jdbc#885) and, surprisingly fast, these guys made it.
So, once 7.1.4 will be released and tested I'll add this feature to SQL Server (Microsoft driver) extension.

@serge-rider serge-rider changed the title Add line number of error in "Error Executing Query" window SQL Server: error line number/position Dec 21, 2018

@novusnick

This comment has been minimized.

Copy link
Author

novusnick commented Dec 21, 2018

That sounds good- thanks Serge

serge-rider added a commit that referenced this issue Jan 12, 2019

serge-rider added a commit that referenced this issue Jan 12, 2019

@serge-rider

This comment has been minimized.

Copy link
Member

serge-rider commented Jan 12, 2019

You can try it in Early Access version (https://dbeaver.io/files/ea).

Note: error positioning works only with driver version 7.1.4+ . If you used SQL Server connection before you need to go to driver settings, click on Download/Update and change the driver version:

image

@uslss uslss removed the ready for qa label Jan 12, 2019

@uslss uslss closed this Jan 12, 2019

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment