File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Create table failure

 
Lee Barney
Ranch Hand
Posts: 37
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
Thanks
 
Pradeep bhatt
Ranch Hand
Posts: 8927
Firefox Browser Java Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Which database is it?
[ May 07, 2003: Message edited by: Pradeep Bhat ]
 
Chris Mathews
Ranch Hand
Posts: 2712
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic