[Opensource] Database troubles in 4.1

Marcus Lindberg lindbergmarcus at hotmail.com
Tue Oct 8 00:56:39 PDT 2002 

Hi!

I downloded the latest version of Expresso 4.1. The
http://www.jcorporate.com page names it Expresso 4.1ea3 Release. And the 
download page just names it Expresso 4.1. Whats its real name?

Anyway, I have tried to get my SQL Server 2K database to work. Create/Verify 
Database Structure & Perform Initial Setup in the setup works ok. But then I 
get trouble with the CheckLogin class. There is a nullpointerexception 
generated due to the null value in the EXPIRES field of the GROUPMEMBERS 
table. Any ideas? Anyone with a working SQL Server 2K or Oracle 
expresso-config.xml?

Stack Trace:

java.lang.NullPointerException
        at java.util.Calendar.setTime(Calendar.java:902)
        at java.text.SimpleDateFormat.format(SimpleDateFormat.java:780)
        at java.text.SimpleDateFormat.format(SimpleDateFormat.java:773)
        at java.text.DateFormat.format(DateFormat.java:314)
        at 
com.jcorporate.expresso.core.misc.DateTime.getDateForDB(DateTime.java:360)
        at 
com.jcorporate.expresso.core.dbobj.DBObject.getCustomStringFieldValue(DBObject.java:3482)
        at 
com.jcorporate.expresso.core.dbobj.DBObject.searchAndRetrieveList(DBObject.java:5886)
        at 
com.jcorporate.expresso.core.dbobj.SecuredDBObject.searchAndRetrieveList(SecuredDBObject.java:635)
        at 
com.jcorporate.expresso.services.dbobj.DefaultUserInfo.getGroups(DefaultUserInfo.java:263)
        at 
com.jcorporate.expresso.core.security.User.getGroups(User.java:433)
        at 
com.jcorporate.expresso.core.security.User.postLogin(User.java:759)
        at 
com.jcorporate.expresso.core.servlet.CheckLogin.loginViaCookie(CheckLogin.java:437)
        at 
com.jcorporate.expresso.core.servlet.CheckLogin.check(CheckLogin.java:201)
        at 
com.jcorporate.expresso.core.servlet.CheckLogin.checkLogin(CheckLogin.java:123)
        at org.apache.jsp.frame$jsp._jspService(frame$jsp.java:164)
        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(JspServlet.java:201)
        at 
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
        at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
        at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
        at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
        at 
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
        at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
        at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
        at 
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
        at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
        at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
        at 
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
        at 
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
        at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
        at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
        at 
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
        at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
        at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: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.java:472)
        at 
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
        at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
        at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
        at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
        at 
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
        at 
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
        at 
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
        at java.lang.Thread.run(Thread.java:536)
2002-10-08 09:55:15,586 ERROR [HttpProcessor[8080][4]] servlet.CheckLogin 
(CheckLogin.java:208) - java.lang.NullPointerException



My expresso-config.xml

<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE expresso-config PUBLIC "-//Jcorporate Ltd//DTD Expresso 
Configuration 4.0//EN"
          "http://www.jcorporate.com/dtds/expresso-config_4_0.dtd">
<expresso-config>
	<logDirectory>%web-app%WEB-INF/log</logDirectory>
	<strongCrypto>n</strongCrypto>
	<servletAPI>2_3</servletAPI>
	<cryptoKey>Sample Test Key - Change for serious deployment</cryptoKey>
	<encryptMode>AES</encryptMode>
	<class-handlers>
		<class-handler name="userInfo" 
classHandler="com.jcorporate.expresso.services.dbobj.DefaultUserInfo"/>
		<class-handler name="orderedCache" 
classHandler="com.jcorporate.expresso.core.cache.OrderedCache"/>
		<class-handler name="unorderedCache" 
classHandler="com.jcorporate.expresso.core.cache.UnOrderedCache"/>
		<!-- Others are:
		<class-handler name="nextNumber" 
classHandler="com.centercomp.clustering.ClusterNextNumber"/>
		<class-handler name="cacheSynchronizer" 
classHandler="com.centercomp.clustering.ClusteredCacheSync"/>
		-->
	</class-handlers>
<context name="default">
  <description>SQLServer2K</description>

  <jdbc
    driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
    
url="jdbc:microsoft:sqlserver://DBSERVER:1036;databaseName=IC;SelectMethod=cursor"
    connectFormat="1"
    login="icuser"
    password="android"
    dateSelectFormat="dd-MM-yyyy"
    dateUpdateFormat="dd-MM-yyyy"
    dateTimeSelectFormat="yyyy-MM-dd"
    dateTimeUpdateFormat="yyyy-MM-dd"
    escapeHandler='com.jcorporate.expresso.core.db.DoubleQuoteEscapeHandler'
    createTableIndicies="true"
    cache="y"
    >


    <dbWildcard>%</dbWildcard>
    <dbWildcard>*</dbWildcard>
  </jdbc>


  <type-mapping>
    <java-type>LONGVARCHAR</java-type>
    <expresso-type>text</expresso-type>
    <db-type>text</db-type>
  </type-mapping>

  <type-mapping>
    <java-type>DATE</java-type>
    <db-type>datetime</db-type>
  </type-mapping>

  <type-mapping>
    <java-type>datetime</java-type>
    <db-type>datetime</db-type>
  </type-mapping>

  <type-mapping>
     <java-type>TIMESTAMP</java-type>
     <db-type>smalldatetime</db-type>
  </type-mapping>

  <type-mapping>
    <java-type>DOUBLE</java-type>
    <db-type>NUMERIC</db-type>
  </type-mapping>

  <type-mapping>
    <java-type>LONGVARCHAR</java-type>
    <db-type>VARCHAR(1024)</db-type>
  </type-mapping>

  <type-mapping>
    <java-type>INTEGER</java-type>
    <db-type>int</db-type>
  </type-mapping>

  <type-mapping>
    <java-type>NUMERIC</java-type>
    <db-type>NUMERIC</db-type>
  </type-mapping>

  <images>%context%/%expresso-dir%/images</images>

  <startJobHandler>y</startJobHandler>
  <showStackTrace>y</showStackTrace>
  <mailDebug>n</mailDebug>

</context>
</expresso-config>



    /Marcus Lindberg




_________________________________________________________________
Skicka snabbmeddelanden till dina vänner online med MSN Messenger: 
http://messenger.msn.se

More information about the Opensource mailing list