A A A

Please consider registering
guest

Log In

Lost password?
Advanced Search:

— Forum Scope —



— Match —



— Forum Options —




Wildcard usage:
*  matches any number of characters    %  matches exactly one character

Minimum search word length is 4 characters - maximum search word length is 84 characters

Topic RSS
Sybase ASE JDBC +SSL connection.
August 13, 2015
10:54 am
Lo0oM
Admin
Forum Posts: 217
Member Since:
September 30, 2012
Offline

Hi

 

Description:

I have Sybase ASE 15.0 server installed and need to connect to it using JDBC through SSL. SSL already configured on Sybase server.

 

 

Solution:

1. I will use NetBeans program which can be downloaded for free from here: 1

2. Also i will use jconnect JDBC sybase driver, can be downloaded for free from SAP: 1

3. Now install both programs and run NetBeans.

4. After starting program right click on "services" tab, "drivers" folder and choose "New Driver"

In new "Customise JDBC Driver" windows click "Add" choose path to jcon driver, in my case:

C:SybasejConnect-7_0classesjconn4.jar

 

In "Driver Class" you will see:

com.sybase.jdbc4.jdbc.SybDataSource

 

In "Name" you can write anything. Click "OK"

 

5. Now you will see "Name" you wrote above in Drivers list.

Right click on it and choose "Connect using"

 

In "JDBC URL" write:

jdbc:sybase:Tds:10.10.10.2:5004/dbname?ENABLE_SSL=true

 

where 10.10.10.2 is Sybase server IP

5004 is DB SSL port.

 

Thank you.

Forum Timezone: UTC 0

Most Users Ever Online: 31

Currently Online:
2 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 0

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 3

Forums: 20

Topics: 214

Posts: 214

Newest Members: Lo0oM

Administrators: Lo0oM (217)