hibernate_sequence missing in distribution 1.5.1

classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

hibernate_sequence missing in distribution 1.5.1

Ted Vinke
Hi!

Is it correct the sequence hibernate_sequence is missing when setting up
dotCMS from the downloaded distribution and distributed postgres.sql ?

Ofcourse I can add it manually with a CREATE SEQUENCE statement, but
maybe this is woth mentioning in the installation textfile.

FYI

Regards, Ted


dotCMS: Opensource CMS goodness.
http://www.dotcms.org 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/dotcms/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/dotcms/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:[hidden email]
    mailto:[hidden email]

<*> To unsubscribe from this group, send an email to:
    [hidden email]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 
Reply | Threaded
Open this post in threaded view
|

Re: hibernate_sequence missing in distribution 1.5.1

Jason Tesser-2
It should not be missing. interesting I will look into it.

On Feb 4, 2008 9:17 AM, Ted Vinke <[hidden email]> wrote:

>
>
>
>
>
>
> Hi!
>
>  Is it correct the sequence hibernate_sequence is missing when setting up
>  dotCMS from the downloaded distribution and distributed postgres.sql ?
>
>  Ofcourse I can add it manually with a CREATE SEQUENCE statement, but
>  maybe this is woth mentioning in the installation textfile.
>
>  FYI
>
>  Regards, Ted
>  



--
Jason Tesser
dotmarketing, Lead Programmer
1-305-858-1422


dotCMS: Opensource CMS goodness.
http://www.dotcms.org 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/dotcms/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/dotcms/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:[hidden email]
    mailto:[hidden email]

<*> To unsubscribe from this group, send an email to:
    [hidden email]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 
Reply | Threaded
Open this post in threaded view
|

Re: hibernate_sequence missing in distribution 1.5.1

David Torres-2
In reply to this post by Ted Vinke
Hello Ted,

Check the file inode.hbm.xml and see if you are correctly using sequences,
if the file says to use native to generate keys, then do an ant buildsql
that will fix the inode.hbm.xml file, we keep both options native and
sequences to support multiple databases.

David


On 2/4/08, Ted Vinke <[hidden email]> wrote:

>
>   Hi!
>
> Is it correct the sequence hibernate_sequence is missing when setting up
> dotCMS from the downloaded distribution and distributed postgres.sql ?
>
> Ofcourse I can add it manually with a CREATE SEQUENCE statement, but
> maybe this is woth mentioning in the installation textfile.
>
> FYI
>
> Regards, Ted
>
>



--
David Torres
Lead Developer
www.dotmarketing.com
www.dotcms.org
Dotmarketing, Inc.
3059 Grand Avenue
Suite 440
Miami, FL 33133
T: 305.858.1422 x. 9278
F: 786.594.5288
Reply | Threaded
Open this post in threaded view
|

Re: hibernate_sequence missing in distribution 1.5.1

wezell-2
Administrator
In reply to this post by Jason Tesser-2
Ted:

Generally, when you see "hibernate_sequence" it means that you are using the
wrong dotcms.jar bundle, or created the bundle with the wrong database
support.  You are going to need to use the dotcms.jar that supports
sequences.

-Will


On 2/4/08, Jason Tesser <[hidden email]> wrote:

>
> It should not be missing. interesting I will look into it.
>
> On Feb 4, 2008 9:17 AM, Ted Vinke <[hidden email]> wrote:
> >
> >
> >
> >
> >
> >
> > Hi!
> >
> >  Is it correct the sequence hibernate_sequence is missing when setting
> up
> >  dotCMS from the downloaded distribution and distributed postgres.sql ?
> >
> >  Ofcourse I can add it manually with a CREATE SEQUENCE statement, but
> >  maybe this is woth mentioning in the installation textfile.
> >
> >  FYI
> >
> >  Regards, Ted
> >
>
>
>
> --
> Jason Tesser
> dotmarketing, Lead Programmer
> 1-305-858-1422
>
>
> dotCMS: Opensource CMS goodness.
> http://www.dotcms.org
> Yahoo! Groups Links
>
>
>
>


--
Will Ezell

phone: 305.858.1422 ext. 286
direct: 978.296.4239

www.dotmarketing.com
www.dotcms.org
Reply | Threaded
Open this post in threaded view
|

Re: hibernate_sequence missing in distribution 1.5.1

Ted Vinke
When I follow Step1-Installing-dotCMS.txt from
http://dotcms.org/documentation/user_documentation/installation I perform

"psql -f ./sql/postgresql.sql dotcms" correctly and
copy the dotcms_seq_1.5.1.jar correctly to /common/lib/ext

and then when I for the _first_ time start dotCMS I get

        Caused by: org.postgresql.util.PSQLException: ERROR: relation
"hibernate_sequence" does not exist

errors of over the place during startup. Somehow this just doesn't seem
be created automatically and I can't find in the instructions I should
create it myself.

Should this automatically be created?
After Tomcat starts with these errors, I shut it down and create it
myself, restart Tomcat and everything works fine.

Regards, Ted

Will Ezell wrote:

>
>
> Ted:
>
> Generally, when you see "hibernate_sequence" it means that you are using
> the wrong dotcms.jar bundle, or created the bundle with the wrong
> database support.  You are going to need to use the dotcms.jar that
> supports sequences.
>
> -Will
>
>
> On 2/4/08, *Jason Tesser* <[hidden email]
> <mailto:[hidden email]>> wrote:
>
>     It should not be missing. interesting I will look into it.
>
>     On Feb 4, 2008 9:17 AM, Ted Vinke <[hidden email]
>     <mailto:[hidden email]>> wrote:
>      >
>      >
>      >
>      >
>      >
>      >
>      > Hi!
>      >
>      >  Is it correct the sequence hibernate_sequence is missing when
>     setting up
>      >  dotCMS from the downloaded distribution and distributed
>     postgres.sql ?
>      >
>      >  Ofcourse I can add it manually with a CREATE SEQUENCE statement, but
>      >  maybe this is woth mentioning in the installation textfile.
>      >
>      >  FYI
>      >
>      >  Regards, Ted
>      >
>
>
>
>     --
>     Jason Tesser
>     dotmarketing, Lead Programmer
>     1-305-858-1422
>
>
>     dotCMS: Opensource CMS goodness.
>     http://www.dotcms.org <http://www.dotcms.org>
>     Yahoo! Groups Links
>
>
>         (Yahoo! ID required)
>
>         mailto:[hidden email]
>     <mailto:[hidden email]>
>
>
>
>
>
>
> --
> Will Ezell
>
> phone: 305.858.1422 ext. 286
> direct: 978.296.4239
>
> www.dotmarketing.com <http://www.dotmarketing.com>
> www.dotcms.org <http://www.dotcms.org>
>


dotCMS: Opensource CMS goodness.
http://www.dotcms.org 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/dotcms/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/dotcms/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:[hidden email]
    mailto:[hidden email]

<*> To unsubscribe from this group, send an email to:
    [hidden email]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 
Reply | Threaded
Open this post in threaded view
|

Re: hibernate_sequence missing in distribution 1.5.1

Jason Tesser-2
Hi Ted I just checked teh sql file and it has this

create sequence content_rating_sequence;
create sequence user_preferences_seq;
create sequence trackback_sequence;
create sequence inode_seq;
create sequence language_seq;
create sequence web_form_seq;
create sequence clickstream_request_seq;
create sequence clickstream_seq;
create sequence permission_seq;
create sequence indexation_seq;

under sql/postgres.sql

Maybe a db permission problem?

On Feb 4, 2008 9:50 AM, Ted Vinke <[hidden email]> wrote:

>
>
>
>
>
>
> When I follow Step1-Installing-dotCMS.txt from
>  http://dotcms.org/documentation/user_documentation/installation I perform
>
>  "psql -f ./sql/postgresql.sql dotcms" correctly and
>  copy the dotcms_seq_1.5.1.jar correctly to /common/lib/ext
>
>  and then when I for the _first_ time start dotCMS I get
>
>  Caused by: org.postgresql.util.PSQLException: ERROR: relation
>  "hibernate_sequence" does not exist
>
>  errors of over the place during startup. Somehow this just doesn't seem
>  be created automatically and I can't find in the instructions I should
>  create it myself.
>
>  Should this automatically be created?
>  After Tomcat starts with these errors, I shut it down and create it
>  myself, restart Tomcat and everything works fine.
>
>  Regards, Ted
>
>
>  Will Ezell wrote:
>  >
>  >
>  > Ted:
>  >
>  > Generally, when you see "hibernate_sequence" it means that you are using
>  > the wrong dotcms.jar bundle, or created the bundle with the wrong
>  > database support. You are going to need to use the dotcms.jar that
>  > supports sequences.
>  >
>  > -Will
>  >
>  >
>  > On 2/4/08, *Jason Tesser* <[hidden email]
>  > <mailto:[hidden email]>> wrote:
>  >
>  > It should not be missing. interesting I will look into it.
>  >
>  > On Feb 4, 2008 9:17 AM, Ted Vinke <[hidden email]
>  > <mailto:[hidden email]>> wrote:
>  > >
>  > >
>  > >
>  > >
>  > >
>  > >
>  > > Hi!
>  > >
>  > > Is it correct the sequence hibernate_sequence is missing when
>  > setting up
>  > > dotCMS from the downloaded distribution and distributed
>  > postgres.sql ?
>  > >
>  > > Ofcourse I can add it manually with a CREATE SEQUENCE statement, but
>  > > maybe this is woth mentioning in the installation textfile.
>  > >
>  > > FYI
>  > >
>  > > Regards, Ted
>  > >
>  >
>  >
>  >
>  > --
>  > Jason Tesser
>  > dotmarketing, Lead Programmer
>  > 1-305-858-1422
>  >
>  >
>  > dotCMS: Opensource CMS goodness.
>  > http://www.dotcms.org <http://www.dotcms.org>
>  > Yahoo! Groups Links
>  >
>  >
>  > (Yahoo! ID required)
>
>  >
>  > mailto:[hidden email]
>  > <mailto:[hidden email]>
>  >
>  >
>  >
>  >
>  >
>  >
>  > --
>  > Will Ezell
>  >
>  > phone: 305.858.1422 ext. 286
>  > direct: 978.296.4239
>  >
>  > www.dotmarketing.com <http://www.dotmarketing.com>
>  > www.dotcms.org <http://www.dotcms.org>
>  >
>  



--
Jason Tesser
dotmarketing, Lead Programmer
1-305-858-1422


dotCMS: Opensource CMS goodness.
http://www.dotcms.org 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/dotcms/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/dotcms/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:[hidden email]
    mailto:[hidden email]

<*> To unsubscribe from this group, send an email to:
    [hidden email]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 
Reply | Threaded
Open this post in threaded view
|

Re: hibernate_sequence missing in distribution 1.5.1

Ted Vinke
No problems with these sequence; these _are_ correctly created. Just no
sequence "hibernate_sequence": since it's not listed in the
sql/postgres.sql I'd assume the system would create it upon startup.

Regards, Ted

Jason Tesser wrote:

>
>
> Hi Ted I just checked teh sql file and it has this
>
> create sequence content_rating_sequence;
> create sequence user_preferences_seq;
> create sequence trackback_sequence;
> create sequence inode_seq;
> create sequence language_seq;
> create sequence web_form_seq;
> create sequence clickstream_request_seq;
> create sequence clickstream_seq;
> create sequence permission_seq;
> create sequence indexation_seq;
>
> under sql/postgres.sql
>
> Maybe a db permission problem?
>
> On Feb 4, 2008 9:50 AM, Ted Vinke <[hidden email]
> <mailto:tvinke%40first8.nl>> wrote:
>  >
>  >
>  >
>  >
>  >
>  >
>  > When I follow Step1-Installing-dotCMS.txt from
>  > http://dotcms.org/documentation/user_documentation/installation 
> <http://dotcms.org/documentation/user_documentation/installation> I perform
>  >
>  > "psql -f ./sql/postgresql.sql dotcms" correctly and
>  > copy the dotcms_seq_1.5.1.jar correctly to /common/lib/ext
>  >
>  > and then when I for the _first_ time start dotCMS I get
>  >
>  > Caused by: org.postgresql.util.PSQLException: ERROR: relation
>  > "hibernate_sequence" does not exist
>  >
>  > errors of over the place during startup. Somehow this just doesn't seem
>  > be created automatically and I can't find in the instructions I should
>  > create it myself.
>  >
>  > Should this automatically be created?
>  > After Tomcat starts with these errors, I shut it down and create it
>  > myself, restart Tomcat and everything works fine.
>  >
>  > Regards, Ted
>  >
>  >
>  > Will Ezell wrote:
>  > >
>  > >
>  > > Ted:
>  > >
>  > > Generally, when you see "hibernate_sequence" it means that you are
> using
>  > > the wrong dotcms.jar bundle, or created the bundle with the wrong
>  > > database support. You are going to need to use the dotcms.jar that
>  > > supports sequences.
>  > >
>  > > -Will
>  > >
>  > >
>  > > On 2/4/08, *Jason Tesser* <[hidden email]
> <mailto:jasontesser%40gmail.com>
>  > > <mailto:[hidden email] <mailto:jasontesser%40gmail.com>>> wrote:
>  > >
>  > > It should not be missing. interesting I will look into it.
>  > >
>  > > On Feb 4, 2008 9:17 AM, Ted Vinke <[hidden email]
> <mailto:tvinke%40first8.nl>
>  > > <mailto:[hidden email] <mailto:tvinke%40first8.nl>>> wrote:
>  > > >
>  > > >
>  > > >
>  > > >
>  > > >
>  > > >
>  > > > Hi!
>  > > >
>  > > > Is it correct the sequence hibernate_sequence is missing when
>  > > setting up
>  > > > dotCMS from the downloaded distribution and distributed
>  > > postgres.sql ?
>  > > >
>  > > > Ofcourse I can add it manually with a CREATE SEQUENCE statement, but
>  > > > maybe this is woth mentioning in the installation textfile.
>  > > >
>  > > > FYI
>  > > >
>  > > > Regards, Ted
>  > > >
>  > >
>  > >
>  > >
>  > > --
>  > > Jason Tesser
>  > > dotmarketing, Lead Programmer
>  > > 1-305-858-1422
>  > >
>  > >
>  > > dotCMS: Opensource CMS goodness.
>  > > http://www.dotcms.org <http://www.dotcms.org>
> <http://www.dotcms.org <http://www.dotcms.org>>
>  > > Yahoo! Groups Links
>  > >
>  > >
>  > > (Yahoo! ID required)
>  >
>  > >
>  > > mailto:[hidden email]
> <mailto:dotcms-fullfeatured%40yahoogroups.com>
>  > > <mailto:[hidden email]
> <mailto:dotcms-fullfeatured%40yahoogroups.com>>
>  > >
>  > >
>  > >
>  > >
>  > >
>  > >
>  > > --
>  > > Will Ezell
>  > >
>  > > phone: 305.858.1422 ext. 286
>  > > direct: 978.296.4239
>  > >
>  > > www.dotmarketing.com <http://www.dotmarketing.com 
> <http://www.dotmarketing.com>>
>  > > www.dotcms.org <http://www.dotcms.org <http://www.dotcms.org>>
>  > >
>  >
>
> --
> Jason Tesser
> dotmarketing, Lead Programmer
> 1-305-858-1422
>
>



dotCMS: Opensource CMS goodness.
http://www.dotcms.org 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/dotcms/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/dotcms/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:[hidden email]
    mailto:[hidden email]

<*> To unsubscribe from this group, send an email to:
    [hidden email]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/