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

jneundorf
Member
Registered: 2014-01-08

SQLServer2008 datasource

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

Offline

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

Thorsten J. Krause
datenwerke
Registered: 2012-02-15
Website

Re: SQLServer2008 datasource

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

Offline

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

jneundorf
Member
Registered: 2014-01-08

Re: SQLServer2008 datasource

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

Offline

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

jneundorf
Member
Registered: 2014-01-08

Re: SQLServer2008 datasource

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]'

Offline

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

jneundorf
Member
Registered: 2014-01-08

Re: SQLServer2008 datasource

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

Offline

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

Thorsten J. Krause
datenwerke
Registered: 2012-02-15
Website

Re: SQLServer2008 datasource

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

Offline

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

Thorsten J. Krause
datenwerke
Registered: 2012-02-15
Website

Re: SQLServer2008 datasource

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

Offline

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

jneundorf
Member
Registered: 2014-01-08

Re: SQLServer2008 datasource

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

Offline

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

Arno Mittelbach
datenwerke
Registered: 2012-02-14

Re: SQLServer2008 datasource

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

Offline

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

jneundorf
Member
Registered: 2014-01-08

Re: SQLServer2008 datasource

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.

Offline

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

Thorsten J. Krause
datenwerke
Registered: 2012-02-15
Website

Re: SQLServer2008 datasource

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

Offline

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

jneundorf
Member
Registered: 2014-01-08

Re: SQLServer2008 datasource

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.

Offline

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

Thorsten J. Krause
datenwerke
Registered: 2012-02-15
Website

Re: SQLServer2008 datasource

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

Offline

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

jneundorf
Member
Registered: 2014-01-08

Re: SQLServer2008 datasource

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?

Offline

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

Thorsten J. Krause
datenwerke
Registered: 2012-02-15
Website

Re: SQLServer2008 datasource

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

Offline

Board footer

Powered by FluxBB