2 Replies Latest reply: Dec 30, 2006 7:15 AM by 807581 RSS

    Can I use RowSet with Type 4 Oracle Driver

    807581
      I am getting following exception when I am using Type 4 Driver with RowSet, but every thing fine with ResultSet.

      [12/Mar/2002 16:01:02:1] error: ODBC-083: could not load the library <db2cli.dll>
      configured in the registry for the driver <256>
      [12/Mar/2002 16:01:02:1] warning: ODBC-002: ODBC-002: DriverConnect: (IM002): [Microsoft][ODBC Driver Manager] Data sour
      ce name not found and no default driver specified (DB Error: 0)
      [12/Mar/2002 16:01:02:1] warning: ODBC-027: CreateConn: failed to create connection
      [new connection]: DSN=,DB=,USER=bp_andy6_d,PASS=xxxxxxxxxx

      [12/Mar/2002 16:01:02:1] error: DATA-108: failed to create a data connection with any of specified drivers
      java.sql.SQLException: no connection for statement execution
      at com.netscape.server.jdbc.NASRowSet.executeConn(Unknown Source)
      at com.netscape.server.jdbc.NASRowSet.readData(Unknown Source)
      at com.netscape.server.jdbc.NASRowSet.execute(Unknown Source)
      at com.exult.andy.base.helpers.DBAccess.executeRowSet(DBAccess.java:227)
      at com.exult.andy.base.ejb.BaseBean.runQueryDS(BaseBean.java:322)
      at com.exult.andy.base.ejb.BaseBean.runQuery(BaseBean.java:295)
      at com.exult.andy.base.ejb.BaseBean.runQueryFromDB(BaseBean.java:118)
      at com.exult.andy.base.ejb.DataGetterBean.DataBaseRequest(DataGetterBean.java:640)
      at java.lang.reflect.Method.invoke(Native Method)
      at com.exult.andy.base.ejb.ejb_skel_com_exult_andy_base_ejb_DataGetterBean.DataBaseRequest(ejb_skel_com_exult_an
      dy_base_ejb_DataGetterBean.java:225)
      at com.exult.andy.base.ejb.ejb_kcp_skel_IDataGetter.DataBaseRequest__java_sql_ResultSet__indir_wstring(ejb_kcp_s
      kel_IDataGetter.java:342)
      at com.kivasoft.ebfp.FPRequest.invokenative(Native Method)
      at com.kivasoft.ebfp.FPRequest.invoke(Unknown Source)
      at com.exult.andy.base.ejb.ejb_kcp_stub_IDataGetter.DataBaseRequest(ejb_kcp_stub_IDataGetter.java:478)
      at com.exult.andy.base.ejb.ejb_stub_IDataGetter.DataBaseRequest(ejb_stub_IDataGetter.java:79)
      at com.exult.andy.base.helpers.ANDY.load(ANDY.java:368)
      at com.exult.andy.base.helpers.ANDY.retrieve(ANDY.java:273)
      at com.exult.andy.base.helpers.ANDY.get(ANDY.java:139)
      at com.exult.andy.base.utilities.Util.readTS(Util.java:526)
      at com.iplanet.ias.startup.StartupClass.startUp(StartupClass.java:26)
      at com.kivasoft.engine.Engine.invokeStartUp(Unknown Source)
      at com.kivasoft.engine.Engine.run(Unknown Source)
      at com.kivasoft.engine.Engine.main(Unknown Source)

      And, it is working fine with ORACLE_OCI driver.

      Any Idea.

      --raj                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
        • 1. Re: Can I use RowSet with Type 4 Oracle Driver
          807581
          You can use type-4 driver with RowSets. Can you please confirm your driver and datasource configuration are correct and working for type-4 driver.
          for more information visit:
          http://docs.iplanet.com/docs/manuals/ias/60/sp4/dg/jpgjdbc.htm#13670

          And to get rid of the line: "could not load the library <db2cli.dll> ...", please see my previous posting on this.
          Please get back if any further quries.
          Thanks,
          Rakesh.
          • 2. Re: Can I use RowSet with Type 4 Oracle Driver
            807581
            Hi Rakesh,
            Even i am gettign the "could not load the library <db2cli.dll>" error message .I tried to locate your earlier post but couldnt find it. could you kindly send me the url for the same .