You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@activemq.apache.org by jonoinnz <Jo...@ecngroup.co.nz> on 2010/06/03 05:26:11 UTC
jdbc postgres
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.
Re: jdbc postgres
Posted by Dejan Bosanac <de...@nighttale.net>.
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
<Jo...@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.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.
>
>