If you get this error: pls check the alerts.log file.
.sql.SQLException: Got minus one from a read call
commisionTxnIdnull, levelOneApprovedQuantity=null,
levelTwoApprovedQuantity=null, levelThreeApprovedQuantity=null, pybleAmt=0.0,
_ntpybleAmt=0.0, _pyinsAmt=0.0, _refTransferIDnull
2013-10-21 10:28:40,075 : 2329 [main] DEBUG
com.btsl.db.pool.OJDBCPoolManager -
createPool :: Creating oracle connection pool
2013-10-21 10:28:40,076 : 2330 [main] DEBUG
com.btsl.db.pool.OJDBCPoolManager -
createPool 10G :: userid=neeraj1, db password=neeraj1,
db_url=jdbc:oracle:thin:@172.23.23.47:1522:orcl, minPoolSize=100 max
poolSize=150 oraclePoolLogFile=null
java.sql.SQLException:
Got minus one from a read call
at
oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at
oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:525)
at
oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
at
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
at
oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
at
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at
oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:275)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:206)
at
oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:139)
at
oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:88)
at
oracle.jdbc.pool.OracleImplicitConnectionCache.makeCacheConnection(OracleImplicitConnectionCache.java:1567)
at
oracle.jdbc.pool.OracleImplicitConnectionCache.makeOneConnection(OracleImplicitConnectionCache.java:499)
at
oracle.jdbc.pool.OracleImplicitConnectionCache.defaultUserPrePopulateCache(OracleImplicitConnectionCache.java:218)
at
oracle.jdbc.pool.OracleImplicitConnectionCache.<init>(OracleImplicitConnectionCache.java:194)
at
oracle.jdbc.pool.OracleConnectionCacheManager.createCache(OracleConnectionCacheManager.java:269)
at
com.btsl.db.pool.OJDBCPoolManager.createPool(OJDBCPoolManager.java:270)
at
com.btsl.db.pool.OJDBCPoolManager.getConnection(OJDBCPoolManager.java:67)
at
com.btsl.util.OracleUtil.getConnection(OracleUtil.java:113)
at
com.btsl.common.IDGenerator.getNextID(IDGenerator.java:81)
at
com.btsl.pretups.channel.transfer.businesslogic.ChannelTransferBL.genrateTransferID(ChannelTransferBL.java:129)
at
com.btsl.pretups.processes.ActivationBonusRedemption.process(ActivationBonusRedemption.java:291)
at
com.btsl.pretups.processes.ActivationBonusRedemption.main(ActivationBonusRedemption.java:119)
Caused by: oracle.net.ns.NetException: Got minus one from a
read call
at
oracle.net.ns.Packet.receive(Packet.java:243)
at
oracle.net.ns.NSProtocol.connect(NSProtocol.java:259)
at
oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966)
at
oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)
... 20 more
com.btsl.common.BaseException
at
com.btsl.db.pool.OJDBCPoolManager.getConnection(OJDBCPoolManager.java:68)
at
com.btsl.util.OracleUtil.getConnection(OracleUtil.java:113)
at
com.btsl.common.IDGenerator.getNextID(IDGenerator.java:81)
at
com.btsl.pretups.channel.transfer.businesslogic.ChannelTransferBL.genrateTransferID(ChannelTransferBL.java:129)
at
com.btsl.pretups.processes.ActivationBonusRedemption.process(ActivationBonusRedemption.java:291)
at
com.btsl.pretups.processes.ActivationBonusRedemption.main(ActivationBonusRedemption.java:119)
2013-10-21 10:28:42,649 : 4903 [main] ERROR
com.btsl.pretups.channel.transfer.businesslogic.ChannelTransferBL - genrateTransferID :: Exception 00000
class=null,method=null,message=00000,date=nullerrorCode=0
at
com.btsl.db.pool.OJDBCPoolManager.getConnection(OJDBCPoolManager.java:143)
at
com.btsl.util.OracleUtil.getConnection(OracleUtil.java:113)
at
com.btsl.common.IDGenerator.getNextID(IDGenerator.java:81)
at
com.btsl.pretups.channel.transfer.businesslogic.ChannelTransferBL.genrateTransferID(ChannelTransferBL.java:129)
at
com.btsl.pretups.processes.ActivationBonusRedemption.process(ActivationBonusRedemption.java:291)
at
com.btsl.pretups.processes.ActivationBonusRedemption.main(ActivationBonusRedemption.java:119)
2013-10-21 10:28:42,650 : 4904 [main] DEBUG
com.btsl.pretups.channel.transfer.businesslogic.ChannelTransferBL - genrateTransferID :: Exited ID =null
class=ChannelTransferBL,method=genrateTransferID,message=9007,date=2013-10-21errorCode=0
at
com.btsl.pretups.channel.transfer.businesslogic.ChannelTransferBL.genrateTransferID(ChannelTransferBL.java:139)
at
com.btsl.pretups.processes.ActivationBonusRedemption.process(ActivationBonusRedemption.java:291)
at
com.btsl.pretups.processes.ActivationBonusRedemption.main(ActivationBonusRedemption.java:119)
class=ChannelTransferBL,method=genrateTransferID,message=9007,date=2013-10-21errorCode=0
at
com.btsl.pretups.channel.transfer.businesslogic.ChannelTransferBL.genrateTransferID(ChannelTransferBL.java:139)
at
com.btsl.pretups.processes.ActivationBonusRedemption.process(ActivationBonusRedemption.java:291)
at
com.btsl.pretups.processes.ActivationBonusRedemption.main(ActivationBonusRedemption.java:119)
-----------------------After checking the alerts.log file you will get this error the do the following--
Mon Oct 21 10:20:26 2013
ORA-00020: maximum number of processes (200) exceeded
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
-- need to increase the processes by running this command ---
alter system set processes=500 scope=spfile;
shutdown immediate
startup
Enjoy this....:-)
