I have the following code in context.xml
for Tomcat:
<Resource name="ds/OracleDS" auth="Container" type="javax.sql.DataSource"
maxActive="1" maxIdle="2" maxWait="2"
username="demo" password="demo"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:orcl"/>
I have this code in web.xml
:
<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>ds/OracleDS</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
I have written code in persistence.xml
like:
<persistence-unit name="ReceivablesPU" transaction-type="RESOURCE_LOCAL">
<provider>oracle.toplink.essentials.PersistenceProvider</provider>
<non-jta-data-source>java:ds/OracleDS</non-jta-data-source>
I don't understand java:ds/OracleDS
,<Resource name="ds/OracleDS"
,<res-ref-name>ds/OracleDS</res-ref-name>
. The error is:
javax.persistence.PersistenceException: Exception [TOPLINK-7060] (Oracle TopLink Essentials - 2.0 (Build b40-rc (03/21/2007))): oracle.toplink.essentials.exceptions.ValidationException
Exception Description: Cannot acquire data source [java:ds/OracleDS].
Internal Exception: javax.naming.NamingException: This context must be accessed through a java: URL
In persistence.xml
, your third line should look like this:
<non-jta-data-source>java:comp/env/ds/OracleDS</non-jta-data-source>
i changes in contex.xml:
<Resource name="OracleDS" auth="Container" type="javax.sql.DataSource"
maxActive="1" maxIdle="2" maxWait="2"
username="demo" password="demo"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:orcl"/>
i changes in web.xml:
<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>OracleDS</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
i changes in persistence.xml
<persistence-unit name="ReceivablesPU" transaction-type="RESOURCE_LOCAL">
<provider>oracle.toplink.essentials.PersistenceProvider</provider>
<non-jta-data-source>java:comp/env/OracleDS</non-jta-data-source>
then i got the output....
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With