This week's book giveaway is in the Design forum.
We're giving away four copies of Building Microservices and have Sam Newman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Building Microservices this week in the Design forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Exception" Watch "Exception" New topic
Author

Exception

raj joe
Ranch Hand

Joined: Mar 17, 2005
Posts: 99
Hi

I get the below SQL Exceeptions.I am using Wehsphere embedded SQL Driver.

1. "no more data available to read"

2.com.abcea.framework.dao.ConnectionException: java.sql.SQLException: [IBM][SQLServer JDBC Driver][IBM][SQLServer JDBC Driver]The requested instance is either invalid or not running.

Can anyone give me fix
thanks
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336


The requested instance is either invalid or not running

First think I'd check is whether your SQL server instance is running...


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

I'd also check the DRiver and database versions, sometimes you can have problems if they're not the same.

Please try to be more descriptive in your thread topics.
raj joe
Ranch Hand

Joined: Mar 17, 2005
Posts: 99
Originally posted by David O'Meara:
[QB]I'd also check the DRiver and database versions, sometimes you can have problems if they're not the same.

yes David ,

I am using WAS as my App server and Websphere IBM embedded SQL Server
JDBC driver.

I have a DAO which calls the SP's running on the microsoft SQL server 2000.
When my application is accessed my multiple users the comes the problems
Below listed are most frequent.(All these just occur randamly can't reproduce always)

1.No more data available to read"
2.SP_sqlexecute:1 blocked"(I get this to see in my SQL analyser when ever i get JDBC SQLException lke "resources blocked" etc.Which just hangs my application
3.java.sql.SQLException: [IBM][SQLServer JDBC Driver][IBM][SQLServer JDBC Driver]The requested instance is either invalid or not running.
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: Exception
 
It's not a secret anymore!