Hi all,

I have got the following error whilst trying to connect the DataSource with Websphere.

DataSource: SQL Server 2008 r2

Error Details:

The test connection operation failed for data source Microsoft SQL Server JDBC Driver - DataSource on server server1 at node WINLotus3Node01 with the following exception: java.lang.ClassNotFoundException: DSRA8000E: No jar or zip files found in C:\Program Files\Microsoft SQL Server\Microsoft SQL Server JDBC Driver 2.0\sqljdbc_2.0\enu\sqljdbc.jar/sqljdbc.jar. View JVM logs for further details.


There are no errors on the JVM logs when I checked it. 

I am failry new to websphere, I would be grateful if anyone would point me to the right direction.
 

Hi Bishal,


  Check if you have the next file in the directory, you are having:

   DSRA8000E: No jar or zip files found in

  C:\Program Files\Microsoft SQL Server\Microsoft SQL Server JDBC Driver 2.0\sqljdbc_2.0\enu\sqljdbc.jar/sqljdbc.jar

  Your driver is pointing to this file and you have used it to implement your datasource, so you need the file sqljdbc.jar in the next directory:

  C:\Program Files\Microsoft SQL Server\Microsoft SQL Server JDBC Driver 2.0\sqljdbc_2.0\enu\sqljdbc.jar/

  Hope this helps.  Tell us if you need more support.

Regards,

Hi Gabriel,

Thanks for the update.

I have sqljdbc on that file path but still it is complaining.

When you say in the next directory what do you mean?

Many thanks. 

Bishal,

  Ok, you have the file.  And what class are you using to implement the datasources? is the last option when you configure the driver something like ms.sqlserver.connectionPollDatasource.

  This class is what is not founding in the sqljdbc.jar.  check the class (open the jar) inside the sqljdbc.jar

regards,

Hi Gabriel,

Inside the sqljdbc.jar there are classes but I do not know if you are looking for anything in particular.

Hi again,

can you explain what is the difference between the JDNC driver path and the driver nativepath.

Thanks in advance. 

Bishal,
 
   you have twice sqljdbc.jar
   
   C:\Program Files\Microsoft SQL Server\Microsoft SQL Server JDBC Driver 2.0\sqljdbc_2.0\enu\sqljdbc.jar/sqljdbc.jar
 
   You need to point to (don't unzip sqljdbc.jar):
   
   C:\Program Files\Microsoft SQL Server\Microsoft SQL Server JDBC Driver 2.0\sqljdbc_2.0\enu\sqljdbc.jar
   
   JDBC Driver path point to your driver (jar or zip file(s))

   The driver native path point to your native libraries (dll in windows so in *nix)
   
   The native libraries are needed when you use T2 driver (local, DB in same machine) if you use T4 (DB in remote machine) you don't need native libraries.
   
   Normally in SQL Server sqljdbc.jar is T2 driver so you need to read how to install the driver usually at this level
   
     C:\Program Files\Microsoft SQL Server\Microsoft SQL Server JDBC Driver 2.0\sqljdbc_2.0\enu\
    
  You will have a directory with instructions on how to install the driver.
 
  I suggest to use the next driver:
    Microsoft SQL Server JDBC Driver 3.0
    www.microsoft.com/en-us/download/details...

  Hope this helps.  tell us if you need more support.

regards,
 

HI Gabriel,

I am still having problems regarding the sqljdbc.jar.

I have attached images in order of creating a JDBC provider and a data source connection.

I would be grateful if you could have a look at those.

I might have selected the wrong category, whilst creating a provider or a data source.

I have glanced at the documentation and it advices to use either sqljdbc.jar or sqljdbc4.jar but when I delete 1 of them and use the other one, it complains about the deleted jar file not being there.

Urgently in need of your suggestion.
 

Bishal,

  At your JDBC provider:

  Resources-JDBC Provideers-> SQL Server provider 

  change sqljdbc.jar by sqljdbc4.jar and restart the server.

  You will use a T4 driver if you have DB in same machine of WAS you can configure T2 driver.

  In the datasource definition is a good practice that the jndi name be


regards


regards,

Hi Gabriel,
Many thanks for your reply and suggestions.

I have also configured with the options you have mentioned but as soon as I choose sqljdbc4.jar, i asks for sqljdbc.jar and vice versa.

 

Thanks Gabriel, I managed to solve it by configuring it as sqljdbc4.jar after the actual {system_path..}