SQLServer2008 datasource

jneundorf · 2014-02-24 17:18:17

I'm having some trouble setting up a working connection to a SQLServer2008 datasource. It would be great if someone could assist or point out what I'm missing ...

I set up the SQLServer data source in the web interface - BTW I can connect and query MySQL datasources successfully - when I test hte connection I get a driver not found error message. Below are the error details.

I have installed the driver files in WEB-INF/lib as sqljdbc.jar & sqljdbc4.jar. Tomcat has been restarted too.

So somehow I've fialed to connect the com.microsoft.sqlserver.jdbc.SQLServerDriver to the sqljdbc4.jar file (I even tried a symbolic link) and am stumped as to what to try next. I've been through the admin & config doc without success.

Please steer me in the right direction if you can, thanks.

Jim.

ERROR DETAILS

Error
Could not open connection to: jdbc:sqlserver://hqnt4v/live_vbbridge_tylint2;domain=pkgmfg.net with user: chris. Driver not found: com.microsoft.sqlserver.jdbc.SQLServerDriver

net.datenwerke.rs.core.service.reportmanager.exceptions.DatabaseConnectionException: Could not open connection to: jdbc:sqlserver://hqnt4v/live_vbbridge_tylint2;domain=pkgmfg.net with user: chris. Driver not found: com.microsoft.sqlserver.jdbc.SQLServerDriver at net.datenwerke.rs.base.service.datasources.table.transformers.DatabaseDatasourceTableTransformer.transform(DatabaseDatasourceTableTransformer.java:62) at net.datenwerke.rs.base.service.datasources.table.transformers.DatabaseDatasourceTableTransformer.transform(DatabaseDatasourceTableTransformer.java:1) at net.datenwerke.rs.core.service.datasourcemanager.datasourcetransformers.DatasourceDefinitionTransformerManager.transform(DatasourceDefinitionTransformerManager.java:49) at net.datenwerke.rs.base.service.reportengines.table.SimpleDataSupplier.getData(SimpleDataSupplier.java:118) at net.datenwerke.rs.base.service.reportengines.table.SimpleDataSupplier.getData(SimpleDataSupplier.java:113) at net.datenwerke.rs.base.service.reportengines.table.SimpleDataSupplier.getData(SimpleDataSupplier.java:105) at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl.testConnection(DatasourceTesterRPCServiceImpl.java:86) at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$d77fff36.CGLIB$testConnection$0(<generated>) at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$d77fff36$$FastClassByGuice$$fef68856.invoke(<generated>) at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:66) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$d77fff36.testConnection(<generated>) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:561) at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:208) at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$d77fff36.CGLIB$processCall$2(<generated>) at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$d77fff36$$FastClassByGuice$$fef68856.invoke(<generated>) at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$d77fff36.processCall(<generated>) at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248) at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$d77fff36.CGLIB$service$19(<generated>) at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$d77fff36$$FastClassByGuice$$fef68856.invoke(<generated>) at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$d77fff36.service(<generated>) at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263) at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178) at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62) at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89) at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118) at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:744) Caused by: net.datenwerke.dbpool.exceptions.DriverNotFoundException: Driver not found: com.microsoft.sqlserver.jdbc.SQLServerDriver at net.datenwerke.dbpool.DbC3p0PoolServiceImpl.createPool(DbC3p0PoolServiceImpl.java:189) at net.datenwerke.dbpool.DbC3p0PoolServiceImpl.getConnectionFromPool(DbC3p0PoolServiceImpl.java:126) at net.datenwerke.dbpool.DbC3p0PoolServiceImpl.getConnection(DbC3p0PoolServiceImpl.java:69) at net.datenwerke.dbpool.MetaPoolService.getConnection(MetaPoolService.java:82) at net.datenwerke.rs.base.service.datasources.table.transformers.DatabaseDatasourceTableTransformer.transform(DatabaseDatasourceTableTransformer.java:59) ... 69 more Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1680) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1526) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:190) at net.datenwerke.dbpool.DbC3p0PoolServiceImpl.createPool(DbC3p0PoolServiceImpl.java:187) ... 73 more

Thorsten J. Krause · 2014-02-25 00:15:21

Hi Jim,

I'm guessing, but the problem might be caused by using both, sqljdbc.jar and sqljdbc4.jar.
The files both contain the same driver, but for different connection mechanisms (jdbc type 3/4).
Try using the sqljdbc4.jar only.

If that doesn't help make sure you are using the latest version of the driver.
For me, this download works:
http://www.microsoft.com/en-us/download … x?id=11774

If it's still not working, check the tomcat logfiles. The ClassNotFoundException is a sure sign that the driver jar was not loaded. Provided it is in the correct directory (there should be, besides many others, a file rsbase.jar in the same directory), there should be an error message.

Cheers,
Thorsten

jneundorf · 2014-02-25 13:59:07

Thorsten,

Thank you for the quick response. As you suggested, I removed sqljdbc.jar leaving sqljdbc4.jar - I downloaded the version you recommended. It's sitting in the WEB-INF/lib folder along with many other files including rsbase.jar. Below is the catalina.out contents after a restart. I'm not a java guy and appreciate the help interpreting what the log file is telling me to do in order to correct the problem.

The sqljdbc4.jar has permissions 755 and is owned by root:tomcat6.

Feb 25, 2014 8:39:11 AM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat6/server/classes], exists: [false], isDirectory: [false], canRead: [false]
Feb 25, 2014 8:39:11 AM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat6/server], exists: [false], isDirectory: [false], canRead: [false]
Feb 25, 2014 8:39:11 AM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat6/shared/classes], exists: [false], isDirectory: [false], canRead: [false]
Feb 25, 2014 8:39:11 AM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/usr/share/tomcat6/shared], exists: [false], isDirectory: [false], canRead: [false]
Feb 25, 2014 8:39:12 AM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Feb 25, 2014 8:39:12 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1157 ms
Feb 25, 2014 8:39:12 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Feb 25, 2014 8:39:12 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.35
Feb 25, 2014 8:39:12 AM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor host-manager.xml
Feb 25, 2014 8:39:13 AM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor manager.xml
Feb 25, 2014 8:39:13 AM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor ROOT.xml
Feb 25, 2014 8:39:13 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory reportserver
08:39:28,127 INFO Version:37 - HCANN000001: Hibernate Commons Annotations {4.0.2.Final}
08:39:28,163 INFO Version:41 - HHH000412: Hibernate Core {4.2.2.Final}
08:39:28,170 INFO Environment:239 - HHH000206: hibernate.properties not found
08:39:28,188 INFO Environment:342 - HHH000021: Bytecode provider name : javassist
08:39:29,762 WARN Ejb3Configuration:1141 - HHH000144: hibernate.connection.autocommit = false breaks the EJB3 specification
08:39:30,208 INFO ConnectionProviderInitiator:188 - HHH000130: Instantiating explicit connection provider: org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider
08:39:30,215 INFO C3P0ConnectionProvider:128 - HHH010002: C3P0 using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/reportserver
08:39:30,215 INFO C3P0ConnectionProvider:129 - HHH000046: Connection properties: {user=ldc, password=****, autocommit=false, release_mode=auto}
08:39:30,216 INFO C3P0ConnectionProvider:132 - HHH000006: Autocommit mode: false
08:39:30,277 INFO MLog:92 - MLog clients using log4j logging.
08:39:30,584 INFO C3P0Registry:216 - Initializing c3p0-0.9.2.1 [built 20-March-2013 10:47:27 +0000; debug? true; trace: 10]
08:39:30,961 INFO AbstractPoolBackedDataSource:522 - Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@bd01cca8 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@dc79a795 [ acquireIncrement -> 5, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 2vy13l90t7j2ss1ugq9o9|7eb0f028, idleConnectionTestPeriod -> 60, initialPoolSize -> 3, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 3600, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 30, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 5, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@c7c9c489 [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 2vy13l90t7j2ss1ugq9o9|17e4c30c, jdbcUrl -> jdbc:mysql://localhost:3306/reportserver, properties -> {user=******, password=******, autocommit=false, release_mode=auto} ], preferredTestQuery -> null, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> 2vy13l90t7j2ss1ugq9o9|5f971825, numHelperThreads -> 3 ]
08:39:31,743 INFO Dialect:130 - HHH000400: Using dialect: net.datenwerke.rs.utils.hibernate.MySQL5Dialect
08:39:31,790 INFO LobCreatorBuilder:120 - HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
08:39:35,014 INFO TransactionFactoryInitiator:73 - HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jdbc.JdbcTransactionFactory
08:39:35,061 INFO ASTQueryTranslatorFactory:48 - HHH000397: Using ASTQueryTranslatorFactory
08:39:35,293 INFO Version:27 - HV000001: Hibernate Validator 5.0.1.Final
08:39:41,663 INFO Version:39 - HSEARCH000034: Hibernate Search 4.2.0.Final
08:39:41,794 WARN ConfigContext:301 - HSEARCH000075: Configuration setting hibernate.search.lucene_version was not specified, using LUCENE_CURRENT.
08:39:51,215 ERROR MetadataContext:443 - HHH015011: Unable to locate static metamodel field : net.datenwerke.security.service.usermanager.entities.AbstractUserManagerNode_#guid
08:39:51,216 ERROR MetadataContext:443 - HHH015011: Unable to locate static metamodel field : net.datenwerke.security.service.usermanager.entities.AbstractUserManagerNode_#origin
08:39:52,298 WARN Ejb3Configuration:1141 - HHH000144: hibernate.connection.autocommit = false breaks the EJB3 specification
Feb 25, 2014 8:39:52 AM com.google.inject.internal.ProxyFactory <init>
WARNING: Method [public net.datenwerke.gxtdto.client.model.DwModel net.datenwerke.rs.core.server.reportexecutor.ReportExecutorRpcServiceImpl.storePNGInSession(net.datenwerke.rs.core.client.reportmanager.dto.reports.ReportDto) throws net.datenwerke.gxtdto.client.servercommunication.exceptions.ServerCallFailedException] is synthetic and is being intercepted by [net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor@10f47709]. This could indicate a bug. The method may be intercepted twice, or may not be intercepted at all.
Feb 25, 2014 8:39:52 AM com.google.inject.internal.ProxyFactory <init>
WARNING: Method [public net.datenwerke.gxtdto.client.model.DwModel net.datenwerke.rs.core.server.reportexecutor.ReportExecutorRpcServiceImpl.storePNGInSession(net.datenwerke.rs.core.client.reportmanager.dto.reports.ReportDto) throws net.datenwerke.gxtdto.client.servercommunication.exceptions.ServerCallFailedException] is synthetic and is being intercepted by [net.datenwerke.security.service.security.aop.SecurityCheckInterceptor@107d40e7]. This could indicate a bug. The method may be intercepted twice, or may not be intercepted at all.
Feb 25, 2014 8:39:54 AM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Feb 25, 2014 8:39:54 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 41965 ms
Feb 25, 2014 8:40:00 AM net.datenwerke.rs.core.service.internaldb.InternalDbServiceImpl initDemoDatabase
INFO: demodata imported
Feb 25, 2014 8:40:00 AM net.datenwerke.rs.incubator.service.jmx.JmxInitializer initialize
INFO: initializing JMX
Feb 25, 2014 8:40:00 AM org.apache.sshd.common.util.SecurityUtils$BouncyCastleRegistration run
INFO: BouncyCastle already registered as a JCE provider
Feb 25, 2014 8:40:03 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [JasperReportVariant] org.hibernate.search.jmx.IndexingProgressMonitor@20372e5b

08:40:03,559 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 0 entities. Unregistering MBean from server
Feb 25, 2014 8:40:04 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [DatasourceFolder] org.hibernate.search.jmx.IndexingProgressMonitor@472deca6

08:40:04,619 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 3 entities. Unregistering MBean from server
Feb 25, 2014 8:40:05 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [DashboardNode] org.hibernate.search.jmx.IndexingProgressMonitor@2d107cea

08:40:05,492 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 0 entities. Unregistering MBean from server
Feb 25, 2014 8:40:06 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [TeamSpace] org.hibernate.search.jmx.IndexingProgressMonitor@6de89dac

08:40:06,571 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 1 entities. Unregistering MBean from server
Feb 25, 2014 8:40:07 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [TableReportVariant] org.hibernate.search.jmx.IndexingProgressMonitor@6a981dd3

08:40:07,583 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 0 entities. Unregistering MBean from server
Feb 25, 2014 8:40:08 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [CrystalReportVariant] org.hibernate.search.jmx.IndexingProgressMonitor@73ef3b3d

08:40:08,502 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 0 entities. Unregistering MBean from server
Feb 25, 2014 8:40:09 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [ExecutedReportFileReference] org.hibernate.search.jmx.IndexingProgressMonitor@21410df6

08:40:09,493 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 0 entities. Unregistering MBean from server
Feb 25, 2014 8:40:10 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [CsvDatasource] org.hibernate.search.jmx.IndexingProgressMonitor@5a7df976

08:40:10,497 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 0 entities. Unregistering MBean from server
Feb 25, 2014 8:40:11 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [FileServerFile] org.hibernate.search.jmx.IndexingProgressMonitor@2901dddf

08:40:11,707 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 35 entities. Unregistering MBean from server
Feb 25, 2014 8:40:11 AM net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor invoke
INFO: Intercepted NonFatalException
net.datenwerke.rs.adminutils.client.datasourcetester.ConnectionTestFailedException: Could not open connection to: jdbc:sqlserver://hqnt4v/live_vbbridge_tylint2;domain=pkgmfg.net with user: chris. Driver not found: com.microsoft.sqlserver.jdbc.SQLServerDriver
at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl.testConnection(DatasourceTesterRPCServiceImpl.java:88)
at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:66)
at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110)
at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:561)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:208)
at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110)
at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)
at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110)
at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)
at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)
at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)
at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89)
at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)
at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:744)
Caused by: net.datenwerke.rs.core.service.reportmanager.exceptions.DatabaseConnectionException: Could not open connection to: jdbc:sqlserver://hqnt4v/live_vbbridge_tylint2;domain=pkgmfg.net with user: chris. Driver not found: com.microsoft.sqlserver.jdbc.SQLServerDriver
at net.datenwerke.rs.base.service.datasources.table.transformers.DatabaseDatasourceTableTransformer.transform(DatabaseDatasourceTableTransformer.java:62)
at net.datenwerke.rs.base.service.datasources.table.transformers.DatabaseDatasourceTableTransformer.transform(DatabaseDatasourceTableTransformer.java:1)
at net.datenwerke.rs.core.service.datasourcemanager.datasourcetransformers.DatasourceDefinitionTransformerManager.transform(DatasourceDefinitionTransformerManager.java:49)
at net.datenwerke.rs.base.service.reportengines.table.SimpleDataSupplier.getData(SimpleDataSupplier.java:118)
at net.datenwerke.rs.base.service.reportengines.table.SimpleDataSupplier.getData(SimpleDataSupplier.java:113)
at net.datenwerke.rs.base.service.reportengines.table.SimpleDataSupplier.getData(SimpleDataSupplier.java:105)
at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl.testConnection(DatasourceTesterRPCServiceImpl.java:86)
... 38 more
Caused by: net.datenwerke.dbpool.exceptions.DriverNotFoundException: Driver not found: com.microsoft.sqlserver.jdbc.SQLServerDriver
at net.datenwerke.dbpool.DbC3p0PoolServiceImpl.createPool(DbC3p0PoolServiceImpl.java:189)
at net.datenwerke.dbpool.DbC3p0PoolServiceImpl.getConnectionFromPool(DbC3p0PoolServiceImpl.java:126)
at net.datenwerke.dbpool.DbC3p0PoolServiceImpl.getConnection(DbC3p0PoolServiceImpl.java:69)
at net.datenwerke.dbpool.MetaPoolService.getConnection(MetaPoolService.java:82)
at net.datenwerke.rs.base.service.datasources.table.transformers.DatabaseDatasourceTableTransformer.transform(DatabaseDatasourceTableTransformer.java:59)
... 44 more
Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1680)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1526)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:190)
at net.datenwerke.dbpool.DbC3p0PoolServiceImpl.createPool(DbC3p0PoolServiceImpl.java:187)
... 48 more

Feb 25, 2014 8:40:12 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [TsDiskFolder] org.hibernate.search.jmx.IndexingProgressMonitor@9160ccf

08:40:12,498 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 0 entities. Unregistering MBean from server
Feb 25, 2014 8:40:13 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [BirtReportVariant] org.hibernate.search.jmx.IndexingProgressMonitor@1e4989fe

08:40:13,546 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 0 entities. Unregistering MBean from server
Feb 25, 2014 8:40:14 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): *User* org.hibernate.search.jmx.IndexingProgressMonitor@3195b393

08:40:14,513 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 1 entities. Unregistering MBean from server
Feb 25, 2014 8:40:15 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [DadgetNode] org.hibernate.search.jmx.IndexingProgressMonitor@ab73492

08:40:15,507 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 0 entities. Unregistering MBean from server
Feb 25, 2014 8:40:16 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [Group] org.hibernate.search.jmx.IndexingProgressMonitor@48b6bb3

08:40:16,511 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 0 entities. Unregistering MBean from server
Feb 25, 2014 8:40:17 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [CsvDatasourceConfig] org.hibernate.search.jmx.IndexingProgressMonitor@6ae97533

08:40:17,513 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 0 entities. Unregistering MBean from server
Feb 25, 2014 8:40:18 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [CrystalReport] org.hibernate.search.jmx.IndexingProgressMonitor@4ec476a

08:40:18,513 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 0 entities. Unregistering MBean from server
Feb 25, 2014 8:40:19 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [JasperReport] org.hibernate.search.jmx.IndexingProgressMonitor@4cde0f64

08:40:19,536 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 0 entities. Unregistering MBean from server
Feb 25, 2014 8:40:20 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [ScriptReport] org.hibernate.search.jmx.IndexingProgressMonitor@5405d518

08:40:20,543 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 3 entities. Unregistering MBean from server
Feb 25, 2014 8:40:21 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [DatabaseBundle] org.hibernate.search.jmx.IndexingProgressMonitor@3f8b55d5

08:40:21,524 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 0 entities. Unregistering MBean from server
Feb 25, 2014 8:40:22 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [BirtReport] org.hibernate.search.jmx.IndexingProgressMonitor@6931f35

08:40:22,528 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 0 entities. Unregistering MBean from server
Feb 25, 2014 8:40:23 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [DatabaseDatasource] org.hibernate.search.jmx.IndexingProgressMonitor@7d15936c

08:40:23,541 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 3 entities. Unregistering MBean from server
Feb 25, 2014 8:40:24 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [DashboardFolder] org.hibernate.search.jmx.IndexingProgressMonitor@69dbed0e

08:40:24,540 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 1 entities. Unregistering MBean from server
Feb 25, 2014 8:40:25 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [ScriptDatasource] org.hibernate.search.jmx.IndexingProgressMonitor@19ead8c7

08:40:25,547 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 0 entities. Unregistering MBean from server
Feb 25, 2014 8:40:26 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [TsDiskReportReference] org.hibernate.search.jmx.IndexingProgressMonitor@6c09fc01

08:40:26,549 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 0 entities. Unregistering MBean from server
Feb 25, 2014 8:40:27 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [TableReport] org.hibernate.search.jmx.IndexingProgressMonitor@11cebca8

08:40:27,571 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 2 entities. Unregistering MBean from server
Feb 25, 2014 8:40:28 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [ScriptReportVariant] org.hibernate.search.jmx.IndexingProgressMonitor@5b46dd22

08:40:28,622 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 0 entities. Unregistering MBean from server
Feb 25, 2014 8:40:29 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [FileServerFolder] org.hibernate.search.jmx.IndexingProgressMonitor@2ac9914e

08:40:29,591 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 23 entities. Unregistering MBean from server
Feb 25, 2014 8:40:30 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [ReportFolder] org.hibernate.search.jmx.IndexingProgressMonitor@30e4af50

08:40:30,567 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 5 entities. Unregistering MBean from server
Feb 25, 2014 8:40:31 AM net.datenwerke.rs.search.service.search.SearchServiceImpl rebuildIndex
INFO: Hibernate Search: (updating): [OrganisationalUnit] org.hibernate.search.jmx.IndexingProgressMonitor@3d3891d7

08:40:31,559 INFO IndexingProgressMonitor:74 - HSEARCH000029: Indexing completed. Reindexed 2 entities. Unregistering MBean from server

jneundorf · 2014-02-25 14:00:52

Thorsten,

I had to replace '[user]' with '*User*' in the catalina.out - I was getting an xml error when trying to post the replay.[/user]

[user]Have to put this in for the reply to post: '[/user]'

jneundorf · 2014-02-25 14:26:17

Thorsten,

One other thing - I fixed the warnings by adding sym links as follows - looks like there is an issue with the default tomcat6 install on debian 7.

ln -s /var/lib/tomcat6/server /usr/share/tomcat6/server
ln -s /var/lib/tomcat6/shared /usr/share/tomcat6/shared

Thorsten J. Krause · 2014-02-25 18:46:49

Jim,
I'm still not sure what might cause your problem. I just tried it with debian 7.4.0, oracle-jdk 7u51 and tomcat 6.0.35 (installed via apt) and it works fine.
Can you send me the other logfiles in /var/log/tomcat6. Some errors are only logged in the localhost file and not printed to the console log. Hopefuly this will give us a clue.

Please send the logfiles to thorsten .krause @datenwerke.net.

Cheers,
Thorsten

Thorsten J. Krause · 2014-02-26 20:16:22

Hi Jim,

thank you for the logfiles - unfortunately there is nothing suspicious in them that hits the eye.
I prepared two small scripts that might help use understand, wahts going on.
dumpcp.groovy prints a list of all loaded libraries, finddriver.grovvy tries to find the driver jar disregarding the classpath, tests if the file is readable and tries to manually load it.

http://www2.datenwerke.net/files/forum/dumpcp.groovy
http://www2.datenwerke.net/files/forum/ … ver.groovy

Place them in the "FileServer Root/bin" directory in ReportServers internal file system.
Open the terminal by pressing ctrl+alt+t.
change the current directory with cd /fileserver/bin
and execute the script with
exec dumpcp.groovy
and
exec finddriver.groovy

Cheers,
Thorsten

jneundorf · 2014-03-03 16:41:19

Thorsten,

Thanks for the scripts. Sorry but I was away for a few days. I will email the output of each to you - am having trouble with the uploads working in this forum.

Thanks for the help.
Jim

Arno Mittelbach · 2014-03-04 08:44:13

Hi Jim,

given the output of the first script it seems that sqljdbc4.jar is not in directory /var/lib/tomcat6/webapps/reportserver/WEB-INF/lib/
(or the file is corrupt). Could you send me the output of

ls -la /var/lib/tomcat6/webapps/reportserver/WEB-INF/lib/

and the output of

md5sum /var/lib/tomcat6/webapps/reportserver/WEB-INF/lib/sqljdbc4.jar

Cheers,
Arno

jneundorf · 2014-03-04 13:36:17

Arno,

Thank you very much for your post. It points out that I missed the boat on something. I had placed the driver in the original install directory for reportserver rather than the directory under tomcat. So I copied the driver to the lib folder and no longer get the 'driver not found' error. However testing the connection now times out. I have sent all the files I could think of the Thorsten's email address - hopefully it's something that is easy to see at your end.

I really appreciate the help as this java config stuff is over my head. When we've got the sql server connection working, I'd like to make a donation as a thank you - is there a way to do that?

Jim.

Thorsten J. Krause · 2014-03-04 21:49:53

Hi Jim,

a timeout probably means either your jdbc connection url is wrong, or there is a network issue preventing the connection.
Did you check if the webserver is able to connect to the database at all?

To make sure there is no network problem you can either install something like freetds (www.freetds.org) or as a basic test use telnet and try to connect to the database port.

telnet hqnt4v [INSTANCE-PORT]

The default port is 1433, but as you specified a named instance, you are probably using a different port.

If this basic test succeeds, you should take a closer look at your connection string.
Two thing you might want to try:
- The documentation at http://technet.microsoft.com/en-us/libr … 78428.aspx suggests, that the instance name is to be seperated by a backslash from the hostname instead of the forward-slash you used. I don't know, if this makes a difference, but it's probably worth trying.

- You might try to explicitly specify the portnumber (instead of the instance name)

Cheers,
Thorsten

jneundorf · 2014-03-05 18:53:31

Got it!

Had to change the URL to jdbc:sqlserver://hqnt4v:1433;databaseName=live_vbbridge_tylnt2.

Thank you for all your help Thorsten & Arno. Can you please post a link to where I can make a donation.

Thank you again.

Thorsten J. Krause · 2014-03-05 19:11:50

Hi Jim,

glad you got it figured out!

We don't have a way to accept donations, but if you like to fund the further development of ReportServer consider buying one of our manuals:

http://reportserver.datenwerke.net/en/shop/

Cheers,
Thorsten

jneundorf · 2014-03-05 20:25:06

Thorsten,

I had purchased manuals a couple of months ago. I think one was free but I have the Admin, Config & User manuals. Are there any others I can buy?

Thorsten J. Krause · 2014-03-06 20:13:14

Hi Jim,

well in that case: Thank you for your support!
Please don't feel obliged to buy something you don't need. If you already got the manuals thats great and I'm glad we were able to help.

Kind regards,
Thorsten

ReportServer Forum

#1 2014-02-24 17:18:17

SQLServer2008 datasource

#2 2014-02-25 00:15:21

Re: SQLServer2008 datasource

#3 2014-02-25 13:59:07

Re: SQLServer2008 datasource

#4 2014-02-25 14:00:52

Re: SQLServer2008 datasource

#5 2014-02-25 14:26:17

Re: SQLServer2008 datasource

#6 2014-02-25 18:46:49

Re: SQLServer2008 datasource

#7 2014-02-26 20:16:22

Re: SQLServer2008 datasource

#8 2014-03-03 16:41:19

Re: SQLServer2008 datasource

#9 2014-03-04 08:44:13

Re: SQLServer2008 datasource

#10 2014-03-04 13:36:17

Re: SQLServer2008 datasource

#11 2014-03-04 21:49:53

Re: SQLServer2008 datasource

#12 2014-03-05 18:53:31

Re: SQLServer2008 datasource

#13 2014-03-05 19:11:50

Re: SQLServer2008 datasource

#14 2014-03-05 20:25:06

Re: SQLServer2008 datasource

#15 2014-03-06 20:13:14

Re: SQLServer2008 datasource

Board footer