Hi, seems like a default schema is missing in your db. Did you try it against "clean" postgres installation?
Cheers -- Dejan Bosanac - http://twitter.com/dejanb Open Source Integration - http://fusesource.com/ ActiveMQ in Action - http://www.manning.com/snyder/ Blog - http://www.nighttale.net On Wed, Jun 2, 2010 at 11:26 PM, jonoinnz <jonathan.opper...@ecngroup.co.nz>wrote: > > 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.pgpoolingdatasou...@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. > >