|
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 Dibya Singh on September 07, 2001 at 10:21 AM
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
Replies:
|
