Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: AndreK on March 11, 2011, 04:58:59 AM

Title: JDBC DAP for UCS connecting to ORACLE 10g
Post by: AndreK on March 11, 2011, 04:58:59 AM

Hi
Need help to create a custom URL in the DAP to use name_service and not SID.

STD URL:
jdbc:oracle:thin@servername:1521:sidname

UCS ERROR:
13:58:41.389 Dbg 29999 [Ucs-Main] JDBC debug is on
13:58:41.389 Trc 29998 [Ucs-Main] Datasource connection pool initialized with maximum size set to 40 connections, maximum login time set to 10s, and maximum connection idle time set to 310s.
13:58:41.404 Trc 21284 [Ucs-Main] JDBC: SQLWarning: reason(URL with SID jdbc:subprotocol:@host:port:sid will be deprecated in 10i
Please use URL with SERVICE_NAME as jdbc:subprotocol:@//host:port/service_name)
13:58:41.639 Trc 21284 [Ucs-Main] JDBC: SQLState(61000) vendor code(20)
13:58:41.639 Trc 21284 [Ucs-Main] JDBC: java.sql.SQLException: The Network Adapter could not establish the connection
13:58:41.639 Trc 21284 [Ucs-Main] JDBC: at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

Thanks
Andre

Title: Re: JDBC DAP for UCS connecting to ORACLE 10g
Post by: cavagnaro on March 11, 2011, 12:27:28 PM

It is more a JDBC issue, it is asking to use this format:

jdbc:subprotocol:@//host:port/service_name

maybe on jdbc help for connection strings