Category: Computers

All things computing.

Eclipse Crashing with SIGSEGV, Problematic Frame libgdk and/or libsoup Problem Solved

Posted on by rchapin

I’m setting up a new workstation under Fedora Core 20 and getting my dev environment set up.

I had copied over my /opt dir from my old machine which included an older version of Eclipse (3.8.2) that I had been using.  That version wasn’t behaving very well and I decided to go with the latest and greatest stable version (Kepler, 4.3.1).

Unfortunately, Kepler was dumping core with the following error:

 A fatal error has been detected by the Java Runtime → Continue reading “Eclipse Crashing with SIGSEGV, Problematic Frame libgdk and/or libsoup Problem Solved”

Excellent Example and Explanation on How to Inject Properties from an External Properties File from Outside of a WAR in a Spring Application

Posted on by rchapin

I am doing some refactoring on a Spring MVC application, pulling out configuration data and login crentials from the spring.xml file.

What I want to do is to consolodate sensitive data into external .properties files that can be read, at runtime by the app and not require recompiling the war to make changes.

Thanks to Ben Northrop and Summa Technologies for such a clear, concise and well written article.

The long and the short of it (copied from the → Continue reading “Excellent Example and Explanation on How to Inject Properties from an External Properties File from Outside of a WAR in a Spring Application”

Disabling Window Snapping for Fedora Core 20 Under Xfce

Posted on by rchapin

For me, window snapping is incredibly annoying.

For FC 20 with the Xfce spin, there a couple of knobs to turn before it can be turned off completely:

Applications Menu/Settings/Window Manager:

Go to the Advanced tab and uncheck ‘Snap windows to screen border’ and ‘Snap windows to other windows’

Applications Menu/Settings/Window Manager Tweaks:

Go to Accessibility tabUncheck the ‘Use edge resistance instead of window snapping’→ Continue reading “Disabling Window Snapping for Fedora Core 20 Under Xfce”

Executing Dynamically Generated SQL Queries in a Shell Script and Saving the Output to a Variable

Posted on by rchapin

If you would like to, in a shell script, dynamically generate SQL queries for MySQL and save the output of those queries to a variable that you can then use in the script, here is an example:

#!/bin/bash

for i in `cat tables_list.txt`
do

   # Build the query
   QUERY="SELECT count(*) FROM ${i}"

   # Run the query from the command-line and save the
   # output into the $ROW_COUNT variable
   ROW_COUNT=$(echo $QUERY | mysql -u${USER_NAME} -p${PASSWORD} -h ${HOST} -P ${PORT} --skip-column-names ${DBASE})

  
→ Continue reading “Executing Dynamically Generated SQL Queries in a Shell Script and Saving the Output to a Variable”

Figuring out MySQL ERROR 1005 (HY000) Can’t create table (errno: 150)

Posted on by rchapin

So I’m dumping a database on a remote server to pull down to my local box to do some development.  When loading the mysqldump file I encountered the error:

ERROR 1005 (HY000) at line 8680: Can't create table 'database.table' (errno: 150)

After doing some searching online it seems that is one of the notoriously cryptic MySQL error messages that is woefully overloaded.

I did manage to fix the error (which ended up being a foreign key reference from another table → Continue reading “Figuring out MySQL ERROR 1005 (HY000) Can’t create table (errno: 150)”

Install Android Application Directly Without it Being in the Market

Posted on by rchapin

When developing apps you will not only want to test them against the Eclipse AVDs but also install them on an actual device.

To do so, set up an HTTP server (here is a link to another article on how to set up a quick and dirty HTTP server) and put you .apk file somewhere where you can get to it from your local network.

Make sure that you check the ‘Unknown sources’ setting that will enable you to → Continue reading “Install Android Application Directly Without it Being in the Market”

Deleting Safari Cookies in iOS Simulator

Posted on by rchapin

If you are doing any kind of development that involves cookies and need to be able to delete them while testing iOS you will likely need to delete them as well.

The iOS simulator (Launched from Xcode by going to Xcode > Open Developer Tool > iOS Simulator) stores data for the simulator in the following directory on the host Mac OSX file system:  /Users/<uid>/Library/Application Support/iPhone Simulator/

First, quit out of the iOS Simulator.

To find the cookies and delete → Continue reading “Deleting Safari Cookies in iOS Simulator”

Executing MySQL Queries and Commands from the Command Line to a Remote Server

Posted on by rchapin

Following are a couple of ways to execute SQL on a remote MySQL server via the shell.

Executing SQL directly from the command line:

$ mysql -u uid -p -h remote.host database -e ‘SQL query here;’

Executing SQL from a file on the local host on the remote server:

$ mysql -u uid -p -h remote.host database < file.sql

You can also connect to the remote mysql server and from the command line execute SQL from files on the local → Continue reading “Executing MySQL Queries and Commands from the Command Line to a Remote Server”

Executing Dynamically Generated SQL Queries from a Shell Script

Posted on by rchapin

Following is how to generate dynamic SQL in a shell script and then execute those queries.

Let’s say, for instance, that you have a list of tables that you want to flush regularly during development and don’t want to type in the SQL queries each time.  Moreover, you just want to maintain a list of the table names and add and remove from it when necessary and have your script dynamically generate and execute the delete statements.

For the purposes → Continue reading “Executing Dynamically Generated SQL Queries from a Shell Script”

© 2005 Ryan Chapin