StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POJDBC connection hangs with no response from SQL Server 2008 r2
text
Body
copied!<p>When connecting to SQL Server 2008 (express locally, full server in production) this works fine for me when developing on my local machine, but this thing just hangs in production.</p> <p>Here is the code :</p> <pre><code>package oata; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import sun.applet.Main; public class Sql { public static final String SQLDRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; protected Connection conn = null; private String ip = ""; private int port = 0; private String databaseName = ""; private String db_userid = ""; private String db_password = ""; public void callDb(String[] args) throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException{ System.out.println("Initialising variables"); ip = args[0]; port = Integer.parseInt(args[1]); databaseName = args[2]; db_userid = args[3]; db_password = args[4]; try{ Log logger = LogFactory.getLog(Main.class); System.out.println("Opening logger..."); logger.debug("opening driver " + SQLDRIVER); System.out.println("Creating connection instance..."); Class.forName(SQLDRIVER).newInstance(); System.out.println("Driver Manager.getConnection..."); conn = DriverManager.getConnection(getDBURL(), db_userid, db_password); System.out.println("Connection prepare statement..."); PreparedStatement ps = conn.prepareStatement("select * from nstupersonal"); System.out.println("Executing query..."); ResultSet rs = ps.executeQuery(); while(rs.next()){ System.out.println(rs.getString("StudentId")); } }catch(Exception e){ System.out.println(e.getMessage()); } conn.close(); } private String getDBURL(){ String url = ""; try { url = "jdbc:sqlserver://" + ip +":" + port +";databaseName="+ databaseName + ";user=" + db_userid + ";password="+db_password; } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } return url; } } </code></pre> <p>That's the code that gets run. In the console it literally just hangs in production. It always seems to hang on SQL server 2008 but works fine in production for all my other customers. Runs simiply with...</p> <p>TCP/IP is enabled on 1433 in SQL Server and allow remote connections is set to true in the management console.</p> <p>java -jar ipaddress port dbname user password</p> <p>Any ideas? Is the SQL driver wrong? I'm using sqljdbc4.jar </p> <p>The resulting command prompt is...</p> <p>Initialising variables Opening logger... Driver Manager.getConnection...</p> <p>No exception gets thrown</p> <p>Thanks,</p> <p>D</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload