[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: ClassCastException when calling DatabaseMetadatat functi

[tonioinho]

The related datasource file :


  | <?xml version="1.0" encoding="UTF-8"?>
  | 
  | <datasources>
  | 
  |   <local-tx-datasource>
  | 
  |     <!-- Setting this to false will bind the DataSource into global jndi -->
  |     <use-java-context>false</use-java-context>
  | 
  |     <jndi-name>Test/DataSource/Data</jndi-name>
  | 
  |     <connection-url>jdbc:oracle:thin:@localhost:1521:XE</connection-url>
  |     <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
  |     <user-name>username</user-name>
  |     <password>password</password>
  |     <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
  |     <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>
  |     <min-pool-size>2</min-pool-size>
  |     <max-pool-size>20</max-pool-size>
  |     <blocking-timeout-millis>5000</blocking-timeout-millis>
  |     <idle-timeout-minutes>10</idle-timeout-minutes>
  |     <prefill>true</prefill>
  |     <metadata>
  |          <type-mapping>Oracle9i</type-mapping>
  |     </metadata>
  |         
  |   </local-tx-datasource>
  | 
  | </datasources>
  | 

Also the ojdbc14.jar file is in the server/default/lib folder

The code works fine using Mysql or SQL Server datasources.

I found a similar post ( http://www.jboss.com/index.html?module=bb&op=viewtopic&t=87423  ) but it is not answered.

thanks in advance 





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

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