activemq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "gkathiravan (JIRA)" <>
Subject [jira] Created: (AMQ-1492) SET AUTOCOMMIT TO OFF is no longer supported Postgre8.1 Error
Date Sat, 17 Nov 2007 09:29:26 GMT
 SET AUTOCOMMIT TO OFF is no longer supported Postgre8.1 Error

                 Key: AMQ-1492
             Project: ActiveMQ
          Issue Type: Bug
          Components: Broker
    Affects Versions: 4.1.1
         Environment: Windows
            Reporter: gkathiravan

I am using Postgresql 8.1 with postgresql-8.1-409.jdbc3.jar driver for starting the broker.

      <journaledJDBC journalLogFiles="5" dataDirectory="../persistencedata" dataSource="#postgres-ds"/>
  <bean id="postgres-ds" class="org.postgresql.ds.PGPoolingDataSource">
    <property name="serverName" value=""/>
    <property name="databaseName" value="merge_emr_billing"/>
    <property name="portNumber" value="5432"/>
    <property name="user" value="pcare"/>
    <property name="password" value="pcare007"/>
    <property name="dataSourceName" value="postgres"/>
    <property name="initialConnections" value="1"/>
    <property name="maxConnections" value="10"/>

When i start the broker using the above configuration the following error is occured.

Nov 17, 2007 2:21:27 PM createAdapter
INFO: Database driver recognized: [postgresql_native_driver]
Exception in thread "main" ERROR:  SET AUTOCOMMIT TO OFF is no longer

	at org.apache.activemq.util.IOExceptionSupport.create(
	at com.glenwood.Queue.StartBroker.createPersistenceAdapter(
	at com.glenwood.Queue.StartBroker.main(
Caused by: java.sql.SQLException: ERROR:  SET AUTOCOMMIT TO OFF is no longer supported

	at org.postgresql.core.QueryExecutor.execute(
	at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(
	at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(
	at org.postgresql.jdbc1.AbstractJdbc1Connection.setAutoCommit(
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.postgresql.ds.common.PooledConnectionImpl$ConnectionHandler.invoke(
	at $Proxy0.setAutoCommit(Unknown Source)
	... 4 more

How to setAutocommit to off?.. Postgre sql doesnot supporting it.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message