activemq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Timothy Bish (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AMQ-1492) SET AUTOCOMMIT TO OFF is no longer supported Postgre8.1 Error
Date Fri, 30 Nov 2012 20:45:59 GMT

    [ https://issues.apache.org/jira/browse/AMQ-1492?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13507636#comment-13507636
] 

Timothy Bish commented on AMQ-1492:
-----------------------------------

I made some updates to the pom file so that the tool will run, we should start looking at
all this now that things have been broken out and figure out what all we need in core.
                
>  SET AUTOCOMMIT TO OFF is no longer supported Postgre8.1 Error
> --------------------------------------------------------------
>
>                 Key: AMQ-1492
>                 URL: https://issues.apache.org/jira/browse/AMQ-1492
>             Project: ActiveMQ
>          Issue Type: Improvement
>          Components: Message Store
>    Affects Versions: 4.1.1
>         Environment: Windows
>            Reporter: gkathiravan
>            Assignee: Claus Ibsen
>            Priority: Minor
>             Fix For: 5.8.0
>
>
> I am using Postgresql 8.1 with postgresql-8.1-409.jdbc3.jar driver for starting the broker.
> <persistenceAdapter>
>        
>       <journaledJDBC journalLogFiles="5" dataDirectory="../persistencedata" dataSource="#postgres-ds"/>
>       
>     </persistenceAdapter>
>    
>   <bean id="postgres-ds" class="org.postgresql.ds.PGPoolingDataSource">
>     <property name="serverName" value="1.1.1.180"/>
>     <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"/>
>   </bean>
>   
> When i start the broker using the above configuration the following error is occured.
> Nov 17, 2007 2:21:27 PM org.apache.activemq.store.jdbc.JDBCPersistenceAdapter createAdapter
> INFO: Database driver recognized: [postgresql_native_driver]
> Exception in thread "main" java.io.IOException: ERROR:  SET AUTOCOMMIT TO OFF is no longer
supported
> 	at org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:43)
> 	at org.apache.activemq.store.jdbc.TransactionContext.getConnection(TransactionContext.java:62)
> 	at org.apache.activemq.store.jdbc.TransactionContext.begin(TransactionContext.java:147)
> 	at org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.start(JDBCPersistenceAdapter.java:156)
> 	at com.glenwood.Queue.StartBroker.createPersistenceAdapter(StartBroker.java:49)
> 	at com.glenwood.Queue.StartBroker.main(StartBroker.java:28)
> Caused by: java.sql.SQLException: ERROR:  SET AUTOCOMMIT TO OFF is no longer supported
> 	at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
> 	at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:482)
> 	at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:461)
> 	at org.postgresql.jdbc1.AbstractJdbc1Connection.setAutoCommit(AbstractJdbc1Connection.java:953)
> 	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(PooledConnectionImpl.java:360)
> 	at $Proxy0.setAutoCommit(Unknown Source)
> 	at org.apache.activemq.store.jdbc.TransactionContext.getConnection(TransactionContext.java:58)
> 	... 4 more
> How to setAutocommit to off?.. Postgre sql doesnot supporting it.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message