error data source for pega marketing 8.1 tomcat
Hi,
I am installing Pega Marketing 8.1. I am creating the data source in order to be able to create de database externalmktData.
So to create it, in my context.xml I added the following
<Resource
name="jdbc/mktDataSource" auth="Container"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@//xxxxxxxxx:1521/PEGA"
username="APPMKT"
password=xxxxxxxxx
maxTotal="100"
maxIdle="30"
maxWaitMillis="10000"
/>
<Environment
name="prconfig/database/databases/mktDataSource/dataSource"
value="java:comp/env/jdbc/mktDataSource"
type="java.lang.String"
/>
<Environment
name="prconfig/database/databases/mktDataSource/defaultSchema"
value="APPMKT"
type="java.lang.String"
/>
but when I create the database ExternalMKTData i get this error
Hi,
I am installing Pega Marketing 8.1. I am creating the data source in order to be able to create de database externalmktData.
So to create it, in my context.xml I added the following
<Resource
name="jdbc/mktDataSource" auth="Container"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@//xxxxxxxxx:1521/PEGA"
username="APPMKT"
password=xxxxxxxxx
maxTotal="100"
maxIdle="30"
maxWaitMillis="10000"
/>
<Environment
name="prconfig/database/databases/mktDataSource/dataSource"
value="java:comp/env/jdbc/mktDataSource"
type="java.lang.String"
/>
<Environment
name="prconfig/database/databases/mktDataSource/defaultSchema"
value="APPMKT"
type="java.lang.String"
/>
but when I create the database ExternalMKTData i get this error
The JNDI name of the Data Source used to connect to this DB—
The DataSource jdbc/mktDataSource is invalid: Unable to obtain DataSource object: code: <none> SQLState: Name [jdbc/mktDataSource] is not bound in this Context. Unable to find [jdbc]. Message: <none>
DatabaseException caused by prior exception: javax.naming.NameNotFoundException: Name [jdbc/mktDataSource] is not bound in this Context. Unable to find [jdbc].
The DataSource jdbc/mktDataSource is invalid: A connection could not be obtained.
can anyone help me? I am more use to use weblogic as a app server, but it seems to have an error with pega 8.1
thank you
Pegasystems Inc.
IN
Hi Alvaro,
Can you please add "/" before "comp" in JNDI Name and check whether you are able to connect to the Data source as required. Please refer to the below links for reference.
https://tomcat.apache.org/tomcat-7.0-doc/jndi-datasource-examples-howto.html
Accenture Technology
ES
I have tried to add this inside the prweb/WEB-INF/web.xml
<resource-ref id="ResourceRef_10">
<description>ExternalMKTData datasource</description>
<res-ref-name>jdbc/mktDataSource</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope> <!-- Shareable is default -->
</resource-ref>
but I am still getting the same error :(
Pegasystems Inc.
US
What type of connection are use using on the ExternalMKTData DB rule?
At this time Pega Marketing does not use the defaultSchema property - the DB user that is used to connect must have the correct schema as its default.