Win a copy of Modern frontends with htmx this week in the Spring forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Hibernate connection problem with struts2

 
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
My CRUD application in struts2 with Hibernate3 is working fine, but when I tried to update, delete or view option with very little interval in that case I got following error and Hibernate could not establish connection with database.


Please give me some guide how to get rid off this error.
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator


ORA-12519, TNS:no appropriate service handler found


Does the service name you are specifying exist? Can it accept connections?
 
Sweta Chauhan
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Paul Sturrock wrote:


ORA-12519, TNS:no appropriate service handler found


Does the service name you are specifying exist? Can it accept connections?



Yes it accepts the connection, I am able to update, add and even delete the records from table.
 
Bartender
Posts: 2661
19
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
From the connection string in the error, it seems that you are using Oracle Express.

There is a known workaround for this problem:
http://en.newinstance.it/2007/06/01/ora-12519-tnsno-appropriate-service-handler-found/
 
Sweta Chauhan
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Jan Cumps wrote:From the connection string in the error, it seems that you are using Oracle Express.

There is a known workaround for this problem:
http://en.newinstance.it/2007/06/01/ora-12519-tnsno-appropriate-service-handler-found/



Yes you are right I am using Oracle Express. I didn't got the idea of how to trouble shoot the problem could you give me some idea.
 
Paul Sturrock
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The last paragraph of that link explains the steps.
 
Sweta Chauhan
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Paul Sturrock wrote:The last paragraph of that link explains the steps.



Means I will have to restart my application?
 
Jan Cumps
Bartender
Posts: 2661
19
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
No. It says: execute an sql command, and restart the [tns] listener. The listener is part of Oracle's software.

Instructions for restarting the listener:
http://download.oracle.com/docs/cd/B25329_01/doc/admin.102/b25107/network.htm#CIHHJEDF
 
Sweta Chauhan
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Jan Cumps wrote:No. It says: execute an sql command, and restart the [tns] listener. The listener is part of Oracle's software.

Instructions for restarting the listener:
http://download.oracle.com/docs/cd/B25329_01/doc/admin.102/b25107/network.htm#CIHHJEDF



Thanks, but if I optimize my coding for database connection then I don't need to restart the listener. As it is mentioned in the url which you have suggested that it is because of
 
Jan Cumps
Bartender
Posts: 2661
19
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You don't need to restart the listener after each sql.

You have to execute the sql statement “ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE;” once.
Then restart the listener once

Fixed.
reply
    Bookmark Topic Watch Topic
  • New Topic