Re: Postgresql

From: Michael Gentry (blacknex..mail.com)
Date: Tue May 06 2008 - 12:21:59 EDT

  • Next message: Scott Anderson: "RE: Query.setRefreshingObjects(boolean)"

    This may not matter for your setup, but is the username "sa" correct?
    With PostgreSQL, you typically create a "postgres" database superuser.

    On Tue, May 6, 2008 at 11:43 AM, Eric Polino
    <eri..ampgroundautomation.com> wrote:
    > We were using derby and have decided to switch to postgresql. I have
    > changed all my adapters and drivers and they seem to be working
    > properly. I'm getting issues when I try to run my initialization
    > script that has always worked before. It's a pretty simple script.
    > It's just a whole bunch of inserts that initialize a development db to
    > work with. It's complaining that it can't find the tables it's
    > attempting to insert into. I think it's pretty fair to assume that
    > since they aren't there, it's because they weren't created. Our setup
    > is pretty simple. Via an ant script, we use the postgresql adapter to
    > take the db schema generated by the CayenneModeler to create the db we
    > need in our postgresql db.
    >
    > I hope this is enough information to trigger some type of help. We
    > are all pretty new to Cayenne. We were working with derby so far,
    > simply because it was what the guide had us start with, and we haven't
    > changed yet. So, some parts we just do blindly. TIA for anyone
    > lending a hand.
    >
    > Facts i know:
    > my database exists, i can connect to it via the console
    > when connecting to my db after trying to build, the tables aren't there
    > it doesn't fail when attempting to setup the db via the schema
    > it fails when trying to run some insert statements
    >
    > Pieces of the build.xml that might be of help:
    >
    > <!-- generate database schema from data map -->
    > <echo message="creating new schema for SunriseDB from cayenne data map..."/>
    > <cdbgen map="${basedir}/src/main/resources/SunriseMap.map.xml"
    > adapter="org.apache.cayenne.dba.postgres.PostgresAdapter"
    > driver="org.postgresql.Driver"
    > url="${jdbc.url}" NOTE: set to
    > jdbc:postgresql://localhost:5432/SunriseDB
    > droptables="true"
    > droppk="true"
    > createtables="true"
    > createpk="true"
    > createfk="true"
    > username="sa"
    > password="*****" />
    >
    > <!-- populate database -->
    > <echo message="populating database with test data..."/>
    > <sql
    > driver="org.postgresql.Driver"
    > classpathref="maven.compile.classpath"
    > url="${jdbc.url}"
    > userid="sa"
    > password="*****"
    > src="${basedir}/src/main/derby/scripts/dataset1-script"/>
    >
    > <sql2
    > driver="org.postgresql.Driver"
    > classpathref="maven.compile.classpath"
    > url="${jdbc.url}"
    > userid="sa"
    > password="*****"
    > script="${basedir}/src/main/derby/binary_data/dataset1-clobs.txt"/>
    >
    >
    > --
    > Eric Polino
    > Campground Automated Systems
    >



    This archive was generated by hypermail 2.0.0 : Tue May 06 2008 - 12:22:29 EDT