JDBC - Please light my Sky

• Cláudia Sousa Rego

  SSCommitted

  Points: 1780

  More actions

  July 12, 2005 at 9:42 am

  #69305

  Hello, guys!!

  Finally I have my replication done and now I have the data avaliable for my Java application.

  I think that the fist step is establish a connection between SQL Server and Java.

  I heard JDBC but I hava SQL SErver 7

  Any good article to light my sky???

  Thanks,

  Claudia

  ---

  Regards,

  Cláudia Rego

  www.footballbesttips.com

• John Snyder

  Grasshopper

  Points: 21

  More actions

  July 13, 2005 at 7:12 am

  #573859

  Try this:

  <%@ page import="java.sql.*"  %>

  String driver = "sun.jdbc.odbc.JdbcOdbcDriver";

  String url = "jdbc:odbc:{your sql server name here}";

  String sSQL;

  ResultSet rs = null;

  String intrnalfield;

  Build your sSQL string

  in a try block

      Class.forName(driver);

      con = DriverManager.getConnection(url, user, password);

      stmt = con.createStatement();

      rs = stmt.executeQuery(sSQL);

      while (rs.next()) {

         internalfield = (rs.getString("{SQL_Field_Name}"));

   }

      rs.close();

  Note: user and password is for the SQL User

  items in red should be replaced with appropriate names

• Shane Petroff

  Old Hand

  Points: 384

  More actions

  July 18, 2005 at 11:03 am

  #575256

  The ODBC bridge is a last resort. No one involved in making the product recommends that it be used for production work.

  When we dumpled CrystalReports in favour of something which actually works, we also bought into their JDBC driver. See http://www.inetsoftware.de/ While I haven't used SQL7 in a long time, when we first made the transition the Opta driver worked in that environment too.