Subsonic Forum

forum.subsonic.org

Skip to content

Running jboss-4.2.2.GA

Need help? Post your questions here.

Moderator: moderators

Post a reply

Running jboss-4.2.2.GA

Postby rimdur » Fri Nov 09, 2007 10:50 pm

Set it up correctly i thougth.
Version 3.1 of Subsonic
Susonic starts fine on port 8080 Im able to login then...


Java version Sun Microsystems Inc. 1.6.0_03
Operating system Windows Vista 6.0
Server JBossWeb/2.0.1.GA
Memory Used 41 of 126 MB


org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 17 in the jsp file: /WEB-INF/jsp/home.jsp The method setItems(String) in the type ForTokensTag is not applicable for the arguments (Object) 14:
15: 16:
17: 18: | 19: 20: An error occurred at line: 128 in the jsp file: /WEB-INF/jsp/home.jsp The method setItems(String) in the type ForTokensTag is not applicable for the arguments (Object) 125:
126: 127: 128: 129: 130: 131: Stacktrace: at org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:92) at org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330) at org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:415) at org.apache.jasper.compiler.Compiler.compile(Compiler.java:308) at org.apache.jasper.compiler.Compiler.compile(Compiler.java:286) at org.apache.jasper.compiler.Compiler.compile(Compiler.java:273) at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:566) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:316) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:336) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292) at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:142) at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:247) at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1105) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:841) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:106) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:229) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at net.sourceforge.subsonic.filter.RequestEncodingFilter.doFilter(RequestEncodingFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at net.sourceforge.subsonic.filter.ParameterDecodingFilter.doFilter(ParameterDecodingFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at net.sourceforge.subsonic.filter.BootstrapVerificationFilter.doFilter(BootstrapVerificationFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) 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:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446) at java.lang.Thread.run(Thread.java:619)
rimdur
 
Posts: 5
Joined: Mon Oct 22, 2007 8:16 pm
Top

Re: Running jboss-4.2.2.GA

Postby rimdur » Fri Nov 09, 2007 10:53 pm

rimdur wrote:Set it up correctly i thougth.
Version 3.1 of Subsonic
Susonic starts fine on port 8080 Im able to login then...


Java version Sun Microsystems Inc. 1.6.0_03
Operating system Windows Vista 6.0
Server JBossWeb/2.0.1.GA
Memory Used 41 of 126 MB


org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 17 in the jsp file: /WEB-INF/jsp/home.jsp The method setItems(String) in the type ForTokensTag is not applicable for the arguments (Object) 14:
15: 16:
17: 18: | 19: 20: An error occurred at line: 128 in the jsp file: /WEB-INF/jsp/home.jsp The method setItems(String) in the type ForTokensTag is not applicable for the arguments (Object) 125:
126: 127: 128: 129: 130: 131: Stacktrace: at org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:92) at org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330) at org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:415) at org.apache.jasper.compiler.Compiler.compile(Compiler.java:308) at org.apache.jasper.compiler.Compiler.compile(Compiler.java:286) at org.apache.jasper.compiler.Compiler.compile(Compiler.java:273) at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:566) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:316) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:336) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292) at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:142) at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:247) at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1105) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:841) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:106) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:229) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at net.sourceforge.subsonic.filter.RequestEncodingFilter.doFilter(RequestEncodingFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at net.sourceforge.subsonic.filter.ParameterDecodingFilter.doFilter(ParameterDecodingFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at net.sourceforge.subsonic.filter.BootstrapVerificationFilter.doFilter(BootstrapVerificationFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) 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:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446) at java.lang.Thread.run(Thread.java:619)


CREATE USER SA PASSWORD "" ADMIN
/*C1*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C2*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C3*/SET SCHEMA PUBLIC
CONNECT USER SA
create table version (version int not null)
DISCONNECT
/*C4*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(1)
DISCONNECT
/*C5*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C6*/SET SCHEMA PUBLIC
CONNECT USER SA
create table role (id int not null,name varchar not null,primary key (id))
DISCONNECT
/*C7*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO ROLE VALUES(1,'admin')
DISCONNECT
/*C8*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO ROLE VALUES(2,'download')
DISCONNECT
/*C9*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO ROLE VALUES(3,'upload')
DISCONNECT
/*C10*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO ROLE VALUES(4,'playlist')
DISCONNECT
/*C11*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO ROLE VALUES(5,'coverart')
DISCONNECT
/*C12*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C13*/SET SCHEMA PUBLIC
CONNECT USER SA
create table user (username varchar not null,password varchar not null,primary key (username))
DISCONNECT
/*C14*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO USER VALUES('admin','admin')
DISCONNECT
/*C15*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C16*/SET SCHEMA PUBLIC
CONNECT USER SA
create table user_role (username varchar not null,role_id int not null,primary key (username, role_id),foreign key (username) references user(username),foreign key (role_id) references role(id))
DISCONNECT
/*C17*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO USER_ROLE VALUES('admin',1)
DISCONNECT
/*C18*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO USER_ROLE VALUES('admin',2)
DISCONNECT
/*C19*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO USER_ROLE VALUES('admin',3)
DISCONNECT
/*C20*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO USER_ROLE VALUES('admin',4)
DISCONNECT
/*C21*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO USER_ROLE VALUES('admin',5)
DISCONNECT
/*C22*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C23*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(2)
DISCONNECT
/*C24*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C25*/SET SCHEMA PUBLIC
CONNECT USER SA
create table music_folder (id identity,path varchar not null,name varchar not null,enabled boolean not null)
DISCONNECT
/*C26*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO MUSIC_FOLDER VALUES(0,'c:\music','Music',TRUE)
DISCONNECT
/*C27*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C28*/SET SCHEMA PUBLIC
CONNECT USER SA
create cached table music_file_info (id identity,path varchar not null,rating int,comment varchar,play_count int,last_played datetime)
DISCONNECT
/*C29*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_music_file_info_path on music_file_info(path)
DISCONNECT
/*C30*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C31*/SET SCHEMA PUBLIC
CONNECT USER SA
create table internet_radio (id identity,name varchar not null,stream_url varchar not null,homepage_url varchar,enabled boolean not null)
DISCONNECT
/*C32*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C33*/SET SCHEMA PUBLIC
CONNECT USER SA
create table player (id int not null,name varchar,type varchar,username varchar,ip_address varchar,auto_control_enabled boolean not null,last_seen datetime,cover_art_scheme varchar not null,transcode_scheme varchar not null,primary key (id))
DISCONNECT
/*C34*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C35*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table player add dynamic_ip boolean default true not null
DISCONNECT
/*C36*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C37*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO ROLE VALUES(6,'comment')
DISCONNECT
/*C38*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO USER_ROLE VALUES('admin',6)
DISCONNECT
/*C39*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C40*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(3)
DISCONNECT
/*C41*/SET SCHEMA PUBLIC
CONNECT USER SA
drop index idx_music_file_info_path
DISCONNECT
/*C42*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table music_file_info alter column path varchar_ignorecase not null
DISCONNECT
/*C43*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_music_file_info_path on music_file_info(path)
DISCONNECT
/*C44*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C45*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user add bytes_streamed bigint default 0 not null
DISCONNECT
/*C46*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user add bytes_downloaded bigint default 0 not null
DISCONNECT
/*C47*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user add bytes_uploaded bigint default 0 not null
DISCONNECT
/*C48*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C49*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(4)
DISCONNECT
/*C50*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C51*/SET SCHEMA PUBLIC
CONNECT USER SA
create table user_settings (username varchar not null,locale varchar,theme_id varchar,final_version_notification boolean default true not null,beta_version_notification boolean default false not null,main_caption_cutoff int default 35 not null,main_track_number boolean default true not null,main_artist boolean default true not null,main_album boolean default false not null,main_genre boolean default false not null,main_year boolean default false not null,main_bit_rate boolean default false not null,main_duration boolean default true not null,main_format boolean default false not null,main_file_size boolean default false not null,playlist_caption_cutoff int default 35 not null,playlist_track_number boolean default false not null,playlist_artist boolean default true not null,playlist_album boolean default true not null,playlist_genre boolean default false not null,playlist_year boolean default true not null,playlist_bit_rate boolean default false not null,playlist_duration boolean default true not null,playlist_format boolean default true not null,playlist_file_size boolean default true not null,primary key (username),foreign key (username) references user(username) on delete cascade)
DISCONNECT
/*C52*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C53*/SET SCHEMA PUBLIC
CONNECT USER SA
create table transcoding (id identity,name varchar not null,source_format varchar not null,target_format varchar not null,step1 varchar not null,step2 varchar,step3 varchar,enabled boolean not null)
DISCONNECT
/*C54*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(0,'wav > mp3','wav','mp3','lame -b %b -S %s -',NULL,NULL,FALSE)
DISCONNECT
/*C55*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(1,'ogg > mp3','ogg','mp3','oggdec %s -o','lame -b %b - -',NULL,FALSE)
DISCONNECT
/*C56*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(2,'wma > mp3','wma','mp3','wmadec %s','lame -b %b -x - -',NULL,FALSE)
DISCONNECT
/*C57*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(3,'flac > mp3','flac','mp3','flac -c -s -d %s','lame -b %b - -',NULL,FALSE)
DISCONNECT
/*C58*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(4,'ape > mp3','ape','mp3','mac %s - -d','lame -b %b - -',NULL,FALSE)
DISCONNECT
/*C59*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(5,'m4a > mp3','m4a','mp3','faad -w %s','lame -b %b -x - -',NULL,FALSE)
DISCONNECT
/*C60*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(6,'mpc > mp3','mpc','mp3','mppdec --wav --silent %s -','lame -b %b - -',NULL,FALSE)
DISCONNECT
/*C61*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(7,'ofr > mp3','ofr','mp3','ofr --decode --silent %s --output -','lame -b %b - -',NULL,FALSE)
DISCONNECT
/*C62*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(8,'wv > mp3','wv','mp3','wvunpack -q %s -','lame -b %b - -',NULL,FALSE)
DISCONNECT
/*C63*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(9,'shn > mp3','shn','mp3','shorten -x %s -','lame -b %b - -',NULL,FALSE)
DISCONNECT
/*C64*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C65*/SET SCHEMA PUBLIC
CONNECT USER SA
create table player_transcoding (player_id int not null,transcoding_id int not null,primary key (player_id, transcoding_id),foreign key (player_id) references player(id) on delete cascade,foreign key (transcoding_id) references transcoding(id) on delete cascade)
DISCONNECT
/*C66*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C67*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(5)
DISCONNECT
/*C68*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C69*/SET SCHEMA PUBLIC
CONNECT USER SA
create table user_rating (username varchar not null,path varchar not null,rating double not null,primary key (username, path),foreign key (username) references user(username) on delete cascade)
DISCONNECT
/*C70*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C71*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C72*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(6)
DISCONNECT
/*C73*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C74*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add last_fm_enabled boolean default false not null
DISCONNECT
/*C75*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add last_fm_username varchar null
DISCONNECT
/*C76*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add last_fm_password varchar null
DISCONNECT
/*C77*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C78*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add transcode_scheme varchar default 'OFF' not null
DISCONNECT
/*C79*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C80*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(7)
DISCONNECT
/*C81*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C82*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table music_file_info add enabled boolean default true not null
DISCONNECT
/*C83*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C84*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table transcoding add default_active boolean default true not null
DISCONNECT
/*C85*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C86*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(8)
DISCONNECT
/*C87*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C88*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add show_now_playing boolean default true not null
DISCONNECT
/*C89*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C90*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add selected_music_folder_id int default -1 not null
DISCONNECT
/*C91*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C92*/SET SCHEMA PUBLIC
CONNECT USER SA
create table podcast_channel (id identity,url varchar not null,title varchar,description varchar,status varchar not null,error_message varchar)
DISCONNECT
/*C93*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C94*/SET SCHEMA PUBLIC
CONNECT USER SA
create table podcast_episode (id identity,channel_id int not null,url varchar not null,path varchar,title varchar,description varchar,publish_date datetime,duration varchar,bytes_total bigint,bytes_downloaded bigint,status varchar not null,error_message varchar,foreign key (channel_id) references podcast_channel(id) on delete cascade)
DISCONNECT
/*C95*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C96*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO ROLE VALUES(7,'podcast')
DISCONNECT
/*C97*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO USER_ROLE VALUES('admin',7)
DISCONNECT
/*C98*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C99*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C100*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C101*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C102*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C103*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C104*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C105*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C106*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C107*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C108*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C109*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C110*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C111*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C112*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C113*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C114*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C115*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C116*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C117*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C118*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C119*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C120*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C121*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C122*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C123*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C124*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C125*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C126*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C127*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C128*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C129*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C130*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C131*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C132*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C133*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C134*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C135*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C136*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C137*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C138*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C139*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C140*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C141*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C142*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C143*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C144*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C145*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C146*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C147*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C148*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO PLAYER VALUES(1,NULL,NULL,NULL,NULL,TRUE,NULL,'MEDIUM','OFF',TRUE)
DISCONNECT
/*C149*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C150*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C151*/SET SCHEMA PUBLIC
CONNECT USER SA
DELETE FROM PLAYER WHERE ID=1
INSERT INTO PLAYER VALUES(1,NULL,NULL,'admin','127.0.0.1',TRUE,NULL,'MEDIUM','OFF',TRUE)
DISCONNECT
/*C152*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C153*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C154*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C155*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C156*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C157*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C158*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C159*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C160*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C161*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C162*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C163*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C164*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C165*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C166*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C167*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C168*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C169*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C170*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C171*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C172*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C173*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C174*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C175*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C176*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C177*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C178*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C179*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C180*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C181*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C182*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C183*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C184*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C185*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C186*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C187*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C188*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C189*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C190*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C191*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C192*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C193*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C194*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C195*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C196*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C197*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C198*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C199*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C200*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C201*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C202*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C203*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C204*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C205*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C206*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C207*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C208*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C209*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C210*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C211*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C212*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C213*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C214*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C215*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C216*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C217*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C218*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C219*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C220*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C221*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C222*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C223*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C224*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C225*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C226*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C227*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C228*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C229*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C230*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C231*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C232*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C233*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C234*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C235*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C236*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C237*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C238*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C239*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C240*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C241*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C242*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C243*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C244*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C245*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C246*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C247*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C248*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C249*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C250*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C251*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C252*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C253*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C254*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C255*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C256*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C257*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C258*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C259*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C260*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C261*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C262*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C263*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C264*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C265*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C266*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C267*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C268*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C269*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C270*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C271*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C272*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C273*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C274*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C275*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C276*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C277*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C278*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C279*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C280*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C281*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C282*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C283*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C284*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C285*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C286*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C287*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C288*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C289*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C290*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C291*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C292*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C293*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C294*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C295*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C296*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C297*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C298*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C299*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C300*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C301*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C302*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C303*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C304*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C305*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C306*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C307*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C308*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C309*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C310*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C311*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C312*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C313*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C314*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C315*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C316*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C317*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C318*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C319*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C320*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C321*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C322*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C323*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C324*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C325*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C326*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C327*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C328*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C329*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C330*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C331*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C332*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C333*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C334*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C335*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C336*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C337*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C338*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C339*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C340*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C341*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C342*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C343*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C344*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C345*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C346*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C347*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C348*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C349*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C350*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C351*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C352*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C353*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C354*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C355*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C356*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C357*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C358*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C359*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C360*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C361*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C362*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C363*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C364*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C365*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C366*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C367*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C368*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C369*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C370*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C371*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C372*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C373*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C374*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C375*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C376*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C377*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C378*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C379*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C380*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C381*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C382*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C383*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C384*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C385*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C386*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C387*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C388*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C389*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C390*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C391*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C392*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C393*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C394*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C395*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C396*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C397*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C398*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C399*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C400*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C401*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C402*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C403*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C404*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C405*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C406*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C407*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C408*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C409*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C410*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C411*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C412*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C413*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C414*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C415*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C416*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C417*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C418*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C419*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C420*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C421*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C422*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C423*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C424*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C425*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C426*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C427*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C428*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C429*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C430*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C431*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C432*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C433*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C434*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C435*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C436*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
rimdur
 
Posts: 5
Joined: Mon Oct 22, 2007 8:16 pm
Top

Postby sindre_mehus » Sat Nov 10, 2007 7:05 am

Hi,

I saw something similar when running Subsonic in Jetty. The solution then was to use the JSP 2.0 version of Jetty, not JSP 2.1.

Hope this helps,
Sindre
User avatar
sindre_mehus
 
Posts: 1955
Joined: Tue Nov 29, 2005 6:19 pm
Location: Oslo, Norway
Top

Reason is: conflicting jar's

Postby ADie » Tue Apr 05, 2011 9:05 pm

You must remove the standard.jar from the subsonic.war file.

For Jboss 5.1.0 I had to remove the xml-apis.jar, too.

Now it's running perfectly under Jboss 5.1.0 GA.
ADie
 
Posts: 3
Joined: Mon Apr 04, 2011 6:47 pm
Top
Post a reply

Return to Help

Who is online

Users browsing this forum: No registered users and 16 guests

Powered by phpBB® Forum Software © phpBB Group
Protected by Anti-Spam ACP