[Opensource] SYBASE - Expresso

[Michael Rimov]

At 10:00 AM 7/22/02 -0500, you wrote:
>Hi to everyone!
>I've been trying to configure Sybase to work with Expresso, the JDBC 
>JConnect is
>already installed, when I tried to perform the Setup procedures which Expresso
>has by default I got the next message...
>
>"Unable to execute statement: CREATE TABLE EVENT(Event nchar(30) not null,
>Descrip sysname(80) not
>null)(com.jcorporate.expresso.core.ExpressoSchema.createTable(), db/context
>'Default'):Specified length is too large for type 'sysname'."

Basically you modify such scripts through changing the type mappings for 
most situations.  If everything else fails, we add special situations to 
handle certain databases in the Schema.createTable().

But the problem is that somehow your JDBC Driver is mapping an Expresso 
type to 'sysname'.  Check com.jcorproate.expresso.services.dbobj.Event's 
definition by checking the setupTable() function.  I believe sysname is 
probably going to be varchar or text.  Then you'll need to add the 
appropriate entry into expresso-config.xml, restart, and rerun dbcreate.

HTH!
                                         -Mike