Hi
I need to know how is the PostgreSQL create table on deploy problem resolving going
(Aaron?).
Its urgent
Thanx
Serhiy
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Sebastien Alborini
Sent: Thursday, October 05, 2000 6:24 AM
To: jBoss
Subject: Re: [jBoss-User] PostgreSQL & Minerva
Aaron Mulder wrote:
>
> Strange... Everything *looks* OK. The only weird thing is
> that the table is supposedly created as "AdProfession" but the log
> complains about "adprofession". I don't know that much about PostgreSQL,
> but does the DB account you're using have permissions to create
> tables? Could the case difference in the table names be a problem?
> It's definitely strange that JAWS seems to think the table was
> created successfully - you would think the DB driver would throw an
> exception if it refused to create the table. Can you narrow down which
> action causes the log message stating that the table does not exist?
>
> Aaron
>
Hi,
I am getting exactly the same behavior: jaws says the table were
created, but then SELECT/INSERT raise the following exception
[JAWS] Create command executing: INSERT INTO nextgen_EnterpriseEntity
(name) VALUES (?)
[JAWS] Set parameter: idx=1, jdbcType=VARCHAR, value=Marc
[JAWS] java.sql.SQLException: ERROR: Relation
'nextgen_enterpriseentity' does not exist
[JAWS]
[JAWS] at org.postgresql.Connection.ExecSQL(Connection.java:393)
[JAWS] at org.postgresql.jdbc2.Statement.execute(Statement.java:273)
[JAWS] at
org.postgresql.jdbc2.Statement.executeUpdate(Statement.java:73)
[JAWS] at
org.postgresql.jdbc2.PreparedStatement.executeUpdate(PreparedStatement.java:126)
[JAWS] at
org.jboss.minerva.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:81)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCUpdateCommand.executeStatementAndHandleResult(JDBCUpdateCommand.java:49)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:154)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEntityCommand.java:135)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.createEntity(JAWSPersistenceManager.java:122)
[JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:155)
[JAWS] at
org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:427)
...
>From the postgresql command line tool, I can see that no table is
created. The user has permission to create tables, and it is not a
configuration problem (I think), since when I create the tables manually
(with the same user), JAWS can fill them with the beans.
This seem to have appeared with the minerva pools, it worked fine
before. (??!?)
It can be reproduced with testbeans. Any idea?
Sebastien
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
