GrassField

I dint write for two weeks. I could not sit in these weekends. so, there are much more error messages left behind my desk. here is the situation. I am doing multiple reads from database. I am opening a connection, creating a statement, and executing a query to get resultset. it was working fine, but when loop goes beyond 100, I got the following error.

java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
152.200.100.5:1521:PANDIAN

I think, the problem is with connection leak. connection or resultset somethign is not closed properly. I removed the connection opening part and replaced with connection pool. Now it is working fine!

Hey guys,

Here is another bug, on the last day of the first month of 2008! jConsole, an interesting performance monitoring tool from java. I was looking at it, got interested, decided to test my own typical Addition! we have to pass the PID of the process to jConsole. the syntax is like this

jConsole.exe <pid>

When I issued the command jConsole 810, he said ‘810 is not a managed VM‘. Later I understood that jConsole uses -Dcom.sun.management.jmxremote flag being set while running java.

So when I run the addition program i have added that flag

java -Dcom.sun.management.jmxremote Addition

jConsole beautifully started and rocking like a cheetah!. I need to write a brief on jConsole. let me see whether I can do it by this weekend.

This month I am logging only the errors I am setting up a backup of a working application, where I came across the previous errors. Here is another one.

java.lang.UnsatisfiedLinkError: no ojdbc14 in java.library.path

Let me tell you the environment,

I have the application, whose lib folder contains class12.jar and ojdbc14.jar. Both the jars are in classpath, then I replaced this ojdbc14.jar of the application with the ojdbc14.jar from the local oracle installation folder. That doesnt solve the issue, later i need to replace classes12.jar also. That application lib folder files are working fine for Oracle 9i. but not for 10g. So, this is basically a version incompatibility.

One of my computer has been affected by this virus. it starts couple of services, and keep on vanishing the important windows like command prompt, service properties, regedit etc. however you go to disable those scripts, he will make that window to disappear. very bad. almost he had taken almost 6 hours today to solve it. Thanks to yahoo answers!

Here is the post

http://ph.answers.yahoo.com/question/index?qid=20071119014159AAZ4GLA

and here is the solution

Remover for AVI Funny UST Scandal.exe

This is another real-time mistake I faced today. I was parsing a log file and uploading into DB. One of the dates in the log file doesnt follow the date format. So I got this error. I cant give that code in this post, I am giving an example below.

SQL> select to_date('20051101 00:00:01', 'YYYYMMDD') from dual ;
select to_date('20051101 00:00:01', 'YYYYMMDD') from dual
*
ERROR at line 1:
ORA-01830: date format picture ends before converting entire input string

I hope you have noticed the error. The query should be like this.

SQL> select to_date('20051101 00:00:01', 'YYYYMMDD hh24:mi:ss') from dual ;

TO_DATE('
---------
01-NOV-05

You can have a detailed view on the Oracle date formats here
http://www.ss64.com/orasyntax/fmt.html