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
<[EMAIL PROTECTED]> 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
>
