ojb_hl_seq table access denied

From: Raja Sekhar Paidi <raj(at)flymine(dot)org>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: ojb_hl_seq table access denied
Date: 2003-07-17 16:52:38
Message-ID: 3F16D456.7010202@flymine.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

WHEN I CONNECT THROUGH PGSQL AND RUN ANT CLEAN TEST-MAIN

ex
---
sudo -u postgres /software/arch/bin/pg_ctl -D /var/lib/pgsql/data -l
/var/log/pgsql restart

ulimit -d 500000
ant clean test-main

3.12) I get /``Sorry, too many clients''/ when trying to connect. Why?
and says permission is denied for |*ojb_hl_seq table...but the table
has public access...this is on alpha server...
could anybody help me out
*|
testSimpleStore Error org.apache.ojb.broker.PersistenceBrokerException:
ERROR: ojb_hl_seq: permission denied

|*org.flymine.objectstore.ObjectStoreException:
org.apache.ojb.broker.PersistenceBrokerException: ERROR: ojb_hl_seq:
permission denied
*
at org.flymine.objectstore.ojb.ObjectStoreWriterOjbImpl.delete(Unknown
Source)
at org.flymine.dataloader.DataLoaderTest.tearDown(Unknown Source)
Caused by: org.apache.ojb.broker.PersistenceBrokerException: ERROR:
ojb_hl_seq: permission denied

at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown
Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown
Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown
Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByQuery(Unknown
Source)
at
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.getObjectByQuery(Unknown
Source)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getSequence(Unknown
Source)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUniqueLong(Unknown
Source)
at
org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueId(Unknown
Source)
at
org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueValue(Unknown
Source)
at org.apache.ojb.broker.util.BrokerHelper.getAutoIncrementValue(Unknown
Source)
at org.apache.ojb.broker.util.BrokerHelper.getKeyValues(Unknown Source)
at org.apache.ojb.broker.util.BrokerHelper.getKeyValues(Unknown Source)
at
org.apache.ojb.broker.accesslayer.StatementManager.getKeyValues(Unknown
Source)
at org.apache.ojb.broker.accesslayer.StatementManager.bindDelete(Unknown
Source)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeDelete(Unknown
Source)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.delete(Unknown
Source)
at
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.delete(Unknown
Source)
... 21 more
Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException: ERROR:
ojb_hl_seq: permission denied

at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
Source)
at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source)
at
org.apache.ojb.broker.singlevm.RsIteratorFactoryImpl.createRsIterator(Unknown
Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQuery(Unknown
Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuery(Unknown
Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown
Source)
... 38 more
Caused by: java.sql.SQLException: ERROR: ojb_hl_seq: permission denied

at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:153)
... 44 more
| 2.228
testStoreWithObjectRef Error

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2003-07-17 17:01:08 Re: JDBC driver compilation error
Previous Message Csaba Nagy 2003-07-17 16:49:43 Re: column not found !