File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes BEA/Weblogic and the fly likes Weblogic Data source Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "Weblogic Data source" Watch "Weblogic Data source" New topic
Author

Weblogic Data source

Meet Gaurav
Ranch Hand

Joined: Oct 08, 2008
Posts: 492
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.



>
Deepak Bala
Bartender

Joined: Feb 24, 2006
Posts: 6661
    
    5

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 ?


SCJP 6 articles - SCJP 5/6 mock exams - More SCJP Mocks
Meet Gaurav
Ranch Hand

Joined: Oct 08, 2008
Posts: 492
I tried with lot of different table names but am getting same error. Even db look up is also failed.
Deepak Bala
Bartender

Joined: Feb 24, 2006
Posts: 6661
    
    5

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
 
Consider Paul's rocket mass heater.
 
subject: Weblogic Data source
 
Similar Threads
Switching to an XA JDBC driver explodes the console output
Deploying WAR file Weblogic 8.1
Error establising socket for Weblogic81 to Oracle9i
why XAException on local transactions?
Oracle 10g driver throws java.sql.SQLException: OALL8 is in an inconsistent state Web