Is there a setting that I can change that would allow verj.io to connect to a sql server that has SSL enabled?
I've had an application running beautifully for 1+ years and now it is no longer able to make the sql connection after the SSL was enabled.
When testing the database connection from the admin application I get the following returned...
REST service failed: JavaException: com.ebasetech.ufs.utility.PersistenceException: Error getting database connection from IERP_SUPPLYCHAIN, I/O Error: DB server closed connection.
SQL Server using SSL
Moderators: Jon, Steve, Ian, Dave
-
- Ebase User
- Posts: 19
- Joined: Tue Oct 03, 2017 3:33 pm
- Location: USA
-
- Ebase User
- Posts: 649
- Joined: Mon Dec 09, 2013 6:37 pm
Re: SQL Server using SSL
Can you explain your set up ?
I'm not sure if I understand this correctly but you set up a REST end point in Verj that connects to SQL Server right ?
Can you provide code that shows how you connect to SQL Server in the REST service ?
I'm not sure if I understand this correctly but you set up a REST end point in Verj that connects to SQL Server right ?
Can you provide code that shows how you connect to SQL Server in the REST service ?
0 x
-
- Moderator
- Posts: 1342
- Joined: Wed Sep 12, 2007 12:49 pm
Re: SQL Server using SSL
Resolved using Ebase support system.
You need to add ssl=require to the URL connection string. See the SSL section of the Jtds driver:
http://jtds.sourceforge.net/faq.html
SSL is switched off by default.
You will need to modify the JDBC connection URL. Modify the Resource URL to (adding ssl=require):
Note that this only applies to the Jtds driver. You can tell if you are using this because of the start of the URL: jdbc:jtds ....
Also you might want to check all the connections using the Ebase Admin App (ebaseAdmin.eb) and add ssl=require to any JTDS connection URLs in here.
You need to add ssl=require to the URL connection string. See the SSL section of the Jtds driver:
http://jtds.sourceforge.net/faq.html
SSL is switched off by default.
You will need to modify the JDBC connection URL. Modify the Resource URL to (adding ssl=require):
Code: Select all
jdbc:jtds:sqlserver://<server-name>/<database-name>;ssl=require
Also you might want to check all the connections using the Ebase Admin App (ebaseAdmin.eb) and add ssl=require to any JTDS connection URLs in here.
0 x
Who is online
Users browsing this forum: No registered users and 7 guests