Hi there, I'm having problems inserting objects v�a castor into a postgres database. I'm kind of clueless ... any help would be greatly appreciated.
Context info:
I'm using Postgres 7.3.2 JDBC Driver 73_2ee JDK 1.4.1 Castor 0.9.5
Debug info:
From the stack trace:
org.exolab.castor.jdo.PersistenceException: org.exolab.castor.jdo.PersistenceException: Nested error: The table for wdm.dataservices.WebDoc is not in the database. Contact the DBA, as the database is in an inconsistent state.
Log from postgres logfile:
2003-09-18 12:08:01 [22282] LOG: connection received: host=XXX.XXX.XXX.XXX
port=1458
2003-09-18 12:08:01 [22282] LOG: connection authorized: user=postgres
database=xxxdb
2003-09-18 12:08:01 [22282] LOG: query: set datestyle to 'ISO'; select
version(), case when pg_encoding_to_char(1) = 'SQL_ASCII' then 'UNKNOWN' else
getdatabaseencoding() end;
2003-09-18 12:08:01 [22282] LOG: query: set client_encoding = 'UNICODE'; show
autocommit
2003-09-18 12:08:01 [22282] LOG: query: set autocommit = off;
2003-09-18 12:08:01 [22282] LOG: query: INSERT INTO "webdocs"
("rid","lit_type","publ_date","correl") VALUES ('1','a','2002-09-09','no')
2003-09-18 12:08:01 [22282] LOG: query: SELECT t.typlen FROM
pg_catalog.pg_type t, pg_catalog.pg_namespace n WHERE t.typnamespace=n.oid AND
t.typname='name' AND n.nspname='pg_catalog'
2003-09-18 12:08:01 [22282] LOG: query: SELECT 1 FROM pg_catalog.pg_type t,
pg_catalog.pg_class c WHERE t.typrelid=c.oid AND c.relkind='r' AND
t.typname='wdm_dataservices_webdoc' AND pg_table_is_visible(c.oid)
2003-09-18 12:08:01 [22282] LOG: query: SELECT 1 FROM pg_catalog.pg_type t,
pg_catalog.pg_class c WHERE t.typrelid=c.oid AND c.relkind='r' AND
t.typname='wdm_dataservices_webdoc' AND pg_table_is_visible(c.oid)
2003-09-18 12:08:01 [22282] LOG: pq_recvbuf: recv() failed: Connection reset
by peerOf course typename wdm_dataservices_webdoc does not exist, but the database table does exist.
any ideas?
TIA
Rodrigo Filgueira Prates [EMAIL PROTECTED]/OIT http://www.cinterfor.org.uy
----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
