Re: [base] Installation error messages

2009-05-15 Thread Nicklas Nordborg
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

2009-05-15 Thread michael watson (IAH-C)
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

2009-05-15 Thread Nicklas Nordborg
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

2009-05-15 Thread michael watson (IAH-C)
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

2009-05-15 Thread Nicklas Nordborg
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

2009-05-15 Thread michael watson (IAH-C)
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

2009-05-11 Thread Nicklas Nordborg
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

2009-05-11 Thread michael watson (IAH-C)
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

2009-05-11 Thread michael watson (IAH-C)
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

2009-05-08 Thread Jari Häkkinen
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

2009-05-08 Thread Nicklas Nordborg
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

[base] Installation error messages

2009-05-08 Thread michael watson (IAH-C)
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.EntityIdentityInsertAction.execute(EntityIdentityIn
sertAction.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(AbstractSa
veEventListener.java:181)

at
org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(Ab
stractSaveEventListener.java:107)

at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGenerat
edOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)

at
org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequ
estedId(DefaultSaveEventListener.java:33)

at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransie
nt(DefaultSaveOrUpdateEventListener.java:172)

at
org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(Def
aultSaveEventListener.java:27)

at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(
DefaultSaveOrUpdateEventListener.java:70)

at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)

at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)

at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)

at
net.sf.basedb.core.HibernateUtil.saveData(HibernateUtil.java:1056)

... 6 more

Caused by: java.sql.SQLException: Incorrect string value: '\xD7--
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