Solution for H2 not failing when inserting NULL into NOT NULL column in MYSQL compatibility mode

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 »

Solution for gitlab - error: RPC failed; result=22, HTTP code = 503

How to fix the problem when you can't push large commits to gitlab. Symptom Client-side error: $ 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 »

How to kill a frozen Java applet on Windows

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: jps -v ...
Read More About How to kill a frozen Java applet on Windows »

How to guestimate Solr storage requirements

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: Documents Fields Terms Some real-life examples: Metric ...
Read More About How to guestimate Solr storage requirements »

How to port forward to SQL Server using AWS NAT

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.
Items per Page 5
of 12