Use of Macromedia JDBC Drivers is restricted

[Guest]

We are building a new CF9 server. We installed the developer version and things appeared to work OK. When we set our single-server license (single server, not Enterprise) we get this message when trying some of our queries against a SQL Server database (did not try against Oracle, we only use SQL Server for this application).

Error Executing Database Query.

Use of Macromedia JDBC Drivers is restricted. Drivers can only be used with Macromedia server products. Please check that your license supports the requested driver.

One of the other threads here indicates that JDBC drivers are only enabled for the Enterprise version. Another thread however seems to indicate that we would need to reinstall and make sure that the correct drivers were selected during the install process. This part *did* work during the developer period (which I believe enables all Enterprise features).

Can standard version support JDBC? If not, can we use something else than JDBC? We don't want Enterprise.

[Dave Watts]

First, yes, CF Standard supports JDBC. All CF database connections, regardless of version or license, use JDBC. The difference between Standard and Enterprise with regard to JDBC drivers is limited to the bundled Oracle driver included with Enterprise, Developer and Trial - this is not available for Standard.

Second, there's no relevant option for which JDBC drivers you get during the install process, regardless of version. There is an option for the JDBC-ODBC bridge, SequeLink, but that's not relevant to this.

Now, to fix your problem. First, make absolutely sure you're not using the Oracle driver! I know you said you're not, but better safe than sorry.

After that, the easiest approach would probably be to just completely uninstall CF and reinstall it with the correct license - at least, that would be the quickest without doing additional digging. However, I'm sure with a bit of tinkering you can fix your problem without uninstalling - I'm just not sure on the direction and amount of time that tinkering would take.

Alternatively, you could open a support ticket with Adobe, although honestly it would probably take you less time to just uninstall and reinstall CF.

Dave Watts, CTO, Fig Leaf Software

[Guest]

Oops - I was wrong about the database usage.

I looked under the Cold Fusion Administrator > Data Services > Data Sources:

     We have one SQL Server

     We also need to access 3 Oracle databases from this instance.

     Plus 4 Apache Derby Embedded with names that look like they are example built-in databases for the CF instal.

Is there a way we can do that (e.g., a different driver) that doesn't require the Enterprise version? Perhaps ODBC Socket? I don't see anything oracle-ish under the Driver options in "Add New Data Source"

Thanks.

[Adam Cameron.]

Just grab some other Oracle JDBC driver from somewhere.  Maybe one of these ones: http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html.

--

Adam

[Charlie Arehart]

And then, Brady, you would install it into CF and configure it as an “other DSN” in the CF Admin, which while both are unusual for most people, are both documented in the CF docs, in the Admin and Config manual.

For CF9, see http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fe9.html.

For CF8, see http://livedocs.adobe.com/coldfusion/8/htmldocs/datasources_ADV_MJS_15.html. Sadly, this page doesn’t talk about where to put the jar files when you get them. IT’s mentioned after the first table on this page: http://livedocs.adobe.com/coldfusion/8/htmldocs/datasources_ADV_MJS_02.html.

/charlie