Hide Forgot
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) ...
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!