simply update the blob(2G) to blob will work for mysql case, but I found the
postgres.sql doesn't work either.
[sql] Failed to execute: CREATE TABLE ode_job ( jobid CHAR(64) NOT
NULL DEFAULT '', ts BIGINT NOT NULL DEFAULT 0, nodeid char(64), scheduled
int NOT NULL DEFAULT 0, transacted int NOT NULL DEFAULT 0, details blob,
PRIMARY KEY(jobid))
[sql] org.postgresql.util.PSQLException: ERROR: type "blob" does not
exist
Regards
Jeff
On Fri, Oct 30, 2009 at 12:16 PM, Jeff Yu <[email protected]> wrote:
> 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
>
>
--
Cheers,
Jeff Yu
----------------
blog: http://jeff.familyyu.net
twitter: http://www.twitter.com/jeffyuchang
