Sybase support

Hi,

We'd like to run JIRA using Sybase as the datastore, although we know it is not tested by you. We have had some success with the field type definition file (below).

When we start Tomcat, JIRA creates all the tables without any problems. We get the initial setup page, but when we click to enter the admin user, we get NullPointerExceptions in the console and the browser is empty.

We have the environment set up and working fine on Oracle. We did this first, seeing as the field type definition file already existed for that database.

Have you any ideas what might be causing the problem? I cannot find anything on the web or here about using JIRA with Sybase.

Many thanks,

Michael Brown

FieldTypes
----------

<fieldtypemodel>
<!-- ===================== field-type-def ==================== -->
<!-- General Types -->
<field-type-def type="blob" sql-type="IMAGE" java-type="java.lang.Object"></field-type-def>

<field-type-def type="date-time" sql-type="DATETIME" java-type="java.sql.Timestamp"></field-type-def>
<field-type-def type="date" sql-type="DATETIME" java-type="java.sql.Date"></field-type-def>
<field-type-def type="time" sql-type="DATETIME" java-type="java.sql.Time"></field-type-def>

<field-type-def type="currency-amount" sql-type="NUMERIC(18,2)" java-type="Double"><validate name="isSignedDouble" /></field-type-def>
<field-type-def type="floating-point" sql-type="NUMERIC(18,6)" java-type="Double"><validate name="isSignedDouble" /></field-type-def>
<field-type-def type="numeric" sql-type="NUMERIC(18,0)" java-type="Long"><validate name="isSignedLong" /></field-type-def>
<field-type-def type="integer" sql-type="NUMERIC(9,0)" java-type="Integer"><validate name="isSignedLong" /></field-type-def>

<field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"></field-type-def>
<field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"></field-type-def>
<field-type-def type="id-vlong" sql-type="VARCHAR(255)" java-type="String"></field-type-def>

<field-type-def type="indicator" sql-type="CHAR(1)" java-type="String"></field-type-def>
<field-type-def type="very-short" sql-type="VARCHAR(10)" java-type="String"></field-type-def>
<field-type-def type="short-varchar" sql-type="VARCHAR(60)" java-type="String"></field-type-def>
<field-type-def type="long-varchar" sql-type="VARCHAR(255)" java-type="String"></field-type-def>
<field-type-def type="very-long" sql-type="VARCHAR(4000)" java-type="String"></field-type-def>

<field-type-def type="comment" sql-type="VARCHAR(255)" java-type="String"></field-type-def>
<field-type-def type="description" sql-type="VARCHAR(255)" java-type="String"></field-type-def>
<field-type-def type="name" sql-type="VARCHAR(60)" java-type="String"></field-type-def>
<field-type-def type="value" sql-type="VARCHAR(255)" java-type="String"></field-type-def>

<!-- Specialized Types -->
<field-type-def type="credit-card-number" sql-type="VARCHAR(40)" java-type="String"><validate name="isAnyCard" /></field-type-def>
<field-type-def type="credit-card-date" sql-type="VARCHAR(20)" java-type="String"><validate name="isDateAfterToday" /></field-type-def>
<field-type-def type="email" sql-type="VARCHAR(255)" java-type="String"><validate name="isEmail" /></field-type-def>
<field-type-def type="url" sql-type="VARCHAR(255)" java-type="String"></field-type-def>
<field-type-def type="id-ne" sql-type="VARCHAR(20)" java-type="String"><validate name="isNotEmpty" /></field-type-def>
<field-type-def type="id-long-ne" sql-type="VARCHAR(60)" java-type="String"><validate name="isNotEmpty" /></field-type-def>
<field-type-def type="id-vlong-ne" sql-type="VARCHAR(255)" java-type="String"><validate name="isNotEmpty" /></field-type-def>
<field-type-def type="tel-number" sql-type="VARCHAR(60)" java-type="String"><validate name="isInternationalPhoneNumber" /></field-type-def>
</fieldtypemodel>

Console log:
------------

Starting service Tomcat-Standalone
Apache Tomcat/4.0.3
2002-05-24 12:02:55,875 FATAL [core.entity.model.ModelReader] FINISHED LOADING E
NTITIES - ALL FILES; #Entities=22 #ViewEntities=0 #Fields=98 #Relationships=14
Starting service Tomcat-Apache
Apache Tomcat/4.0.3
java.lang.NullPointerException
at com.opensymphony.module.user.provider.ofbiz.OFBizAbstractProvider.fin
dUser(OFBizAbstractProvider.java:166)
at com.opensymphony.module.user.provider.ofbiz.OFBizProfileProvider.hand
les(OFBizProfileProvider.java:140)
at com.opensymphony.module.user.UserManager.getProvider(UserManager.java
:330)
at com.opensymphony.module.user.UserManager.access$1(UserManager.java)
at com.opensymphony.module.user.UserManager$Accessor.getProfileProvider(
UserManager.java:366)
at com.opensymphony.module.user.Entity.getProfileProvider(Entity.java:10
5)
at com.opensymphony.module.user.Entity.getPropertySet(Entity.java:59)
at com.opensymphony.module.user.User.getFullName(User.java:49)
at org.apache.jsp.insecure$jsp._jspService(insecure$jsp.java:323)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspSer
vlet.java:202)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
82)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:683)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
ispatcher.java:574)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
patcher.java:497)
at com.opensymphony.module.sitemesh.filter.PageFilter.applyDecorator(Unk
nown Source)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(Unknown S
ource)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:193)
at com.atlassian.jira.web.security.SecurityFilter.doFilter(SecurityFilte
r.java:201)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:193)
at com.atlassian.jira.web.security.LoginFilter.doFilter(LoginFilter.java
:189)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:190)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:
2343)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:180)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatche
rValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
468)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:174)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline
.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcesso
r.java:1012)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.ja
va:1107)
at java.lang.Thread.run(Thread.java:484)