0 Replies Latest reply on Jan 11, 2002 7:45 AM by Sinchan

    Table is not exists problem with CMP + Oracle

    Sinchan Newbie

      I created CMP EJB, and i already configure my jboss.jcml file to connect to my Oracle DB.

      Here is the parts of the configuration :



      I Always used it as DefaultDS, because if I use
      with another name then the error will come.
      But that's fine.. I use it as DefaultDS, and
      everything works fine. And I can deploy my EJB
      without any problems.

      But when I run the client, the codes
      looks like this :

      // Create property for JBoss
      Properties prop = new Properties();
      prop.setProperty("java.naming.factory.url.pkgs", "org.jboss.naming:org.jnp.interfaces");

      // Create an Initial Context
      Context initial = new InitialContext(prop);
      System.out.println("Step 1. Initial Context");

      // Look for the object
      Object objref = initial.lookup("AccountBean");
      System.out.println("Step 2. Look For The Object");

      // Cast it
      AccountHome myAccountHome = (AccountHome) PortableRemoteObject.
      narrow(objref, AccountHome.class);
      System.out.println("Step 3. Casting the Object");

      // Create the object
      boolean docreate = true;
      if (docreate)
      Account player = myAccountHome.create("104", 1000.2, "Hanna", "Hit");
      System.out.println("Step 4. Creating the player");

      It will not print the Step 4, because it fail
      to create a new row for Account.
      And the error message is just like this :

      javax.ejb.CreateException: Could not create entity:java.sql.SQLException: ORA-00942: table or view does not exist

      I check the table, and it's there !

      What's happening ?

      I used to use J2EE App Server, and it works fine !