File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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!