1 Reply Latest reply on Dec 19, 2020 11:19 PM by mani vincent

    Error creating delegate data source for 'JNDI: jdbc/XXXMSSQL'      Error looking up JNDI DataSource (not found).

    mani vincent Active Member

      getting below error from dataaccess service..

       

      followed below steps

      1.. copied sqljdbc41.jar into ...Process Developer\designer\plugins\com.activee.serverep_9.35.0.201807121021\server\lib

      2. ...\Process Developer\designer\plugins\com.activee.serverep_9.35.0.201807121021\server\conf\Catalina\localhost\activevos.xml

           <Resource driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" maxActive="10" maxIdle="3" maxWait="10000" name="jdbc/XXXMSSQL" password="informaticauser" type="javax.sql.DataSource" url="jdbc:sqlserver://xxxxdev.database.windows.net:1433;databaseName=sqldb-xxx-profile-dev;" username="**********"/>

      3. ...\Process Developer\designer\plugins\com.activee.serverep_9.35.0.201807121021\server\conf\Catalina\localhost\active-bpel.xml

      <Resource driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" maxActive="10" maxIdle="3" maxWait="10000" name="jdbc/XXXMSSQL" password="informaticauser" type="javax.sql.DataSource" url="jdbc:sqlserver://xxxxdev.database.windows.net:1433;databaseName=sqldb-xxx-profile-dev;" username="**********"/>

      4. in PDD partner linke i have configured system service with "jdbc/XXXMSSQL"