Hi,
I tried create database specify "type=InnoDB".
with the following script:
>create table objects(uri blob not null, primary key uriIndex (uri(255)),
classname blob) type=InnoDB;
I'm getting the following error
ERROR 1073: BLOB column 'uri' can't be used in key specification with the used
table type
Is it supported with slide? If yes, please let me know how?
Any help is welcome.
----- Original Message -----
From: "Dirk Verbeeck" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, September 01, 2001 8:31 AM
Subject: Re: What should i use mysql table type to do transactions?
Kiyoko Takanabe wrote:
> Hello All,
>
> We tryied to use mysql v3.23+ via JDBC.
> I have some question.
>
> Prior to version 3.23, MySQL had no support for transactions, so Slide's standard
>JDBC store cannot populate the namespace
properly.
>
> Slide use mysql Table type 'myisam' by default,
> but myisam has no support for transactions.
>
> As a workaround, should i use innoDB type?
>
> ___________________________________________
> iDimension Inc.
> Kiyoko Takanabe
I don't use a mysql database but InnoDB seems the best table type.
Please report back if this type works for you.
Dirk
