Details
-
Support Request
-
Resolution: Answered
-
Medium
-
None
-
3.1.1
-
See Below (included JIRA error dump)
Description
I tried installing JIRA on Jetty + Apache Derby.
Im having problem deploying it successfully.
Things I added on edit-webapp/WEB-INF/classes/entityengine.xml:
....
<field-type name="derby" loader="maincp" location="entitydefs/fieldtype-cloudscape.xml"/>
....
<datasource name="defaultDS"
field-type-name="derby"
helper-class="org.ofbiz.core.entity.GenericHelperDAO"
check-on-start="true"
add-missing-on-start="true">
<inline-jdbc
jdbc-driver="com.ibm.db2.jcc.DB2Driver"
jdbc-uri="jdbc:derby:net://localhost:1527/jiradb;create=true;user=jiradb;password=jiradb;retrieveMessagesFromServerOnGetMessage=true;"
jdbc-username="jiradb"
jdbc-password="jiradb"
isolation-level="Serializable"/>
</datasource>
.....
I also extracted the jira-jars-jetty.zip files on $JIRA/webapp/WEB-INF/lib
and copied cloudscape/derby jdbc drivers on $JIRA/edit-webapp/WEB-INF/lib
db2jcc.jar
db2jcc_license_c.jar
The Derby database is running as Network Server/Standalone, and I can
access it without problem using DbVisualizer JDBC client.
I can also connect to the database using the "ij" tool that came with Derby.
Any idea on how to make this work?
--------------------------error dump by jira-----------------------
Cause:
Referer URL: http://localhost:8080/
Build Information:
Uptime: 18 minutes
Edition: Professional
Version: 3.1.1
Build Number: 81
Server Information:
Application Server: Jetty/5.1.2
Servlet Version: 2.4
Memory Information:
Total Memory: 26 MB
Free Memory: 3 MB
Used Memory: 23 MB
System Information:
System Date: Monday, 11 Apr 2005
System Time: 01:20:25
Java Version: 1.4.2_07
Java Vendor: Sun Microsystems Inc.
JVM Version: 1.0
JVM Vendor: Sun Microsystems Inc.
JVM Implementation Version: 1.4.2_07-b05
Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition
Java VM: Java HotSpot(TM) Client VM
User Name: ibo
User Timezone: GMT+08:00
User Locale: English (Philippines)
System Encoding: ISO-8859-1
Operating System: Linux 2.6.8.1-3-386
OS Architecture: i386
Application Server Container: Jetty/5.1.2
Database type: derby
Database JNDI address:
Request Information:
Request URL: http://localhost:8080/atlassian-jira-3.1.1/500page.jsp
- Scheme: http
- Server: localhost
- Port: 8080
- URI: /atlassian-jira-3.1.1/500page.jsp
- - Context Path: /atlassian-jira-3.1.1
- - Servlet Path: /500page.jsp
- - Path Info: null
- - Query String: null
Request Attributes: - javax.servlet.forward.context_path : /atlassian-jira-3.1.1
- javax.servlet.error.message : while inserting: [GenericEntity:OSPropertyEntry][propertyKey,webwork.i18n.encoding][type,5][id,null][entityName,jira.properties][entityId,1] (SQL Exception while executing the following:INSERT INTO propertyentry (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype) VALUES (?, ?, ?, ?, ?) (DB2 SQL error: SQLCODE: -1, SQLSTATE: 23502, SQLERRMC: ID�23502))
com.opensymphony.module.propertyset.PropertyImplementationException: while inserting: [GenericEntity:OSPropertyEntry][propertyKey,webwork.i18n.encoding][type,5][id,null][entityName,jira.properties][entityId,1] (SQL Exception while executing the following:INSERT INTO propertyentry (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype) VALUES (?, ?, ?, ?, ?) (DB2 SQL error: SQLCODE: -1, SQLSTATE: 23502, SQLERRMC: ID�23502))
at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.setImpl(OFBizPropertySet.java:185)
at com.opensymphony.module.propertyset.AbstractPropertySet.set(AbstractPropertySet.java:570)
at com.opensymphony.module.propertyset.AbstractPropertySet.setString(AbstractPropertySet.java:368)
at com.atlassian.jira.propertyset.JiraCachingPropertySet.setString(JiraCachingPropertySet.java:317)
at com.atlassian.jira.config.properties.ApplicationPropertiesImpl.setString(ApplicationPropertiesImpl.java:120)
at com.atlassian.jira.web.action.setup.Setup.setLanguage(Setup.java:111)
at com.atlassian.jira.web.action.setup.Setup.doDefault(Setup.java:58)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:61)
at webwork.util.InjectionUtils.invoke(InjectionUtils.java:52)
at webwork.action.ActionSupport.invokeCommand(ActionSupport.java:417)
at webwork.action.ActionSupport.execute(ActionSupport.java:146)
at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:46)
at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:131)
at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:186)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:822)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58)
at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:36)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:813)
at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:168)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:813)
at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:177)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:813)
at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132)
at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:25)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:813)
at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:37)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:813)
at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:91)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:813)
at com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:72)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:813)
at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:36)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:813)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:494)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:624)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1434)
at org.mortbay.http.HttpServer.service(HttpServer.java:896)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
- os_securityfilter_already_filtered : true
- com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true
- com.atlassian.jira.web.filters.ActionCleanupDelayFilter : true
- javax.servlet.error.request_uri : /atlassian-jira-3.1.1/secure/Setup!default.jspa
- javax.servlet.forward.query_string : null
- javax.servlet.error.status_code : 500
- jira.webwork.cleanup : false
- os_authstatus : null
- _sitemesh_filterapplied : true
- javax.servlet.error.servlet_name : action
- com.atlassian.jira.web.filters.gzip.GzipFilter_already_filtered : true
- javax.servlet.forward.path_info : null
- loginfilter.already.filtered : true
- atlassian.core.seraph.original.url : /secure/Setup!default.jspa
- javax.servlet.forward.servlet_path : /secure/Setup!default.jspa
- webwork.result : Value stack =========== ===========
- javax.servlet.forward.request_uri : /atlassian-jira-3.1.1/secure/Setup!default.jspa
Request Logging:
0 log statements generated by this request: