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
