Re: gotta take a shot

From: Joe Weinstein (joeNOSPAM_at_bea.com)
Date: 07/23/04 

Date: Fri, 23 Jul 2004 10:48:54 -0700
To: "D. Alvarado" <laredotornado@zipmail.com>

D. Alvarado wrote:

> Damn, Joe, you guys at BEA know what you're doing. When I changed the
> Connection retrieval code from
>
> return DriverManager.getConnection("jdbc:weblogic:pool:" +
> poolName, null);
>
> to
>
> return DriverManager.getConnection("jdbc20:weblogic:pool:" +
> poolName, null);
>
> everything worked great.
>
> Thanks, -

You're very welcome. We want you successful.
Joe Weinstein at BEA

>
> Joe Weinstein <joeNOSPAM@bea.com> wrote in message news:<40FFF0DC.1090306@bea.com>...
>
>>D. Alvarado wrote:
>>
>>>Ok, this error is pretty out there, but here goes.
>>>
>>>I want to retrieve an Oracle 8.1.7 CLOB value in a java.lang.String.
>>>I'm running WL 5.1 SP12 on Solaris 8. The code is
>>>
>>> oracle.sql.CLOB contClob = (oracle.sql.CLOB)
>>>resultset.getClob(headings[k]); // line 78
>>> sData = contClob.getSubString(1, (int)contClob.length());
>>>
>>>The type of "headings[k]" is a String. I have verified that the
>>>"classes12.zip" file is in my Java runtime path. The error I get is
>>>
>>>java.lang.AbstractMethodError
>>> at com.hrw.xls.GenerateXLSFile.CreateXLSFileWithQuery(GenerateXLSFile.java:78)
>>
>>Hi. Are you using the oracle driver directly, or are you using Weblogic pools?
>>Note that Weblogic version 5 is a JDBC 1.0-vintage product... I suspect that
>>you need to alter your pool URL from "jdbc:..." to "jdbc20:...".
>>
>>Joe Weinstein at BEA
>>
>>PS: Your shot was extremely lucky, given the non-technical Subject string. You can also
>>use the BEA weblogic developer newsgroups for such questions.
>>
>>
>>> at com.hrw.xls.GenerateXLSFile.CreateXLSFile(GenerateXLSFile.java:41)
>>> at com.hrw.xls.GenerateXLSFile.createFile(GenerateXLSFile.java:33)
>>> at jsp_servlet._db_portal.__db_results.getFileLocation(__db_results.java:104)
>>> at jsp_servlet._db_portal.__db_results._jspService(__db_results.java:213)
>>> at weblogic.servlet.jsp.JspBase.service(JspBase.java:27)
>>> at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:120)
>>> at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImpl.java:945)
>>> at weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImpl.java:909)
>>> at weblogic.servlet.internal.ServletContextManager.invokeServlet(ServletContextManager.java:269)
>>> at weblogic.socket.MuxableSocketHTTP.invokeServlet(MuxableSocketHTTP.java:392)
>>> at weblogic.socket.MuxableSocketHTTP.execute(MuxableSocketHTTP.java:274)
>>> at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:130)
>>>
>>>Any ideas? -