[Opensource] Expresso 505 AppIntegration Setup Failure

[Jennifer Chen]

Thank you for everyone's suggestions and help:)

The failure was due to a type-mapping problem. By
adding the following mapping to my expresso-config.xml
file(For Oracle database), Expresso 505 setup runs
great.

-Jennifer

<type-mapping>
    <java-type>LONGVARCHAR</java-type>
    <db-type>varchar(4000)</db-type>
</type-mapping>
 
 
--- opensource-request at jcorporate.com wrote:

Message: 5
Date: Thu, 19 Jun 2003 18:10:13 -0700
To: opensource at jcorporate.com
From: Larry Hamel <larry at codeguild.com>
Subject: Re: [Opensource] Expresso 505 AppIntegration
Setup Failure
Reply-To: opensource at jcorporate.com

mapping generally varies by database, but I can't
imagine a situation 
where text is mapped to long.

the following web page has links

http://www.jcorporate.com/econtent/Content.do;jsessionid=a0UCj5Hv2EJa?state=runView&db=default&resource=254

which describe setup for various databases.

in our setup for MySql, we map text to longvarchar,
for example.

Larry

At 04:10 PM 6/19/2003, you wrote:
>We had the follow failure when initialize the
Expresso
>505. 
>
>In the AppIntegration.java we have:
>
>addField("FromKey", "text", 0, false, "fromKey");
>addField("ToKey", "text", 0, false, "toKey");
>
>Do we really want to map "text" type to "LONG"?!
>
>-Jennifer
>
>
>2003-06-19 18:15:01,343 WARN  [ExecuteThread: '9' for
>queue: 'default'] dbobj.Sc
>hema (Schema.java:1524) - Unable to map
java.sql.Types
>value -101 to a string. T
>he database  may have returned an invalid type map.
>New type being added...
><Jun 19, 2003 6:15:01 PM EDT> <Error> <HTTP> <101017>
><[ServletContext(id=179111
>4,name=cwAppl,context-path=/cwAppl)] Root cause of
>ServletException
>com.jcorporate.expresso.core.db.DBException: Unable
to
>execute statement: CREATE
> TABLE APPINTEGRATE(IntegrationId NUMBER not null,
>FromSchema VARCHAR2
>              (128) not null, ToSchema VARCHAR2      

>                (128) not
> null, FromObj VARCHAR2                        (128)
>not null, ToObj VARCHAR2
>                     (128) not null, FromKey LONG    

>                       no
>t null, ToKey LONG                             not
>null)(com.jcorporate.expresso
>.core.dbobj.Schema.createTable(), db/context
>'default'):ORA-01754: a table may c
>ontain only one column of type LONG
>
>        at
>com.jcorporate.expresso.core.db.DBConnection.executeUpdate(DBConnecti
>on.java:882)
>        at
>com.jcorporate.expresso.core.dbobj.Schema.createTable(Schema.java:124
>2)
>        at
>com.jcorporate.expresso.core.dbobj.Schema.createAsNeeded(Schema.java:
>592)


__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com