Milinda is right in that those scripts are generated by Hibernate. Just for future reference, shown below are the column types that denote blobs in certain database providers:
MySQL - mediumblob Postgres - bytea Ingres - long byte Oracle - blob Derby - blob(2G) DB2 - blob(1073741823) Sybase - IMAGE null SQL Server - image null Hope it helps. Best Regards, Karthick Sankarachary On Fri, Oct 30, 2009 at 3:51 AM, Milinda Pathirage < [email protected]> wrote: > Hi Jeff, > > There were some errors in SQL scripts generated by hibernate, even in MS > SQL > Server scripts. You'll have to manually fix those errors. AFAIK those > scripts are generated hibernate built-in tool. > > Thanks > Milinda > > On Fri, Oct 30, 2009 at 10:57 AM, Jeff Yu <[email protected]> wrote: > > > 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> > > >>> > > >> > > > > > > > > > -- > Milinda Pathirage > Senior Software Engineer & Product Manager WSO2 BPS; http://wso2.org/bps > WSO2 Inc.; http://wso2.com > E-mail: [email protected], [email protected] > Web: http://mpathirage.com > Blog: http://blog.mpathirage.com >
