Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

java.sql.SQLException: Data Source OE does not exist

srimanApr 14 2015 — edited Apr 17 2015

Hi All,

I have installed the Oracle(R) Database 11g Release 2 (Express Edition) and Oracle(R) JDeveloper Studio Edition Version 11.1.2.4.0. I am perfectly able to create business components based on tables from the OE schema. They work perfectly from the model tester and I am able to insert/update/delete records from the database. When I tried to create a JSF page and run it, I am getting the following message in the log. I am providing my bc4j.xcfg source below. Please help me out if something is wrong with the configuration here.

Log

---------------

<RichExceptionHandler> <_logUnhandledException> ADF_FACES-60098:Faces lifecycle receives unhandled exceptions in phase RENDER_RESPONSE 6

oracle.jbo.DMLException: JBO-26061: Error while opening JDBC connection.

...

java.sql.SQLException: Pool connect failed : java.sql.SQLException: Data Source OE does not exist.

---------------


bc4j.xcfg

---------------

<?xml version = '1.0' encoding = 'UTF-8'?>

<BC4JConfig version="11.1" xmlns="http://xmlns.oracle.com/bc4j/configuration">

   <AppModuleConfigBag ApplicationName="myapp17.model.AppModule">

      <AppModuleConfig name="AppModuleLocal" jbo.project="myapp17.model.Model" ApplicationName="myapp17.model.AppModule" DeployPlatform="LOCAL">

         <Database jbo.TypeMapEntries="OracleApps"/>

         <Security AppModuleJndiName="myapp17.model.AppModule"/>

         <Custom JDBCDataSource="java:comp/env/jdbc/OE@LOCALHOSTDS"/>

      </AppModuleConfig>

      <AppModuleConfig name="AppModuleShared" jbo.project="myapp17.model.Model" ApplicationName="myapp17.model.AppModule" DeployPlatform="LOCAL">

         <AM-Pooling jbo.ampool.maxpoolsize="1" jbo.ampool.isuseexclusive="false"/>

         <Database jbo.TypeMapEntries="OracleApps"/>

         <Security AppModuleJndiName="myapp17.model.AppModule"/>

         <Custom JDBCDataSource="java:comp/env/jdbc/OE@LOCALHOSTDS"/>

      </AppModuleConfig>

   </AppModuleConfigBag>

</BC4JConfig>

---------------


Thanks & Regards,

Sriman

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 15 2015
Added on Apr 14 2015
6 comments
818 views