Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (athena.apache.org: domain of blacknext@gmail.com
 designates 209.85.200.174 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=dIFRgJPifawIveyDKTTeUdzs4iqhqSuCT69KYgFBRCWza54k3Oy3dFAM6ueEp0GjWjdJKFPmjcnbpOzXIRPGShfmCEIChR7Hr7wVMhh5MQHaFnklDBtMmrF80n/LRcfxpGOMK/Vqp/sMMA4r7utuaWeJCYtfE1VKBmB+eti7QN0=
Message-ID: <f65b8ae30805060921n56d10bfqa0a0645c1eb210bf@mail.gmail.com>
Date: Tue, 6 May 2008 12:21:59 -0400
From: "Michael Gentry" <blacknext@gmail.com>
To: user@cayenne.apache.org
Subject: Re: Postgresql
In-Reply-To: <6d49210b0805060843p3d2005adq949ccc7d37f9fc8e@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <6d49210b0805060843p3d2005adq949ccc7d37f9fc8e@mail.gmail.com>

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
<eric@campgroundautomation.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
>