CF to Oracle using Standard

[w0lvie]

I currently have CFMX 7 standard edition and I'm trying to connect to an oracle
database. Since I'm on Standard, the Oracle driver doesnt display in the
dropdown of available drivers, but I DO have the Host, Port and SID of the
Oracle db. There are even existing Oracle datasources on the server, but I
cant seem to get the new connection string to work out...

The existing DSN (that is working) only has this as its JDBC URL:
jdbc:oracle:oci:@DBNAME

But, everything that I've seen so far says that I should have something like:
jdbc:oracle:oci:@SERVERNAME:PORT/DBNAME

I've tried all kinds of combinations and gotten various results, but I'm
hoping that I can find something to point me in the right direction..

Thanks all!

[tzimmerman]

You didn't mention the errors you were getting. See
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18344[/url]. The
article uses the classes12.zip file, but your probably using the the 1.4 jvm so
would want to make sure you have the ojdbc14.jar file in your classpath. Also
the connections you mentioned use oci and the article is for straight jdbc
connection.

HTH.

Ted Zimmerman

[paross1]

There is always the ODBC socket connection, but this really is a last resort
option, as it is not the best method of accessing your data source unless you
have no other choice. (If you do decide to use ODBC, do NOT use the Microsoft
ODBC drivers. Download and install the ODBC driver from Oracle for your
particular version, otherwise you will have tons of problems, especially if you
ever plan on calling stored procedures, etc.)

Phil

[sdupre]

I'd stay away from ODBC.

You have a few options. Oracle thin is OK if you're not doing heavy duty
clob/blob work. There are some other limits you can read about in the
various migration notes, etc. It's a type 4 though and the price is right.

The other to look at is Inet Software. They have a 20 connection driver for
under $300, I think. I've tested it here and it's pretty good. Depending on
the size of your application, a 20 connection driver might be fine.

Stephen Dupre
Adobe Systems, Inc.

[w0lvie]

All,

Excellent advice all around... My only problem is that I'm quite a newbie when
it comes to all this stuff and pretty much need everything spelled out for
me... Does anyone know of any sites that have a checklist for doing something
like this? Granted, the easiest answer is to buy Enterprise edition, but I
doubt thats going to happen any time soon... So, I'm looking for the next best
thing...

Thanks again!!

[paross1]

The previous post by Ted Zimmermin gives you a link that pretty much spells it
out, if you want to download and install the JDBC drivers from Oracle, then
configure an "other" data source. Keep in mind, you won't be able to call
stored procedures that return result sets via ref cursors with this thin client.

Phil

[pradeepu]

Now what is the work around for it. Is
it not possible to use a Oracle thin client with CFMX for Stored Procedures
which return Reference Cursors.
Is it possible to call jdbc calls directly from CFMX. Please suggest.