Don't know how close it would be to a real Stingray, but it should be a great bang-for-the-buck instrument. I like Jazzes as well (not as much as Stingrays, or Musicmans in general) and I have a Sire V5R five string, which is a passive Jazz bass. I like it a lot. It does a vintage Jazz tone very well and the sound fits my classic rock and blues band very nicely.
I bought it to be a relatively inexpensive bass to use when conditions make me hesitant to take my good basses out (such as outdoor gigs when there's a threat of rain), but I found it to be a really nice instrument that sounds great. It doesn't get as much gig time as my Musicmans, but it gets its share. My band loves it, especially our guitar player, who subtly and sometimes not so subtly suggests I use it more.