add sql server driver in jaspersoft

Navigation
0

I'm trying to create a Data Adapter that connects to sql server 2008. When I created the Data Adapters, I selected the driver that gives me to select for sql server I put:

bd: RecursosHum

user: sa

password: sa

but when I give it a test it gives me an error: 

Reason:java.lang.ClassNotFoundException:
com.microsoft.sqlserver.jdbc.SQLServerDriver

I think the problem is that jaspersoft does not have the sql server driver installed and I wanted to add driver to the jasper but I have not found anything useful for me.

I tried to put the driver that I downloaded into the jaspersoft plugins folder but nothing.

    
asked by Omar Miranda 10.04.2017 в 15:44
source

1 answer

0

It is necessary to include the MS SQL Server JDBC JAR file in Jaspersoft Studio. You can download it from the Microsoft website. Then, to use them in Jaspersoft Studio do this:

  • Click on your project in the Project Explorer and select Build Path-> Configure Build Path.

  • On the Libraries tab Click on Add External JARs ...

  • Find the JDBC JAR file.

    • answered by 10.04.2017 / 17:11
    source
    (Incomparable Types: String and Order) Compare an entry in JTextField with the database in JPA How to upload an excel file that is in a folder contained in the same path of the .exe?