Getting data through an SSH tunnel using Hibernate

Question

I recently started to learn Hibernate technology and have to get data from a database using Hibernate. The problem is that I can connect to the database only via an SSH tunnel. Are there any properties which I can use in the hibernate.cfg.xml file to solve this problem? Or may be you can suggest another way which will be understandable to a newbie.

Can you build a simple JDBC connection through this SSH tunnel? What DB do you use? — user647772
– user647772, Commented Sep 7, 2012 at 11:33
@Tichodroma , previosly I tried to connect to this MySQL database only manually, using MySQL clients... — Victoria
– Victoria, Commented Sep 7, 2012 at 11:44

BendaThierry.com · Accepted Answer · 2012-09-07 14:26:55Z

5

Maybe using Jsch. Some examples could give you a way to go.

Another way could be implementing your own SSH SocketFactory, maybe with http proxy handler and port forwarding stuff. A starting point could be:

SSHSocketFactory fact = new SSHSocketFactory(sshHost, sshPort, new SSHPasswordAuthenticator(sshUser, sshPassword));

sock = fact.createSocket(host, port);

And you could link your implementation with the following parameter inside your hibernate.cfg.xml file:

hibernate.connection.socketFactory=com.mysql.jdbc.NamedPipeSocketFactory

Or maybe like the way they do here or here (the latter is the better way to go).

Good ssh stuff!

edited Sep 7, 2012 at 14:26

answered Sep 7, 2012 at 14:18

BendaThierry.com

2,1281 gold badge16 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

sampopes Over a year ago

shared link(latter one) doesn't work anymore.

Collectives™ on Stack Overflow

Getting data through an SSH tunnel using Hibernate

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related