ansaurus

Question

Weblogic 10.3 MDB throwing javax.sql.DataSource exception

Answer 1

A:

Your configuration is faulty. Here's the message that tells you so:

Caused by: com.bea.core.repackaged.springframework.beans.factory.NoSuchBeanDefin
itionException: No unique bean of type [javax.sql.DataSource] is defined: No bea
ns of type javax.sql.DataSource

You either don't have a DataSource or it's not configured properly.

duffymo 2010-07-01 01:01:51

The datasource was created via the Weblogic Admin Console and was successfully able to connect to the database. I've added some more information to my problem including a code snippet. Please let me know if there anything else you'd required. Thanks for your help.

Naqeeb 2010-07-01 03:49:10

Then it's not injected properly would be my guess.

duffymo 2010-07-01 09:24:59

Answer 2

A:

From the posted trace, it seems the MDB can't write to the database because the DataSource fails at being injected:

No unique bean of type [javax.sql.DataSource] is defined

There is a collision somewhere. I think you need to tell us more for a more precise answer.

Update: I wonder if using the same name for the @Resource and the DataSource property (database in this case) is not causing the problem.

So, instead of:

// Datasource declaration
@Resource(name = "database", mappedName = "datasource/oracle-11g")
private DataSource database;

Could you try this (assuming datasource/oracle-11g is the global JNDI name):

// Datasource declaration
@Resource(mappedName="datasource/oracle-11g") 
private DataSource database;

ansaurus

tags:

views:

answers:

Weblogic 10.3 MDB throwing javax.sql.DataSource exception

See also:

related questions