[jboss-user] [Beginners Corner] - Re: Jboss and Oracle DB Question

[sahmed223]

Thanks Peter.

Here is my oracle-ds.xml file:


  | <?xml version="1.0" encoding="UTF-8"?>
  | <datasources>
  |     <local-tx-datasource>
  |         <jndi-name>basic_ds</jndi-name>
  |         <use-java-context>false</use-java-context>
  |         <connection-url>jdbc:oracle:thin:@192.168.100.102:1521:JBOSSTST</connection-url>
  |         <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
  |         <user-name>bendev</user-name>
  |         <password>bendev</password>
  |         <metadata>
  |             <type-mapping>Oracle9i</type-mapping>
  |         </metadata>
  |     </local-tx-datasource>
  | </datasources>
  | 
  | 

Here is the Error from my application log, Is this configuration problem or code issue? :

009-04-14 09:54:38,171 INFO  [STDOUT] 09:54:38,156 ERROR V3Engine:169 - Error logging exception
java.lang.ClassCastException: org.jboss.resource.adapter.jdbc.jdk5.WrappedConnectionJDK5
	at oracle.sql.CLOB.createTemporary(CLOB.java:754)
	at oracle.sql.CLOB.createTemporary(CLOB.java:716)
	at com.vitechinc.core.model.ClobType.nullSafeSet(ClobType.java:77)
	at net.sf.hibernate.type.CustomType.nullSafeSet(CustomType.java:118)
	at net.sf.hibernate.persister.EntityPersister.dehydrate(EntityPersister.java:393)
	at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:466)
	at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:439)
	at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)
	at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2418)
	at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371)
	at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)
	at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
	at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:507)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:662)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:632)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:314)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:117)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	at $Proxy74.saveExceptionLog(Unknown Source)
	at com.vitechinc.v3.core.view.V3Engine.activateExceptionPage(V3Engine.java:161)
	at org.apache.tapestry.engine.AbstractEngine.service(AbstractEngine.java:914)
	at org.apache.tapestry.ApplicationServlet.doService(ApplicationServlet.java:197)
	at org.apache.tapestry.ApplicationServlet.doPost(ApplicationServlet.java:326)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.vitechinc.core.locale.ExtractLocaleFilter.doFilterInternal(ExtractLocaleFilter.java:43)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:170)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
	at java.lang.Thread.run(Thread.java:595)
2009-04-14 09:54:38,437 INFO  [STDOUT] 09:54:38,437 ERROR V3Engine:126 - org.apache.tapestry.ApplicationRuntimeException
org.jboss.resource.adapter.jdbc.jdk5.WrappedConnectionJDK5
	component:com.vitechinc.v3.dashboard.Home at 48089e[dashboard:Home]
	location:classpath:/com/vitechinc/v3/dashboard/Home.page, line 7, column 61
java.lang.ClassCastException
org.jboss.resource.adapter.jdbc.jdk5.WrappedConnectionJDK5
	* oracle.sql.BLOB.createTemporary(BLOB.java:587)
	* com.vitechinc.core.model.BlobType.nullSafeSet(BlobType.java:94)
	* net.sf.hibernate.type.CustomType.nullSafeSet(CustomType.java:118)
	* net.sf.hibernate.persister.EntityPersister.dehydrate(EntityPersister.java:393)
	* net.sf.hibernate.persister.EntityPersister.update(EntityPersister.java:663)
	* net.sf.hibernate.persister.EntityPersister.update(EntityPersister.java:642)
	* net.sf.hibernate.impl.ScheduledUpdate.execute(ScheduledUpdate.java:52)
	* net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2418)
	* net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2372)
	* net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)


View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4225426#4225426

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4225426