Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-6378

Problem deploying JIRA on Jetty + Derby

    XMLWordPrintable

Details

    • Support Request
    • Resolution: Answered
    • Medium
    • None
    • 3.1.1
    • Installation
    • 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:

      Attachments

        Activity

          People

            Unassigned Unassigned
            2b3d423243fa Stephen Olano
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: