[Opensource] Expresso 505 AppIntegration Setup Failure

[Jennifer Chen]

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