Coldfusion 2016 with Oracle 19c
We have Coldfusion 2016 and it is running on Oracle 11g. we just updated from Oracle 11g to 19c and have tried to make a connection by creating a new data source with ojdbc8.jar in Data Source on a CF Admin. The creation was sucessfully and the verfication also showed me "OK"
however, when running our web it showed an error below
Here are the steps what I did.
1. downloaded a ojdbc8.jar ( I also tried ojdbc10.jar but no luck ) and placed it in C:\ColdFusion2016\cfusion\lib and then restated the service.
2. create a new data source in a DS page (I added the tnsoraname.ora below)
-----
AAAA=
(description=
(address_list=
(address = (protocol = TCP)(host =xxxxxx)(port = 1521))
)
(connect_data =
(service_name=AAAA)
)
)
-----
so, I put the JDBC URL and Driver class like that:
JDBC URL:jdbc:Oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxxx)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME = AAAA)))
Driver Class: oracle.jdbc.driver.OracleDriver
the creation was successful and the verification also showed me "OK"
FYI: we have applied the update 11 so far.
I am still not getting a connection in our web. Can you tell me how to solve this problem? Your comments would be greatly appreciated.
Many Thanks!
