You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@activemq.apache.org by F-kris <en...@hotmail.com> on 2006/09/01 00:18:18 UTC
Postgresql type "blob" does not exist
Hi again !
I am trying to set up ActiveMQ persistence with postgreSQL. I have created
the database activemq in postgres, but when I launch Activemq, I have the
following error :
RMIConnectorServer started at:
service:jmx:rmi://localhost/jndi/rmi://localhost:1099/jmxrmi
WARN DefaultJDBCAdapter - Could not create JDBC tables; they
could already exist. Failure was: CREATE TABLE ACTIVEMQ_MSGS(ID INTEGER NOT
NULL, CONTAINER VARCHAR(250), MSGID_PROD VARCHAR(250), MSGID_SEQ INTEGER,
EXPIRATION BIGINT, MSG BLOB, PRIMARY KEY ( ID ) )
Message: ERROR: type "blob" does not exist SQLState: 42704 Vendor code: 0
Do I have to load a library into postgreSQL server?
Thanks.
--
View this message in context: http://www.nabble.com/Postgresql-type-%22blob%22-does-not-exist-tf2199586.html#a6089370
Sent from the ActiveMQ - User forum at Nabble.com.
Re: Postgresql type "blob" does not exist
Posted by James Strachan <ja...@gmail.com>.
It can depend on what JDBC driver you are using and what your
activemq.xml looks like. Could you provide us with your XML
configuration file and the full log of the output - since we try to
auto-detect the JDBC driver and use different SQL for different JDBC
drivers
On 8/31/06, F-kris <en...@hotmail.com> wrote:
>
> Hi again !
>
> I am trying to set up ActiveMQ persistence with postgreSQL. I have created
> the database activemq in postgres, but when I launch Activemq, I have the
> following error :
>
> RMIConnectorServer started at:
> service:jmx:rmi://localhost/jndi/rmi://localhost:1099/jmxrmi
>
> WARN DefaultJDBCAdapter - Could not create JDBC tables; they
> could already exist. Failure was: CREATE TABLE ACTIVEMQ_MSGS(ID INTEGER NOT
> NULL, CONTAINER VARCHAR(250), MSGID_PROD VARCHAR(250), MSGID_SEQ INTEGER,
> EXPIRATION BIGINT, MSG BLOB, PRIMARY KEY ( ID ) )
>
> Message: ERROR: type "blob" does not exist SQLState: 42704 Vendor code: 0
>
>
> Do I have to load a library into postgreSQL server?
>
> Thanks.
>
>
> --
> View this message in context: http://www.nabble.com/Postgresql-type-%22blob%22-does-not-exist-tf2199586.html#a6089370
> Sent from the ActiveMQ - User forum at Nabble.com.
>
>
--
James
-------
http://radio.weblogs.com/0112098/