This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes  TNS:no appropriate service handler found Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark " TNS:no appropriate service handler found" Watch " TNS:no appropriate service handler found" New topic

TNS:no appropriate service handler found

Ankita Jha
Ranch Hand

Joined: Sep 15, 2008
Posts: 55
hello Ranchers,


Listener refused the connection with the following error:ORA-12519, TNS:no appropriate service handler foundThe Connection descriptor used by the client was:


I get this error when i try to insert 63 records simultaneously.
After inserting 15 records it throws the above exception.While inserting record it is using BasicDataSource connection factory.

My Question is :Whether BasicDataSource creates a new connection for each insert or it uses the same connection.

In hibernate we have SingleConnectionDataSource which uses the same connection for inserting all 63 record.

I wanted to know whether same kind of factory is available in dbcp.
Please let me know.It's urgent.

Thnks in advance
Amit Ghorpade

Joined: Jun 06, 2007
Posts: 2801

Hi Ankita Jha Welcome to Javaranch ,
Please choose an appropriate forum for your posts, that will result in more useful responses.

This looks like a Oracle question and we have a forum dedicated to it.

|Asking Good Questions|
Paul Campbell
Ranch Hand

Joined: Oct 06, 2007
Posts: 338
Are you sure a record is ever actually inserted... that error message means you do not have a listner associated with your datasource... which implies you do not have a valid connection.

ORA-12519: TNS:no appropriate service handler found

Cause: The listener could not find any available service handlers that are appropriate for the client connection.

Action: Run "lsnrctl services" to ensure that the instance(s) have registered with the listener, and are accepting connections.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: TNS:no appropriate service handler found
It's not a secret anymore!