aspose file tools*
The moose likes JDBC 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 » Databases » JDBC
Bookmark "TNS:no appropriate service handler found" Watch "TNS:no appropriate service handler found" New topic
Author

TNS:no appropriate service handler found

Ankita Jha
Ranch Hand

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



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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: TNS:no appropriate service handler found
 
Similar Threads
JDBC connection issue with RAC database
Hibernate connection problem with struts2
Could not create connection; - nested throwable:
Hibernate problem when building SessionFactory
TNS:no appropriate service handler found