You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ode.apache.org by Heiko Braun <hb...@redhat.com> on 2009/10/13 16:02:22 UTC
Database scripts
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
Re: Postgres Script RE: Database scripts
Posted by Jeff Yu <je...@gmail.com>.
I meant: 42 tables? I think it has too many tables?
On Thu, Jan 21, 2010 at 4:13 PM, Jeff Yu <je...@gmail.com> wrote:
> 42 tables? I don't think it has too many schemas?
>
> As my version of db scripts (include index) for hsql, mysql, postgres,
> oracle and sqlserver, which is at:
> http://anonsvn.jboss.org/repos/riftsaw/trunk/runtime/engine-assembly/src/main/resources/bpel-sql/doesn't create 42 tables, it is just about 25 tables.
>
> Regards
> Jeff
>
>
> On Mon, Jan 18, 2010 at 7:43 PM, Dhanush Gopinath <
> dhanush.gopinath@altair.com> wrote:
>
>> Jeff,
>>
>> I have attached it. It creates 42 tables in the schema for ODE. As of
>> now it is working fine for me with deployment and execution of the
>> example process.
>>
>> Please have a look at it.
>>
>> Thanks
>> Dhanush
>>
>>
>
> --
> Cheers,
> Jeff Yu
>
> ----------------
> blog: http://jeff.familyyu.net
>
>
--
Cheers,
Jeff Yu
----------------
blog: http://jeff.familyyu.net
Re: Postgres Script RE: Database scripts
Posted by Jeff Yu <je...@gmail.com>.
42 tables? I don't think it has too many schemas?
As my version of db scripts (include index) for hsql, mysql, postgres,
oracle and sqlserver, which is at:
http://anonsvn.jboss.org/repos/riftsaw/trunk/runtime/engine-assembly/src/main/resources/bpel-sql/doesn't
create 42 tables, it is just about 25 tables.
Regards
Jeff
On Mon, Jan 18, 2010 at 7:43 PM, Dhanush Gopinath <
dhanush.gopinath@altair.com> wrote:
> Jeff,
>
> I have attached it. It creates 42 tables in the schema for ODE. As of
> now it is working fine for me with deployment and execution of the
> example process.
>
> Please have a look at it.
>
> Thanks
> Dhanush
>
>
--
Cheers,
Jeff Yu
----------------
blog: http://jeff.familyyu.net
RE: Postgres Script RE: Database scripts
Posted by Dhanush Gopinath <dh...@altair.com>.
Jeff,
I have attached it. It creates 42 tables in the schema for ODE. As of
now it is working fine for me with deployment and execution of the
example process.
Please have a look at it.
Thanks
Dhanush
-----Original Message-----
From: Jeff Yu [mailto:jeff.yuchang@gmail.com]
Sent: Wednesday, January 13, 2010 12:26 PM
To: user@ode.apache.org
Subject: Re: Postgres Script RE: Database scripts
sorry for the late response, but I didn't see the attachment, could you
attach the sql into the jira (ODE-690) please?
Regards
Jeff
On Thu, Jan 7, 2010 at 5:34 PM, Dhanush Gopinath <
dhanush.gopinath@altair.com> wrote:
> Hi,
>
> I am attaching the sql script for postgres for the community's
> reference. I made this from the oracle.sql script that's shipped along
> ODE 1.3.3.
>
> The hibernate scripts were not creating the all tables, and I was
> getting this exception while visiting the ODE web page
> org.apache.ode.bpel.iapi.contextexception: error retrieving node list.
>
> Saying ode_job relation doesn't exist.
>
> Hope this script helps. I am no longer getting any error while
accessing
> the ODE page.
>
> Thanks & Regards
> Dhanush
>
>
> -----Original Message-----
> From: Jeff Yu [mailto:jeff.yuchang@gmail.com]
> Sent: Monday, November 02, 2009 1:06 PM
> To: user@ode.apache.org
> Subject: Re: Database scripts
>
> 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
>
> <http://www.twitter.com/jeffyuchang>
>
--
Cheers,
Jeff Yu
----------------
blog: http://jeff.familyyu.net
Re: Postgres Script RE: Database scripts
Posted by Jeff Yu <je...@gmail.com>.
sorry for the late response, but I didn't see the attachment, could you
attach the sql into the jira (ODE-690) please?
Regards
Jeff
On Thu, Jan 7, 2010 at 5:34 PM, Dhanush Gopinath <
dhanush.gopinath@altair.com> wrote:
> Hi,
>
> I am attaching the sql script for postgres for the community's
> reference. I made this from the oracle.sql script that's shipped along
> ODE 1.3.3.
>
> The hibernate scripts were not creating the all tables, and I was
> getting this exception while visiting the ODE web page
> org.apache.ode.bpel.iapi.contextexception: error retrieving node list.
>
> Saying ode_job relation doesn't exist.
>
> Hope this script helps. I am no longer getting any error while accessing
> the ODE page.
>
> Thanks & Regards
> Dhanush
>
>
> -----Original Message-----
> From: Jeff Yu [mailto:jeff.yuchang@gmail.com]
> Sent: Monday, November 02, 2009 1:06 PM
> To: user@ode.apache.org
> Subject: Re: Database scripts
>
> 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
>
> <http://www.twitter.com/jeffyuchang>
>
--
Cheers,
Jeff Yu
----------------
blog: http://jeff.familyyu.net
Postgres Script RE: Database scripts
Posted by Dhanush Gopinath <dh...@altair.com>.
Hi,
I am attaching the sql script for postgres for the community's
reference. I made this from the oracle.sql script that's shipped along
ODE 1.3.3.
The hibernate scripts were not creating the all tables, and I was
getting this exception while visiting the ODE web page
org.apache.ode.bpel.iapi.contextexception: error retrieving node list.
Saying ode_job relation doesn't exist.
Hope this script helps. I am no longer getting any error while accessing
the ODE page.
Thanks & Regards
Dhanush
-----Original Message-----
From: Jeff Yu [mailto:jeff.yuchang@gmail.com]
Sent: Monday, November 02, 2009 1:06 PM
To: user@ode.apache.org
Subject: Re: Database scripts
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 <
sankarachary@intalio.com> 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 <
> milinda.pathirage@gmail.com> 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 <je...@gmail.com>
> 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 <je...@gmail.com>
> > 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
<je...@gmail.com>
> > > 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 <
> > > >> milinda.pathirage@gmail.com> 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
<hb...@redhat.com>
> > > 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: milinda@wso2.com, milinda.pathirage@gmail.com
> > > >>> 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: milinda@wso2.com, milinda.pathirage@gmail.com
> > Web: http://mpathirage.com
> > Blog: http://blog.mpathirage.com
> >
>
--
Cheers,
Jeff Yu
----------------
blog: http://jeff.familyyu.net
twitter: http://www.twitter.com/jeffyuchang
Re: Database scripts
Posted by Jeff Yu <je...@gmail.com>.
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 <
sankarachary@intalio.com> 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 <
> milinda.pathirage@gmail.com> 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 <je...@gmail.com>
> 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 <je...@gmail.com>
> > 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 <je...@gmail.com>
> > > 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 <
> > > >> milinda.pathirage@gmail.com> 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 <hb...@redhat.com>
> > > 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: milinda@wso2.com, milinda.pathirage@gmail.com
> > > >>> 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: milinda@wso2.com, milinda.pathirage@gmail.com
> > Web: http://mpathirage.com
> > Blog: http://blog.mpathirage.com
> >
>
--
Cheers,
Jeff Yu
----------------
blog: http://jeff.familyyu.net
twitter: http://www.twitter.com/jeffyuchang
Re: Database scripts
Posted by Karthick Sankarachary <sa...@intalio.com>.
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 <
milinda.pathirage@gmail.com> 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 <je...@gmail.com> 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 <je...@gmail.com>
> 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 <je...@gmail.com>
> > 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 <
> > >> milinda.pathirage@gmail.com> 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 <hb...@redhat.com>
> > 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: milinda@wso2.com, milinda.pathirage@gmail.com
> > >>> 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: milinda@wso2.com, milinda.pathirage@gmail.com
> Web: http://mpathirage.com
> Blog: http://blog.mpathirage.com
>
Re: Database scripts
Posted by Milinda Pathirage <mi...@gmail.com>.
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 <je...@gmail.com> 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 <je...@gmail.com> 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 <je...@gmail.com>
> 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 <
> >> milinda.pathirage@gmail.com> 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 <hb...@redhat.com>
> 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: milinda@wso2.com, milinda.pathirage@gmail.com
> >>> 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: milinda@wso2.com, milinda.pathirage@gmail.com
Web: http://mpathirage.com
Blog: http://blog.mpathirage.com
Re: Database scripts
Posted by Jeff Yu <je...@gmail.com>.
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 <je...@gmail.com> 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 <je...@gmail.com> 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 <
>> milinda.pathirage@gmail.com> 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 <hb...@redhat.com> 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: milinda@wso2.com, milinda.pathirage@gmail.com
>>> Web: http://mpathirage.com
>>> Blog: http://blog.mpathirage <http://blog.mpathirage.com>
>>>
>>
>
Re: Database scripts
Posted by Jeff Yu <je...@gmail.com>.
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 <je...@gmail.com> 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 <
> milinda.pathirage@gmail.com> 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 <hb...@redhat.com> 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: milinda@wso2.com, milinda.pathirage@gmail.com
>> 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
Re: Database scripts
Posted by Jeff Yu <je...@gmail.com>.
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 <
milinda.pathirage@gmail.com> 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 <hb...@redhat.com> 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: milinda@wso2.com, milinda.pathirage@gmail.com
> Web: http://mpathirage.com
> Blog: http://blog.mpathirage.com
>
--
Cheers,
Jeff Yu
----------------
blog: http://jeff.familyyu.net
Re: Database scripts
Posted by Milinda Pathirage <mi...@gmail.com>.
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 <hb...@redhat.com> 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 Inc.; http://wso2.com
E-mail: milinda@wso2.com, milinda.pathirage@gmail.com
Web: http://mpathirage.com
Blog: http://blog.mpathirage.com