I am trying to configure the Expresso Framework i Apache Tomcat.
I 've unjar the expresso war file into my tomcat server. But not in ROOT
`/home/gdd2_dev/jakarta-tomcat/webapps/ROOT'
but rather install in a new web app subdirectory which I called
`/home/gdd2_dev/jakarta-tomcat/webapps/expresso'
I created a separate configuration directory
`home/gdd2_dev/jakarta-tomcat/expresso_config'
and installed a `default.properties' into it. Modified of course.
pilgpe@cedar (bash) [369] > cat
/home/gdd2_dev/jakarta-tomcat/expresso_config/default.properties
dbDriver=org.hsql.jdbcDriver
dbURL=jdbc:HypersonicSQL:/home/gdd2_dev/tmp/expresso/db
dbConnectFormat=3
dbLogin=sa
dbPassword=
prefix=/expresso/servlet
## images=/components/images
images=/expresso/components/images
dbCache=y
## trace=n
trace=y
trace.sql=y
## loginForm=/components/expresso/jsp/login.jsp
loginForm=/expresso/components/expresso/jsp/login.jsp
dbTest=select 0
description=Hypersonic Database
dbMap.LONGVARCHAR=LONGVARCHAR
I added to the Tomcat classpath also
`/home/gdd2_dev/jakarta-tomcat/webapps/expresso/WEB-INF/classes'
I gone through the online config on the website. I can't find an answer.
The expresso framework does not seem to find this Hypersonic SQL database.
Why?
What am I doing so wrong?
pilgpe@cedar (bash) [378] >
pilgpe@cedar (bash) [378] > run-tomcat.sh
==================================
Running Apache Jakarta Tomcat
==================================
Tomcat IS running --- force de majeur ---
Sending SIGTERM to Tomcat
3835
Starting tomcat now
Using classpath:
.:/home/gdd2_dev/jakarta-tomcat/lib/ant.jar:/home/gdd2_dev/jakarta-tomcat/lib/jasper.jar:/home/gdd2_dev/jakarta-tomcat/lib/servlet.jar:/home/gdd2_dev/jakarta-tomcat/lib/test:/home/gdd2_dev/jakarta-tomcat/lib/webserver.jar:/home/gdd2_dev/jakarta-tomcat/lib/xml.jar:/home/gdd2_dev/j2sdk1_3_0beta_refresh/lib/tools.jar:.:/home/pilgpe/JavaClasses:/home/gdd2_dev/cos/lib/cos.jar:/home/gdd2_dev/jakarta-tomcat/lib/servlet.jar:/home/gdd2_dev/jakarta-tomcat/webapps/expresso/WEB-INF/classes:/home/gdd2_dev/cocoon-1.8/lib/xerces_1_2.jar:/home/gdd2_dev/cocoon-1.8/lib/xalan_1_2_D02.jar:$/home/gdd2_dev/classes/gnu-regexp-1.0.8.jar:/home/pilgpe/JavaClasses/JMF1.1/lib/jmf.jar:/home/pilgpe/JavaClasses/jh1.0/javahelp/lib/jhall.jar:UNSET:/apps/summit/java/lib/connectJdbc113.zip:/home/pilgpe/JavaClasses/mysql_comp.jar:/lib/jsdk.jar:/home/gdd2_dev/lib:/home/gdd2_dev/classes/ecs-1.3.3.jar:/home/gdd2_dev/webmacro/webmacro.jar:/home/gdd2_dev/webmacro/examples:/home/gdd2_dev/classes/mai!
l.!
!
jar:/home/gdd2_dev/classes/activa
tion.jar:/home/gdd2_dev/classes/pop3.jar
pilgpe@cedar (bash) [379] > Context log: path="/examples" Adding context
path="/examples" docBase="webapps/examples"
Context log: path="" Adding context path="" docBase="webapps/ROOT"
Context log: path="/test" Adding context path="/test" docBase="webapps/test"
Starting tomcat. Check logs/tomcat.log for error messages
Starting tomcat install="/home/gdd2_dev/jakarta-tomcat"
home="/home/gdd2_dev/jakarta-tomcat"
classPath=".:/home/gdd2_dev/jakarta-tomcat/lib/ant.jar:/home/gdd2_dev/jakarta-tomcat/lib/jasper.jar:/home/gdd2_dev/jakarta-tomcat/lib/servlet.jar:/home/gdd2_dev/jakarta-tomcat/lib/test:/home/gdd2_dev/jakarta-tomcat/lib/webserver.jar:/home/gdd2_dev/jakarta-tomcat/lib/xml.jar:/home/gdd2_dev/j2sdk1_3_0beta_refresh/lib/tools.jar:.:/home/pilgpe/JavaClasses:/home/gdd2_dev/cos/lib/cos.jar:/home/gdd2_dev/jakarta-tomcat/lib/servlet.jar:/home/gdd2_dev/jakarta-tomcat/webapps/expresso/WEB-INF/classes:/home/gdd2_dev/cocoon-1.8/lib/xerces_1_2.jar:/home/gdd2_dev/cocoon-1.8/lib/xalan_1_2_D02.jar:$/home/gdd2_dev/classes/gnu-regexp-1.0.8.jar:/home/pilgpe/JavaClasses/JMF1.1/lib/jmf.jar:/home/pilgpe/JavaClasses/jh1.0/javahelp/lib/jhall.jar:UNSET:/apps/summit/java/lib/connectJdbc113.zip:/home/pilgpe/JavaClasses/mysql_comp.jar:/lib/jsdk.jar:/home/gdd2_dev/lib:/home/gdd2_dev/classes/ecs-1.3.3.jar:/home/gdd!
2_!
!
dev/webmacro/webmacro.jar:/home/g
dd2_dev/webmacro/examples:/home/gdd2_dev/classes/mail.jar:/home/gdd2_dev/classes/activation.jar:/home/gdd2_dev/classes/pop3.jar"
Context log: path="/admin" Automatic context load
docBase="/home/gdd2_dev/jakarta-tomcat/webapps/admin"
Context log: path="/admin" Adding context path="/admin"
docBase="/home/gdd2_dev/jakarta-tomcat/webapps/admin"
Context log: path="/expresso" Automatic context load
docBase="/home/gdd2_dev/jakarta-tomcat/webapps/expresso"
Context log: path="/expresso" Adding context path="/expresso"
docBase="/home/gdd2_dev/jakarta-tomcat/webapps/expresso"
XmlMapper: Can't find method setDistributable in
Ctx(/expresso,/home/gdd2_dev/jakarta-tomcat/webapps/expresso) CLASS class
org.apache.tomcat.core.Context
XmlMapper: Can't find method setDescription in Wrapper(DefaultInit
com.javacorporate.common.servlet.DefaultInit) CLASS class
org.apache.tomcat.core.ServletWrapper
XmlMapper: Can't find method setDescription in Wrapper(Status
com.javacorporate.common.servlet.Status) CLASS class
org.apache.tomcat.core.ServletWrapper
XmlMapper: Can't find method setDescription in Wrapper(RunSQL
com.javacorporate.common.servlet.RunSQL) CLASS class
org.apache.tomcat.core.ServletWrapper
XmlMapper: Can't find method setDescription in Wrapper(InitServletProps
com.javacorporate.common.servlet.InitServletProps) CLASS class
org.apache.tomcat.core.ServletWrapper
XmlMapper: Can't find method setDescription in Wrapper(Search
com.javacorporate.common.servlet.Search) CLASS class
org.apache.tomcat.core.ServletWrapper
XmlMapper: Can't find method setDescription in Wrapper(DBMaint
com.javacorporate.common.servlet.DBMaint) CLASS class
org.apache.tomcat.core.ServletWrapper
XmlMapper: Can't find method setDescription in Wrapper(ChangePassword
com.javacorporate.common.servlet.ChangePassword) CLASS class
org.apache.tomcat.core.ServletWrapper
XmlMapper: Can't find method setDescription in Wrapper(SendNotice
com.javacorporate.common.servlet.SendNotice) CLASS class
org.apache.tomcat.core.ServletWrapper
XmlMapper: Can't find method setDescription in Wrapper(Download
com.javacorporate.common.servlet.Download) CLASS class
org.apache.tomcat.core.ServletWrapper
XmlMapper: Can't find method setDescription in Wrapper(Login
com.javacorporate.common.servlet.Login) CLASS class
org.apache.tomcat.core.ServletWrapper
XmlMapper: Can't find method setDescription in Wrapper(RegisterUser
com.javacorporate.common.servlet.RegisterUser) CLASS class
org.apache.tomcat.core.ServletWrapper
XmlMapper: Can't find method setDescription in Wrapper(ShowLog
com.javacorporate.common.servlet.ShowLog) CLASS class
org.apache.tomcat.core.ServletWrapper
XmlMapper: Can't find method setDescription in Wrapper(DBCreate
com.javacorporate.common.servlet.DBCreate) CLASS class
org.apache.tomcat.core.ServletWrapper
XmlMapper: Can't find method setDescription in Wrapper(ControllerServlet
com.javacorporate.common.servlet.ControllerServlet) CLASS class
org.apache.tomcat.core.ServletWrapper
XmlMapper: Can't find method setDescription in Wrapper(ControllerActionServlet
com.javacorporate.common.servlet.ControllerActionServlet) CLASS class
org.apache.tomcat.core.ServletWrapper
XmlMapper: Can't find method setDescription in Wrapper(ClearLogs
com.javacorporate.common.servlet.ClearLogs) CLASS class
org.apache.tomcat.core.ServletWrapper
XmlMapper: Can't find method setDescription in Wrapper(EmailValidation
com.javacorporate.common.servlet.EmailValidation) CLASS class
org.apache.tomcat.core.ServletWrapper
XmlMapper: Can't find method setDescription in Wrapper(Logout
com.javacorporate.common.servlet.Logout) CLASS class
org.apache.tomcat.core.ServletWrapper
XmlMapper: Can't find method setDescription in Wrapper(Test
com.javacorporate.common.servlet.Test) CLASS class
org.apache.tomcat.core.ServletWrapper
com.javacorporate.common.servlet.DefaultInit.init(ServletConfig):Initializing
com.javacorporate.common.servlet.DefaultInit.init(ServletConfig):Loading
configurations from /home/gdd2_dev/jakarta-tomcat/expresso_config
com.javacorporate.common.util.ConfigManager.load(String):Loading configurations from
'/home/gdd2_dev/jakarta-tomcat/expresso_config'
com.javacorporate.common.util.ConfigManager.load(String):Loading configuration
'default.properties'
com.javacorporate.common.util.ConfigManager.load(String):Loading configuration
'default.properties~'
com.javacorporate.common.util.ConfigManager.load(String):All configuration files loaded
com.javacorporate.common.servlet.DefaultInit.init(ServletConfig):Initializing
connection pool(s)
com.javacorporate.common.util.ConfigManager.dbInitialize():Initializing connection
pool(s)
com.javacorporate.common.util.ConfigManager.dbInitialize():Initializing pool for
configuration 'default'
com.javacorporate.common.util.ConfigManager.dbInitialize():Tracing disabled
com.javacorporate.common.util.ConfigManager.dbInitialize():DB connection testing
enabled
com.javacorporate.common.util.ConfigManager.dbInitialize():All connection pools
initialized
com.javacorporate.common.servlet.DefaultInit.init(ServletConfig):Reading setup values
com.javacorporate.common.dbobj.Setup.readSetups():Reading setup values for all
databases/contexts
com.javacorporate.common.dbobj.Setup.readSetups():Reading setup values for 'default'
com.javacorporate.common.dbobj.Setup.readSetups():WARNING: Unable to read setup values
for db 'default'
com.javacorporate.db.DBException: com.javacorporate.db.DBConnection.connect(String,
String):Cant get connection to database via driver 'org.hsql.jdbcDriver' and URL
'jdbc:HypersonicSQL:/usr/db/expresso' (no description):File input/output error:
/usr/db/expresso.properties
at com.javacorporate.db.DBConnection.connect(DBConnection.java:238)
at
com.javacorporate.db.DBConnectionPool.getConnection(DBConnectionPool.java:364)
at
com.javacorporate.db.DBConnectionPool.getConnection(DBConnectionPool.java:405)
at com.javacorporate.dbobj.DBObject.searchAndRetrieve(DBObject.java:2679)
at
com.javacorporate.dbobj.SecuredDBObject.searchAndRetrieve(SecuredDBObject.java:304)
at com.javacorporate.common.dbobj.Setup.readSetups(Setup.java:259)
at com.javacorporate.common.servlet.InitServlet.init(InitServlet.java:124)
at org.apache.tomcat.core.ServletWrapper.initServlet(ServletWrapper.java:315)
at org.apache.tomcat.core.ServletWrapper.loadServlet(ServletWrapper.java:276)
at
org.apache.tomcat.context.LoadOnStartupInterceptor.contextInit(LoadOnStartupInterceptor.java:132)
at org.apache.tomcat.core.ContextManager.initContext(ContextManager.java:227)
at org.apache.tomcat.core.ContextManager.init(ContextManager.java:201)
at org.apache.tomcat.startup.Tomcat.execute(Tomcat.java:156)
at org.apache.tomcat.startup.Tomcat.main(Tomcat.java:163)
com.javacorporate.common.servlet.DefaultInit.init(ServletConfig):Starting job
handler(s)
com.javacorporate.common.util.ConfigManager.startJobHandler():Starting job handler(s)
com.javacorporate.common.util.ConfigManager.startJobHandler():Job handler for
configuration 'default' not enabled. Use "startJobHandler=y" in properties file.
com.javacorporate.common.util.ConfigManager.startJobHandler():All job handlers started
com.javacorporate.common.servlet.DefaultInit.init(ServletConfig):Loading
application-specific lists
com.javacorporate.common.servlet.DefaultInit.init(ServletConfig):Expresso
initialization complete
pilgpe@cedar (bash) [379] >
--
Peter Pilgrim
G.O.A.T
"the Greatest Of All Time"
--
This e-mail may contain confidential and/or privileged information. If you are not the
intended recipient (or have received this e-mail in error) please notify the sender
immediately and destroy this e-mail. Any unauthorised copying, disclosure or
distribution of the material in this e-mail is strictly forbidden.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets