| Summary: | Error in deployment when using Microsoft SQL Server 2008 as a DB backend for Jackrabbit | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | [JBoss] JBoss Enterprise BRMS Platform 5 | Reporter: | Jiri Locker <jlocker> | ||||||
| Component: | BRM (Guvnor) | Assignee: | Tihomir Surdilovic <tsurdilo> | ||||||
| Status: | CLOSED NOTABUG | QA Contact: | |||||||
| Severity: | unspecified | Docs Contact: | |||||||
| Priority: | urgent | ||||||||
| Version: | 5.1.0.ER3 | ||||||||
| Target Milestone: | --- | ||||||||
| Target Release: | --- | ||||||||
| Hardware: | Unspecified | ||||||||
| OS: | Unspecified | ||||||||
| URL: | http://jira.jboss.org/jira/browse/BRMS-429 | ||||||||
| Whiteboard: | |||||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||||
| Doc Text: | Story Points: | --- | |||||||
| Clone Of: | Environment: | ||||||||
| Last Closed: | 2010-11-08 16:14:48 UTC | Type: | Bug | ||||||
| Regression: | --- | Mount Type: | --- | ||||||
| Documentation: | --- | CRM: | |||||||
| Verified Versions: | Category: | --- | |||||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||||
| Attachments: |
|
||||||||
Attaching JCR and datasource configuration files. Attachment: Added: repository.xml Attachment: Added: jboss-brms-ds.xml Can you also upload the sql driver you are using? I would start with trying to check if the driver is appropriate for your environment first. in repository.xml try using MSSqlFileSystem instead of DbFileSystem, that should help because DbFileSystem does not replace the ${tableSpace} in the mssql.dll
Thanks, Tiho - this was just a misconfiguration on our part! |
securitylevel_name: Public 2010-11-05 13:54:53,368 FINER [com.microsoft.sqlserver.jdbc.Statement] (main) ENTRY create table FS_FSENTRY (FSENTRY_PATH varchar(2048) not null, FSENTRY_NAME varchar(255) not null, FSENTRY_DATA image null, FSENTRY_LASTMOD bigint not null, FSENTRY_LENGTH bigint not null) ${tableSpace} 2010-11-05 13:54:53,369 FINE [com.microsoft.sqlserver.jdbc.internals.SQLServerStatement] (main) SQLServerStatement:2 Executing (not server cursor) create table FS_FSENTRY (FSENTRY_PATH varchar(2048) not null, FSENTRY_NAME varchar(255) not null, FSENTRY_DATA image null, FSENTRY_LASTMOD bigint not null, FSENTRY_LENGTH bigint not null) ${tableSpace} 2010-11-05 13:54:53,498 FINE [com.microsoft.sqlserver.jdbc.internals.SQLServerException] (main) *** SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '$'. Msg 102, Level 15, State 1, Incorrect syntax near '$'. 2010-11-05 13:54:53,498 FINER [com.microsoft.sqlserver.jdbc.Statement] (main) ENTRY 2010-11-05 13:54:53,498 FINER [com.microsoft.sqlserver.jdbc.Statement] (main) RETURN 2010-11-05 13:54:53,514 INFO [STDOUT] (main) ERROR 05-11 13:54:53,505 (ConnectionHelper.java:doTry:454) Failed to execute SQL (stacktrace on DEBUG log level) com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '$'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:658) at org.jboss.resource.adapter.jdbc.WrappedStatement.execute(WrappedStatement.java:91) at org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyExec(ConnectionHelper.java:274) at org.apache.jackrabbit.core.util.db.ConnectionHelper.access$000(ConnectionHelper.java:65) at org.apache.jackrabbit.core.util.db.ConnectionHelper$1.call(ConnectionHelper.java:260) at org.apache.jackrabbit.core.util.db.ConnectionHelper$1.call(ConnectionHelper.java:256) at org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:450) at org.apache.jackrabbit.core.util.db.ConnectionHelper.exec(ConnectionHelper.java:256) at org.apache.jackrabbit.core.util.db.CheckSchemaOperation.run(CheckSchemaOperation.java:89) at org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.init(DatabaseFileSystem.java:197) at org.apache.jackrabbit.core.config.RepositoryConfigurationParser$6.getFileSystem(RepositoryConfigurationParser.java:1061) at org.apache.jackrabbit.core.config.RepositoryConfig.getFileSystem(RepositoryConfig.java:892) at org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:311) at org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:673) at org.apache.jackrabbit.core.TransientRepository$2.getRepository(TransientRepository.java:231) at org.apache.jackrabbit.core.TransientRepository.startRepository(TransientRepository.java:279) at org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:375) at org.apache.jackrabbit.commons.AbstractRepository.login(AbstractRepository.java:123) at org.drools.guvnor.server.repository.RepositoryStartupService.newSession(RepositoryStartupService.java:151) at org.drools.guvnor.server.repository.RepositoryStartupService.create(RepositoryStartupService.java:72) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.seam.util.Reflections.invoke(Reflections.java:22) at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31) at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56) at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28) at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44) at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107) at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:166) at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:102) at org.drools.guvnor.server.repository.RepositoryStartupService_$$_javassist_1.create(RepositoryStartupService_$$_javassist_1.java) ...