Unanswerable. No "James" is specified—could be James Bond, James Hetfield, James from a game/movie, or a real person. Without context, no favorite gun can be identified.
If you mean James Bond: his iconic sidearm is the Walther PPK (most films), briefly P99 (Brosnan/Craig era), and PPK/S (recent).
Please clarify which James.