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 :



      oracle.jdbc.driver.OracleDriver



      DefaultDS
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
      jdbc:oracle:thin:@110.15.23.16:1521:mydb
      test
      test
      0
      5


      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.initial","org.jnp.interfaces.NamingContextFactory");
      prop.setProperty("java.naming.provider.url","jnp://localhost:1099");
      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 !