[jboss-user] [Installation, Configuration & Deployment] - [JBoss-5.0.0Beta2] PostgreSQL DataSource problems

[avdyk]

Hi,

I'm trying to install JBoss 5.0.0Beta2 with a PostgreSQL DataSource.

There was a failure at JBoss startup, trying to create qrtz_job_details. AFAIK (but I'm not an expert), there is no BINARY type in PostgreSQL but 'bytea'. Here is the SQL code to create the table:

  | CREATE TABLE qrtz_job_details
  | (
  |   job_name varchar(80) NOT NULL,
  |   job_group varchar(80) NOT NULL,
  |   description varchar(120),
  |   job_class_name varchar(128) NOT NULL,
  |   is_durable varchar(1) NOT NULL,
  |   is_volatile varchar(1) NOT NULL,
  |   is_stateful varchar(1) NOT NULL,
  |   requests_recovery varchar(1) NOT NULL,
  |   job_data bytea,
  |   CONSTRAINT qrtz_job_details_pkey PRIMARY KEY (job_name, job_group)
  | )
  | 

Now, I have problems with another relation: jbm_tx.

Where can I find the SQL source so I could try to replace it for PostgreSQL?

Thanks

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4040956#4040956

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4040956