CMP Problem : Please Help

[mandarjboss]

I am using JBoss for an enterprise application development.I am accesing the EJB called "QuestionBean" from a Servlet. I have mapped QuestionBean to PostgreSQL .My application gets deployed Successfuly.But when i execute the application it searches for a table called "questionbean" in Postgre's database.As I have turned off the auto-creation of the table by JBoss it gives me an exception "Relation 'questionbean' does not exist". However,I don't want jboss to create a table when i execute the application but rather whatever data i enter through EJB should go into a table "question"which is already present in the database.

My jbosscmp-jdbc.xml contains following:
<jbosscmp-jdbc>
<enterprise-beans>
<ejb-name>QuestionBean</ejb-name>
java:/PostgresDS
<datasource-mapping>PostgreSQL</datasource-mapping>
<create-table>false</create-table>
<table-name>newquestion</table-name>
<cmp-field>
<field-name>questionid</field-name>
<column-name>question_id</column-name>
......... so on..

After few experimentation i found that Jboss is expecting the table name to be exactly identical to the value of "<ejb-name>" tag.
I really don't know why this is happening so?
Is it a JBoss bug or a Requirement?

Do i need to make any changes in this file or in any other file?
Do i need to make any config settings in web.xml or jboss-web.xml for datasource?

[sesques]

Hi,

It seems that your error message refers to a relation named 'questionbean', not the table which name is 'newquestion' in your example.

There is no requirements about the table name and the EJB name. Post the exact message log.

[pilhuhn]

just put the name of the expected table in the [table-name] tag.