Java program to connect to Sql Server and running the sample query From Eclipse

Question

package sqlselection  import java sql Connection  import java sql DriverManager  import java sql ResultSet  import java sql Statement   public class Sqlselection                public static void main String   args                        try                               Class forName  com microsoft jdbc sqlserver SQLServerDriver                     String userName    sa                   String password    password                   String url    jdbc microsoft sqlserver   localhost 1433    databaseName AdventureWorks2008R2                   Connection con   DriverManager getConnection url  userName  password                   Statement s1   con createStatement                    ResultSet rs   s1 executeQuery  SELECT TOP 1   FROM HumanResources Employee                    String   result   new String 20                   if rs  null                       while  rs next                             for int i   0  i  lt result length  i                                                          for int j   0  j  lt result length j                                                                  result j  rs getString i                               System out println result j                                                                                                                   String result   new result 20                  catch  Exception e                                e printStackTrace                                 enter code here   The Above is my sample program to connect to the Sql server to run the sample select query from eclipse   I am getting the below error   java lang ClassNotFoundException  com microsoft jdbc sqlserver SQLServerDriver     at java net URLClassLoader 1 run Unknown Source      at java net URLClassLoader 1 run Unknown Source      at java security AccessController doPrivileged Native Method      at java net URLClassLoader findClass Unknown Source      at java lang ClassLoader loadClass Unknown Source      at sun misc Launcher AppClassLoader loadClass Unknown Source      at java lang ClassLoader loadClass Unknown Source      at java lang Class forName0 Native Method      at java lang Class forName Unknown Source      at sqlselection Sqlselection main Sqlselection java 13    i have added the sqljdbc jar sqljdbc4 jar to the library  Help to fix this

User · Answer

Just Change the query like this   SELECT TOP 1   FROM  HumanResources   Employee    where Employee is your table name and HumanResources is your Schema name if I am not wrong   Hope your problem will be resolved

User · Answer

download Microsoft JDBC Driver 4 0 for SQL Server which supports       SQL Server versions  2005  2008  2008 R2  and 2012      JDK version  5 0 and 6 0    Run the downloaded program sqljdbc   exe  It will extract the files into a specified directory  default is Microsoft JDBC Driver 4 0 for SQL Server   You will find two jar files sqljdbc jar  for JDBC 3 0  and sqljdbc4 jar  for JDBC 4 0   plus some  dll files and HTML help files   Place the sqljdbc4 jar file under your application   s classpath if you are using JDK 4 0 or sqljdbc4 1 jar file if you are using JDK 6 0 or later

User · Answer

you forgotten to add the sqlserver jar in eclipse external library follow the process to add jar files   Right click on your project  click buildpath click configure bulid path click add external jar and then give the path of jar

User · Answer

Right click your project--- Build path---- configure Build path----  Libraries Tab--- Add External jars---  Navigate to the location where you have kept the sql driver jar --- ok

User · Answer

Add sqlserver jar Here is link  As the name suggests ClassNotFoundException in Java is a subclass of java lang Exception and Comes when Java Virtual Machine tries to load a particular class and doesn t found the requested class in classpath      Another important point about this Exception is that  It is a checked Exception and you need to provide explicitly Exception handling while using methods which can possibly throw ClassNotFoundException in java either by using try-catch block or by using throws clause    Oracle docs  public class ClassNotFoundException  extends ReflectiveOperationException   Thrown when an application tries to load in a class through its string name using    The forName method in class Class  The findSystemClass method in class ClassLoader   The loadClass method in class ClassLoader      but no definition for the class with the specified name could be found

User · Answer

Refer the below link   There are two important changes that you should make  driver name as  com microsoft sqlserver jdbc SQLServerDriver    amp  in URL  jdbc sqlserver   localhost 1433    databaseName AdventureWorks2008R2   http   www programcreek com 2010 05 java-code-for-connecting-ms-sql-server-by-using-sql-server-authentication

User · Answer

The problem is with Class forName  com microsoft jdbc sqlserver SQLServerDriver    this line  The Class qualified name is wrong  It is sqlserver jdbc not jdbc sqlserver

User · Answer

The link has the driver for sqlserver  download and add it your eclipse buildpath

[java] Java program to connect to Sql Server and running the sample query From Eclipse

Examples related to java

Examples related to eclipse

Examples related to jdbc

Examples related to jdbc-odbc