Hi,
I have CA BI installed in dedicated server.
In EM Server I did Squirrel JDBC connection without any error. I can execute some sql query from there.
In CA BI Server I try the connection from CA BI I, but I got error
Cannot get a connection, pool error Could not create a validated object, cause: Call to method setReadOnly(true) not valid during a transaction.
I follow the instruction to troubleshot this error from this URL Connect to CA APMSQL - CA Application Performance Management - 10.5 - CA Technologies Documentation. I add <property name=”defaultReadOnly” value=”false”/> to jdbcDataSourceServiceFactory bean:
<bean id="jdbcDataSourceServiceFactory" class="com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcReportDataSourceServiceFactory">
<property name="pooledJdbcDataSourceFactory">
<ref bean="dbcpJdbcDataSourceFactory"/>
</property>
<property name="autoCommitUnsupportedDrivers">
<set>
<value>com.simba.cassandra.jdbc4.Driver</value>
<value>com.simba.impala.jdbc4.Driver</value>
</set>
</property>
<property name="driverAuthMethMap">
<map>
<entry key="com.simba.cassandra.jdbc4.Driver" value="1"/>
<entry key="com.simba.impala.jdbc4.Driver" value="3"/>
</map>
</property>
<property name="poolTimeout" value="900"/>
<property name=”defaultReadOnly” value=”false”/>
</bean>
After I add the property and restart the CA Business Intelligence Tomcat Service, the CA BI browser does not work with error: HTTP ERROR 404
Then, I remove the <property name=”defaultReadOnly” value=”false”/>. I restart the CA Business Intelligence Tomcat Service and CA BI can work.
The <property name=”defaultReadOnly” value=”false”/> seems made the tomcat does not work properly.
Now I'm still getting error: Cannot get a connection, pool error Could not create a validated object, cause: Call to method setReadOnly(true) not valid during a transaction. Is there any other ways to solve this error message?
Regards
Rio