Update the blob into bytea for postgres.sql will fix this issue. I am wondering how do we generate these db scripts? by using Hibernate built-in tool?
Regards Jeff On Fri, Oct 30, 2009 at 12:49 PM, Jeff Yu <[email protected]> wrote: > 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 <http://blog.mpathirage.com> >>> >> >
