Weblogic Data source

[Meet Gaurav]

Hi

Am just creating a data source in weblogic 10 and trying to connect to Oracle using a "Bea oracle type 4Driver". While testing the connection on the using the Test Configuration button am getting "Test successful" message but in the console am getting the below error. As a result my application is unable to connect. Please assist me.

<Aug 5, 2009 6:39:15 PM IST> <Error> <JDBC> <BEA-001112> <Test "select count(*)  from SELECT 1 FROM DUAL" set up for pool "DS_NAME" failed with exception: "java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-00903: invalid table name 

>

[Deepak Bala]

Change the table name to something that exists in the DB. Select count(*) from table_name on a small table like a lookup table will help.

The test connections can sometimes fail because of driver related problems. They may also fail even if the connection is valid but the table name specified is incorrect.

Are you able to lookup the JDBC connection ?

[Meet Gaurav]

I tried with lot of different table names but am getting same error. Even db look up is also failed.

[Deepak Bala]

Meet Gaurav wrote:I tried with lot of different table names but am getting same error. Even db look up is also failed.

If DB lookup fails there is something wrong with your configuration.

Check again under the JNDI tree if this name is bound. If it is not redeploy the data source and observe the exception thrown. Check if the data source is up and running and if you are able to connect from a SQL editor