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!!!
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.".
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 " . 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 "jdbc:sqlserver://localhost;databaseName=JavaWebDemo". So why it's must be "localhost" instead of /[serverName[\instanceName][:portNumber]] 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:))
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
I had a problem during setup: com.microsoft.sqlserver.jdbc.SQLServerException: 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?
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."
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
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
@@CodeJava in url do we have to write the same thing that u have written. Cuz I m getting an error that says the connection to host sqlserver, named instance sqlexpress failed. No such host is known...help me with this.
then you should use the JDBC URL like this: jdbc:sqlserver://localhost;integratedSecurity=true; Reference: www.codejava.net/java-se/jdbc/connect-to-microsoft-sql-server-via-jdbc
em bị lỗi này ạ com.microsoft.sqlserver.jdbc.sqlserverexception: the driver could not establish a secure connection to sql server by using secure sockets layer (ssl) encryption
@@CodeJava i already use jdbc river 12.(the latest one) but still mess the same error like him. but when i add trustServerCertificate= true; in URL the error disappear, it not last long until reconnect. any helpful suggestion?
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!!!
Glad it helped :)
Thanks ! You saved my life!!!
Glad it helped!
Thank you very much, you are awesome!!!
Glad it helped!
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.".
thanks a lot friend!!!
You're welcome!
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 ạ.
không em ạ. chỉ có kênh English này thôi.
@@CodeJava lần đầu nghe cũng đoán ra anh người Việt, accent không thể lẫn đi đâu được :))
What should I do if my schemas aren t showing when I expand ‘Schemas’ folder from my database project
do you have any database schemas created before?
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 " . 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 "jdbc:sqlserver://localhost;databaseName=JavaWebDemo". So why it's must be "localhost" instead of /[serverName[\instanceName][:portNumber]]
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:))
Can you make a video series for React
or Angular?
I will do in future. Currently I'm busy completing my course on Udemy: www.udemy.com/course/spring-boot-e-commerce-ultimate/?couponCode=PERFECT
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
Hmm, I don't know why :(
i couldn't find mssql in enu
I had a problem during setup:
com.microsoft.sqlserver.jdbc.SQLServerException: 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?
If I remember correctly, you need to configure SQL server to allow listening on TCP/IP protocol.
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."
that means Eclipse unable to edit the data due to unrecognized data type. In this case, you need to use SQL Management Studio directly.
@@CodeJava you mean to create the table in eclipse directly ?
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
Glad it helped!
When i did the test connection it is showing ping failed
make sure SQL server is running
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
Hmm, sorry to hear that. It is still able to connect, isn't it?
Not it is not able to connect because we need to add Encrpt:true
I wanted to use a centralize server. is this how we do it? Help me with that...
yes, that is described in this video.
@@CodeJava in url do we have to write the same thing that u have written. Cuz I m getting an error that says the connection to host sqlserver, named instance sqlexpress failed. No such host is known...help me with this.
how do i find the url to my sql server
check this answer: stackoverflow.com/questions/16088151/how-to-find-server-name-of-sql-server-management-studio
What if we are using windows authentication not remote server??
then you should use the JDBC URL like this: jdbc:sqlserver://localhost;integratedSecurity=true;
Reference: www.codejava.net/java-se/jdbc/connect-to-microsoft-sql-server-via-jdbc
@@CodeJava Tried this. But error says 'Enter a user name.' Please help
@@priyanthafernando2849 you need to know username and password of the database.
@@CodeJava but im using windows authentication. It does not have username and password ☹️?
@@priyanthafernando2849 Windows Auth doesn't require credentials as it uses the current Windows user.
What is the password where can i find?
it's the password you set when you install SQL Server (localhost). If it is a remove server, you need to ask your database admin.
What did you smoke
why do you ask that?
em bị lỗi này ạ
com.microsoft.sqlserver.jdbc.sqlserverexception: the driver could not establish a secure connection to sql server by using secure sockets layer (ssl) encryption
maybe the JDBC driver version is outdated. Check and use the latest one.
@@CodeJava i already use jdbc river 12.(the latest one) but still mess the same error like him. but when i add trustServerCertificate= true; in URL the error disappear, it not last long until reconnect. any helpful suggestion?