-
Hi,
JoSQL just uses the standard Java mechanisms for comparing objects (i.e. the Comparable interface) so it may be better to wrap the values that will contain the nulls in a custom function that will return a value (instead of null) that will force it to sort at the "top". It doesn't seem that the behavior for handling nulls is defined in the Comparable interface so a custom function is...
2009-10-29 23:38:38 UTC in JoSQL (SQL for Java Objects)
-
The JDomSerializer doesn't take namespaces into account (regardless of whether you have the setNamespacesAware flag set in the properties).
This leads to a:
"org.jdom.IllegalNameException: The name "x:attr" is not legal for JDOM/XML attributes: Attribute names cannot contain colons."
being thrown by JDOM.
For example:
2009-07-29 01:45:14 UTC in HtmlCleaner
-
Done. I had forgotten all about it. The source jar contains all the classes that polliwog actually uses.
2009-05-18 13:11:27 UTC in polliwog - Java Web Log Analyzer
-
barrygently added the gentlyWEB-src-1.1.tar.gz file.
2009-05-18 13:07:46 UTC in polliwog - Java Web Log Analyzer
-
Thanks for reporting this Steve.
This is fixed in version 2.2.
It is caused by the % not being greedy when it does the match.
To fix this in a source version of JoSQL (until the new version is released):
Add method:
public static int getLastMatch (String value,
String search,
int start)
{.
2009-05-06 11:53:36 UTC in JoSQL (SQL for Java Objects)
-
Hi Pranesh,
The important thing to remember with JoSQL is that it does not have the concept of aggregation, this is useful in some contexts and not in others. The main issue to take into account is performance, with that in mind I'd write the query as:
SELECT dept, @count
FROM employee
GROUP BY dept
EXECUTE ON GROUP_BY_RESULTS count(:_currobj) count
The execute on clause prevents...
2009-04-13 23:42:35 UTC in JoSQL (SQL for Java Objects)
-
Hi,
Thanks for reporting this.
This is due to the way that inner selects work. Because they cannot be inited until execution time the anonymous bind variable has not been allocated an internal name, so in effect (for the 2nd query) "johnnyTester" becomes bind variable 1 and then "key" becomes 2 and "val" becomes 3. For the first query it just so happens that the bind variables will be in...
2009-03-31 00:19:11 UTC in JoSQL (SQL for Java Objects)
-
Hi,
This isn't something I'm going to do myself, to be honest I no vested interest in making it happen. If there is someone who wants to do the work to put the pieces in place to make it happen I'll happily work with them but I won't be publishing stuff to Maven myself. That is for someone else to do.
Gary.
2009-03-16 12:13:39 UTC in JoSQL (SQL for Java Objects)
-
Hi Sandeep,
This problem is actually caused by the JoSQL parser, there is a bug in the 2.0 version. I've just released (finally, god I hate the new SourceForge release mechanism, pain in the arse it is) version 2.1 which fixes this issue.
Basically if you have 2 strings in the WHERE clause then the parser was taking everything between the 2 outermost ' as a single string (if you notice...
2009-02-28 03:10:29 UTC in JoSQL (SQL for Java Objects)
-
barrygently added the JoSQL-bin-stable-2.1.tar.gz file.
2009-02-28 03:04:22 UTC in JoSQL (SQL for Java Objects)