chemat92 Posted November 12, 2014 Share Posted November 12, 2014 Hi, I am new to jaspersoft. I have some problem. I wanna create new data adapter or use present data adapter in Jaspersoft studio 5.6.1 and 5.6.2, but I have error. It prompt this error : "Exception, if you want to see more information look into details. Reason : java.lang.ClassNotFoundException : com.microsoft.sqlserver.jdbc.SQLServerDriver."I have this error when I am using community edition. But when I switched to professional version, this error not prompted. How to solve this issue? ThanksHere is the error details :net.sf.jasperreports.engine.JRRuntimeException: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:173) at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:128) at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:129) at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.run(AbstractDataAdapterWizard.java:165) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:501) at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:421) at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:412) at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:175) at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:145) ... 4 more Link to comment Share on other sites More sharing options...
james.t Posted November 14, 2014 Share Posted November 14, 2014 You need to include the MS SQL Server JDBC JAR file in Jaspersoft Studio.You can download this from Microsoft's website. Then to use them in Studio do this:1. Right-click on your project in the Project Explorer and then select Build Path->Configure Build Path.2. From the Libraries tab click Add External JARs...3. Find your JDBC JAR file Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now