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&p...
|
| 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&...]