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/2648333) http://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]
_______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
