Hi Jason, Thanks for the reply.I looked at the link but didn't find it much useful. I think it is classpath problem. The ojdbc14.jar is not budled into my war file. When I deploy on tomcat, it gives the previous error.
But when I copy ojdbc.jar into my application lib directory, it reads the clob and doesn't give any errors. But when I try to save into clob, it gives this error: Warning OracleLobCreator needs to work on [oracle.jdbc.OracleConnection], not on [class oracle.jdbc.driver.OracleConnection] - specify a corresponding NativeJdbcExtractor The same thing happens on my windows machine if I copy the ojdbc14.jar into the application. But if I take it out it starts working properly. The only thing on my windows is that I have set ojdbc.jar into my windows envireonment path. i tried to do the same thing on Linux but it still gave the same error. Any suggestions. Thanks, Pankaj --- Jason Brice <[EMAIL PROTECTED]> wrote: > This thread had some things to check: > http://forum.springframework.org/archive/index.php/t-10002.html > > Also... is it possible that you have another copy of > the JDBC jar somewhere > (in the shared lib perhaps) that is causing > problems? > > Jason > > > > On 12/19/06, pankaj singla <[EMAIL PROTECTED]> > wrote: > > > > Hi, > > > > I am using appfuse 1.7 wiht hibernate 2. I am > > trying to use clob in one of my tables. > > > > I added these in applicationContext-hibernate.xml > > under sessionFactory bean. > > > > <property name="lobHandler"> > > > > <bean > > > class="org.springframework.jdbc.support.lob.OracleLobHandler"> > > <property name="nativeJdbcExtractor"> > > <bean > > class=" > > > org.springframework.jdbc.support.nativejdbc.SimpleNativeJdbcExtractor"/> > > </property> > > </bean> > > > > </property> > > > > While this application works fine on my windows > > machine on tomcat 5.0.28, it is throwing following > > errors when I try to deploy on the server. > > > > > [org.springframework.jdbc.support.lob.OracleLobHandler]; > > constructor threw exception; nested exception is > > > org.springframework.dao.InvalidDataAccessApiUsageException: > > Couldn't initialize OracleLobHandler because > Oracle > > driver classes are not available; nested exception > is > > java.lang.NoSuchFieldException: DURATION_SESSION > > > > java.lang.NoSuchFieldException: DURATION_SESSION > > at > java.lang.Class.getField(Class.java:919) > > at > > > org.springframework.jdbc.support.lob.OracleLobHandler.<init>( > > OracleLobHandler.java:121) > > at > > > sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > > Method)............. > > > > I checked tomcat libraties and everything is > exacly > > same on the server. I was using classes12.jar but > I > > changed it to ojdbc14.jar, but to no use. > > > > Could someone tell me what I might be missing to > get > > rid of this error. > > > > Thanks, > > > > Pankaj > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam > protection around > > http://mail.yahoo.com > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]