I tried to config an oracle datasource, but i get the following error message.
What could be the problem?
org.jboss.deployment.DeploymentException: Error in jbosscmp-jdbc.xml :
datasource-mapping Oracle9i not found
at
org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCEntityMetaData.(JDBCEntityMetaData.java:487)
...
These are my config files:
standardjbosscmp-jdbc.xml
<jbosscmp-jdbc>
| <defaults>
| <datasource>java:/OracleDS</datasource>
| <datasource-mapping>Oracle9i</datasource-mapping>
| </defaults>
| </jbosscmp-jdbc>
standardjaws.xml
<jaws>
| <datasource>java:/OracleDS</datasource>
| <type-mapping>Oracle9i</type-mapping>
| </jaws>
oracle-ds.xml
<datasources>
| <local-tx-datasource>
| <jndi-name>OracleDS</jndi-name>
| <connection-url>jdbc:oracle:thin:@localhost:1521:mysid</connection-url>
| <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
| <user-name>x</user-name>
| <password>y</password>
| <!-- Uses the pingDatabase method to check a connection is still valid
before handing it out from the pool -->
|
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>
| <!-- Checks the Oracle error codes and messages for fatal errors -->
|
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
| <!-- sql to call when connection is created
| <new-connection-sql>some arbitrary sql</new-connection-sql>
| -->
|
| <!-- sql to call on an existing pooled connection when it is
obtained from pool - the OracleValidConnectionChecker is prefered
| <check-valid-connection-sql>some arbitrary
sql</check-valid-connection-sql>
| -->
|
| <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml
(optional) -->
| <metadata>
| <type-mapping>Oracle9i</type-mapping>
| </metadata>
| </local-tx-datasource>
|
| </datasources>
Thanks for your help!
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3895408#3895408
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3895408
-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
