How to Connect to Microsoft SQL Server in Eclipse IDE

Показать описание

In this video, I'd like to share with you how connect to Microsoft SQL Server in Eclipse IDE using Database Development perspective. It would be helpful in case you need to manage data in a remote SQL server instance but you don't have any SQL server client tools on your computer.

In details, I will show you:
- Download SQL Server JDBC driver
- Make connection to a SQL server database
- View & Edit data in a table
- Execute SQL statements

Software programs:
- Java Development Kit (JDK)
- Eclipse IDE for Enterprise Java Developers
- Microsoft SQL Server 2019 (Express edition)

Рекомендации по теме

Комментарии

Holy shit - Eclipse is absolute dog shit when it comes to this. All the default SQL Server stuff is "broken" as you say and I fully agree. Was setting up and it wasn't giving me any properties window, no error messages, nothing to help me figure out why it wasn't working AT ALL. Wasted so many hours trying to figure this out. Using "Other Driver" and your settings was the saving grace. They should link your video from that window no joke. Your video freggin saved me so much, thank you!!!

tbrizOfficial

The TCP/IP connection to the host SV5503DB1021 qlexpress, port 1433 has failed. Error: "null. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".

RohitThirukarthick

Thank you very much, you are awesome!!!

jmrodriguez

What should I do if my schemas aren t showing when I expand ‘Schemas’ folder from my database project

mirrajeac

1/I had an error when I try to edit data from a table. The error message says: "Cannot edit table. An unknown or unsupported data type encountered for column <my column name>" . That column name "Hoten" and it's data type is nvarchar(50). So pls help me ..
2/When I try to add new connection URL. It's only work when I use URL So why it's must be "localhost" instead of
I'm learning Java Web for my school Java Project and I'm VietNamese too but I want to practice English so I wrote this comment:))

minhnguyenquang

Can you make a video series for React
or Angular?

ashwinvp

Thank you so much for this. I was struggling to connect for a JPA project and my problem was that the Spring Boot connection string has \\sqlexpress where from the IDE it is a single \sqlexpress SAVED my bacon. Thanks again

tartanclips

I had a problem during setup:
The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "No appropriate protocol (protocol is disabled or cipher suites are inappropriate)".
I'm using sqljdbc_12.4.1lib
How can I fix it?

MrHungdangtuan

I couldn't able to edit the url connection in Properties. I am literally connecting MSSQL server with IP adddess. But i was need to add Encrpt: true, Trustcertificates:true; but it was neglacting

rameshkannan

Anh người việt bảo sao em nghe rõ tiếng anh thế. anh có kênh tiếng việt không ạ.

daotuyentravel

thank you so much, this video really help me ... when I tried to edit the data this message appear "Cannot edit table. An unknown or unsupported data type encountered for column Template."

sabahalhasan

hi anh
em đã tạo được nhưng tới đoạn edit table(14:27) nó báo lỗi Cannot read the array length because "editors" is null
# các table của em đều đã có dữ liệu rồi ạ
mong anh phản hồi sớm

changtraitre