cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
906
Views
0
Helpful
4
Replies

Oracle connection checker class for Datasource in CPSC 10.0.R2

Hi,

I am trying to configure a datasource with an Oracle database [RequestCenter is on SQL Server] in v.10.0.R2. In previous version of CPSC, we used the UnifiedDriver class and UDBValidConnectionChecker.

<driver-class>com.newscale.jdbc.UnifiedDriver</driver-class>

<valid-connection-checker-class-name>com.newscale.jboss.resource.UDBValidConnectionChecker</valid-connection-checker-class-name>

 

In the installation guide, it is mentioned as "If you have any customization that makes use of the newScale unified driver, it has to be replaced with the appropriate JDBC driver based on the database type". Where can we refer the 'appropriate driver class'? In the standalone-full.xml file, what JDBC driver class and connetion checker I can provide?

 

Appreciate your help!

 

Thanks,

Guna

4 Replies 4

I am able to add the data source via JBoss administrator; but it is not listed in the Administration -> Data Source Registry in 10.0.R2. 

Can any one have suggestion for this?

Thanks,

Guna

The issue is resolved now.

When migrating from 9.3.2 to 10.0.R2, the "Type" column in DefDataSource table was not altered.

Used the below query to fix this issue

 ALTER TABLE [DefDataSource] ALTER COLUMN [Type] varchar(500)

This was identified and resolved via the service request 638364597 

Thanks,

Guna

mpetra
Cisco Employee
Cisco Employee