chaitu chaitu
asked on
not able to connect database in jdeveloper
I created jpr's for web and EJB's in Jdeveloper;
for EJB this is ejb-jar.xml file
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE ejb-jar PUBLIC '-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 2.0//EN' 'http://java.sun.com/dtd/ejb-jar_2_0.dtd'>
<ejb-jar>
<description>No Description</description>
<display-name>EJB</display -name>
<small-icon />
<large-icon />
<enterprise-beans>
<session>
<description>No Description</description>
<display-name>ESupplyUtili tiesSessio nBean</dis play-name>
<ejb-name>ESupplyUtilities SessionBea n</ejb-nam e>
<home>com.foursoft.esupply .common.ej b.sls.ESup plyUtiliti esSessionH ome</home>
<remote>com.foursoft.esupp ly.common. ejb.sls.ES upplyUtili tiesSessio n</remote>
<ejb-class>com.foursoft.es upply.comm on.ejb.sls .ESupplyUt ilitiesSes sionBean</ ejb-class>
<session-type>Stateless</s ession-typ e>
<transaction-type>Containe r</transac tion-type>
<resource-ref>
<description>No Description</description>
<res-ref-name>jdbc/DB</res -ref-name>
<res-type>javax.sql.DataSo urce</res- type>
<res-auth>Container</res-a uth>
</resource-ref>
</session>
</enterprise-beans>
</ejb-jar>
orion-ejb-jar.xml
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE orion-ejb-jar PUBLIC "-//Evermind//DTD Enterprise JavaBeans 1.1 runtime//EN" "http://xmlns.oracle.com/ias/dtds/orion-ejb-jar.dtd">
<orion-ejb-jar deployment-version="9.0.2. 0.0" deployment-time="f862b4565 3">
<enterprise-beans>
<session-deployment name="ConsolSessionBean" max-instances="10" location="ConsolSessionBea n" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ETCustomerContractSe ssionBean" max-instances="10" location="ETCustomerContra ctSessionB ean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ETransGatewaySetupSe ssionBean" max-instances="10" location="ETransGatewaySet upSessionB ean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="QuoteSessionBean" max-instances="10" location="QuoteSessionBean " >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ETransHOSuperUserSet upSessionB ean" max-instances="10" location="ETransHOSuperUse rSetupSess ionBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ETransHOAdminSetupSe ssionBean" max-instances="10" location="ETransHOAdminSet upSessionB ean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="OceanTariffSessionBe an" max-instances="10" location="OceanTariffSessi onBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ClausesSessionBean" max-instances="10" location="ClausesSessionBe an" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="TaxEngineBean" max-instances="10" location="TaxEngineBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ChargeMasterSessionB ean" max-instances="10" location="ChargeMasterSess ionBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="AccessControlSession Bean" max-instances="10" location="AccessControlSes sionBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="UserRoleRegistration SessionBea n" max-instances="10" location="UserRoleRegistra tionSessio nBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ESupplyUtilitiesSess ionBean" max-instances="10" location="ESupplyUtilities SessionBea n" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="MailerBean" max-instances="10" location="MailerBean" >
<resource-ref-mapping name="mail/MS" location="mailPool" />
</session-deployment>
<session-deployment name="ETSSetupSessionBean" max-instances="10" location="ETSSetupSessionB ean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ETDOSessionBean" max-instances="10" location="ETDOSessionBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="OIDSessionBean" max-instances="10" location="OIDSessionBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="CustomerReportSessio nBean" max-instances="10" location="CustomerReportSe ssionBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="OperationalReportSes sionBean" max-instances="10" location="OperationalRepor tSessionBe an" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="TrackingSessionBean" max-instances="10" location="TrackingSessionB ean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ShipmentEventsSessio nBean" max-instances="10" location="ShipmentEventsSe ssionBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="GpsSetupSessionBean" max-instances="10" location="GpsSetupSessionB ean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="BeyondCostSessionBea n" max-instances="10" location="BeyondCostSessio nBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="BillingSessionBean" max-instances="10" location="BillingSessionBe an" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="BookingSessionBean" max-instances="10" location="BookingSessionBe an" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="BreakBulkSessionBean " max-instances="10" location="BreakBulkSession Bean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ProfilesSessionBean" max-instances="10" location="ProfilesSessionB ean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ConsoleSessionBean" max-instances="10" location="ConsoleSessionBe an" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="HBLSessionBean" max-instances="10" location="HBLSessionBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ETSReportsSessionBea n" max-instances="10" location="ETSReportsSessio nBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="CustomerSessionBean" max-instances="10" location="CustomerSessionB ean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="VendorSessionBean" max-instances="10" location="VendorSessionBea n" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="HouseDocumentSession Bean" max-instances="10" location="HouseDocumentSes sionBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="MAWBSessionBean" max-instances="10" location="MAWBSessionBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ETAReportsSessionBea n" max-instances="10" location="ETAReportsSessio nBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ETUtilitiesSessionBe an" max-instances="10" location="ETUtilitiesSessi onBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ETOperationUtilities SessionBea n" max-instances="10" location="ETOperationUtili tiesSessio nBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="HouseSessionBean" max-instances="10" location="HouseSessionBean " >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<entity-deployment name="QuoteBean" max-instances="10" location="QuoteBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
<entity-deployment name="OceanTariffBean" max-instances="10" location="OceanTariffBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
<entity-deployment name="RoleMasterBean" max-instances="10" location="RoleMasterBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
<entity-deployment name="UserMasterBean" max-instances="10" location="UserMasterBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
<entity-deployment name="ConsoleEntityBean" max-instances="10" location="ConsoleEntityBea n" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
<entity-deployment name="HAWBEntityBean" max-instances="10" location="HAWBEntityBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
<entity-deployment name="MAWBEntityBean" max-instances="10" location="MAWBEntityBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
<entity-deployment name="HBLEntityBean" max-instances="10" location="HBLEntityBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
<entity-deployment name="HouseEntityBean" max-instances="10" location="HouseEntityBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
<entity-deployment name="BookingEntityBean" max-instances="10" location="BookingEntityBea n" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
<entity-deployment name="CustomerBean" max-instances="10" location="CustomerBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
<entity-deployment name="VendorBean" max-instances="10" location="VendorBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
</enterprise-beans>
<assembly-descriptor>
<default-method-access>
<security-role-mapping name="<default-ejb-call er-role> ;" impliesAll="true" />
</default-method-access>
</assembly-descriptor>
</orion-ejb-jar>
;i will run index.jsp from jdeveloper,this jsp will call ejb file ;in jdeveloper on what name should i create the connection ?
for EJB this is ejb-jar.xml file
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE ejb-jar PUBLIC '-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 2.0//EN' 'http://java.sun.com/dtd/ejb-jar_2_0.dtd'>
<ejb-jar>
<description>No Description</description>
<display-name>EJB</display
<small-icon />
<large-icon />
<enterprise-beans>
<session>
<description>No Description</description>
<display-name>ESupplyUtili
<ejb-name>ESupplyUtilities
<home>com.foursoft.esupply
<remote>com.foursoft.esupp
<ejb-class>com.foursoft.es
<session-type>Stateless</s
<transaction-type>Containe
<resource-ref>
<description>No Description</description>
<res-ref-name>jdbc/DB</res
<res-type>javax.sql.DataSo
<res-auth>Container</res-a
</resource-ref>
</session>
</enterprise-beans>
</ejb-jar>
orion-ejb-jar.xml
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE orion-ejb-jar PUBLIC "-//Evermind//DTD Enterprise JavaBeans 1.1 runtime//EN" "http://xmlns.oracle.com/ias/dtds/orion-ejb-jar.dtd">
<orion-ejb-jar deployment-version="9.0.2.
<enterprise-beans>
<session-deployment name="ConsolSessionBean" max-instances="10" location="ConsolSessionBea
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ETCustomerContractSe
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ETransGatewaySetupSe
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="QuoteSessionBean" max-instances="10" location="QuoteSessionBean
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ETransHOSuperUserSet
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ETransHOAdminSetupSe
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="OceanTariffSessionBe
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ClausesSessionBean" max-instances="10" location="ClausesSessionBe
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="TaxEngineBean" max-instances="10" location="TaxEngineBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ChargeMasterSessionB
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="AccessControlSession
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="UserRoleRegistration
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ESupplyUtilitiesSess
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="MailerBean" max-instances="10" location="MailerBean" >
<resource-ref-mapping name="mail/MS" location="mailPool" />
</session-deployment>
<session-deployment name="ETSSetupSessionBean"
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ETDOSessionBean" max-instances="10" location="ETDOSessionBean"
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="OIDSessionBean" max-instances="10" location="OIDSessionBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="CustomerReportSessio
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="OperationalReportSes
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="TrackingSessionBean"
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ShipmentEventsSessio
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="GpsSetupSessionBean"
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="BeyondCostSessionBea
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="BillingSessionBean" max-instances="10" location="BillingSessionBe
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="BookingSessionBean" max-instances="10" location="BookingSessionBe
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="BreakBulkSessionBean
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ProfilesSessionBean"
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ConsoleSessionBean" max-instances="10" location="ConsoleSessionBe
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="HBLSessionBean" max-instances="10" location="HBLSessionBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ETSReportsSessionBea
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="CustomerSessionBean"
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="VendorSessionBean" max-instances="10" location="VendorSessionBea
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="HouseDocumentSession
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="MAWBSessionBean" max-instances="10" location="MAWBSessionBean"
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ETAReportsSessionBea
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ETUtilitiesSessionBe
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="ETOperationUtilities
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<session-deployment name="HouseSessionBean" max-instances="10" location="HouseSessionBean
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</session-deployment>
<entity-deployment name="QuoteBean" max-instances="10" location="QuoteBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
<entity-deployment name="OceanTariffBean" max-instances="10" location="OceanTariffBean"
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
<entity-deployment name="RoleMasterBean" max-instances="10" location="RoleMasterBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
<entity-deployment name="UserMasterBean" max-instances="10" location="UserMasterBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
<entity-deployment name="ConsoleEntityBean" max-instances="10" location="ConsoleEntityBea
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
<entity-deployment name="HAWBEntityBean" max-instances="10" location="HAWBEntityBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
<entity-deployment name="MAWBEntityBean" max-instances="10" location="MAWBEntityBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
<entity-deployment name="HBLEntityBean" max-instances="10" location="HBLEntityBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
<entity-deployment name="HouseEntityBean" max-instances="10" location="HouseEntityBean"
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
<entity-deployment name="BookingEntityBean" max-instances="10" location="BookingEntityBea
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
<entity-deployment name="CustomerBean" max-instances="10" location="CustomerBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
<entity-deployment name="VendorBean" max-instances="10" location="VendorBean" >
<resource-ref-mapping name="jdbc/DB" location="oraclePool" />
</entity-deployment>
</enterprise-beans>
<assembly-descriptor>
<default-method-access>
<security-role-mapping name="<default-ejb-call
</default-method-access>
</assembly-descriptor>
</orion-ejb-jar>
;i will run index.jsp from jdeveloper,this jsp will call ejb file ;in jdeveloper on what name should i create the connection ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.