I kept finding references to the thin client being able to use the tnsnames. Specifies the maximum number of database connections for the data source. Enter the following in the Driver Class field: The default value is bytes. However, when creating the secure connection using ColdFusion, there is an error when using the basic connection string.

Uploader: Nasida
Date Added: 25 February 2005
File Size: 56.72 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 31533
Price: Free* [*Free Regsitration Required]

Leave a Reply Cancel reply Enter your comment here ColdFusion11 helps you build and deploy web and mobile apps. Description Optional A description for this connection. You are commenting using your Twitter account.

If you need to connect to an Oracle database from Coldfusion 10 the following are some recommendations on how to configure your connection. In this example, the driver class should be com. Learn how your comment data is processed. Post was not sent – check your email addresses!

View Help PDF adobe. This site uses Akismet to reduce spam. On a dbinfo call. The information in this field is case-sensitive.

ColdFusion MX: Configuring the Oracle JDBC-OCI Instant Client driver

By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service.


The error message is shown below:. And there we coldfksion, successful connection and Oracle was back up and running. Email required Address never made public. The root cause was that: The thin datasource driver does not support reference cursors in packages or stored procedures. To resolve that the issue, download the Unlimited Policy jar from Oracle website link given below.

I have two data sources connected to the same database, using the same credentials in CF 9.

Connecting to Oracle

Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies. Max Pooled Statements Enables reuse of prepared statements that is, stored procedures and queries that use the cfqueryparam tag.

oracoe Optional Enter the name of the driver in the Driver Name field. If selected, suspends all client connections. Is this ColdFusion 9 Standard or Enterprise?


ColdFusion MX: Configuring the Oracle JDBC-OCI Instant Client driver

A field that passes database-specific parameters, such as login credentials, to the data source. This can slow query response time jbdc an additional query is generated. Use the settings in the following table to connect ColdFusion to Oracle data sources: I went to Oracle here to get the latest drivers.

Notify me of new comments via email. If the database is local, enclose the word local in parentheses. Services Consulting Education Modernization Outsourcing. At least until they don’t provide some sort of functionality that you need.

Specify the validation query before restarting the database to verify all connections, but remove the validation query after restarting the database to avoid any performance loss. This is the proper way when using Standard Edition.