activemq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Claus Ibsen (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 07:09:59 GMT

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

Claus Ibsen commented on AMQ-1492:
----------------------------------

The XSD schema file in activemq-core needs to be updated to include new option changeAutoCommitAllowed
in the XSD.

And for that we need to run the generator, and checkin the updated source files. But after
the xbean upgrade and some changes by Hiram, the tool doesn't generete the schema file correctly
last time I tried.


                
>  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