db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Greg Monroe <Greg.Mon...@dukece.com>
Subject RE: Can I use torque over ssh?
Date Thu, 04 Mar 2010 14:25:09 GMT
All true... but remember that interaction with an SQL Server (regardless 
of the method) is generally net traffic intensive.  Using a method like
this has two possible "gotchas".

First, the added complexity may cause communication problems.  SQL Servers
are not built around handling frequently dropping packets/clients.  Your
code will need to do a lot of transaction protection and you will need to
be prepared to clear out deadlocks created by clients dropping.

Also, distance and SSH are both going to add some lag factors.  So don't 
expect the normal SQL rapid response.  Make sure all your users are 
aware of this too.

Bottom line, IMHO, this is probably OK for something that just retrieves
a little bit of data... with a nice stable network connection and users
who don't mind lag/variable response times.  But I wouldn't build a 
fully interactive app that allows data modification, etc with it.

> -----Original Message-----
> From: Emmanuel Bardet [mailto:ebardet@bardet-u2ee.com]
> Sent: Thursday, March 04, 2010 3:16 AM
> To: Apache Torque Users List
> Subject: Re: Can I use torque over ssh?
> Hello Ludwig,
> It's not really Torque related but more to your jdbc driver.  From an
> ssh perspective, as long as it uses TCP/IP to connect to your database
> server AND IF your ssh server allows ssh-tunneling (ana ssh-port-
> forwarding) then you should be fine.  There's a few how-to available.
> E
> Le 4 mars 10 à 04/03-08:56, Ludwig Magnusson a écrit :
> > Hi!
> >
> > If I have a database on a server that I can connect to via ssh, can
> > I use
> > torque to access that database? I.e write a java program that runs
> > on my
> > compyter but reads/writes to the database.
> >
> > Can I also run maven goals like torque:datadump that connects to the
> > remote
> > database?
> >
> > /Ludwig
> >
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org

DukeCE Privacy Statement:
Please be advised that this e-mail and any files transmitted with
it are confidential communication or may otherwise be privileged or
confidential and are intended solely for the individual or entity
to whom they are addressed. If you are not the intended recipient
you may not rely on the contents of this email or any attachments,
and we ask that you please not read, copy or retransmit this
communication, but reply to the sender and destroy the email, its
contents, and all copies thereof immediately. Any unauthorized
dissemination, distribution or copying of this communication is
strictly prohibited.

To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

View raw message