I am trying to set up Weblogic 7.0 to access a MySQL database.

I am able to create a connection pool and a data source, but I receive the following error when I attempt to deply my entity bean JAR.

Unable to deploy EJB: AddressBean from ejbc_CagwEntityBeans.jar:

weblogic.ejb20.WLDeploymentException: Incorrect DataSource type detected. The DataSource with JNDI name 'CagwDataSource', specified in the RDBMS deployment descriptor for the EJB 'AddressBean', is not a TXDataSource. The EJB Container requires a TXDataSource to be specified for transactions to be managed correctly. at weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.verifyTXDataSource(RDBMSPersistenceManager.java:977)

at weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.setup(RDBMSPersistenceManager.java:134)

at weblogic.ejb20.manager.BaseEntityManager.setupPM(BaseEntityManager.java:214)

at weblogic.ejb20.manager.BaseEntityManager.setup(BaseEntityManager.java:186)

at weblogic.ejb20.manager.DBManager.setup(DBManager.java:161) at weblogic.ejb20.deployer.ClientDrivenBeanInfoImpl.activate(ClientDrivenBeanInfoImpl.java:936)

at weblogic.ejb20.deployer.EJBDeployer.activate(EJBDeployer.java:1302) at weblogic.ejb20.deployer.EJBModule.activate(EJBModule.java:342) at weblogic.j2ee.J2EEApplicationContainer.activateModule(J2EEApplicationContainer.java:1534)

at weblogic.j2ee.J2EEApplicationContainer.activate(J2EEApplicationContainer.java:991)

at weblogic.j2ee.J2EEApplicationContainer.activate(J2EEApplicationContainer.java:978)

at weblogic.management.deploy.slave.SlaveDeployer.processPrepareTask(SlaveDeployer.java:1104)

at weblogic.management.deploy.slave.SlaveDeployer.prepareUpdate(SlaveDeployer.java:724)

at weblogic.drs.internal.SlaveCallbackHandler.execute(SlaveCallbackHandler.java:24)

at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:152) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:133)

It appears that my AddressBean entity bean needs a TXDataSource? Is there a way to change the deployment descriptors to not require a TXDataSource? I'm kinda new to Weblogic and CMP as well.

I know somebody has to have this working. Can you share your configuration with me??

I'm using version 3.23.49a of MySQL, and Weblogic 7.0.

My CagwDataSource is defined as follows: <JDBCDataSource JNDIName="CagwDataSource" Name="CagwDataSource" PoolName="MySqlCagw" Targets="myserver"/>

My ConnectionPool is defined as:

<JDBCConnectionPool DriverName="org.gjt.mm.mysql.Driver" MaxCapacity="3" Name="MySqlCagw" Password="{3DES}zh9nq34OpH5SslovCt9nFw==" Properties="profileSql=true;user=ejbcmp" Targets="myserver" TestTableName="application" URL="jdbc:mysql://jalopy.ccs.com/cagw"/>

-- Paul Stath Senior Systems Programmer/Analyst Circuit City Stores, Inc.

pst...@circuitcity.com