Re: [base] Installation error messages
dardHost.java:736) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014) > at > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) > at > org.apache.catalina.core.StandardService.start(StandardService.java:448) > at > org.apache.catalina.core.StandardServer.start(StandardServer.java:700) > at org.apache.catalina.startup.Catalina.start(Catalina.java:552) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav > a:57) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.java:43) > at java.lang.reflect.Method.invoke(Method.java:616) > at > org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295) > at > org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433) > 14:55:50,918 ERROR [/base]:3958 - Servlet /base threw load() exception > java.lang.NoSuchMethodError: > javax.servlet.ServletContext.getContextPath()Ljava/lang/String; > at > net.sf.basedb.clients.web.servlet.ExtensionsServlet.init(ExtensionsServl > et.java:78) > at javax.servlet.GenericServlet.init(GenericServlet.java:212) > at > org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.jav > a:1139) > at > org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966) > at > org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.j > ava:3956) > at > org.apache.catalina.core.StandardContext.start(StandardContext.java:4230 > ) > at > org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.ja > va:760) > at > org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740) > at > org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544) > at > org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:9 > 20) > at > org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java > :883) > at > org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492) > at > org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138) > at > org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:31 > 1) > at > org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSu > pport.java:120) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022) > at > org.apache.catalina.core.StandardHost.start(StandardHost.java:736) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014) > at > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) > at > org.apache.catalina.core.StandardService.start(StandardService.java:448) > at > org.apache.catalina.core.StandardServer.start(StandardServer.java:700) > at org.apache.catalina.startup.Catalina.start(Catalina.java:552) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav > a:57) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.java:43) > at java.lang.reflect.Method.invoke(Method.java:616) > at > org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295) > at > org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433) > 15-May-2009 14:55:51 org.apache.catalina.core.ApplicationContext log > INFO: ContextListener: contextInitialized() > 15-May-2009 14:55:51 org.apache.catalina.core.ApplicationContext log > INFO: SessionListener: contextInitialized() > 15-May-2009 14:55:51 org.apache.coyote.http11.Http11BaseProtocol start > INFO: Starting Coyote HTTP/1.1 on http-8080 > 15-May-2009 14:55:51 org.apache.jk.common.ChannelSocket init > INFO: JK: ajp13 listening on /0.0.0.0:8009 > 15-May-2009 14:55:51 org.apache.jk.server.JkMain start > INFO: Jk running ID=0 time=0/13 config=null > 15-May-2009 14:55:51 org.apache.catalina.storeconfig.StoreLoader load > INFO: Find registry server-registry.xml at classpath resource > 15-May-2009 14:55:51 org.apache.catalina.startup.Catalina start > INFO: Server startup in 7631 ms > > -Original Message- > From: Nicklas Nordborg [mailto:nick...@thep.lu.se] > Sent: 15 May 2009 13:58 > To: BASE ML > Subject: Re: [base] Installation error messages > > This is the same stacktrace as you sent before. If you clean up the log > file and > restart your server do you see anything in the log file that is related > to the > start up that happens before y
Re: [base] Installation error messages
ethodError: javax.servlet.ServletContext.getContextPath()Ljava/lang/String; at net.sf.basedb.clients.web.servlet.ExtensionsServlet.init(ExtensionsServl et.java:78) at javax.servlet.GenericServlet.init(GenericServlet.java:212) at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.jav a:1139) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.j ava:3956) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4230 ) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.ja va:760) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:9 20) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java :883) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:31 1) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSu pport.java:120) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022) at org.apache.catalina.core.StandardHost.start(StandardHost.java:736) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:448) at org.apache.catalina.core.StandardServer.start(StandardServer.java:700) at org.apache.catalina.startup.Catalina.start(Catalina.java:552) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433) 15-May-2009 14:55:51 org.apache.catalina.core.ApplicationContext log INFO: ContextListener: contextInitialized() 15-May-2009 14:55:51 org.apache.catalina.core.ApplicationContext log INFO: SessionListener: contextInitialized() 15-May-2009 14:55:51 org.apache.coyote.http11.Http11BaseProtocol start INFO: Starting Coyote HTTP/1.1 on http-8080 15-May-2009 14:55:51 org.apache.jk.common.ChannelSocket init INFO: JK: ajp13 listening on /0.0.0.0:8009 15-May-2009 14:55:51 org.apache.jk.server.JkMain start INFO: Jk running ID=0 time=0/13 config=null 15-May-2009 14:55:51 org.apache.catalina.storeconfig.StoreLoader load INFO: Find registry server-registry.xml at classpath resource 15-May-2009 14:55:51 org.apache.catalina.startup.Catalina start INFO: Server startup in 7631 ms -Original Message- From: Nicklas Nordborg [mailto:nick...@thep.lu.se] Sent: 15 May 2009 13:58 To: BASE ML Subject: Re: [base] Installation error messages This is the same stacktrace as you sent before. If you clean up the log file and restart your server do you see anything in the log file that is related to the start up that happens before you even try to load the login page in a web browser? If not, enable the info-level logging as described in the previous mail and restart Tomcat again. /Nicklas michael watson (IAH-C) wrote: > This from my Catalina.out file: > > 13:44:51,875 ERROR [jsp]:723 - Servlet.service() for servlet jsp threw > exception > java.lang.NullPointerException > at > net.sf.basedb.clients.web.extensions.ExtensionsControl.useExtensions(Ext > ensionsControl.java:249) > at > org.apache.jsp.include.menu_jsp._jspService(menu_jsp.java:2186) > at > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > at > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja > va:328) > at > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315) > 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(Applica > tionFilterChain.java:269) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt > erChain.java:188) > at > org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatc > her.java:691) > at &
Re: [base] Installation error messages
t javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > at > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja > va:328) > at > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315) > 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(Applica > tionFilterChain.java:269) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt > erChain.java:188) > at > org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatc > her.java:691) > at > org.apache.catalina.core.ApplicationDispatcher.processRequest(Applicatio > nDispatcher.java:471) > at > org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDisp > atcher.java:403) > at > org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispat > cher.java:301) > at > org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java > :364) > at > org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.j > ava:213) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java > :135) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java > :117) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. > java:108) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1 > 51) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:87 > 0) > at > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc > essConnection(Http11BaseProtocol.java:665) > at > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint > .java:528) > at > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow > erWorkerThread.java:81) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool > .java:685) > at java.lang.Thread.run(Thread.java:636) > 15-May-2009 13:44:51 org.apache.catalina.core.StandardHostValve custom > SEVERE: Exception Processing > ErrorPage[exceptionType=java.lang.Throwable, > location=/exception/exception.jsp] > org.apache.jasper.JasperException: Exception in JSP: > /exception/exception.jsp:146 > > 143: } > 144: > 145: > 146: > 147: "+request.getAttribute("javax.servlet.error.request_uri")%>" > 148: style="width:90%;" messagestyle="height: 450px;"> > 149: class="form"> > > > Stacktrace: > at > org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServle > tWrapper.java:467) > at > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja > va:371) > at > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315) > 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(Applica > tionFilterChain.java:269) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt > erChain.java:188) > at > org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatc > her.java:691) > at > org.apache.catalina.core.ApplicationDispatcher.processRequest(Applicatio > nDispatcher.java:471) > at > org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDisp > atcher.java:403) > at > org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispat > cher.java:301) > at > org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java > :364) > at > org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.j > ava:213) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java > :135) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java > :117) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. > java:108) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1 > 51) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:87 > 0) > at > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc > essConnection(Http11BaseProtocol.java:665) >
Re: [base] Installation error messages
erWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool .java:685) at java.lang.Thread.run(Thread.java:636) 15-May-2009 13:44:51 org.apache.catalina.core.StandardHostValve custom SEVERE: Exception Processing ErrorPage[exceptionType=java.lang.Throwable, location=/exception/exception.jsp] org.apache.jasper.JasperException: Exception in JSP: /exception/exception.jsp:146 143:} 144: 145: 146: 147:" 148:style="width:90%;" messagestyle="height: 450px;"> 149: Stacktrace: at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServle tWrapper.java:467) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja va:371) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315) 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(Applica tionFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:188) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatc her.java:691) at org.apache.catalina.core.ApplicationDispatcher.processRequest(Applicatio nDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDisp atcher.java:403) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispat cher.java:301) at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java :364) at org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.j ava:213) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1 51) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:87 0) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc essConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint .java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow erWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool .java:685) at java.lang.Thread.run(Thread.java:636) -Original Message- From: Nicklas Nordborg [mailto:nick...@thep.lu.se] Sent: 15 May 2009 13:29 To: BASE ML Subject: Re: [base] Installation error messages This is most likely a secondary problem that is caused by some other problem when the server is started. Can you check the log file in Tomcat to see if there are more information. If you can't find anything you can try to enable INFO-level logging in BASE by setting the following property in the log4j.properties file. This file is found in WEB-INF/classes. This is the property you should set: log4j.logger.net.sf.basedb=info /Nicklas michael watson (IAH-C) wrote: > Hmmm, I don't know if this is related, but having set up BASE, I can get > to http://localhost:8080/base no problem, but as soon as I log in: > > HTTP Status 500 - > type Exception report > message > description The server encountered an internal error () that prevented > it from fulfilling this request. > exception > javax.servlet.ServletException: javax.servlet.jsp.JspTagException: > Exception in JSP: /include/menu.jsp:972 > > 969:// Extensions menu > 970:JspContext context = ExtensionsControl.createContext(dc, > pageContext); > 971:ExtensionsInvoker invoker = > 972: > (ExtensionsInvoker)ExtensionsControl.useExtensions(conte > xt, > 973: > "net.sf.basedb.clients.web.menu.extensions"); > 974:ExtensionsControl ec = ExtensionsControl.get(dc); > 975:ActionIterator it = invoker.iterate(); > > -- Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects ___ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to basedb-users-requ...@lists.sourceforge.net -- C
Re: [base] Installation error messages
This is most likely a secondary problem that is caused by some other problem when the server is started. Can you check the log file in Tomcat to see if there are more information. If you can't find anything you can try to enable INFO-level logging in BASE by setting the following property in the log4j.properties file. This file is found in WEB-INF/classes. This is the property you should set: log4j.logger.net.sf.basedb=info /Nicklas michael watson (IAH-C) wrote: > Hmmm, I don't know if this is related, but having set up BASE, I can get > to http://localhost:8080/base no problem, but as soon as I log in: > > HTTP Status 500 - > type Exception report > message > description The server encountered an internal error () that prevented > it from fulfilling this request. > exception > javax.servlet.ServletException: javax.servlet.jsp.JspTagException: > Exception in JSP: /include/menu.jsp:972 > > 969:// Extensions menu > 970:JspContext context = ExtensionsControl.createContext(dc, > pageContext); > 971:ExtensionsInvoker invoker = > 972: > (ExtensionsInvoker)ExtensionsControl.useExtensions(conte > xt, > 973: > "net.sf.basedb.clients.web.menu.extensions"); > 974:ExtensionsControl ec = ExtensionsControl.get(dc); > 975:ActionIterator it = invoker.iterate(); > > -- Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects ___ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to basedb-users-requ...@lists.sourceforge.net
Re: [base] Installation error messages
From: michael watson (IAH-C) [mailto:michael.wat...@bbsrc.ac.uk] Sent: 11 May 2009 12:10 To: BASE ML Cc: nick...@thep.lu.se Subject: Re: [base] Installation error messages Hi Niklas Thanks for the help - however, how do I actually do this?! :) The initdb.sh script is a very small script and simply calls java. This then creates connection url. So what file do I have to edit in order to add 'characterEncoding=UTF-8' to the connection url? Many thanks Mick -Original Message- From: Nicklas Nordborg [mailto:nick...@thep.lu.se] Sent: 08 May 2009 19:01 To: BASE ML Subject: Re: [base] Installation error messages It doesn't seem related to the Java version. If I remember correctly there has been users with similar problems before and I think the problem was a mismatch of the character encoding used by the MySQL server and the character encoding used by the JDBC driver. I recommend that you use the UTF-8 character set since from BASE 2.9 this is required for BASE to work. I can see that you connection url is missing an encoding. Try adding 'characterEncoding=UTF-8' to it and see if it helps. /Nicklas michael watson (IAH-C) wrote: > Dear List > > > > I'm trying to install BASE 2.8.4 on a new server. > > > > We have Java 1.6 but I think it is the Red Hat OpenJDK version. We also > have MySQL 5.0.45 > > > > Any clues appreciated! > > > > When I run initdb.sh I get: > > > > --System information- > > BASE : 2.8.4 > > Database : > jdbc:mysql://localhost/base2?useCursorFetch=true&defaultFetchSize=100&us eServerPrepStmts=true > > Dialect : org.hibernate.dialect.MySQLInnoDBDialect > > JDBC : com.mysql.jdbc.Driver; version 5.1 > > Java : OpenJDK Runtime Environment; 1.6.0-b09; Sun Microsystems Inc. > > OS : Linux; amd64; 2.6.18-92.el5 > > - > > Building database.. > > Database built successfully. > > Initialising database... > > --Creating quota types... > > --Creating quota... > > --Creating roles... > > --Creating users... > > --Creating groups... > > --Creating keys... > > --Creating protocol types... > > --Creating hardware types... > > --Creating hardware... > > --Creating software types... > > --Creating software... > > --Creating directories... > > --Creating file types... > > --Creating MIME types... > > --Creating plate geometries... > > --Creating plate mappings... > > --Creating labels... > > --Creating annotation types... > > --Creating clients... > > --Creating news... > > --Creating plugin definitions... > > --Creating example plugin configurations... > > --Creating formulas... > > --Creating job agents... > > --Creating data file types... > > --Creating platforms... > > Database initialised successfully. > > Updating database... > > Database updated successfully. > > Installing web application... > > > > net.sf.basedb.core.BaseException: could not insert: > [net.sf.basedb.core.data.HelpData] > > at > net.sf.basedb.plugins.HelpImporter.doImport(HelpImporter.java:395) > > at > net.sf.basedb.plugins.HelpImporter.installHelpTexts(HelpImporter.java:47 8) > > at > net.sf.basedb.install.Webclient.installHelpTexts(Webclient.java:196) > > at net.sf.basedb.install.Webclient.install(Webclient.java:155) > > at net.sf.basedb.install.InitDB.main(InitDB.java:81) > > Caused by: net.sf.basedb.core.BaseException: could not insert: > [net.sf.basedb.core.data.HelpData] > > at > net.sf.basedb.core.HibernateUtil.saveData(HibernateUtil.java:1065) > > at net.sf.basedb.core.DbControl.commit(DbControl.java:381) > > at > net.sf.basedb.plugins.HelpImporter.doImport(HelpImporter.java:386) > > ... 4 more > > Caused by: org.hibernate.exception.GenericJDBCException: could not > insert: [net.sf.basedb.core.data.HelpData] > > at > org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQ LStateConverter.java:103) > > at > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java :91) > > at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper. java:43) > > at > org.hibernate.id.insert.AbstractReturningDelegate.performInsert(Abstract ReturningDelegate.java:40) > > at > org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEn tityPersister.java:2158) > >
Re: [base] Installation error messages
michael watson (IAH-C) wrote: > Hi Niklas > > Thanks for the help - however, how do I actually do this?! :) > > The initdb.sh script is a very small script and simply calls java. This > then creates connection url. So what file do I have to edit in order to > add 'characterEncoding=UTF-8' to the connection url? It's in the base.config configuration file. http://base.thep.lu.se/chrome/site/latest/html/appendix/appendix.base.config.html#appendix.base.config /Nicklas -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com ___ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to basedb-users-requ...@lists.sourceforge.net
Re: [base] Installation error messages
Hi Niklas Thanks for the help - however, how do I actually do this?! :) The initdb.sh script is a very small script and simply calls java. This then creates connection url. So what file do I have to edit in order to add 'characterEncoding=UTF-8' to the connection url? Many thanks Mick -Original Message- From: Nicklas Nordborg [mailto:nick...@thep.lu.se] Sent: 08 May 2009 19:01 To: BASE ML Subject: Re: [base] Installation error messages It doesn't seem related to the Java version. If I remember correctly there has been users with similar problems before and I think the problem was a mismatch of the character encoding used by the MySQL server and the character encoding used by the JDBC driver. I recommend that you use the UTF-8 character set since from BASE 2.9 this is required for BASE to work. I can see that you connection url is missing an encoding. Try adding 'characterEncoding=UTF-8' to it and see if it helps. /Nicklas michael watson (IAH-C) wrote: > Dear List > > > > I'm trying to install BASE 2.8.4 on a new server. > > > > We have Java 1.6 but I think it is the Red Hat OpenJDK version. We also > have MySQL 5.0.45 > > > > Any clues appreciated! > > > > When I run initdb.sh I get: > > > > --System information- > > BASE : 2.8.4 > > Database : > jdbc:mysql://localhost/base2?useCursorFetch=true&defaultFetchSize=100&us eServerPrepStmts=true > > Dialect : org.hibernate.dialect.MySQLInnoDBDialect > > JDBC : com.mysql.jdbc.Driver; version 5.1 > > Java : OpenJDK Runtime Environment; 1.6.0-b09; Sun Microsystems Inc. > > OS : Linux; amd64; 2.6.18-92.el5 > > - > > Building database.. > > Database built successfully. > > Initialising database... > > --Creating quota types... > > --Creating quota... > > --Creating roles... > > --Creating users... > > --Creating groups... > > --Creating keys... > > --Creating protocol types... > > --Creating hardware types... > > --Creating hardware... > > --Creating software types... > > --Creating software... > > --Creating directories... > > --Creating file types... > > --Creating MIME types... > > --Creating plate geometries... > > --Creating plate mappings... > > --Creating labels... > > --Creating annotation types... > > --Creating clients... > > --Creating news... > > --Creating plugin definitions... > > --Creating example plugin configurations... > > --Creating formulas... > > --Creating job agents... > > --Creating data file types... > > --Creating platforms... > > Database initialised successfully. > > Updating database... > > Database updated successfully. > > Installing web application... > > > > net.sf.basedb.core.BaseException: could not insert: > [net.sf.basedb.core.data.HelpData] > > at > net.sf.basedb.plugins.HelpImporter.doImport(HelpImporter.java:395) > > at > net.sf.basedb.plugins.HelpImporter.installHelpTexts(HelpImporter.java:47 8) > > at > net.sf.basedb.install.Webclient.installHelpTexts(Webclient.java:196) > > at net.sf.basedb.install.Webclient.install(Webclient.java:155) > > at net.sf.basedb.install.InitDB.main(InitDB.java:81) > > Caused by: net.sf.basedb.core.BaseException: could not insert: > [net.sf.basedb.core.data.HelpData] > > at > net.sf.basedb.core.HibernateUtil.saveData(HibernateUtil.java:1065) > > at net.sf.basedb.core.DbControl.commit(DbControl.java:381) > > at > net.sf.basedb.plugins.HelpImporter.doImport(HelpImporter.java:386) > > ... 4 more > > Caused by: org.hibernate.exception.GenericJDBCException: could not > insert: [net.sf.basedb.core.data.HelpData] > > at > org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQ LStateConverter.java:103) > > at > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java :91) > > at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper. java:43) > > at > org.hibernate.id.insert.AbstractReturningDelegate.performInsert(Abstract ReturningDelegate.java:40) > > at > org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEn tityPersister.java:2158) > > at > org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEn tityPersister.java:2638) > > at > org.hibernate.action.EntityIden
Re: [base] Installation error messages
Trying to keep our test and production servers in sync :) -Original Message- From: Jari Häkkinen [mailto:j...@thep.lu.se] Sent: 08 May 2009 22:10 To: BASE ML Subject: Re: [base] Installation error messages And why not use the latest BASE 2.11? Jari Nicklas Nordborg wrote: > It doesn't seem related to the Java version. If I remember correctly > there has been users with similar problems before and I think the > problem was a mismatch of the character encoding used by the MySQL > server and the character encoding used by the JDBC driver. > > I recommend that you use the UTF-8 character set since from BASE 2.9 > this is required for BASE to work. I can see that you connection url is > missing an encoding. Try adding 'characterEncoding=UTF-8' to it and see > if it helps. > > /Nicklas > > michael watson (IAH-C) wrote: >> Dear List >> >> >> >> I'm trying to install BASE 2.8.4 on a new server. >> >> >> >> We have Java 1.6 but I think it is the Red Hat OpenJDK version. We also >> have MySQL 5.0.45 >> >> >> >> Any clues appreciated! >> >> >> >> When I run initdb.sh I get: >> >> >> >> --System information- >> >> BASE : 2.8.4 >> >> Database : >> jdbc:mysql://localhost/base2?useCursorFetch=true&defaultFetchSize=100&useServerPrepStmts=true >> >> Dialect : org.hibernate.dialect.MySQLInnoDBDialect >> >> JDBC : com.mysql.jdbc.Driver; version 5.1 >> >> Java : OpenJDK Runtime Environment; 1.6.0-b09; Sun Microsystems Inc. >> >> OS : Linux; amd64; 2.6.18-92.el5 >> >> - >> >> Building database.. >> >> Database built successfully. >> >> Initialising database... >> >> --Creating quota types... >> >> --Creating quota... >> >> --Creating roles... >> >> --Creating users... >> >> --Creating groups... >> >> --Creating keys... >> >> --Creating protocol types... >> >> --Creating hardware types... >> >> --Creating hardware... >> >> --Creating software types... >> >> --Creating software... >> >> --Creating directories... >> >> --Creating file types... >> >> --Creating MIME types... >> >> --Creating plate geometries... >> >> --Creating plate mappings... >> >> --Creating labels... >> >> --Creating annotation types... >> >> --Creating clients... >> >> --Creating news... >> >> --Creating plugin definitions... >> >> --Creating example plugin configurations... >> >> --Creating formulas... >> >> --Creating job agents... >> >> --Creating data file types... >> >> --Creating platforms... >> >> Database initialised successfully. >> >> Updating database... >> >> Database updated successfully. >> >> Installing web application... >> >> >> >> net.sf.basedb.core.BaseException: could not insert: >> [net.sf.basedb.core.data.HelpData] >> >> at >> net.sf.basedb.plugins.HelpImporter.doImport(HelpImporter.java:395) >> >> at >> net.sf.basedb.plugins.HelpImporter.installHelpTexts(HelpImporter.java:478) >> >> at >> net.sf.basedb.install.Webclient.installHelpTexts(Webclient.java:196) >> >> at net.sf.basedb.install.Webclient.install(Webclient.java:155) >> >> at net.sf.basedb.install.InitDB.main(InitDB.java:81) >> >> Caused by: net.sf.basedb.core.BaseException: could not insert: >> [net.sf.basedb.core.data.HelpData] >> >> at >> net.sf.basedb.core.HibernateUtil.saveData(HibernateUtil.java:1065) >> >> at net.sf.basedb.core.DbControl.commit(DbControl.java:381) >> >> at >> net.sf.basedb.plugins.HelpImporter.doImport(HelpImporter.java:386) >> >> ... 4 more >> >> Caused by: org.hibernate.exception.GenericJDBCException: could not >> insert: [net.sf.basedb.core.data.HelpData] >> >> at >> org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) >> >> at >> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) >> >> at >> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43
Re: [base] Installation error messages
And why not use the latest BASE 2.11? Jari Nicklas Nordborg wrote: > It doesn't seem related to the Java version. If I remember correctly > there has been users with similar problems before and I think the > problem was a mismatch of the character encoding used by the MySQL > server and the character encoding used by the JDBC driver. > > I recommend that you use the UTF-8 character set since from BASE 2.9 > this is required for BASE to work. I can see that you connection url is > missing an encoding. Try adding 'characterEncoding=UTF-8' to it and see > if it helps. > > /Nicklas > > michael watson (IAH-C) wrote: >> Dear List >> >> >> >> I’m trying to install BASE 2.8.4 on a new server. >> >> >> >> We have Java 1.6 but I think it is the Red Hat OpenJDK version. We also >> have MySQL 5.0.45 >> >> >> >> Any clues appreciated! >> >> >> >> When I run initdb.sh I get: >> >> >> >> --System information- >> >> BASE : 2.8.4 >> >> Database : >> jdbc:mysql://localhost/base2?useCursorFetch=true&defaultFetchSize=100&useServerPrepStmts=true >> >> Dialect : org.hibernate.dialect.MySQLInnoDBDialect >> >> JDBC : com.mysql.jdbc.Driver; version 5.1 >> >> Java : OpenJDK Runtime Environment; 1.6.0-b09; Sun Microsystems Inc. >> >> OS : Linux; amd64; 2.6.18-92.el5 >> >> - >> >> Building database.. >> >> Database built successfully. >> >> Initialising database... >> >> --Creating quota types... >> >> --Creating quota... >> >> --Creating roles... >> >> --Creating users... >> >> --Creating groups... >> >> --Creating keys... >> >> --Creating protocol types... >> >> --Creating hardware types... >> >> --Creating hardware... >> >> --Creating software types... >> >> --Creating software... >> >> --Creating directories... >> >> --Creating file types... >> >> --Creating MIME types... >> >> --Creating plate geometries... >> >> --Creating plate mappings... >> >> --Creating labels... >> >> --Creating annotation types... >> >> --Creating clients... >> >> --Creating news... >> >> --Creating plugin definitions... >> >> --Creating example plugin configurations... >> >> --Creating formulas... >> >> --Creating job agents... >> >> --Creating data file types... >> >> --Creating platforms... >> >> Database initialised successfully. >> >> Updating database... >> >> Database updated successfully. >> >> Installing web application... >> >> >> >> net.sf.basedb.core.BaseException: could not insert: >> [net.sf.basedb.core.data.HelpData] >> >> at >> net.sf.basedb.plugins.HelpImporter.doImport(HelpImporter.java:395) >> >> at >> net.sf.basedb.plugins.HelpImporter.installHelpTexts(HelpImporter.java:478) >> >> at >> net.sf.basedb.install.Webclient.installHelpTexts(Webclient.java:196) >> >> at net.sf.basedb.install.Webclient.install(Webclient.java:155) >> >> at net.sf.basedb.install.InitDB.main(InitDB.java:81) >> >> Caused by: net.sf.basedb.core.BaseException: could not insert: >> [net.sf.basedb.core.data.HelpData] >> >> at >> net.sf.basedb.core.HibernateUtil.saveData(HibernateUtil.java:1065) >> >> at net.sf.basedb.core.DbControl.commit(DbControl.java:381) >> >> at >> net.sf.basedb.plugins.HelpImporter.doImport(HelpImporter.java:386) >> >> ... 4 more >> >> Caused by: org.hibernate.exception.GenericJDBCException: could not >> insert: [net.sf.basedb.core.data.HelpData] >> >> at >> org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) >> >> at >> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) >> >> at >> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) >> >> at >> org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40) >> >> at >> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158) >> >> at >> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638) >> >> at >> org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48) >> >> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250) >> >> at >> org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298) >> >> at >> org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181) >> >> at >> org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107) >> >> at >> org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187) >> >> at >> org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListene
Re: [base] Installation error messages
It doesn't seem related to the Java version. If I remember correctly there has been users with similar problems before and I think the problem was a mismatch of the character encoding used by the MySQL server and the character encoding used by the JDBC driver. I recommend that you use the UTF-8 character set since from BASE 2.9 this is required for BASE to work. I can see that you connection url is missing an encoding. Try adding 'characterEncoding=UTF-8' to it and see if it helps. /Nicklas michael watson (IAH-C) wrote: > Dear List > > > > I’m trying to install BASE 2.8.4 on a new server. > > > > We have Java 1.6 but I think it is the Red Hat OpenJDK version. We also > have MySQL 5.0.45 > > > > Any clues appreciated! > > > > When I run initdb.sh I get: > > > > --System information- > > BASE : 2.8.4 > > Database : > jdbc:mysql://localhost/base2?useCursorFetch=true&defaultFetchSize=100&useServerPrepStmts=true > > Dialect : org.hibernate.dialect.MySQLInnoDBDialect > > JDBC : com.mysql.jdbc.Driver; version 5.1 > > Java : OpenJDK Runtime Environment; 1.6.0-b09; Sun Microsystems Inc. > > OS : Linux; amd64; 2.6.18-92.el5 > > - > > Building database.. > > Database built successfully. > > Initialising database... > > --Creating quota types... > > --Creating quota... > > --Creating roles... > > --Creating users... > > --Creating groups... > > --Creating keys... > > --Creating protocol types... > > --Creating hardware types... > > --Creating hardware... > > --Creating software types... > > --Creating software... > > --Creating directories... > > --Creating file types... > > --Creating MIME types... > > --Creating plate geometries... > > --Creating plate mappings... > > --Creating labels... > > --Creating annotation types... > > --Creating clients... > > --Creating news... > > --Creating plugin definitions... > > --Creating example plugin configurations... > > --Creating formulas... > > --Creating job agents... > > --Creating data file types... > > --Creating platforms... > > Database initialised successfully. > > Updating database... > > Database updated successfully. > > Installing web application... > > > > net.sf.basedb.core.BaseException: could not insert: > [net.sf.basedb.core.data.HelpData] > > at > net.sf.basedb.plugins.HelpImporter.doImport(HelpImporter.java:395) > > at > net.sf.basedb.plugins.HelpImporter.installHelpTexts(HelpImporter.java:478) > > at > net.sf.basedb.install.Webclient.installHelpTexts(Webclient.java:196) > > at net.sf.basedb.install.Webclient.install(Webclient.java:155) > > at net.sf.basedb.install.InitDB.main(InitDB.java:81) > > Caused by: net.sf.basedb.core.BaseException: could not insert: > [net.sf.basedb.core.data.HelpData] > > at > net.sf.basedb.core.HibernateUtil.saveData(HibernateUtil.java:1065) > > at net.sf.basedb.core.DbControl.commit(DbControl.java:381) > > at > net.sf.basedb.plugins.HelpImporter.doImport(HelpImporter.java:386) > > ... 4 more > > Caused by: org.hibernate.exception.GenericJDBCException: could not > insert: [net.sf.basedb.core.data.HelpData] > > at > org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) > > at > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) > > at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) > > at > org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40) > > at > org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158) > > at > org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638) > > at > org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48) > > at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250) > > at > org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298) > > at > org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181) > > at > org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107) > > at > org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187) > > at > org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33) > > at > org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172) > > at > org.hibernate.event.def.Defau