JDBC Wrapper Error - FusionReactor JDBC: [1] Wrapper - driver options must be name=value pairs.

[Cameron Childress]

I'm attempting to setup FR for the first time on my laptop (Mac - Lion) on Railo (3.3.2) and am getting an error "FusionReactor JDBC: [1] Wrapper - driver options must be name=value pairs.".

Google results seem to offer up trial and error troubleshooting for this, recreating the Datasource voer and over till it take.  I'd prefer to cut to the chase - is there a manual setup guide for this JDBC wrapper since the scripted installer seems to have problems?  I don't see one.

-Cameron

--
Cameron Childress
--
p:   678.637.5072

im: cameroncf

facebook | twitter | google+

[charlie arehart]

Hey Cam, there is indeed a manual for the JDBC Wrapper: 2 of them, in fact. Check out the support page for FR, where it shows links to all the docs (there are many, and most never realize they exist).

As for the problem, I recall there being a curious known bug (in Railo, tracked in their bug tracking system) for this. Perhaps someone else using Railo or from Intergral may chime in with more info.

/charlie

 

--
You received this message because you are subscribed to the Google Groups "FusionReactor" group.
To post to this group, send email to fusion...@googlegroups.com.
To unsubscribe from this group, send email to fusionreacto...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/fusionreactor?hl=en.

[Dustin Martin]

I'm not sure how you're setting up FR JDBC wrapping but here's how I do it:

1.) Create new datasource of "Other" type
2.) The JDBC URL should be something like this:

jdbc:fusionreactor:wrapper:{jdbc:macromedia:sqlserver://[server]:1433;databaseName=[database_name];SelectMethod=direct;sendStringParametersAsUnicode=false;MaxPooledStatements=1000};name=[datasource_name]

Replace [server], [database_name], and [datasource_name] with your values.

3.) Use the following for the driver class:
com.intergral.fusionreactor.jdbc.Wrapper
4.) Enter in any other info required for the datasource (like username
and password)

I haven't done this in a while so I might be missing some steps but
that's generally how I go about it. If you have more issues let me
know and I'll investigate further.

Dustin

[John Hawksley]

Hi Cam, Charlie,

There is indeed a known issue, we logged it at Railo as RAILO-598:

https://issues.jboss.org/browse/RAILO-598

I've just pinged the guys at Railo via email to see if they'll look at this issue for us.  Essentially if you have any  url-style "?a=b&b=c" parameters on the internal URL (the 'wrapped' URL), you'll see this error.  These are used by the mysql driver (amongst others).

The only workaround we know of right now is to not use these parameters.  But this may eliminate some essential options for you, so it can't be applied in all cases.  E.g.:

url: jdbc:fusionreactor:wrapper:{jdbc:mysql://int0045:3306/db?a=b&c=d};driver=org.gjt.mm.mysql.Driver

becomes

url: jdbc:fusionreactor:wrapper:{jdbc:mysql://int0045:3306/db};driver=org.gjt.mm.mysql.Driver

-John

-- 
John Hawksley
Senior Engineer

Voice: +49 7031 221 502 | Fax: +49 7031 221 524
www.intergral.com

Intergral GmbH - Schickardstr 32 - D-71034 Boeblingen - Germany
Geschaeftsfuehrer: David Tattersall, Darren Pywell
Sitz der Gesellschaft: Boeblingen

[Cameron Childress]

Sorry Charile / John / Dustin - I'm just getting back to this thread...

As John indicates there does appear to be a Railo related issue causing this.  I've also been communicating with Integral support about trying to cross link the JDBC Wrapper articles a bit better. After download you're sent to one of the articles, and there's no hint in that one that there are others, which is the dead end I was running into.  Hopefully my headache can save someone else next time around!

Thanks for the suggestions!

-Cameron

[charlie arehart]

Thanks for updating us, Cam. So on your suggestion, do you mean that you wish each article had links to any others it might be related to? Or simply that each article ought to have a link to all the other articles? (I know the cheeky answer would be a simple “yes”, but please do clarify what you meant, if it may help them address your concern. Thanks.)

/charlie

[Cameron Childress]

On Mon, Feb 20, 2012 at 11:28 AM, charlie arehart <charli...@carehart.org> wrote:

Thanks for updating us, Cam. So on your suggestion, do you mean that you wish each article had links to any others it might be related to? Or simply that each article ought to have a link to all the other articles? (I know the cheeky answer would be a simple “yes”, but please do clarify what you meant, if it may help them address your concern. Thanks.)

Well, it may be either or both.  I think that my experience on the site was that of someone who's not really visited very often.  You (and others who've been all over the site) know about the support links and where to go for that stuff.  I, being an infrequent visitor, was looking for the path of least resistance - imagining a FusionReactor Unicorn would lead me to a download page and "first time user" instructional path - across a ColdFusion rainbow to a troubleshooting pot of gold.

So - as a first time user - if you click through "Download Windows x64 Installer", this will bring you through a process that leads to the download of the installer, and lands you on a page that contains links to some other tools, including a link for "JDBC Wrapper Tool".  So I think "ohh gooide, I want the JDBC wrapper too!"

When I click through, I mistakenly believe that I am downloading the JDBC wrapper itself, not a CF based tool to configure it.  So - suggestion number one would be to make it clearer that the JDBC wrapper is installed with FusionReactor and does not require a separate download. It kinda says that now, sorta, but it's not as clear as it could be, especially to someone not already familiar with the product.

So - at this point I'm clearly delusional and click "JDBC Wrapper Tool".  I'm then greeted with a technote that my impatient attention span allows me just long enough to scan the page for the "download" link. Now I'm downloading what I think is the JDBC Wrapper itself.  I'm expecting the download to contain a jar file I need to drop into a directory somewhere.  I'm expecting the "Documentation" link to contain documentation for said JAR file.

Whoops - boy was I wrong.  And, admittedly, I am probably in a SeeFusion induced set of instal expectations, which are wrong here.  So, seeing no other instructions on the page, I attempt to run the ColdFusion configurator, which fails (due to the Railo issue identified earlier in this thread).  

So... it fails and I go back to the technote.  I hunt for hints for manual instal.  Another technote? Anything?  But there is nothing to find.  This technote is a dead end.

I know that the technote might stand on it's own just fine.  Really, my issue was that the download page led me to it and I didn't see an easy route to alternate docs about the JDBC wrapper.  I did finally find them, but I suspect they could be better linked from the download page, and also from that technote.

I also know I'll never run into this problem again, because I've learned where the other links are. But for a first time visitor, the distinction between "JDBC Wrapper" and "JDBC Wrapper Tool" is not really well understood.  Perhaps there could be some improvement there.  Either better links on the download page itself, or a few cross links in the technote, or both.

-Cameron

 

[charlie arehart]

Thanks for all that. It is indeed interesting to hear—and to be clear, no there’s nothing one needs to “download” to use the “jdbc wrapper”. It’s built-in. The tool is just a way to help automate the process, as perhaps by now you’ve come to realize.  Offering the link to it was an attempt to help point out an optional tool, but I can see now how someone could misunderstand, if new to JDBC wrapping.

I’m sure the FR guys will give serious consideration to your thoughts. It always helps to have someone share their objective perspective to review things from a newcomer’s perspective, so that they can be improved if necessary. I’ll say that it was their willingness to consider such feedback several years ago that got me hooked on the tool(s) then. :-)

/charlie

 

From: fusion...@googlegroups.com [mailto:fusion...@googlegroups.com] On Behalf Of Cameron Childress
Sent: Monday, February 20, 2012 2:13 PM
To: fusion...@googlegroups.com
Subject: Re: [fusionreactor] JDBC Wrapper Error - FusionReactor JDBC: [1] Wrapper - driver options must be name=value pairs.

 

On Mon, Feb 20, 2012 at 11:28 AM, charlie arehart <charli...@carehart.org> wrote:

--

[charlie arehart]

If you’ve not heard, I'll be talking later today (11am ET on Wed Feb 22) about ColdFusion troubleshooting using FusionReactor, at this Adobe Adobe eseminar:

http://www.adobe.com/cfusion/event/index.cfm?event=detail&id=1965964&loc=en_us

Anyone’s welcome, but you do need to signup in advance (free) to get the details on attending. This is part of an occasional Adobe seminar on CF, and they asked me to present on FR, which is pretty cool of them to do! :-)

Let’s show our support as the FR community. Even those who’ve been using FR for a while may learn something. :-) I’ll be showing FR 4, but it’s not a “what’s new in FR 4” talk. Rather, it’s a “why use FR to do troubleshooting as a CF user” talk.

/charlie

[charlie arehart]

Hey folks, following up my note below from last week, Adobe gave me the URL today for the recording of the presentation, which I think went quite well:

https://www.adobe.com/cfusion/event/index.cfm?event=register%5Fno%5Fsession&id=1995344&loc=en%5Fus

Note that you do have to login with an Adobe ID (like when you download updates, etc.) It’s just about an hour, and even experienced FR users may learn something, or you may want to share it with others. I tried to point out a lot, but couldn’t point out everything. Keep in mind also that this was an Adobe webinar: I had to balance what I said to keep it seeming too much a pure FR sales pitch. I’d look forward to feedback from anyone.

 

/charlie

--