[Opensource] Expresso 505 AppIntegration Setup Failure

[larry hamel]

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
>_______________________________________________
>Opensource mailing list
>Opensource at jcorporate.com
>http://mail.jcorporate.com/mailman/listinfo/opensource
>Archives: http://mail.jcorporate.com/pipermail/opensource/