[jboss-user] [Datasource Configuration] - Oracle datasource configuration with jboss 5.1

rukia do-not-reply at jboss.com
Thu May 24 09:47:12 EDT 2012


rukia [https://community.jboss.org/people/rukia] created the discussion

"Oracle datasource configuration with jboss 5.1"

To view the discussion, visit: https://community.jboss.org/message/737685#737685

--------------------------------------------------------------
|  %2% 
 Posts: 2 
      | 
   http://www.coderanch.com/templates/default/images/icon_minipost_new.gif  (http://www.coderanch.com/forums/posts/list/581141#2648333)posted Today 15:43:55  

  http://www.coderanch.com/templates/default/images/thumbs-up.gif  (http://www.coderanch.com/templates/default/images/thumbs-up.gif)
  http://www.coderanch.com/templates/default/images/icon_quote.gif  (http://www.coderanch.com/forums/posts/quote/0/2648333http://www.coderanch.com/templates/default/images/icon_edit.gif  (http://www.coderanch.com/forums/jforum?module=posts&action=edit&post_id=2648333&start=0)       |
|   Hello, 
 
 Actuallly i am unable to configure correctly a new oracle datasource, i spent a week trying to make it work but no way!! 
 
 I need to define a new oracle datasource, i am using Oracle 11g , Jboss 5.1 
 
 My oracle-ds.xml 
 [code=java] 
 [b]<?xml version="1.0" encoding="UTF-8"?> 
 <datasources> 
 <local-tx-datasource> 
 <jndi-name>OracleDS</jndi-name> 
 <use-java-context>false</use-java-context> 
 <!--<connection-url>jdbc:oracle:thin:@localhost:1521:iamsaas</connection-url> --> 
 <connection-url>jdbc:oracle:thin:@localhost:1521:iamsaas</connection-url> 
 <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> 
 <user-name>ADMIAMSAAS</user-name> 
 <password>iamsaas</password> 
 
 <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> 
 <min-pool-size>5</min-pool-size> 
 <max-pool-size>200</max-pool-size> 
 <idle-timeout-minutes>5</idle-timeout-minutes> 
 <blocking-timeout-millis>10000</blocking-timeout-millis> 
 
 <metadata> <type-mapping>Oracle9i</type-mapping> </metadata> 
 
 
 </local-tx-datasource> 
 </datasources>[/b][color=red] [/color] 
 [/code] 
 
 My persistence.xml 
 [code=java] 
 <persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
 xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" version="1.0"> 
 
   <persistence-unit name="IAMPersistance" transaction-type="JTA"> 
     <jta-data-source>java:/OracleDS</jta-data-source> 
 
         <properties> 
          <property name="hibernate.hbm2ddl.auto" value="update"/> 
         </properties> 
 
  </persistence-unit> 
 </persistence>  [color=red] [/color] 
 [/code] 
 
 when i deploy my ejb project on jboss i get these errors, 
 
 [b]2012-05-24 15:37:07,908 INFO [org.jboss.jpa.deployment.PersistenceUnitDeployment] (main) Starting persistence unit persistence.unit:unitName=#IAMPersistance 
 2012-05-24 15:37:07,908 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Start: name=persistence.unit:unitName=#IAMPersistance state=Create 
 javax.naming.NameNotFoundException: OracleDS not bound[/b][color=red] [/color] 
 
 
 [b]DEPLOYMENTS MISSING DEPENDENCIES: 
   Deployment "jboss.j2ee:jar=IAMPersistence2.jar,name=RequestBean,service=EJB3" is missing the following dependencies: 
     Dependency "<UNKNOWN jboss.j2ee:jar=IAMPersistence2.jar,name=RequestBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'persistence.unit:unitName=#IAMPersistance' **") 
   Deployment "jboss.j2ee:jar=IAMPersistence2.jar,name=RequestBean,service=EJB3_endpoint" is missing the following dependencies: 
     Dependency "jboss.j2ee:jar=IAMPersistence2.jar,name=RequestBean,service=EJB3" (should be in state "Configured", but is actually in state "PreInstall") 
 
 DEPLOYMENTS IN ERROR: 
   Deployment "<UNKNOWN jboss.j2ee:jar=IAMPersistence2.jar,name=RequestBean,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'persistence.unit:unitName=#IAMPersistance' ** 
   Deployment "persistence.unit:unitName=#IAMPersistance" is in error due to the following reason(s): javax.naming.NameNotFoundException: OracleDS not bound[/b][color=red] [/color] 
 
 
 but in the JMX console i can see my beans! 
 
 Please can anyone help me, i really need it :s ???
  |
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/737685#737685]

Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120524/032c7b69/attachment-0001.html 


More information about the jboss-user mailing list