This page contains an archived post to the Java Answers Forum made prior to February 25, 2002. If you wish to participate in discussions, please visit the new Artima Forums.

Message:

com.ibm.ejs.cm.proxy.OracleConnectionProxy

Posted by Rajeev Govil on September 10, 2001 at 4:16 AM

Hi,

I am also facing the same problem. Please also update me if you find a solution.

Regards,

Rajeev

> Hi I have the same problem the funny part is if U use Class.ForName to load the Driver this problem will notbe caused
> because There is a difference in using DB pooling DataSources and the plain JDBC thin driver from oracle. The difference is that the JDBC thin driver from oracle instantiated a connection object for each request. So it instantiates and garbage collects etc. The DataSource in WebSphere pools 10 objects and all requests borrow the references.

> letme know if U have a solution with DataSources
> Regards
> Dibya
> > Hello,
> > I am trying to use the updatable resultset in my program.I am developing a servlet with IBM Visulage for Java (including the feature, Oracle JDBC JDK 11 ) on NT environment and connecting to an Oracle database.
> > When creating a statement, I receive such an error as :
> > "java.lang.AbstractMethodError java.lang.Throwable() java.lang.Error()
> > java.lang.LinkageError() java.lang.IncompatibleClassChangeError()
> > java.lang.AbstractMethodError() java.sql.Statement
> > com.ibm.ejs.cm.pool.ConnectO.createStatement(int, int) java.sql.Statement
> > com.ibm.ejs.cm.pool.ConnectO.createStatement(int, int) java.sql.Statement
> > com.ibm.ejs.cm.proxy.OracleConnectionProxy.createStatement(int, int) void
> > com.abank.cbs.login.SetUserPasswordCommand.setPassword(java.lang.String) void
> > com.abank.esube.actions.login.ChangeUserPasswordAction.triggerChangeUserPasswordAutorize(com.abank.servlet.framework.ActionContext)
> > void....."

> > And here is the code I use;

> >
> > Context ctx = new InitialContext();
> > DataSource ds = (DataSource)ctx.lookup("jdbc/ahu");

> > String strSelect = "SELECT uname, usirname FROM user";
> > String strWhere = "WHERE (USERID = '323232') ";
> >
> > Connection connection = ds.getConnection("ahu", "ahu");

> > Statement stmt = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

> > ResultSet rs = stmt.executeQuery(strSelect + strWhere);
> > while (rs.next() ) {
> > rs.updateString("uname","ahu");
> > rs.updateRow();
> > }
> > stmt.close();
> > connection.close();

> > Any help is appreciated.
> > Regards,
> > Ahu ERYURUK