CMP deployment problem
demian Jun 26, 2002 4:47 AMHi all,
I try redeploy my application .jar from WLS to JBoss 3.0, and have problem.
1. create DataSource for Oracle8i, I get example from CVS and setting to my DB (oracledb-service.xml):
2002-06-26 08:40:35,734 DEBUG [org.jboss.system.ServiceConfigurator] ManagedConnectionFactoryProperties set to
<config-property name="ConnectionURL" type="java.lang.String">jdbc:oracle:thin:@s2_abb:1521:vyvoj</config-property>
<config-property name="DriverClass" type="java.lang.String">oracle.jdbc.driver.OracleDriver</config-property>
<!--set these only if you want only default logins, not through JAAS -->
<config-property name="UserName" type="java.lang.String"/>
<config-property name="Password" type="java.lang.String"/>
in jboss.jca:service=LocalTxDS,name=OracleDS
......
2002-06-26 08:40:35,859 INFO [org.jboss.deployment.MainDeployer] Successfully completed deployment of package: file:/D:/JBoss/server/default/deploy/oracledb-service.xml
2. edit jboss.xml and jbosscmp-jdbc.xml
<ejb-name>Pouzivatel</ejb-name>
java:/OracleDS
<table-name>ajf_pouzivatel</table-name>
...
3. When try deploy this bean get error:
2002-06-26 08:40:47,703 INFO [org.jboss.ejb.EjbModule] Deploying Pouzivatel
..
2002-06-26 08:40:54,546 ERROR [org.jboss.ejb.EjbModule] Initialization failed
org.jboss.deployment.DeploymentException: Error while fixing table name; - nested throwable: (java.sql.SQLException: ResourceException javax.resource.ResourceException: Could not create connection)
at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.fixTableName(SQLUtil.java:67)
at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.(JDBCEntityBridge.java:103)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.create(JDBCStoreManager.java:333)
at org.jboss.ejb.plugins.CMPPersistenceManager.create(CMPPersistenceManager.java:155)
at org.jboss.ejb.EntityContainer.create(EntityContainer.java:337)
at org.jboss.ejb.Container.invoke(Container.java:789)
Error say I can't create DB connection to Oracle DB, I trying change some settings, but still unsucesfull.
Some ideas?
(DB is live, and connections from WLS are sucesfull)
Miro