Identifier expected, (already searched and read about this, still confused

[jim gemlo]

Here is my class:

  package osg;
 
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */
import java.sql.*;
 
public class sqlValues {
  
  private String hello = "h";
  private String id = "o";
  private String pass = "a";
  private String url = "jdbc:microsoft:sqlserver://dbatest\\dbatest2k:1433;databasename=OSGServ_Test2";
  private String sqlInsert = "INSERT INTO dbo.SERVER_DIM (srvr_nme, osg_supp_fname, osg_supp_lname) values " +
                                "(?,?,?)";
  private String sql1 = "SELECT DISTINCT osg_supp_fname FROM dbo.SERVER_DIM";
  private String sql2 = "SELECT DISTINCT srvr_nme FROM dbo.SERVER_DIM";
 
  Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
  Connection conn = DriverManager.getConnection(url, id, pass);
  PreparedStatement stmtInsert = conn.prepareStatement(sqlInsert);
  PreparedStatement stmt1 = conn.prepareStatement(sql1);
 

}

getting identifier expected at the 'Class.forName'line.

This same piece of code works fine when I have it in a jsp page. Im trying to place this code in a Bean so I can remove business logic from my page. So I created this class and get the error.
thanks

[Jeffrey Hunter]

You need to wrap your expressions inside a method. Right now, you have your variables declared correctly as instance variables, but you cannot have those expressions in the class scope. For instance, the following Class, though useless, represents the proper structure:

 
class Test {
   private String instanceVariable;
 
   public void Foo() {
     try {
        Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
     }
     catch(java.lang.ClassNotFoundException e) {}
   }
}
 

[ July 02, 2004: Message edited by: Jeffrey Hunter ]