bug

Oracle Invalid number ORA-01722

February 21, 2019 / English Content, Knowledgebase, Structured Query Language (SQL) / , , , ,
I stumbled upon a very brain-f**k error on Oracle 10g on these days. Context: the following query [sql]SELECT * FROM ( SELECT TO_NUMBER(CUSTOMER_ID) AS SNDG FROM BAD_CODES_TABLE WHERE AND I_LIKE=UPPER(‘STATIC_CONDITION’) AND CUSTOMER_ID NOT LIKE ‘%P%’ ) S WHERE TO_NUMBER(S.SNDG) >2000[/sql] could trigger a Invalid number if CUSTOMER_ID column contains invalid numbers. Why? Well…if you ask …

Oracle Invalid number ORA-01722 Read More »

Java HttpClient and Load Balancer bad interactions

May 21, 2009 / English Content, Knowledgebase, Software / , , , , , , , ,
Working for a very big customer, I found a very nasty interaction between Sun HttpClient (JDK 1.4) and Http  Load Balancers. In a complex network environment, sometimes you can experience low level TCP/IP comunication errors, because sometimes HttpClient get confused and hangs. The bad behavior of Sun HttpClient is well known: some guys suggested me …

Java HttpClient and Load Balancer bad interactions Read More »

Brasil4Win 1.1 and Jython 2.5a3: testing in progress

September 17, 2008 / English Content / , , , , , ,
Because of the forthcoming release of Jython 2.5 (after an year of silence), we at Gioorgi.com are checking Brasil compatibility, right now.  What is Jython?… we read from the Jython website: Jython is an implementation of the high-level, dynamic, object-oriented language Python written in 100% Pure Java, and seamlessly integrated with the Java platform. It …

Brasil4Win 1.1 and Jython 2.5a3: testing in progress Read More »