activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jonoinnz <Jonathan.Opper...@ecngroup.co.nz>
Subject jdbc postgres
Date Thu, 03 Jun 2010 03:26:11 GMT

Hi All,

I hope someone can please assist, we are trying to use postgres as a ds for
activemq, but we are getting the following error:

snip out of activemq-jdbc.xml

<bean id="postgres-ds" class="org.postgresql.ds.PGPoolingDataSource">
    <property name="serverName" value="myserver"/>
    <property name="databaseName" value="message"/>
    <property name="portNumber" value="5432"/>
    <property name="user" value="postgres"/>
    <property name="password" value="postgres"/>
    <property name="dataSourceName" value="postgres"/>
    <property name="initialConnections" value="1"/>
    <property name="maxConnections" value="10"/>
  </bean>

But we get the following error?

./activemq-admin start xbean:activemq-jdbc.xml 
Java Runtime: Sun Microsystems Inc. 1.6.0_12
/usr/lib/jvm/java-6-sun-1.6.0.12/jre
  Heap sizes: current=7680k  free=6027k  max=506816k
    JVM args: -Xmx512M -Dorg.apache.activemq.UseDedicatedTaskRunner=true
-Djava.util.logging.config.file=logging.properties
-Dcom.sun.management.jmxremote -Dactivemq.classpath=/opt/activemq/conf;
-Dactivemq.home=/opt/activemq -Dactivemq.base=/opt/activemq
ACTIVEMQ_HOME: /opt/activemq
ACTIVEMQ_BASE: /opt/activemq
Loading message broker from: xbean:activemq-jdbc.xml
 INFO | Using Persistence Adapter:
JDBCPersistenceAdapter(org.postgresql.ds.PGPoolingDataSource@40f892a4)
 INFO | Database adapter driver override recognized for :
[postgresql_native_driver] - adapter: class
org.apache.activemq.store.jdbc.adapter.PostgresqlJDBCAdapter
 WARN | Could not create JDBC tables; they could already exist. Failure was:
CREATE TABLE ACTIVEMQ_MSGS(ID BIGINT NOT NULL, CONTAINER VARCHAR(250),
MSGID_PROD VARCHAR(250), MSGID_SEQ BIGINT, EXPIRATION BIGINT, MSG BYTEA,
PRIMARY KEY ( ID ) ) Message: ERROR: no schema has been selected to create
in SQLState: 3F000 Vendor code: 0
 WARN | Failure details: ERROR: no schema has been selected to create in
org.postgresql.util.PSQLException: ERROR: no schema has been selected to
create in

Any help really appreciated .

Regards,
Jonathan
-- 
View this message in context: http://old.nabble.com/jdbc-postgres-tp28762766p28762766.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.


Mime
View raw message