It's not a secret anymore!
The moose likes EJB and other Java EE Technologies and the fly likes Create table failure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Create table failure" Watch "Create table failure" New topic

Create table failure

Lee Barney
Ranch Hand

Joined: May 07, 2003
Posts: 37
I am attempting to find out why JBoss is failing to create this table. I am using the default JBoss installation.
The error is :
08:37:54,715 WARN [ServiceController] Problem starting service jboss.j2ee:jndiName=HaHVisitBean,service=EJB
org.jboss.deployment.DeploymentException: Error while creating table; - nested throwable: (java.sql.SQLException: Column not found: ) in statement [CREATE TABLE HAHVISITBEAN (iD VARCHAR(256), date VARCHAR(256), time VARCHAR(256), data VARCHAR(256), CONSTRAINT PK_HAHVISITBEAN PRIMARY KEY ())])

Any ideas?
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8927

Which database is it?
[ May 07, 2003: Message edited by: Pradeep Bhat ]

Chris Mathews
Ranch Hand

Joined: Jul 18, 2001
Posts: 2712
It would help if we knew which database you were using. Regardless, date is a reserved word in most databases and therefore should not be used as a column name.
I agree. Here's the link:
subject: Create table failure
It's not a secret anymore!