[Opensource] Expresso 5.0, Oracle database and OC4J

[MAU NGUYEN]

Hi,
I just installed Expresso 5.0 to work with Oracle OC4J container. It works
OK. When I go to setup and create database with Hypersonic database, it
works OK. However when I try to create database with Oracle database, it
fails. Error message as follows:
500 Internal Server Error
java.lang.NullPointerException
 at com.jcorporate.expresso.core.dbobj.Schema.typeForDB(Schema.java:1597)
 at com.jcorporate.expresso.core.dbobj.Schema.createTable(Schema.java:1118)
 at
com.jcorporate.expresso.core.dbobj.Schema.createAsNeeded(Schema.java:585)
 at
com.jcorporate.expresso.core.utility.DBTool.createTables(DBTool.java:2117)
 at
com.jcorporate.expresso.services.servlet.DBCreate.doPost(DBCreate.java:282)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at com.evermind[Oracle9iAS (9.0.3.0.0) Containers for
J2EE].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.j
ava:721)
 at com.evermind[Oracle9iAS (9.0.3.0.0) Containers for
J2EE].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDis
patcher.java:306)
 at com.evermind[Oracle9iAS (9.0.3.0.0) Containers for
J2EE].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:
767)
 at com.evermind[Oracle9iAS (9.0.3.0.0) Containers for
J2EE].server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)
 at com.evermind[Oracle9iAS (9.0.3.0.0) Containers for
J2EE].server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)
 at
EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.ja
va:803)
 at java.lang.Thread.run(Unknown Source)

Content of my expresso-config.xml as follows:
<?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>Hypersonic Database</description>
  <jdbc driver="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:%web-app%WEB-INF/db/default/default" connectFormat="3"
login="sa" password="" cache="y" createTableIndicies="true"
limitationPosition=""
escapeHandler="com.jcorporate.expresso.core.db.DoubleQuoteEscapeHandler"/>
  <type-mapping>
   <java-type>LONGVARCHAR</java-type>
   <db-type>LONGVARCHAR</db-type>
  </type-mapping>
  <images>%context%/%expresso-dir%/images</images>
  <startJobHandler>y</startJobHandler>
  <showStackTrace>y</showStackTrace>
  <mailDebug>n</mailDebug>
 </context>

 <context name="Oracle">
  <description>Oracle Database</description>
  <jdbc
   driver="oracle.jdbc.driver.OracleDriver"
   url="jdbc:oracle:thin:@pandora.pwc.com:1530:cmd1"
   connectFormat="1"
   login="bf28518"
   password="canada1"
   dateTimeSelectFormat="yyyy-MM-dd HH:mm:ss"
   dateTimeSelectFunction="TO_CHAR(%s,'YYYY-MM-DD HH24:MI:SS') %s"
   dateTimeUpdateFormat="yyyy-MM-dd HH:mm:ss"
   dateTimeUpdateFunction="TO_DATE('%s','YYYY-MM-DD HH24:MI:SS')"
   dateSelectFormat="yyyy-MM-dd HH:mm:ss"
   dateSelectFunction="TO_CHAR(%s,'YYYY-MM-DD HH24:MI:SS') %s"
   dateUpdateFormat="yyyy-MM-dd HH:mm:ss"
   dateUpdateFunction="TO_DATE('%s','YYYY-MM-DD HH24:MI:SS')"
   cache="y"
   createTableIndicies="true"
   limitationPosition=""
   escapeHandler="com.jcorporate.expresso.core.db.DoubleQuoteEscapeHandler">
   <dbWildcard>%</dbWildcard>
  </jdbc>
  <type-mapping>
   <java-type>LONGVARCHAR</java-type>
   <db-type>varchar(4000)</db-type>
  </type-mapping>
  <type-mapping>
   <java-type>DATE</java-type>
   <db-type>DATE</db-type>
  </type-mapping>
  <type-mapping>
   <java-type>DOUBLE</java-type>
   <db-type>FLOAT</db-type>
  </type-mapping>
  <type-mapping>
   <java-type>INTEGER</java-type>
   <db-type>NUMBER</db-type>
  </type-mapping>
  <type-mapping>
   <java-type>DATETIME</java-type>
   <db-type>DATE</db-type>
  </type-mapping>
  <type-mapping>
   <java-type>TIMESTAMP</java-type>
   <db-type>DATE</db-type>
  </type-mapping>
  <type-mapping>
   <java-type>BIT</java-type>
   <db-type>NUMBER</db-type>
  </type-mapping>
  <images>%context%/%expresso-dir%/images</images>
  <startJobHandler>n</startJobHandler>
  <showStackTrace>y</showStackTrace>
  <mailDebug>n</mailDebug>
 </context>

</expresso-config>

Please let me know how to make it work.
Thank you very much in advance.
Best regards,
Mau Nguyen