Re: [Springframework-developer] re: OracleLobCreator

[Thomas R. <tho...@tr...>]

That's close to what I have available here.  I'm using the 9.2.0.3 
ojdbc14.jar driver though.  You might want to try downloading the latest 
driver from Oracle's OTN site and see if that makes any difference.  If 
that does not help, could you email me a small testcase that I could try 
here.  My email is "trisberg [at] tridb.com"

Thomas


Bronwen Cassidy wrote:

>Hi I have:
>
>Weblogic 8 service pack 2 
>ojdbc.jar (Oracle9i 9.2.0.1 JDBC Drivers) 
>Oracle9i 
>I have set up the connection pool using the jdbc:oracle:thin (oracle thin
>drivers (not weblogic ones)  
>
>Actually I managed to find some information (very little) one from a
>hibernate mail, suggested using the getPhysicalConnection() instead of
>createTemporary, but this method does not seem to available on the CLOB
>class?? 
>
>-----Original Message-----
>From: spr...@li...
>[mailto:spr...@li...] On Behalf Of
>Thomas Risberg
>Sent: 31 May 2004 02:09
>To: spr...@li...
>Subject: Re: [Springframework-developer] re: OracleLobCreator
>
>Bronwen,
>
>In order to pinpoint the problem quicker - what version of WebLogic, 
>Oracle and JDBC drivers are you using?
>
>Thomas
>
>Bronwen Cassidy wrote:
>
>  
>
>>Hi I have a CLOB column in oracle and in the test there are no 
>>problems, unfortunately deploying to weblogic I get the exception 
>>below. We are using classes12.jar whereas weblogic uses ojdbc14.jar, I 
>>firstly replaced weblogics jars and classpath settings to use the 
>>classes12.jar, but got the same error, so I pulled weblogic oracle jar 
>>into my test classpath to test if the problem was with the jars but 
>>the test worked fine ?? I am really stuck as to whom this should go to 
>>weblogic, oracle, or . I am hoping there is an expert there who can 
>>shed some light. Google did not have a single match for variations of 
>>the first 2 lines!!
>>
>>java.lang.ClassCastException
>>
>>at 
>>
>>    
>>
>oracle.jdbc.driver.OracleConnection.unwrapCompletely(OracleConnection.java:5
>090)
>  
>
>>at 
>>
>>    
>>
>oracle.jdbc.driver.OracleConnection.physicalConnectionWithin(OracleConnectio
>n.java:5141)
>  
>
>>at oracle.sql.CLOB.createTemporary(CLOB.java:1009)
>>
>>at oracle.sql.CLOB.createTemporary(CLOB.java:956)
>>
>>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>
>>at 
>>
>>    
>>
>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
>)
>  
>
>>at 
>>
>>    
>>
>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
>.java:25)
>  
>
>>at java.lang.reflect.Method.invoke(Method.java:324)
>>
>>at 
>>
>>    
>>
>org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.prepa
>reLob(OracleLobHandler.java:375)
>  
>
>>at 
>>
>>    
>>
>org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.creat
>eLob(OracleLobHandler.java:327)
>  
>
>>at 
>>
>>    
>>
>org.springframework.jdbc.support.lob.OracleLobHandler$OracleLobCreator.setCl
>obAsString(OracleLobHandler.java:255)
>  
>
>>thank-you for any help
>>
>>Bronwen
>>
>>    
>>
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: Oracle 10g
>Get certified on the hottest thing ever to hit the market... Oracle 10g. 
>Take an Oracle 10g class now, and we'll give you the exam FREE.
>http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
>_______________________________________________
>Springframework-developer mailing list
>Spr...@li...
>https://lists.sourceforge.net/lists/listinfo/springframework-developer
>
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: Oracle 10g
>Get certified on the hottest thing ever to hit the market... Oracle 10g. 
>Take an Oracle 10g class now, and we'll give you the exam FREE.
>http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
>_______________________________________________
>Springframework-developer mailing list
>Spr...@li...
>https://lists.sourceforge.net/lists/listinfo/springframework-developer
>
>
>
>  
>