File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

TNS:no appropriate service handler found

 
Ankita Jha
Ranch Hand
Posts: 55
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello Ranchers,
Error

code:
--------------------------------------------------------------------------------

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

--------------------------------------------------------------------------------




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
Bartender
Posts: 2851
10
Fedora Firefox Browser Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Paul Campbell
Ranch Hand
Posts: 338
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic