[JCA] New message: "How best to handle DB failover?"
by Mike Cev
User development,
A new message was posted in the thread "How best to handle DB failover?":
http://community.jboss.org/message/527747#527747
Author : Mike Cev
Profile : http://community.jboss.org/people/mcevikce
Message:
--------------------------------------------------------------
I have read how to configure HA maneged connection factories as well as how to configure a data source to detect if connection is valid by useing:
<check-valid-connection-sql>. Unfortunetly I am still running into issues.
I have a data source configured in a following wat:
<local-tx-datasource>
<jndi-name>jdbc/DSWriteSybaseServer</jndi-name>
<connection-url>jdbc:sybase:Tds:dswrite.sybase.url.com:4500</connection-url>
<driver-class>com.sybase.jdbc3.jdbc.SybDriver</driver-class>
<security-domain>DSWriteSybaseDBPassword</security-domain>
<min-pool-size>5</min-pool-size>
<max-pool-size>${m25</max-pool-size>
<connection-property name="APPLICATIONNAME">${jbmyapplication</connection-property>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.SybaseExceptionSorter</exception-sorter-class-name>
<check-valid-connection-sql>select @@servername</check-valid-connection-sql>
<metadata>
<type-mapping>Sybase</type-mapping>
</metadata>
</local-tx-datasource>
What happens is, the connection URL defined above is a DNS cname mapped to an IP address. When DB failover occurs, we switch the IP address for that DNS cname to our DR DB server's IP address. DB failover doesn't mean the database server is totally down. DB server can still be accesses but all accounts are locked.
But even with <check-valid-connection-sql> defined, my old connections are still there. I would expect all of the old connections to be recycled but thats not the case.
Is there a way to clear all the connections in my datasource and recreate them with new URL?
--------------------------------------------------------------
To reply to this message visit the message page: http://community.jboss.org/message/527747#527747
16 years, 2 months
[jBPM] New message: "Re: unable to start a process instance in a console"
by Puneet Singhal
User development,
A new message was posted in the thread "unable to start a process instance in a console":
http://community.jboss.org/message/527708#527708
Author : Puneet Singhal
Profile : http://community.jboss.org/people/pscoe2
Message:
--------------------------------------------------------------
Hi,
I am facing a similar error but i am using Ibatis instead of hibernate...
[junit] --- Cause: java.sql.SQLException: Column not found: ROWNUM in statement [ .....
....
WHERE rownum <= ? ) WHERE rnum > ? ]
[junit] at org.hsqldb.jdbc.Util.throwError(Unknown Source)
[junit] at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
[junit] at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
[junit] at com.ibatis.common.jdbc.SimpleDataSource$SimplePooledConnection.invoke(SimpleDataSource.java:958)
[junit] at $Proxy11.prepareStatement(Unknown Source)
[junit] at com.ibatis.common.jdbc.logging.ConnectionLogProxy.invoke(ConnectionLogProxy.java:53)
[junit] at $Proxy11.prepareStatement(Unknown Source)
[junit] at com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:497)
[junit] at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:175)
[junit] at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)
[junit] at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
I dont know what this error means.
I am trying to implement oracle pagination in ibatis when i got this error...
Can someone help me out???
Thanks
--------------------------------------------------------------
To reply to this message visit the message page: http://community.jboss.org/message/527708#527708
16 years, 2 months