[Opensource] Expresso 4.02 and Oracle frustration

[McBrayer, Roy]

I have worked for two days trying to configure Expresso 4.02 and Oracle 9
but have had very little progress. I am running the complete package
(4.02)and using TomCat on Windows NT 4 server. 

First, I do not get a Login nav bar option after installation. But perhaps
this is not supposed to be present until after setup. When I go to
Setup/Initialize Database and click run, I get this error from my log file
followed, of course, by many other errors.

2002-09-11 16:37:49,328 ERROR [main] misc.ConfigManager
(com.jcorporate.expresso.core.misc.ConfigManager.mapOtherDBs(ConfigManager.j
ava:1120)) - Unable to read database mapping entries for context 'default'

My expresso-config.xml file is in 
this location E:expressonstall/webapps/expresso/WEB-INF

The content of the file is below. I also read about a default.properties
file. I located one under
E:expressoinstall/webapps/expresso/WEB-INF/db/default/default.properties.
But it only contained the following four lines and I cannot find any docs to
tell me how it should be altered. I did experiment with it to no avail.


#HSQL database
#Wed Sep 11 14:06:57 CDT 2002
version=1.6
modified=yes

I'd appreciate some pointers on how to solve these problems. 
 
 

Here is the expresso-config.xml file.

<!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>Oracle Database</description>
  
    <jdbc driver='oracle.jdbc.driver.OracleDriver'
       url='jdbc:oracle:thin:@localhost:1521:test'
       connectFormat='1'
       login='system'
       password='test'
       dateTimeUpdateFormat='yyyy-MM-dd HH mm ss'
       dateTimeUpdateFunction='TO_DATE( %s,'YYYY-MM-DD HH24 MI SS')'
      cache='n'
    />
  <type-mapping>
         <java-type>VARCHAR</java-type>
         <db-type>varchar2(4000)</db-type>
    </type-mapping>
    <type-mapping>
       <java-type>LONGVARCHAR</java-type>
       <db-type>varchar2(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>
       <expresso-type>datetime</expresso-type>
       <db-type>DATE</db-type>
    </type-mapping>
  
  
    <type-mapping>
           <expresso-type>BIT</expresso-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> 

Thanks,

Roy McBrayer<?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office" />


 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.jcorporate.com/pipermail/opensource/attachments/20020912/60b3b617/attachment-0002.htm