| Solution to a problem [message #92632] |
Fri, 29 October 2004 01:54 |
Venkateswarlu S
Messages: 1
Registered: October 2004
|
Junior Member |
|
|
Hi,
I want to call a java program whenever data is inserted into a databse table. How can acheive this.
Now I have wrote a program such that, it is running infinitly in a loop in that I am opening a coonection and closing it. It is infinite loop and opening lot of connectiones in single second, so it is giving following exceptions.
DataBaseConnections::getConnection--[>]Error: Io exception: The Network Adapter could not establish the connection
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3695)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:352)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:362)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:536)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:328)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at DataBaseConnections.getConnection(DataBaseConnections.java:52)
at SMSSender.run(SMSSender.java:85)
at java.lang.Thread.run(Thread.java:534)
Please give me a solution.
Thanks & Regards,
Venkat
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
