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:ebar...@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-unsubscr...@db.apache.org > For additional commands, e-mail: torque-user-h...@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-unsubscr...@db.apache.org For additional commands, e-mail: torque-user-h...@db.apache.org