amit prajapati

Greenhorn
+ Follow
since Oct 18, 2011
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by amit prajapati


Hi,

My input file has data in below format

9090909090,3567,1
9876090000,4098,0
98,1

I want to delete third where first field is not 10 digits in length. How can i do this

Regards,
Amit P

10 years ago

Hi,

I Am getting below Exception. Application stops working after 5-6 days. How to avoid this kind of Exception.

java.sql.SQLException: Failed to find Statement: 1832597169
at org.jboss.resource.adapter.jdbc.remote.WrapperDataSourceService.invoke(WrapperDataSourceService.java:221)
at sun.reflect.GeneratedMethodAccessor198.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.invocation.jrmp.server.JRMPInvoker$MBeanServerAction.invoke(JRMPInvoker.java:818)
at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:419)
at sun.reflect.GeneratedMethodAccessor197.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294)
at sun.rmi.transport.Transport$1.run(Transport.java:153)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:149)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:466)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:707)
at java.lang.Thread.run(Thread.java:595)
at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:247)
at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:223)
at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:126)
at org.jboss.invocation.jrmp.server.JRMPInvoker_Stub.invoke(Unknown Source)
at org.jboss.invocation.jrmp.interfaces.JRMPInvokerProxy.invoke(JRMPInvokerProxy.java:133)
at org.jboss.invocation.InvokerInterceptor.invokeInvoker(InvokerInterceptor.java:365)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:197)
at org.jboss.proxy.ClientMethodInterceptor.invoke(ClientMethodInterceptor.java:74)
at org.jboss.resource.adapter.jdbc.remote.StatementInterceptor.invoke(StatementInterceptor.java:58)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
at $Proxy2.close(Unknown Source)
at com.hp.mnp.lnpdb.dao.LNPDBAdapterAuditTableDAO.insertAuditTNInfo(LNPDBAdapterAuditTableDAO.java:98)
at com.hp.mnp.lnpdb.connection.LNPDBHuaweiSG7000.handleUpdateAuditInfo(LNPDBHuaweiSG7000.java:1003)
at com.hp.mnp.lnpdb.connection.LNPDBHuaweiSG7000.handleLNPDBCommands(LNPDBHuaweiSG7000.java:306)
at com.hp.mnp.lnpdb.connection.LNPDBHuaweiSG7000.init(LNPDBHuaweiSG7000.java:209)
at com.hp.mnp.lnpdb.startup.ProvisioningDaemon$1.run(ProvisioningDaemon.java:448)
at com.hp.mnp.lnpdb.threadpool.ThreadPoolWorker.runIt(ThreadPoolWorker.java:132)
at com.hp.mnp.lnpdb.threadpool.ThreadPoolWorker.runWork(ThreadPoolWorker.java:112)
at com.hp.mnp.lnpdb.threadpool.ThreadPoolWorker.access$000(ThreadPoolWorker.java:39)
at com.hp.mnp.lnpdb.threadpool.ThreadPoolWorker$1.run(ThreadPoolWorker.java:67)
at java.lang.Thread.run(Thread.java:595)
com.hp.mnp.lnpdb.exception.LNPDBException: Failed to find Statement: 1832597169
at com.hp.mnp.lnpdb.dao.LNPDBAdapterAuditTableDAO.insertAuditTNInfo(LNPDBAdapterAuditTableDAO.java:142)
at com.hp.mnp.lnpdb.connection.LNPDBHuaweiSG7000.handleUpdateAuditInfo(LNPDBHuaweiSG7000.java:1003)
at com.hp.mnp.lnpdb.connection.LNPDBHuaweiSG7000.handleLNPDBCommands(LNPDBHuaweiSG7000.java:306)
at com.hp.mnp.lnpdb.connection.LNPDBHuaweiSG7000.init(LNPDBHuaweiSG7000.java:209)
at com.hp.mnp.lnpdb.startup.ProvisioningDaemon$1.run(ProvisioningDaemon.java:448)
at com.hp.mnp.lnpdb.threadpool.ThreadPoolWorker.runIt(ThreadPoolWorker.java:132)
at com.hp.mnp.lnpdb.threadpool.ThreadPoolWorker.runWork(ThreadPoolWorker.java:112)
at com.hp.mnp.lnpdb.threadpool.ThreadPoolWorker.access$000(ThreadPoolWorker.java:39)
at com.hp.mnp.lnpdb.threadpool.ThreadPoolWorker$1.run(ThreadPoolWorker.java:67)
at java.lang.Thread.run(Thread.java:595)
java.lang.reflect.UndeclaredThrowableException
at $Proxy3.close(Unknown Source)
at com.hp.mnp.lnpdb.dao.LNPDBAdapterAuditTableDAO.isTxnIdExistsInAuditTable(LNPDBAdapterAuditTableDAO.java:305)
at com.hp.mnp.lnpdb.dao.LNPDBAdapterAuditTableDAO.insertAuditTNInfo(LNPDBAdapterAuditTableDAO.java:72)
at com.hp.mnp.lnpdb.connection.LNPDBHuaweiSG7000.handleUpdateAuditInfo(LNPDBHuaweiSG7000.java:1003)
at com.hp.mnp.lnpdb.connection.LNPDBHuaweiSG7000.handleLNPDBCommands(LNPDBHuaweiSG7000.java:306)
at com.hp.mnp.lnpdb.connection.LNPDBHuaweiSG7000.init(LNPDBHuaweiSG7000.java:209)
at com.hp.mnp.lnpdb.startup.ProvisioningDaemon$1.run(ProvisioningDaemon.java:448)
at com.hp.mnp.lnpdb.threadpool.ThreadPoolWorker.runIt(ThreadPoolWorker.java:132)
at com.hp.mnp.lnpdb.threadpool.ThreadPoolWorker.runWork(ThreadPoolWorker.java:112)
at com.hp.mnp.lnpdb.threadpool.ThreadPoolWorker.access$000(ThreadPoolWorker.java:39)
at com.hp.mnp.lnpdb.threadpool.ThreadPoolWorker$1.run(ThreadPoolWorker.java:67)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.IllegalAccessException: Failed to find ResultSet: 377730241
at org.jboss.resource.adapter.jdbc.remote.WrapperDataSourceService.invoke(WrapperDataSourceService.java:231)
at sun.reflect.GeneratedMethodAccessor198.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.invocation.jrmp.server.JRMPInvoker$MBeanServerAction.invoke(JRMPInvoker.java:818)
at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:419)
at sun.reflect.GeneratedMethodAccessor197.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294)
at sun.rmi.transport.Transport$1.run(Transport.java:153)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:149)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:466)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:707)
at java.lang.Thread.run(Thread.java:595)
at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:247)
at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:223)
at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:126)
at org.jboss.invocation.jrmp.server.JRMPInvoker_Stub.invoke(Unknown Source)
at org.jboss.invocation.jrmp.interfaces.JRMPInvokerProxy.invoke(JRMPInvokerProxy.java:133)
at org.jboss.invocation.InvokerInterceptor.invokeInvoker(InvokerInterceptor.java:365)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:197)
at org.jboss.proxy.ClientMethodInterceptor.invoke(ClientMethodInterceptor.java:74)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
... 12 more

Regards,
Kemeneu

Hi,

I have oracle procedure which run every one hour though cron job. But during night time when procedure is executed it do not generate proper data. I am not able to find the exact reason for this

The Procedure generate data in the below format

9938446473,20130822120458,2496,1
8233566279,20130822120525,3080,1
8233175625,20130822120527,2498,1

But in the night, i find some of rows were not generated properly in text file.

67,1


PLSQL PROC :



10 years ago

Hi,

I have tried below command to send email from unix box but i did not receive any mail . What other setting need to be configured ?


mailx -s "subject" receipent2@gmail.com < /dir/sometextfile


Regards,
Kemmannu
11 years ago

Hi,

I am facing problem in converting String to Time stamp.



How can i convert into Timestamp from String object when i Update the DB ?

Regards,
Amit P.