AnsweredAssumed Answered

APMSQL JDBC connection error in CA BI

Question asked by SusSatriyoAdiSuryo4211615 on Sep 26, 2018
Latest reply on Sep 26, 2018 by SusSatriyoAdiSuryo4211615

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

Outcomes