HSQL has built-in GUI query tool called [Database manager][1]. In the directory of the database files run:

    java -cp ../lib/hsqldb.jar org.hsqldb.util.DatabaseManager 

and then setting the config to:

    jdbc:hsqldb:file:databaseName

Allowed me to edit what I needed in a really convenient way. 


  [1]: http://hsqldb.org/doc/2.0/util-guide/dbm-chapt.html

DBeaver works very nicely:

http://dbeaver.jkiss.org

Also, SQuirreL is always a safe bet for any database:

http://squirrel-sql.sourceforge.net

Meanwhile, IntelliJ has decent database tooling, too

https://www.jetbrains.com/datagrip/

I&#39;ve had good experience with SQL Workbench/J. Some of the best features compared to other tools: Auto completion for tables and columns in SQL statements, Code formatting etc.

Check out the features on the project site:

http://www.sql-workbench.net/

I have a list of strings and I have a function to generate a value for each key in the list.

I want to create a map using this function. Can I do this with Google collections?


How to transform List&lt;String&gt; to Map&lt;String,String&gt; with Google collections?

I imported external libraries using absolute path. But I have two work environments, switching between Linux and Windows. Projects are downloaded from SVN. So I was wondering whether I can import these libraries by relative path.


How to import external library by relative path in eclipse?

Whats the best browser tool for HSQLDB databases?

Best SQL browser for HSQLDB?

<p>Whats the best browser tool for HSQLDB databases?</p>


I have currently evaluating Java based security frameworks, I am a Spring 3.0 user so it seemed that SpringSecurity would be the right Choice, but Spring security seems to suffer from excessive complexity, it certainly does not seem like it is making security easier to implement, Shiro seems to be much more coherent and easier to understand. I am looking for lists of pros and cons between these two frameworks.

Shiro vs. SpringSecurity

I&#39;m getting a compile error at the following method.

    public static boolean isValidPasswd(String passwd) {
        String reg = &quot;^(?=.*[0-9])(?=.*[a-z])(?=.*[A-Z])(?=.*[~#;:?/@&amp;!\&quot;&#39;%*=&#172;.,-])(?=[^\\s]+$).{8,24}$&quot;;
        return Pattern.matches(reg, passwd);
    }

&lt;pre&gt;
at Utility.java:[76,74] unmappable character for 
enoding UTF-8. 74th character is&#39; &quot; &#39;
&lt;/pre&gt;

How can I fix this? Thanks.


&quot;Unmappable character for encoding UTF-8&quot; error

I need to generate classes from xml that doesn&#39;t provide a schema. I understand this is near useless, but the fact is we have xml, it&#39;s structured, and we should be able to create a model from the xml. In the past I&#39;ve done it by hand, but the current xml documents I am working with are quite large and my time would probably be better spent building something that does what I need. But, I am guessing it has already been done, and I just can&#39;t find it.

Any pointers?

How to generate JAXB classes from just XML

Consider the following controller method:

    @RequestMapping(value = &quot;/test&quot;, method = RequestMethod.GET)
    public void test(@RequestParam(value = &quot;fq&quot;, required = false) String[] filterQuery) {
        logger.debug(fq = &quot; + StringUtils.join(filterQuery, &quot;|&quot;));
    }

Here is the output for different `fq` combinations:

1. `/test?fq=foo` results in `fq = foo`  
2. `/test?fq=foo&amp;fq=bar` results in `fq = foo|bar`  
3. `/test?fq=foo,bar` results in `fq = foo|bar`  
4. `/test?fq=foo,bar&amp;fq=bash` results in `fq = foo,bar|bash`  
5. `/test?fq=foo,bar&amp;fq=` results in `fq = foo,bar|`

Example 3 is the problem. I expect (want/need) it to output `fq = foo,bar`.

I&#39;ve tried escaping the comma with `\` and using `%3C` but niether work. 

If I look at the `HttpServletRequest` object&#39;s version:

    String[] fqs = request.getParameterValues(&quot;fq&quot;);
    logger.debug(fqs = &quot; + StringUtils.join(fqs, &quot;|&quot;));

It prints the expected output: `fqs = foo,bar`. So the &quot;problem&quot; is with the Spring data binding.

I could by-pass Spring&#39;s binding and use `HttpServletRequest` but I really don&#39;t want to as I&#39;m using a **backing bean** in my real code (same thing is happening) and don&#39;t wish to re-implement the binding functionality. I&#39;m hoping someone can provide a simple way of preventing this behavior via escaping or some other mechanism.

TIA

**UPDATE:** I posted this Q on Twitter and got a reply saying **the expected output appears with Spring 3.0.4.RELEASE**. I&#39;ve now confirmed this is the case and thus is a temporary fix. I&#39;ll go ahead and log this as a bug on the Spring JIRA system. If anyone can provide a work around or fix with 3.0.5, I&#39;ll accept their answer.

How to prevent parameter binding from interpreting commas in Spring 3.0.5?

I&#39;m implementing MVC using JSP and JDBC. I have imported a database class file to my JSP file and I would like to show the data of a DB table. I don&#39;t know how I should return the `ResultSet` from the Java class to the JSP page and embed it in HTML.

How can I achieve this?

Show JDBC ResultSet in HTML in JSP page using MVC and DAO pattern

like when I do 

    SELECT [Date]
      FROM [FRIIB].[dbo].[ArchiveAnalog]
      GROUP BY [Date]

how can I specify the group period ?

MS SQL 2008

**2nd Edit**

I&#39;m trying 

    SELECT MIN([Date]) AS RecT, AVG(Value)
      FROM [FRIIB].[dbo].[ArchiveAnalog]
      GROUP BY (DATEPART(MINUTE, [Date]) / 10)
      ORDER BY RecT

changed %10 to / 10. is it possible to make Date output without milliseconds ?

How to group time by hour or by 10 minutes 

I was reading my trusty O&#39;Reilly book and came across a passage about how Mongo, by nature, avoids the morass of SQL injection-like flaws.

In my gut, I think I understand this. If unsanitized vars are passed into queries, they can&#39;t break out of the document-oriented query structure with a `UNION`, `JOIN`, query turned comment, etc.

How does MongoDB avoid the SQL injection mess? Is it just by nature of this query syntax?



How does MongoDB avoid the SQL injection mess?

Let&#39;s say I have the following query.

    SELECT ID, Email, ProductName, ProductModel FROM Products

How can I modify it so that it returns no duplicate Emails?

In other words, when several rows contain the same email, I want the results to include only one of those rows (preferably the last one). Duplicates in other columns should be allowed.

Clauses like `DISTINCT` and `GROUP BY` appear to work on entire rows. So I&#39;m not sure how to approach this.

DISTINCT for only one column

I have a field `COLORS (varchar(50))` in a my table `SHIRTS` that contains a comma delimited string such as `1,2,5,12,15,`. Each number representing the available colors.

When running the query `select * from shirts where colors like &#39;%1%&#39;` to get all the red shirts (color=1), I also get the shirts whose color is grey (=12) and orange (=15). 

How should I rewrite the query so that is selects ONLY the color 1 and not all colors containing the number 1?



MySQL query finding values in a comma separated string

I am interested in exporting a subset of values from a MySQL database into a JSON-formatted file on disk.

I found a link that talks about a possible way to do this: http://www.thomasfrank.se/mysql_to_json.html

... but when I use the method from that page, it seems to work but with two problems:

1) It only returns around 15 results, with the last one abruptly cut off (incomplete). My standard query for this returns around 4000 results when I just run it as `SELECT name, email FROM students WHERE enrolled IS NULL`
But when I run it as:

    SELECT 
         CONCAT(&quot;[&quot;,
              GROUP_CONCAT(
                   CONCAT(&quot;{name:&#39;&quot;,name,&quot;&#39;&quot;),
                   CONCAT(&quot;,email:&#39;&quot;,email,&quot;&#39;}&quot;)
              )
         ,&quot;]&quot;) 
    AS json FROM students WHERE enrolled IS NULL;

... as described in the link, it only returns (as I mentioned) 15 results. (fwiw, I checked these results against the 4000 I&#39;m supposed to get, and these 15 are the same as the first 15 of the 4000)

2) There seem to be &quot;escape&quot; characters included in the actual file when I add `INTO OUTFILE &#39;/path/to/jsonoutput.txt&#39; FIELDS TERMINATED BY &#39;,&#39;` to the end of that query. So commas end up looking like &#39;\\,&#39; when obviously I would just like to have the commas without the \\.

Any ideas on how to get proper JSON output from MySQL? (Either using this method, or some other method)?

Thanks!

How to export a MySQL database to JSON?

First of all, here is a list of event types that are defined by the W3C standards. (This list is based on the onevent attributes defined in the HTML5 standard. I assume that there are dozens of other event types, but this list is long enough as it is.)  

 - abort
 - afterprint
 - beforeprint
 - beforeunload
 - blur
 - canplay
 - canplaythrough
 - change
 - click
 - contextmenu
 - copy
 - cuechange
 - cut
 - dblclick
 - DOMContentLoaded
 - drag
 - dragend
 - dragenter
 - dragleave
 - dragover
 - dragstart
 - drop
 - durationchange
 - emptied
 - ended
 - error
 - focus
 - focusin
 - focusout
 - formchange
 - forminput
 - hashchange
 - input
 - invalid
 - keydown
 - keypress
 - keyup
 - load
 - loadeddata
 - loadedmetadata
 - loadstart
 - message
 - mousedown
 - mouseenter
 - mouseleave
 - mousemove
 - mouseout
 - mouseover
 - mouseup
 - mousewheel
 - offline
 - online
 - pagehide
 - pageshow
 - paste
 - pause
 - play
 - playing
 - popstate
 - progress
 - ratechange
 - readystatechange
 - redo
 - reset
 - resize
 - scroll
 - seeked
 - seeking
 - select
 - show
 - stalled
 - storage
 - submit
 - suspend
 - timeupdate
 - undo
 - unload
 - volumechange
 - waiting

Now, is it possible to define a global event handler that is called when **any** event originally occurs on **any** element on the page? (In this case, I don&#39;t want to count those events that occurred on elements because they bubbled up from a descendant element - that&#39;s why I wrote &quot;originally occurs&quot;.)

If that is not possible, is it at least possible to define an event handler that is called when **any** event bubbles up to the root of the DOM tree (which is either the `document` object or the `window` object - both should work)? (I know that it&#39;s possible to stop bubbling programmatically, but I would use this event handler on a page that has no other handlers defined on any other elements.) (Also, I believe some events don&#39;t bubble up, but let&#39;s ignore these cases for the sake of this argument.)

I know that I can do this (using jQuery): 

    $(document).bind(&#39;abort afterprint beforeprint beforeunload etc.&#39;, function() {
        // handle event
    });

but that would be a rather undesirable solution for me.

btw I don&#39;t need a cross-browser solution. If it works in just one browser, I&#39;m fine.

Also, [Firebug is able to log events](https://stackoverflow.com/questions/4089516/view-javascript-events-in-browser/4089542#4089542), but I would like to be able to catch the event programmatically (via JavaScript) rather then having them simply logged in the console.

Is it possible to programmatically catch all events on the page in the browser?

What command we have to execute (from Java, but that should not matter) on Linux (different common distributions) to open a given URL in the default browser?

Linux: command to open URL in default browser

When I myself send many requests to the server I found it amazing that in IE if I choose opera user string that the value of user string was

    User-Agent	Opera/9.80 (Windows NT 6.1; U; en) Presto/2.2.15 Version/10.00

But if I choose another browser in Internet Explorer that it puts Mozilla 5.0 in the user string first.

When I send the ajax request from Chrome that I found same thing that they put user string 

    Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) AppleWebKit/534.20 (KHTML, like Gecko) Chrome/11.0.672.2 Safari/534.20


I found that Mozilla is an organization that doesn&#39;t have anything to do with Google and Microsoft. Perhaps it was a competitor for both. Why do MSFT and Google both put Mozilla in their user agent? Is there any reason for putting Mozilla in connection string?


Why do chrome and IE both put Mozilla in the userstring when they send the request? I do not know why but is there any specific reason for that?

Why do Chrome and IE put &quot;Mozilla 5.0&quot; in the User-Agent they send to the server?

Both [WebSockets][1] and [Server-Sent Events][2] are capable of pushing data to browsers. To me they seem to be competing technologies. What is the difference between them? When would you choose one over the other?


  [1]: http://dev.w3.org/html5/websockets/
  [2]: https://html.spec.whatwg.org/multipage/server-sent-events.html#server-sent-events

WebSockets vs. Server-Sent events/EventSource

I want to do a conditional in PHP for the different versions of Internet Explorer along the lines of:

`if($browser == ie6){ //do this} elseif($browser == ie7) { //dothis } elseif...`

I have seen many variations on similar code, but looking for something super simple that is very easy to code to do some simple if and else and do different things.

Thanks

EDIT: I need this to show some different messages to users so CSS conditionals etc are no good.

PHP: If internet explorer 6, 7, 8 , or 9

Is there a way to browse the content of an H2 or an HSQLDB in-memory database for viewing? For example, during a debugging session with Hibernate in order to check when the flush is executed; or to make sure the script that instantiates the DB gives the expected result.

Does it exist an addon or a library that you can embed with your code in order to allow this?

Please, mention which one you&#39;re talking about (H2 or HSQLDB) in case you have an answer specific to one of them.

View content of H2 or HSQLDB in-memory database

I am performing some tests on a `HSQLDB` server with a table containing 500 000 entries. The table has no indices. There are 5000 distinct business keys. I need a list of them.

Naturally I started with a `DISTINCT` query:

    SELECT DISTINCT business_key
    FROM memory
    WHERE concept &lt;&gt; &#39;case&#39;   OR 
          attrib  &lt;&gt; &#39;status&#39; OR 
          value   &lt;&gt; &#39;closed&#39;;

It takes around 90 seconds!!!

Then I tried using `GROUP BY`:

    SELECT business_key
    FROM memory
    WHERE concept &lt;&gt; &#39;case&#39;   OR 
          attrib  &lt;&gt; &#39;status&#39; OR
          value   &lt;&gt; &#39;closed&#39;;
    GROUP BY business_key

And it takes 1 second!!!

Trying to figure out the difference I ran `EXLAIN PLAN FOR` but it seems to give the same information for both queries.

`EXLAIN PLAN FOR DISTINCT ...`

    isAggregated=[false]
    columns=[
      COLUMN: PUBLIC.MEMORY.BUSINESS_KEY
    ]
    [range variable 1
      join type=INNER
      table=MEMORY
      alias=M
      access=FULL SCAN
      condition = [    index=SYS_IDX_SYS_PK_10057_10058
        other condition=[
        OR arg_left=[
         OR arg_left=[
          NOT_EQUAL arg_left=[
           COLUMN: PUBLIC.MEMORY.CONCEPT] arg_right=[
           VALUE = case, TYPE = CHARACTER]] arg_right=[
          NOT_EQUAL arg_left=[
           COLUMN: PUBLIC.MEMORY.ATTRIB] arg_right=[
           VALUE = status, TYPE = CHARACTER]]] arg_right=[
         NOT_EQUAL arg_left=[
          COLUMN: PUBLIC.MEMORY.VALUE] arg_right=[
          VALUE = closed, TYPE = CHARACTER]]]
      ]
    ]]
    PARAMETERS=[]
    SUBQUERIES[]
    Object References
    PUBLIC.MEMORY
    PUBLIC.MEMORY.CONCEPT
    PUBLIC.MEMORY.ATTRIB
    PUBLIC.MEMORY.VALUE
    PUBLIC.MEMORY.BUSINESS_KEY
    Read Locks
    PUBLIC.MEMORY
    WriteLocks


`EXLAIN PLAN FOR SELECT ... GROUP BY ...`

    isDistinctSelect=[false]
    isGrouped=[true]
    isAggregated=[false]
    columns=[
      COLUMN: PUBLIC.MEMORY.BUSINESS_KEY
    ]
    [range variable 1
      join type=INNER
      table=MEMORY
      alias=M
      access=FULL SCAN
      condition = [    index=SYS_IDX_SYS_PK_10057_10058
        other condition=[
        OR arg_left=[
         OR arg_left=[
          NOT_EQUAL arg_left=[
           COLUMN: PUBLIC.MEMORY.CONCEPT] arg_right=[
           VALUE = case, TYPE = CHARACTER]] arg_right=[
          NOT_EQUAL arg_left=[
           COLUMN: PUBLIC.MEMORY.ATTRIB] arg_right=[
           VALUE = status, TYPE = CHARACTER]]] arg_right=[
         NOT_EQUAL arg_left=[
          COLUMN: PUBLIC.MEMORY.VALUE] arg_right=[
          VALUE = closed, TYPE = CHARACTER]]]
      ]
    ]]
    groupColumns=[
    COLUMN: PUBLIC.MEMORY.BUSINESS_KEY]
    PARAMETERS=[]
    SUBQUERIES[]
    Object References
    PUBLIC.MEMORY
    PUBLIC.MEMORY.CONCEPT
    PUBLIC.MEMORY.ATTRIB
    PUBLIC.MEMORY.VALUE
    PUBLIC.MEMORY.BUSINESS_KEY
    Read Locks
    PUBLIC.MEMORY
    WriteLocks

---
## EDIT
I did additional tests. With 500 000 records in `HSQLDB` with all distinct business keys, the performance of `DISTINCT` is now better - 3 seconds, vs `GROUP BY` which took around 9 seconds.

In `MySQL` both queries preform the same:

MySQL: 500 000 rows - 5 000 distinct business keys:
Both queries: 0.5 second
MySQL: 500 000 rows - all distinct business keys:
`SELECT DISTINCT ...` - 11 seconds
`SELECT ... GROUP BY business_key` - 13 seconds

So the problem is only related to `HSQLDB`.

I will be very grateful if someone can explain why there is such a drastic difference.


Huge performance difference when using GROUP BY vs DISTINCT

I&#39;m using Spring 3.1.1.RELEASE, JUnit 4.8.1 and the HSQL 2.7.7 in-memory database.  I have one test class annotated as

	@RunWith(SpringJUnit4ClassRunner.class)
	@ContextConfiguration({ &quot;classpath:test-trainingSessionServiceContext.xml&quot; })
	@DirtiesContext(classMode = ClassMode.AFTER_EACH_TEST_METHOD)
	public class TrainingSessionServiceTest  
	{

The problem is, when I run &quot;mvn clean test&quot;, it seems that all test classes run after the above class fail because the in-memory database is destroyed and not re-created.  I get errors like

	org.hibernate.exception.SQLGrammarException: user lacks privilege or object not found: CB_ORGANIZATION&quot; type=&quot;javax.persistence.PersistenceException&quot;&gt;javax.persistence.PersistenceException: 	org.hibernate.exception.SQLGrammarException: user lacks privilege or object not found: CB_ORGANIZATION
        at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1360)
        at org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:817)
        at org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:771)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:240)
        at $Proxy46.find(Unknown Source)
        at org.mainco.subco.organization.repo.OrganizationDaoImpl.findById(OrganizationDaoImpl.java:77)
        at org.mainco.subco.pd.repo.LinkDaoTest.createDummyLink(LinkDaoTest.java:686)
        at org.mainco.subco.pd.repo.LinkDaoTest.testSaveLink(LinkDaoTest.java:67)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
        at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)

Here is how I setup the test class (run after the above class) that gives the exceptions …

	@RunWith(SpringJUnit4ClassRunner.class)
	@ContextConfiguration({ &quot;classpath:test-context.xml&quot; })
	public class LinkDaoTest extends AbstractTransactionalJUnit4SpringContextTests
	{

Is there any way I can restore my application context to its original state before each test class is run?  I don&#39;t want to make the &quot;TrainingSessionServiceTest&quot; class extend AbstractTransactionalJUnit4SpringContextTests.  Here is the relevant part of my application context:

	&lt;bean id=&quot;dataSource&quot; class=&quot;org.springframework.jdbc.datasource.DriverManagerDataSource&quot;&gt;
        &lt;property name=&quot;driverClassName&quot; value=&quot;org.hsqldb.jdbcDriver&quot;/&gt;
        &lt;property name=&quot;url&quot; value=&quot;jdbc:hsqldb:mem:pd&quot; /&gt;
        &lt;property name=&quot;username&quot; value=&quot;sa&quot; /&gt;
        &lt;property name=&quot;password&quot; value=&quot;&quot; /&gt;
    &lt;/bean&gt;
    
	&lt;bean id=&quot;entityManagerFactory&quot; class=&quot;org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean&quot;&gt;
        &lt;property name=&quot;jpaVendorAdapter&quot;&gt;
            &lt;bean class=&quot;org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter&quot;/&gt;
        &lt;/property&gt;
        &lt;property name=&quot;persistenceXmlLocation&quot; value=&quot;classpath:META-INF/test-persistence.xml&quot;/&gt;
        &lt;property name=&quot;persistenceUnitName&quot; value=&quot;testingDatabase&quot;/&gt;
        &lt;property name=&quot;dataSource&quot; ref=&quot;dataSource&quot;/&gt;
    &lt;/bean&gt;

	&lt;bean id=&quot;sharedEntityManager&quot; class=&quot;org.springframework.orm.jpa.support.SharedEntityManagerBean&quot;&gt;
       &lt;property name=&quot;entityManagerFactory&quot; ref=&quot;entityManagerFactory&quot;/&gt;
    &lt;/bean&gt;

	&lt;bean id=&quot;transactionManager&quot; class=&quot;org.springframework.orm.jpa.JpaTransactionManager&quot;&gt;
        &lt;property name=&quot;entityManagerFactory&quot; ref=&quot;entityManagerFactory&quot;/&gt;
    &lt;/bean&gt;

	&lt;tx:annotation-driven /&gt;

	&lt;jdbc:embedded-database id=&quot;embedded&quot; type=&quot;HSQL&quot;/&gt; 
	&lt;jdbc:initialize-database data-source=&quot;dataSource&quot;&gt;
		&lt;jdbc:script location=&quot;classpath:db-test-data.sql&quot;/&gt;	
	&lt;/jdbc:initialize-database&gt;  

Content Type	Original Author	Original Content on Stackoverflow
Question	hawkeye	View Question on Stackoverflow
Solution 1 - Java	hawkeye	View Answer on Stackoverflow
Solution 2 - Java	Lukas Eder	View Answer on Stackoverflow
Solution 3 - Java	Martin Klinke	View Answer on Stackoverflow

Best SQL browser for HSQLDB?

Java Problem Overview

Java Solutions

Solution 1 - Java

Solution 2 - Java

Solution 3 - Java

How to import external library by relative path in eclipse?

How to transform List<String> to Map<String,String> with Google collections?

Attributions