Java logger

import java.util.logging.Logger;
import java.util.logging.FileHandler;
import java.util.logging.SimpleFormatter;
import java.util.logging.Level;

logger = Logger.getLogger("com.mycompany.conversion"); // logger internal name
FileHandler fileHandler = new FileHandler("basic.conversion.txt", 1000, 1);
fileHandler.setFormatter(new SimpleFormatter());
logger.addHandler(fileHandler);
logger.log(Level.INFO, " Initializing GgWebService");

See also:
C:\Program Files\Java\jdk1.6.0_10\jre\lib\logging.properties
.

Strings

C#
string is an alias for String
String: UTF16

Java
UTF16

C++
wchar_t: UTF16 on Windows, UTF32 on Unix
wchar_t is not portable, better to use ICU instead.

stl::string
typedef basic_string < char > string;
typedef basic_string < wchar_t > wstring;
wstring string1 = L"obecně";

CString

ICU
UnicodeString: UTF16 internally. Note that the endianess of UTF-16 is platform dependent.
ICU does not use UCS-2. UCS-2 is a subset of UTF-16. UCS-2 does not support surrogates, and UTF-16 does support surrogates.

Note: most commonly, "Unicode" means UCS-2, but the difference between UCS-2 and UTF16 is not visible from the Java and C# standpoint

Windows TCHAR
#ifdef UNICODE
typedef wchar_t TCHAR;
#else
typedef char TCHAR;
#endif
TCHAR * toto = _T("obecně");

Note: in Java and C#, strings are immutable. String content cannot be changed after the object is created. See StringBuffer (Java) and StringBuilder (C#)

IP addresses easy to remember to ping

4.2.2.2 ...
8.8.8.8 (Google DNS)

Eclipse survival kit

To find the associated bracket in a Java source on Eclipse, double-click the bracket to find the matching one.

Select square: Alt+Shift+A

Smaller fonts: open the General > Appearance > Colors and Fonts preference page. Select Basic>Text Fonts, Edit and change font size
create WAR files, or AAR axis2 archive files)

Change author / user:
Windows > Preferences > Java > Code Style > Code Templates > Comments
Select Types

When installing Eclipse on Kubuntu, install on /usr/local, otherwise you may have issues with the plugins install

CDT
- tab spaces not taken into account (Helios, Ubuntu 64 bits)
- Needed to do a "apt-get update" after installing CDT otherwise, gave me funky compile error messages on printf and stuff
- To access the gdb CLI, select the gdb process node in the Debug view. The gdb command line will then be available in the Console view. Though no prompt is visible, you can enter commands at the bottom line of the Console view. Doing so may desynchronize the IDE and gdb, so be careful when driving the debugger using this interface.
- automatic save: Windows > Preferences > General > Workspace

cmake

create  a sibbling directory of the sources root:     search-l-2S-build 

cd search-l-2S-build 

cmake -G "Eclipse CDT4 - Unix Makefiles" -D CMAKE_BUILD_TYPE=Debug ../search-l-2S 

In eclipse CDT:

File > Import Existing Projects into Workspace > Next

Select root directory => Répertoire "cmakebuild" créé plus haut

Source accessible in "Subprojects".

./eclipse_cdt -vmargs -XX:PermSize=512m -XX:MaxPermSize=512m -Xms1024m -Xmx1024m

J2EE
You just get "Dynamic Web Project" creation menu only when you install J2EE Eclipse version

Useful files
    - eclipse.ini

if you get black zones within the Eclipse editor, you will have to switch from GTK3 to GTK2. To do this, add the following two lines to eclipse.ini  

--launcher.GTK_version

2 

Software sites 

maven2 - http://download.eclipse.org/technology/m2e/releases

Problems

when using the maven plugin, the "Java build path" in the Eclipse will take the default JRE Eclipse config unless you specify "maven-compiler-plugin" as artifact in the pom.xml with version 1.8 for example

Formatting
window->Preferences, ensuite choisir Java->Code Style-> formatter et sélectionner "Java conventions [build-in]".

Ganimede: 3.4 .. 25 June 2008

Galileo: 3.5 .. 24 June 2009

Helios: 3.6 .. 23 June 2010

C# survival kit

* C# is the first “component oriented” language in the C/C++ family

* csharp string <--> C++ wchar_t
* to display a string from multiline (somewhat equivalent to the C++ backslash ):
string toto = @"toto
toto";
* One must specify “override” to the method in the subclass if one want to override a virtual method from the superclass (as opposed to C++ where override is automatic)
* Mutexes are of two types: local mutexes and named system mutexes. If you create a Mutex object using a constructor that accepts a name, it is associated with an operating-system object of that name. Named system mutexes are visible throughout the operating system, and can be used to synchronize the activities of processes.

HTML frames automatic refresh

<script type="text/javascript">
top.frames['frame1'].location.reload();
top.frames['frame2'].location.reload();
</script>

<html>
<frameset rows="50%,50%">
<frame src="TestResults.html" name="frame2">
<frame src="Hem-1.0/nunit-logs/results-nunit_32.xml" name="frame1">
<frame src="Hem-1.0/nunit-logs/results-nunit_64.xml" name="frame1">
</frameset>
</html>

Registry (Windows autologon, colors)

How to do it trough the registry:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon
String Value: DefaultUserName=domain/Administrator
String Value: DefaultPassword=up...
String Value: AutoAdminLogon=1

also possible is DefaultUserName=username

If you have a color problem from Remove server client (Ubuntu):

XP Mode with 32 bit color + integration is possible!
I found an easier way to get 24 bit colors with integration on here.
1. Run regedit in XP.
2. Navigate to [HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows NT\Terminal Services].
3. Add a DWORD Value named "ColorDepth" w/o parenthesis.
4. Right-click it, modify, then put "4" in the Value data.
5. Restart XP mode / Reboot

SVN survival kit

> Hello, somehow when I update the repository, another username/password is being use.

Tortoise SVN | Settings | Saved Data | Authentication Data | Clear

That will clear the stored information, and you will be prompted for
it the next time it's needed.

Other useful commands:
- svn list svn://whatever.com
- svn status --show-updates --verbose | sort -k 2rn | less
- svn log --verbose --limit 10
- svn status -u (same as --show-updates, svn status usually doesn't check the repository, except when using -u, it just add a * when a file needs updating)
- delete directory
- - svn delete directory
- - svn ci -m " " directory

tagging
- svn copy -m " " svn://192.168.0.1/seng/trunk/ svn://192.168.0.1/seng/tags/2.4/
- svn move -m " " svn://192.168.0.1/seng/tags/2.4/trunk svn://192.168.0.1/seng/tags/2.4/2.4.0.a1

Status values
A: Resource is scheduled for Addition
D: Resource is scheduled for Deletion
M: Resource has local Modifications
C: Resource has Conflicts (changes have not been completely merged between the repository and working copy version)
X: Resource is eXternal to this working copy (may come from another repository). See «svn:externals»
?: Resource is not under version control
!: Resource is missing or incomplete (removed by another tool than Subversion)
~: Something is messed up

/MP C++ compilation option in VS2008

"Multi-processor" compilation.
Not a default, need to be added manually to the command line options.

Windows admin Survival kit

C:\> FOR %f IN (dir c:\tmp\*.*) DO toto.exe %f param2

tracert.exe

C:\Windows\System32\drivers\etc\hosts

To change program that start when Windows starts

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run
RunOnce
RunServices
RunServicesOnce

If what you are looking for is not there, you can check also: HKEY_CURRENT_USER
.

To disable the PC board speaker

- "gestionnaire de peripheriques",
- afficher les peripheriques caches
- "beep", right click, "disable"

MySQL survival kit

To start it:
C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin>mysqld-nt.exe
You can also start it as a service
On Vista, the db file is:
C:\ProgramData\MySQL\MySQL Server 5.1\data\ibdata1

To see the tables:
mysql -u root
> use mysql
> show tables

> CREATE TABLE cumul_bench (
id int(11) NOT NULL auto_increment,
test_desc varchar(100) default '',
tstamp datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (id)
) TYPE=MyISAM;

> show tables

> SHOW COLUMNS FROM cumul_bench

regex in mysql

WHERE cat_id REGEXP '^10.{6}$'    (start with a 10, followed by 6 digits)

• Enable query log  in  /etc/mysql/my.cnf   (affects performances)
• [mysqld]
• general_log      = on
• general_log_file = /var/log/mysql/query.log

•  

Cygwin survival kit

cygcheck -p

--- crontab:
cygrunsrv -I cron -p /usr/sbin/cron -a -D
net start cron

Vista / W2008server / Windows7 survival kit

* Reading the following, some folders are 'virtualized' on Vista
http://support.microsoft.com/kb/927387

The way around I took, is to create a c:\MyProgramFiles

* To add 'SendTo' shortcuts:
C:\Users\myusername\AppData\Roaming\Microsoft\Windows\SendTo

* Stop continuous OS Disk Access (Vista):
- "points de restauration" in Panel/System/System protection
- Windows Defender

* Remove corrupted thumbnails in Windows7
- cleanmgr.exe (system32) and select "thumbnails". You may have to switch to the "details" view, and back again to the "large icons" view to finalize the reset

Initials

- AD: Active Directory
- ACL: Access Control List
- CLR: Common Language Runtime
- CLI: Common Language Infrastructure
- CPL: Courant Porteur en Ligne = Power Line Communication (PLC)
- CMF: content management frameworks
- CMS: content management system
- ERP: Enterprise Resource Planning
- GAC: Global Assembly Cache
- GED: Gestion Electronique de Documents
- LRU: Least Recently Used
- IT: Information technology
- LAMP: Linux, Apache, MySQL and PHP
- MOA: Maitrise d'ouvrage (cree les specs, effectue la recette), parois appele "metiers"
- MOE: Maitrise d'oeuvre (recommande, implemente)
- MVP: Minimum Viable Product  (asked as a first step for start up )
- PLN = CPL
- RIA: rich Internet application
- SLA: Service Level Agreement. In practice, the term SLA is sometimes used to refer to the contracted delivery time
- WMI: Windows Management Instrumentation
(nom du service en francais: Lanceur de processus DCOM)

SQL survival kit

SELECT * FROM ITL WHERE str CONTAINS  'BBB';   --> exact match 
SELECT * FROM ITL WHERE str LIKE  'C';         --> starts with 
SELECT * FROM mytable WHERE Md IS null; 
SELECT * FROM mytable WHERE Id>5; 
SELECT count(*) FROM mytable;                  --> count the number of rows
UPDATE table_13 SET Width=50, Height=50 WHERE id=1; 
ALTER TABLE mytable ADD COLUMN Width int; 
ALTER TABLE mytable CHANGE col col_new_name VARCHAR(255); 
RENAME TABLE mytable TO newtable;

DELETE FROM `mytable` WHERE Url LIKE '%sylvain%';
DELETE FROM ourson_offer;
DELETE FROM lt.image WHERE lt_kimage_id IN (select lt.image.lt_kimage_id from lt.image INNER JOIN lt.keyword ON lt.image.ltu_kimage_id = lt.keyword.lt_kimage_id WHERE lt.keyword.keyword LIKE '%_dead' ORDER BY lt_kimage_id LIMIT 100000);

jointure explicite:

SELECT *   
  FROM employee INNER JOIN department
  ON employee.DepartmentID = department.DepartmentID; 

jointure implicite:

SELECT *   
  FROM   employee, department  
  WHERE  employee.DepartmentID = department.DepartmentID; 

• list sorted column names of a table 

SELECT COLUMN_NAME FROM information_schema.columns WHERE table_schema='app_v2' AND table_name='guest' ORDER BY COLUMN_NAME;

Perl's survival kit

[] empty array
{} empty hash

my $toto = shift equivalent to shift(@_) meaning the first function parameter.

msbuild.exe

c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\msbuild.exe "c:\build\MyBuild.sln" /t:Build /p:Configuration=Release;Platform=Win32 /v:diag

Switch AZERTY/QWERTY key settings (when it is changed using Studio)

When using Visual Studio, it happens that the key settings change from AZERTY to QWERTY. To put them back:

left ALT + SHIFT

Formulas in MS Excel

------ Formulas

1. Click the cell you want the product of the multiplication formula to go in.

2. Type: =(cellname1*cellname2). Substitute "cellname1" and "cellname2" with the names of the cells you would like to multiply.

Also, to mask some of the columns: "Accueuil/Cellules/Format"

------- SUM a column

  . Type =SUM in the cell and then select the cells in the column, press enter

------ open a csv with specific separators in Excel

To open these “|” separated files:
Open Excel / Données/ A partir du texte / importer / Suivant / Séparateurs :autres : « | »

------- to change source cells in a pie graph

   select the cells in the column, drag and drop the cell group on the pie chart 

Disable C$, D$ drives sharing

For NT 4.0/W2K/Windows Server 2003s, the change is: (if the key does not exists, create it)

Hive: HKEY_LOCAL_MACHINE
Key: SYSTEM\CurrentControlSet\Services\LanManServer\Parameters
Name: AutoShareServer
Data Type: REG_DWORD
Value: 0

Do a wait with the Windows API

HANDLE handle = CreateEvent(NULL, TRUE, FALSE, NULL);
WaitForSingleObject(handle,4000);