5 Replies Latest reply on Sep 11, 2002 10:10 PM by jason

    BMP problem (db is oracle)

    jason Newbie

      i use a sample from oreilly enterprise javabean book. it's seemly all ok, no matter wheather to preform DML or select data from db. but a problem makes me confused because, when i login to oracle, i try to, via sqlplus, select data from the table, which i create through the sample BMP bean. it issues "table or view does not exist". the similar problem occurred when selecting data out of database, after data inserted. exactly, i have no idea why. the only thing i suppose it's strange is that, seemly it only uses setter and gette methods (like <A.>) to store data, but i am not sure it's right or not.
      is there anysuggestion?
      i appreciate it, thank you very much~
      BTW, i think i successfully depoly jar file onto jboss and configure oracle-services.xml for no error message, but hope to know how to make sure. beside, my env is jboss3.0.0-tomcat4.0.3, j2sdk1.4.0, window2000 pro.
      =======
      <A.>
      ...
      public String name;
      ...
      public void setName(String a){
      this.name = a;
      }
      public String getName(){
      return name;
      }

        • 1. Re: BMP problem (db is oracle)
          jason Newbie

          avec its source code

          • 2. Re: BMP problem (db is oracle)
            Dain Sundstrom Master

            First, I would use JBoss 3.0.2 and JDB 1.3.1. As for you specific problem, I don't use BMP so I can't be much help. Are you sure you are creating the table in Oracle and not Hypersonic? Are you sure that when you login via sqlplus you are connecting to the schema to which Jboss is connecting?

            • 3. Re: BMP problem (db is oracle)
              jason Newbie

              thanks your reply. i think i ask a stupid question that i am not aware of; finally
              i found out the primary problem should be that the database it uses is default
              database resided in jboss3.0. thus, of course, it is impossible to select data
              or create any tables in oracle. i apologize for it.
              however, after i change my steps to setup connection to oracle, still there's problem
              occurred. it issues problem like A). i guess it perhpas results from JAAS setting in
              login-config.xml and oracle-service.xml, according to "JBoss 3.0 Quick Start Guide", but
              in fact, i do not know why and how to adjust it.
              would you please to give me some suggestions of how to connect to oracle (necessary
              steps and files)
              thank you very much
              i appreciate it

              ========
              A)

              java.rmi.ServerException: RemoteException occurred in server thread; nested exce
              ption is:
              java.rmi.ServerException: null
              Embedded Exception
              Invalid authentication attempt, principal=null; nested exception is:
              javax.ejb.EJBException: null
              Embedded Exception
              Invalid authentication attempt, principal=null
              ========

              • 4. Re: BMP problem (db is oracle)
                Dain Sundstrom Master

                I suggest you ask this in the datasource configuration forum.

                • 5. Re: BMP problem (db is oracle)
                  jason Newbie

                  ok, i see. thank you~