error in creating datasource

Discussions

EJB programming & troubleshooting: error in creating datasource

  1. error in creating datasource (3 messages)

    Hi there,
      I am using wl5.1 and oracle8.1 . I using oracle oci driver to connect wl with the database. When I am starting the wl server with the following settings in the weblogic.properties file ,
    -----------------------------------------------
     weblogic.jdbc.connectionPool.demoPool=\
           url=jdbc:weblogic:oracle,\
           driver=weblogic.jdbc.oci.Driver,\
           loginDelaySecs=0,\
           initialCapacity=4,\
           maxCapacity=10,\
           capacityIncrement=2,\
          allowShrinking=true,\
          shrinkPeriodMins=15,\
          refreshMinutes=10,\
          testTable=ejbAccounts,\
         props=user=SYSTEM;password=manager;server=;

    -----------------------------------------------------
    i am getting the following error:

    java.sql.SQLException: ORA-00942: table or view doesn't exist. I couldn't trace out the error. please let me know what is wrong with my settings or database.
                               Regards,
                                Rahul

    Threaded Messages (3)

  2. error in creating datasource[ Go to top ]

    Read my response to the last time you posted this....
  3. error in creating datasource[ Go to top ]

    First put the the oci drivers extract the jar file(i mean oci driver) in weblogic\classes directory or else any where but set the classpath properly.
    In the url of the weblogic property sheet you have given oracle as a DSN name so check it in your machine it is there properly and at last see that the table exists in your database or not.
    cheer's
    kiran Bikkina!
  4. error in creating datasource[ Go to top ]

    Hi Richard!
        You are correct!!! I have to comment the JMS entries. I will do that i will see whether it works fine.
     Hi kiran,
             Thanks a lot for your response.
                          Regards,
                           Rahul