Every fretted bass line I've ever recorded has been on a Yamaha CBX800A from the 1980s. This is a bit of a quirky animal—a 4-string, long-scale, active-electronics beast that's fatiguing for smaller people to play, but offers some of the most tonal versatility I've ever heard even in a bass that doesn't, in its design, feel like it's meant to be versatile.
The active pickups are terrific, and provide a much different response than the standard J-Bass/P-Bass pickups on your neighbourhood Fender. The neck is a bolt-on, but it's very deeply bolted into the body, if that makes sense; sustain goes for days and the bass isn't too muddy or thumpy on the bottom end, even on strings that have been dead for years. Hang onto one of these beauties if you can find one—they're not worth much to sell, but you'd pay two or three times as much for a custom shop bass that does the job so well, if the long-scale neck is something you can learn to like.