[Opensource] Expresso with OC4J and Oracle Driver

[MAU NGUYEN]

Hi,
I just tried to install Expresso in OC4J container and it works with
Hypersonic database. However when I try to change to Oracle database, it
failed.
Error message:

500 Internal Server Error
com.jcorporate.expresso.core.db.DBException:
com.jcorporate.expresso.core.db.DBConnection.connect(String, String):Cant
get connection to database via driver 'oracle.jdbc.driver.OracleDriver' and
URL 'jdbc:oracle:thin:@myoracle:1550:dev1' (no description):Io exception:
Connection
refused(DESCRIPTION=(TMP=)(VSNNUM=135294976)(ERR=12505)(ERROR_STACK=(ERROR=(
CODE=12505)(EMFI=4))))
 at
com.jcorporate.expresso.core.db.DBConnection.connect(DBConnection.java:503)
 at
com.jcorporate.expresso.core.db.DBConnectionPool.getConnection(DBConnectionP
ool.java:748)
 at
com.jcorporate.expresso.core.db.DBConnectionPool.getConnection(DBConnectionP
ool.java:836)
 at
com.jcorporate.expresso.core.dbobj.Schema.initializeMaps(Schema.java:1491)
 at com.jcorporate.expresso.core.dbobj.Schema.typeForDB(Schema.java:1577)
 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:797)
 at java.lang.Thread.run(Unknown Source)


Content of 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>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 why it cannot connect to Oracle database.
Best regards,
Mau Nguyen