Login
[x]
Log in using an account from:
Fedora Account System
Red Hat Associate
Red Hat Customer
Or login using a Red Hat Bugzilla account
Forgot Password
Login:
Hide Forgot
Create an Account
Red Hat Bugzilla – Attachment 652517 Details for
Bug 879635
JDBCCacheStore doesn't work propertly with MSSql
[?]
New
Simple Search
Advanced Search
My Links
Browse
Requests
Reports
Current State
Search
Tabular reports
Graphical reports
Duplicates
Other Reports
User Changes
Plotly Reports
Bug Status
Bug Severity
Non-Defaults
|
Product Dashboard
Help
Page Help!
Bug Writing Guidelines
What's new
Browser Support Policy
5.0.4.rh83 Release notes
FAQ
Guides index
User guide
Web Services
Contact
Legal
This site requires JavaScript to be enabled to function correctly, please enable it.
Relevant part of trace log
trace.log (text/x-log), 15.87 KB, created by
Martin Gencur
on 2012-11-27 07:50:22 UTC
(
hide
)
Description:
Relevant part of trace log
Filename:
MIME Type:
Creator:
Martin Gencur
Created:
2012-11-27 07:50:22 UTC
Size:
15.87 KB
patch
obsolete
>08:41:32,723 TRACE [org.infinispan.loaders.LockSupportCacheStore] (MSC service thread 1-6) Starting cache with config: JdbcStringBasedCacheStoreConfig{key2StringMapper=org.infinispan.loaders.keymappers.DefaultTwoWayKey2StringMapper@17698cbe} AbstractNonDelegatingJdbcCacheStoreConfig{lockConcurrencyLevel=2048, lockAcquistionTimeout=60000, tableManipulation=org.infinispan.loaders.jdbc.TableManipulation@7e28ebb4, manageConnectionFactory=true} AbstractJdbcCacheStoreConfig{connectionFactoryConfig=ConnectionFactoryConfig{connectionFactoryClass='org.infinispan.loaders.jdbc.connectionfactory.ManagedConnectionFactory', driverClass='null', connectionUrl='null', userName='null'}} LockSupportCacheStoreConfig{lockConcurrencyLevel=0, lockAcquistionTimeout=0} JdbcStringBasedCacheStoreConfig{className='org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore', ignoreModifications=false, fetchPersistentState=true, properties={key2StringMapperClass=org.infinispan.loaders.keymappers.DefaultTwoWayKey2StringMapper}, purgeOnStartup=false},, singletonStore{org.infinispan.loaders.decorators.SingletonStoreConfig@62fcf06c}, async{org.infinispan.loaders.decorators.AsyncStoreConfig@45e41830}, purgeSynchronously{true}, purgerThreads{1} >08:41:32,723 TRACE [org.infinispan.loaders.LockSupportCacheStore] (MSC service thread 1-2) Starting cache with config: JdbcStringBasedCacheStoreConfig{key2StringMapper=org.infinispan.loaders.keymappers.DefaultTwoWayKey2StringMapper@129719f4} AbstractNonDelegatingJdbcCacheStoreConfig{lockConcurrencyLevel=2048, lockAcquistionTimeout=60000, tableManipulation=org.infinispan.loaders.jdbc.TableManipulation@308ab721, manageConnectionFactory=true} AbstractJdbcCacheStoreConfig{connectionFactoryConfig=ConnectionFactoryConfig{connectionFactoryClass='org.infinispan.loaders.jdbc.connectionfactory.ManagedConnectionFactory', driverClass='null', connectionUrl='null', userName='null'}} LockSupportCacheStoreConfig{lockConcurrencyLevel=0, lockAcquistionTimeout=0} JdbcStringBasedCacheStoreConfig{className='org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore', ignoreModifications=false, fetchPersistentState=true, properties={key2StringMapperClass=org.infinispan.loaders.keymappers.DefaultTwoWayKey2StringMapper}, purgeOnStartup=false},, singletonStore{org.infinispan.loaders.decorators.SingletonStoreConfig@4c0c7539}, async{org.infinispan.loaders.decorators.AsyncStoreConfig@1f01b29}, purgeSynchronously{true}, purgerThreads{1} >08:41:32,725 TRACE [org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore] (MSC service thread 1-6) Using managed connection factory: org.infinispan.loaders.jdbc.connectionfactory.ManagedConnectionFactory >08:41:32,725 TRACE [org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore] (MSC service thread 1-2) Using managed connection factory: org.infinispan.loaders.jdbc.connectionfactory.ManagedConnectionFactory >08:41:32,726 TRACE [org.infinispan.loaders.jdbc.connectionfactory.ManagedConnectionFactory] (MSC service thread 1-6) Datasource lookup for java:jboss/datasources/JdbcDS succeeded: true >08:41:32,726 TRACE [org.infinispan.loaders.jdbc.connectionfactory.ManagedConnectionFactory] (MSC service thread 1-2) Datasource lookup for java:jboss/datasources/JdbcDS succeeded: true >08:41:34,302 TRACE [org.infinispan.loaders.jdbc.connectionfactory.ManagedConnectionFactory] (MSC service thread 1-2) Connection checked out: org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6@2453f89f >08:41:34,302 TRACE [org.infinispan.loaders.jdbc.connectionfactory.ManagedConnectionFactory] (MSC service thread 1-6) Connection checked out: org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6@2453f89f >08:41:35,610 TRACE [org.infinispan.loaders.jdbc.connectionfactory.ManagedConnectionFactory] (MSC service thread 1-2) Connection checked out: org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6@48129552 >08:41:35,609 TRACE [org.infinispan.loaders.jdbc.connectionfactory.ManagedConnectionFactory] (MSC service thread 1-6) Connection checked out: org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6@df4e1c6 >08:41:35,615 DEBUG [org.infinispan.loaders.jdbc.TableManipulation] (MSC service thread 1-2) Guessing database type as 'SQL_SERVER'. If this is incorrect, please specify the correct type using the 'databaseType' property in your configuration. Supported database type strings are [MYSQL, POSTGRES, DERBY, HSQL, H2, SQLITE, DB2, DB2_390, INFORMIX, INTERBASE, FIREBIRD, SQL_SERVER, ACCESS, ORACLE, SYBASE] >08:41:35,615 DEBUG [org.infinispan.loaders.jdbc.TableManipulation] (MSC service thread 1-6) Guessing database type as 'SQL_SERVER'. If this is incorrect, please specify the correct type using the 'databaseType' property in your configuration. Supported database type strings are [MYSQL, POSTGRES, DERBY, HSQL, H2, SQLITE, DB2, DB2_390, INFORMIX, INTERBASE, FIREBIRD, SQL_SERVER, ACCESS, ORACLE, SYBASE] >08:41:35,736 TRACE [org.infinispan.loaders.jdbc.TableManipulation] (MSC service thread 1-6) SQLException occurs while checking the table "EDG_STRING_default": com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'FROM'. > at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197) > at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493) > at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775) > at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676) > at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575) > at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400) > at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179) > at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154) > at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:611) > at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:340) > at org.infinispan.loaders.jdbc.TableManipulation.tableExists(TableManipulation.java:138) [infinispan-cachestore-jdbc-5.2.0.Beta4-redhat-1.jar:5.2.0-SNAPSHOT] > at org.infinispan.loaders.jdbc.TableManipulation.start(TableManipulation.java:261) [infinispan-cachestore-jdbc-5.2.0.Beta4-redhat-1.jar:5.2.0-SNAPSHOT] > at org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore.doConnectionFactoryInitialization(JdbcStringBasedCacheStore.java:372) [infinispan-cachestore-jdbc-5.2.0.Beta4-redhat-1.jar:5.2.0-SNAPSHOT] > at org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore.start(JdbcStringBasedCacheStore.java:121) [infinispan-cachestore-jdbc-5.2.0.Beta4-redhat-1.jar:5.2.0-SNAPSHOT] > at org.infinispan.loaders.CacheLoaderManagerImpl.start(CacheLoaderManagerImpl.java:159) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_30] > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_30] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_30] > at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_30] > at org.infinispan.util.ReflectionUtil.invokeAccessibly(ReflectionUtil.java:203) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at org.infinispan.factories.AbstractComponentRegistry$PrioritizedMethod.invoke(AbstractComponentRegistry.java:883) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at org.infinispan.factories.AbstractComponentRegistry.invokeStartMethods(AbstractComponentRegistry.java:654) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at org.infinispan.factories.AbstractComponentRegistry.internalStart(AbstractComponentRegistry.java:643) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at org.infinispan.factories.AbstractComponentRegistry.start(AbstractComponentRegistry.java:546) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at org.infinispan.factories.ComponentRegistry.start(ComponentRegistry.java:199) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at org.infinispan.CacheImpl.start(CacheImpl.java:520) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at org.infinispan.manager.DefaultCacheManager.wireAndStartCache(DefaultCacheManager.java:690) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at org.infinispan.manager.DefaultCacheManager.createCache(DefaultCacheManager.java:653) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at org.infinispan.manager.DefaultCacheManager.getCache(DefaultCacheManager.java:549) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at org.infinispan.manager.DefaultCacheManager.getCache(DefaultCacheManager.java:563) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at org.jboss.as.clustering.infinispan.DefaultEmbeddedCacheManager.getCache(DefaultEmbeddedCacheManager.java:107) [jboss-datagrid-infinispan-6.1.0.ER4-redhat-1.jar:6.1.0.ER4-redhat-1] > at org.jboss.as.clustering.infinispan.DefaultEmbeddedCacheManager.getCache(DefaultEmbeddedCacheManager.java:98) [jboss-datagrid-infinispan-6.1.0.ER4-redhat-1.jar:6.1.0.ER4-redhat-1] > at org.jboss.as.clustering.infinispan.subsystem.CacheService.start(CacheService.java:78) [jboss-datagrid-infinispan-6.1.0.ER4-redhat-1.jar:6.1.0.ER4-redhat-1] > at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.2.GA-redhat-1.jar:1.0.2.GA-redhat-1] > at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.GA-redhat-1.jar:1.0.2.GA-redhat-1] > at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [rt.jar:1.6.0_30] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [rt.jar:1.6.0_30] > at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_30] > >08:41:35,736 TRACE [org.infinispan.loaders.jdbc.TableManipulation] (MSC service thread 1-2) SQLException occurs while checking the table "EDG_STRING_memcachedCache": com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'FROM'. > at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197) > at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493) > at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775) > at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676) > at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575) > at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400) > at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179) > at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154) > at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:611) > at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:340) > at org.infinispan.loaders.jdbc.TableManipulation.tableExists(TableManipulation.java:138) [infinispan-cachestore-jdbc-5.2.0.Beta4-redhat-1.jar:5.2.0-SNAPSHOT] > at org.infinispan.loaders.jdbc.TableManipulation.start(TableManipulation.java:261) [infinispan-cachestore-jdbc-5.2.0.Beta4-redhat-1.jar:5.2.0-SNAPSHOT] > at org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore.doConnectionFactoryInitialization(JdbcStringBasedCacheStore.java:372) [infinispan-cachestore-jdbc-5.2.0.Beta4-redhat-1.jar:5.2.0-SNAPSHOT] > at org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore.start(JdbcStringBasedCacheStore.java:121) [infinispan-cachestore-jdbc-5.2.0.Beta4-redhat-1.jar:5.2.0-SNAPSHOT] > at org.infinispan.loaders.CacheLoaderManagerImpl.start(CacheLoaderManagerImpl.java:159) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_30] > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_30] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_30] > at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_30] > at org.infinispan.util.ReflectionUtil.invokeAccessibly(ReflectionUtil.java:203) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at org.infinispan.factories.AbstractComponentRegistry$PrioritizedMethod.invoke(AbstractComponentRegistry.java:883) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at org.infinispan.factories.AbstractComponentRegistry.invokeStartMethods(AbstractComponentRegistry.java:654) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at org.infinispan.factories.AbstractComponentRegistry.internalStart(AbstractComponentRegistry.java:643) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at org.infinispan.factories.AbstractComponentRegistry.start(AbstractComponentRegistry.java:546) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at org.infinispan.factories.ComponentRegistry.start(ComponentRegistry.java:199) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at org.infinispan.CacheImpl.start(CacheImpl.java:520) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at org.infinispan.manager.DefaultCacheManager.wireAndStartCache(DefaultCacheManager.java:690) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at org.infinispan.manager.DefaultCacheManager.createCache(DefaultCacheManager.java:653) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at org.infinispan.manager.DefaultCacheManager.getCache(DefaultCacheManager.java:549) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at org.infinispan.manager.DefaultCacheManager.getCache(DefaultCacheManager.java:563) [infinispan-core-5.2.0.Beta4-redhat-1.jar:5.2.0.Beta4-redhat-1] > at org.jboss.as.clustering.infinispan.DefaultEmbeddedCacheManager.getCache(DefaultEmbeddedCacheManager.java:107) [jboss-datagrid-infinispan-6.1.0.ER4-redhat-1.jar:6.1.0.ER4-redhat-1] > at org.jboss.as.clustering.infinispan.DefaultEmbeddedCacheManager.getCache(DefaultEmbeddedCacheManager.java:98) [jboss-datagrid-infinispan-6.1.0.ER4-redhat-1.jar:6.1.0.ER4-redhat-1] > at org.jboss.as.clustering.infinispan.subsystem.CacheService.start(CacheService.java:78) [jboss-datagrid-infinispan-6.1.0.ER4-redhat-1.jar:6.1.0.ER4-redhat-1] > at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.2.GA-redhat-1.jar:1.0.2.GA-redhat-1] > at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.GA-redhat-1.jar:1.0.2.GA-redhat-1] > at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [rt.jar:1.6.0_30] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [rt.jar:1.6.0_30] > at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_30] > >08:41:35,742 TRACE [org.infinispan.loaders.jdbc.TableManipulation] (MSC service thread 1-2) Creating table with following DDL: 'CREATE TABLE "EDG_STRING_memcachedCache"(id VARCHAR(255) NOT NULL, datum VARBINARY(1000), version BIGINT, PRIMARY KEY (id))'. >08:41:35,742 TRACE [org.infinispan.loaders.jdbc.TableManipulation] (MSC service thread 1-6) Creating table with following DDL: 'CREATE TABLE "EDG_STRING_default"(id VARCHAR(255) NOT NULL, datum VARBINARY(1000), version BIGINT, PRIMARY KEY (id))'. >08:41:35,864 TRACE [org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore] (MSC service thread 1-2) Using key2StringMapper: org.infinispan.loaders.keymappers.DefaultTwoWayKey2StringMapper >08:41:35,864 TRACE [org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore] (MSC service thread 1-6) Using key2StringMapper: org.infinispan.loaders.keymappers.DefaultTwoWayKey2StringMapper
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 879635
: 652517