It seems the mysql db script still doesn't work well, below is what I got
when i am trying to run it. (my mysql version is 5.0.84)
[sql] Failed to execute: create table LARGE_DATA (ID bigint not null
auto_increment, BIN_DATA blob(2G), INSERT_TIME datetime, MLOCK integer not
null, primary key (ID))
[sql] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near '2G), INSERT_TIME datetime,
MLOCK integer not null, primary key (ID))' at line 1
I am testing against 1.x trunk. Seems this issue was existed for a long
time?? (http://mmondora.mondora.com/2009/01/apache-ode-jboss-and-mysql.html)
Regards
Jeff
On Wed, Oct 14, 2009 at 1:16 AM, Milinda Pathirage <
[email protected]> wrote:
> Hi Helko,
>
> After building ODE 1.x you will find hibernate SQL scripts at
> ODE_ROOT/dao-hibernate-db/target directory and JPA SQL scripts at
> ODE_ROOT/dao-jpa-ojpa-derby/target directory.
>
> Thanks
> Milinda
>
> On Tue, Oct 13, 2009 at 7:32 PM, Heiko Braun <[email protected]> wrote:
>
> >
> > I am looking for the DB scripts to initialize the table structure on any
> > other DB then derby.
> > We are using the 1.x branch of ODE and the 1.3.3 release scripts don't
> seem
> > to work (at least on mysql).
> >
> > Also, do JPA and Hibernate require different schemas?
> > If so, what should the scripts in the distribution be used for?
> >
> > Can anyone point in the right direction?
> >
> >
> > Thanks a lot,
> > Heiko
> >
>
>
>
> --
> Milinda Pathirage
> Senior Software Engineer & Product Manager WSO2 BPS; http://wso2.org/bps
> WSO2 <http://wso2.org/bps%0AWSO2> Inc.; http://wso2.com
> E-mail: [email protected], [email protected]
> Web: http://mpathirage.com
> Blog: http://blog.mpathirage.com
>
--
Cheers,
Jeff Yu
----------------
blog: http://jeff.familyyu.net
