#1 2016-03-28 01:30:42

ramesh
Member
Registered: 2016-03-15

DataBase Connection with SQLSERVER

Hi ,

I am trying to run birt report with MSSQLSERVER database and JTDS drivers.  it is working with jdbc:sqlserver://192.606.21.15:12120;databaseName=MYDEV

but i want to use jtds drivers , as adding-support-for-additional-databases-to-reportserver-firebird article i added MSSQLSERVER hook and when i am testing i am getting following error

net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: Could not open connection to: jdbc:jtds:sqlserver://192.606.21.15:12120;databaseName=MYDEV with user: MFINEC. java.sql.SQLException: No suitable driver.

Offline

#2 2016-03-28 08:58:12

Arno Mittelbach
datenwerke
Registered: 2012-02-14

Re: DataBase Connection with SQLSERVER

Offline

#3 2016-03-30 03:53:27

ramesh
Member
Registered: 2016-03-15

Re: DataBase Connection with SQLSERVER

Thanks for your replay. as per link provided  in https://reportserver.net/blog/2015/10/3 … -via-jtds/  , i have created JTDSSqlServer.java for MSSQLHOOK and created Groovy script and executed in terminal.

then i have created new data source for MSSQL and provided connection parameters below

jdbc:jtds:sqlserver://112.120.11.102:618/MY_DEV  and apply , when i am executing report i am getting following error.

23:40:07,497 WARN  [com.mchange.v2.resourcepool.BasicResourcePool] (C3P0PooledConnectionPoolManager[identityToken->1hgeb7w9f1itm3r2azwcfb|51ff7fe7]-HelperThread-#1) Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@44f4f7ee is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
23:40:07,482 WARNING [net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$a9289d51] (http--127.0.0.1-8080-1) The report could not be executed: Could not open connection to: jdbc:jtds:sqlserver://172.20.1.205:61820/MFINAFP_DEV with user: MFINEC. java.sql.SQLException: No suitable driver: net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: Could not open connection to: jdbc:jtds:sqlserver://112.120.11.102:618/MY_DEV with user: MFINEC. java.sql.SQLException: No suitable driver
    at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:218) [rscore.jar:]
    at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:119) [rscore.jar:]
    at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exeucteReport(ReportExportServlet.java:527) [rscore.jar:]
    at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doExportReport(ReportExportServlet.java:407) [rscore.jar:]
    at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReport(ReportExportServlet.java:333) [rscore.jar:]
    at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReportViaSession(ReportExportServlet.java:326) [rscore.jar:]
    at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doGet(ReportExportServlet.java:164) [rscore.jar:]
    at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$a9289d51.CGLIB$doGet$0(<generated>) [guice-3.0.jar:]
    at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$a9289d51$$FastClassByGuice$$f7fb1506.invoke(<generated>) [guice-3.0.jar:]
    at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) [guice-3.0.jar:]
    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:]
    at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:66) [guice-persist-3.0.jar:]
    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:]
    at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110) [dwsecurity.jar:]
    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:]
    at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) [guice-3.0.jar:]
    at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$a9289d51.doGet(<generated>) [guice-3.0.jar:]
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
    at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$a9289d51.CGLIB$service$15(<generated>) [guice-3.0.jar:]
    at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$a9289d51$$FastClassByGuice$$f7fb1506.invoke(<generated>) [guice-3.0.jar:]
    at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) [guice-3.0.jar:]
    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:]
    at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110) [dwsecurity.jar:]
    at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:]
    at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) [guice-3.0.jar:]
    at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$a9289d51.service(<generated>) [guice-3.0.jar:]
    at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263) [guice-servlet-3.0.jar:]
    at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178) [guice-servlet-3.0.jar:]
    at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91) [guice-servlet-3.0.jar:]
    at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62) [guice-servlet-3.0.jar:]
    at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89) [guice-persist-3.0.jar:]
    at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163) [guice-servlet-3.0.jar:]
    at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]
    at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118) [guice-servlet-3.0.jar:]
    at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113) [guice-servlet-3.0.jar:]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.13.Final.jar:]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]
    at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final]
    at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]
    at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_80]
Caused by: net.datenwerke.rs.core.service.reportmanager.exceptions.DatabaseConnectionException: Could not open connection to: jdbc:jtds:sqlserver://112.120.11.102:618/MY_DEV  with user: MFINEC. java.sql.SQLException: No suitable driver
    at net.datenwerke.rs.birt.service.datasources.birt.transformers.BirtDBDatasourceTransformer.transform(BirtDBDatasourceTransformer.java:48) [rsbirt.jar:]
    at net.datenwerke.rs.birt.service.datasources.birt.transformers.BirtDBDatasourceTransformer.transform(BirtDBDatasourceTransformer.java:1) [rsbirt.jar:]
    at net.datenwerke.rs.core.service.datasourcemanager.datasourcetransformers.DatasourceDefinitionTransformerManager.transform(DatasourceDefinitionTransformerManager.java:49) [rscore.jar:]
    at net.datenwerke.rs.birt.service.reportengine.BirtReportEngine.doExecute(BirtReportEngine.java:68) [rsbirt.jar:]
    at net.datenwerke.rs.core.service.reportmanager.engine.ReportEngine.execute(ReportEngine.java:127) [rscore.jar:]
    at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:186) [rscore.jar:]
    ... 49 more
Caused by: java.lang.RuntimeException: java.sql.SQLException: No suitable driver
    at net.datenwerke.dbpool.DbC3p0PoolServiceImpl$1.get(DbC3p0PoolServiceImpl.java:158) [dwdbpool.jar:]
    at net.datenwerke.dbpool.DbC3p0PoolServiceImpl$1.get(DbC3p0PoolServiceImpl.java:1) [dwdbpool.jar:]
    at net.datenwerke.rs.birt.service.datasources.birt.transformers.BirtDBDatasourceTransformer.transform(BirtDBDatasourceTransformer.java:45) [rsbirt.jar:]
    ... 54 more
Caused by: java.sql.SQLException: No suitable driver
    at java.sql.DriverManager.getDriver(DriverManager.java:278) [rt.jar:1.7.0_80]
    at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:240) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:146) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:195) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:211) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648) [mchange-commons-java-0.2.3.4.jar:]

23:40:07,555 WARN  [com.mchange.v2.resourcepool.BasicResourcePool] (C3P0PooledConnectionPoolManager[identityToken->1hgeb7w9f1itm3r2azwcfb|51ff7fe7]-HelperThread-#1) com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@4b52e8af -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (10). Last acquisition attempt exception: : java.sql.SQLException: No suitable driver
    at java.sql.DriverManager.getDriver(DriverManager.java:278) [rt.jar:1.7.0_80]
    at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:240) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:146) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:195) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:211) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648) [mchange-commons-java-0.2.3.4.jar:]

23:40:07,485 WARN  [com.mchange.v2.resourcepool.BasicResourcePool] (C3P0PooledConnectionPoolManager[identityToken->1hgeb7w9f1itm3r2azwcfb|51ff7fe7]-HelperThread-#0) com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@18c25861 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (10). Last acquisition attempt exception: : java.sql.SQLException: No suitable driver
    at java.sql.DriverManager.getDriver(DriverManager.java:278) [rt.jar:1.7.0_80]
    at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:240) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:146) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:195) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:211) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648) [mchange-commons-java-0.2.3.4.jar:]

23:40:07,485 WARN  [com.mchange.v2.resourcepool.BasicResourcePool] (C3P0PooledConnectionPoolManager[identityToken->1hgeb7w9f1itm3r2azwcfb|51ff7fe7]-HelperThread-#2) com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@7f3854f9 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (10). Last acquisition attempt exception: : java.sql.SQLException: No suitable driver
    at java.sql.DriverManager.getDriver(DriverManager.java:278) [rt.jar:1.7.0_80]
    at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:240) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:146) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:195) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:211) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810) [c3p0-0.9.2.1.jar:0.9.2.1]
    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648) [mchange-commons-java-0.2.3.4.jar:]

Offline

#4 2016-03-30 06:17:19

Arno Mittelbach
datenwerke
Registered: 2012-02-14

Re: DataBase Connection with SQLSERVER

Have you downloaded the jtds driver?

Offline

#5 2016-03-30 13:01:01

ramesh
Member
Registered: 2016-03-15

Re: DataBase Connection with SQLSERVER

yes i have download jtds-1.2.5.jar from site and put in web-inf\lib directory . there is errors for CLASSNOTFOUNDEXCEPTION ir NOCLASSDEFFOUNDERROR, i am sure that driver class files are available in classpath .

This is my connection string


jdbc:jtds:sqlserver://112.10.111.125:15999;databaseName=MYP_DEV

Offline

#6 2016-03-30 14:23:20

Arno Mittelbach
datenwerke
Registered: 2012-02-14

Re: DataBase Connection with SQLSERVER

Hi Ramesh,

to ensure that the driver is indeed available on the classpath you could use the following script:

try{
  Class.forName("net.sourceforge.jtds.jdbc.Driver");
  return "driver is available";
} catch(all) {
 	return "Driver is missing: " + all.getClass() + " (" + all.getMessage() + ")";
}

Offline

#7 2016-03-30 15:18:22

ramesh
Member
Registered: 2016-03-15

Re: DataBase Connection with SQLSERVER

Hi,

as you said i have writen simple jsp file to test driver loaded with your snippet , driver loaded and it is available in classpath.

<%
       out.println("testing net.sourceforge.jtds.jdbc.Driver ");
try{
  Class.forName("net.sourceforge.jtds.jdbc.Driver");
  out.println("driver loaded sucessfully");
} catch(Exception all) {
   
    out.println(all.getMessage());
    all.printStackTrace();
}

%>


output : testing net.sourceforge.jtds.jdbc.Driver driver loaded sucessfully


i have concern on URL format


jdbc:jtds:sqlserver://112.110.1.115:618/MYAPP_DEV

Offline

#8 2016-03-30 15:24:22

Arno Mittelbach
datenwerke
Registered: 2012-02-14

Re: DataBase Connection with SQLSERVER

Does it also work if you run this as a ReportServer script?

Offline

#9 2016-03-30 15:44:56

ramesh
Member
Registered: 2016-03-15

Re: DataBase Connection with SQLSERVER

Hi Arno,

I ram my birt report once test the testdriver.jsp file then i am able to view results from database, for testing purpose i logout and login then run report only it is getting same problem  then it means mssql.groovy doesn;t work properly?

Offline

Board footer

Powered by FluxBB