[JBoss-5.0.0Beta2] PostgreSQL DataSource problems

avdyk Apr 26, 2007 9:05 AM

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

1. Re: [JBoss-5.0.0Beta2] PostgreSQL DataSource problems

avdyk Apr 26, 2007 9:06 AM (in response to avdyk)

I also have a problem with 'qrtz_locks'
Actions

2. Re: [JBoss-5.0.0Beta2] PostgreSQL DataSource problems

avdyk Apr 26, 2007 10:24 AM (in response to avdyk)

Here is the configuration of the PostgreSQL DataSource:

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
 <local-tx-datasource>
 <jndi-name>DefaultDS</jndi-name>
<connection-url>jdbc:postgresql://localhost:5432/ejb</connection-url>
 <driver-class>org.postgresql.Driver</driver-class>
 <user-name>ejb</user-name>
 <password>ejb</password>
 <min-pool-size>5</min-pool-size>
 <max-pool-size>20</max-pool-size>
 <idle-timeout-minutes>0</idle-timeout-minutes>
 <track-statements/>
<prepared-statement-cache-size>32</prepared-statement-cache-size>
 <metadata>
 <type-mapping>PostgreSQL</type-mapping>
 </metadata>
 </local-tx-datasource>
</datasources>

I changed the name of the hsqldb-ds.xml datasource name to DefaultDS2. But JBoss was not able to create all the relations.

Go to original post