The H2 database can be used in MySQL compatibility mode to enable unit testing of MySQL-targeted applications:
jdbc:h2:mem:test; MODE=MYSQL ;DB_CLOSE_ON_EXIT=FALSE
However, if you have any database fields declared as "not null", then H2 will insert a default value for these fields and won't fail as you might expect! From the H2 docs :
"When inserting data, if a...
Read More About Solution for H2 not failing when inserting NULL into NOT NULL column in MYSQL compatibility mode »
How to fix the problem when you can't push large commits to gitlab.
$ git push -u origin master
Counting objects: 961, done.
Delta compression using up to 4 threads.
Compressing objects: 100% (919/919), done.
Writing objects: 100% (961/961), 114.64 MiB | 6.81 MiB/s, done.
Total 961 (delta 222), reused 0 (delta 0)
error: RPC failed; result=22, HTTP code =...
Read More About Solution for gitlab - error: RPC failed; result=22, HTTP code = 503 »
Let's say you've got a Java Applet that's locked up your browser, but you're also running other Java processes (like Eclipse) that you want to keep and don't want to just kill every java.exe process. You can kill just the applet!
1. Find the process ID of the applet
Use the " jps " command from JDK7+ to list all the Java processes and their command line arguments:
Read More About How to kill a frozen Java applet on Windows »
I haven't yet found (Googled) an easy way to estimate Solr (or Lucene) storage requirements. Typically we know how many documents we need to index and then we want to estimate how much storage (GB) we will need for the index.
Using the Luke UI we get can easily see three metrics:
Some real-life examples:
Read More About How to guestimate Solr storage requirements »
Our SQL Server instance is located within our private subnet in an AWS VPC. We require remote access to the SQL Server instance on port 1433 for administration purposes. This can be achieved using iptables as follows:
1. Connect to NAT.
ssh -i <<nat-keypair>> ec2-user@<<nat-ip-address>>
2. Set up port forwarding using ...
Read More About How to port forward to SQL Server using AWS NAT »
Showing 1 - 5 of 58 results.