Thanks Milinda and Karthick. I've just created a jira ( https://issues.apache.org/jira/browse/ODE-690) for the tracking, and also good for others search.
Regards Jeff On Sat, Oct 31, 2009 at 1:17 AM, Karthick Sankarachary < [email protected]> wrote: > 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 > > > -- Cheers, Jeff Yu ---------------- blog: http://jeff.familyyu.net twitter: http://www.twitter.com/jeffyuchang
