I've just downloaded and installed JBoss. When I try to
start-up the server, I get an exception about half way through.
(the top of the error stack is listed below)
I'm attempting to run JBoss 3.0 on XP using Postgress.
If you have any ideas on what might be causing the error,
please let me know.
Here's the error:
[ServiceController] Problem starting service
org.jboss.deployment.DeplorymentException: Error while
creating table; - nested throwable: (java.sql.SQLException:
Wrong data type: INT4 in statement [CREATE TABLE TESTENTITY
(Id INT4 NOT NULL, First_Name TEXT, Last_Name TEXT, Password
TEXT, Email TEXT, Address TEXT, City TEXT, ZIP TEXT, State
TEXT, Country TEXT, Creation_Date DATE, Modification_Date
DATE, CONSTRAINT PK_TESTENTITY PRIMARY KEY (Id))]
Not sure. Something wrong in the id field when it tries to create the table. In any event, the error message is generated by your database, so refer to the database docs for more info. You could disable having JBoss create the table and create it manually with your database tools.