Being a session Bassist and Pro Engineer, here are my .02........
I have used just about everything over the years...Older Fenders (I have a REAL '62 and a REAL '67 Jazz) are hard to beat for just about anything...I used Warwick Streamer Stage 2 4 and 5 strings for a few years for more modern stuff and I currently use my Sadowsky Vintage 4 for EVERY Session I do....Anything that HAS to have a 5 string typically will get a Warwick NT Thumb 5....
One piece of advice I will give is be careful of what you send to tape....typically I do not send a lot of low or High end to tape from the bass's onboard pre....just enough to make things full....I will use compression to tape at times depending on the type of track but typically RECORD WITHOUT IT....remember, you can always add ANYTHING later in the mix stage but what goes to tape is ALWAYS on tape....it is almost impossible to "take it back"......
I like the UA 1176 Compressor, a dbx 160X (just about the coolest since sliced bread) or even the older dbx 166 is not bad in a pinch....my favorite compressors are an Avalon 737 (rackmount pre with built in compressor), API 200 and 500 series, Neve 33609, and most any SSL compressor on the console or one of the new outboard mic pre units the XLogic channel....
Keep in mind that a good engineer can make just about anything work as long as there is a decent track there to begin with....we are not magicians.....Don Was once said to a guitarist "If you don't put it on tape, it won't be on tape!".....think about it.......
Peace,
T