Coldfusion 10 Oracle Driver Rating: 8,5/10 3870 votes

TheCFQUERY tag is the main tag used by ColdFusion tointeract with databases. Using CFQUERY, you canpass any Structured Query Language (SQL) statement to a data sourceregistered with the ColdFusion Administrator. The content of your SQLstatements determines what action is performed against the datasource. The next section provides a quick primer on SQL.

  1. Coldfusion 10 Oracle Jdbc Driver
  2. Oracle Driver Download
  3. Java Download Windows 10 Oracle

TheCFQUERY tag works by establishing a connectionwith the specified data source, passing a series of SQL commands, andreturning query variables that contain information about theoperation. The basic syntax for using the CFQUERYtag is as follows:

Each attribute in the openingCFQUERY tag specifies information about the datasource and how ColdFusion should access it. TheNAME attribute assigns a name to the query. Validquery names must begin with a letter and can contain only letters,numbers, and underscore characters. NAME isrequired when passing an SQL SELECT statement andis optional for all other SQL operations.[5]The DATASOURCE attribute is required in allcircumstances except when DBTYPE isQuery or Dynamic and specifiesthe name of the data source (as it appears in the ColdFusionAdministrator) to connect to when executing the query. TheDBTYPE attribute is optional and specifies thetype of database driver to use when connecting to the data source.Possible entries are:

Adobe ColdFusion 11. And Windows 10.5 • Oracle 11g R2. For more information on ColdFusion support for JDBC drivers not shipped with the product, read the. We're in the process of upgrading from ColdFusion 8 to ColdFusion 9, and we're starting by testing out the newest thin Oracle JDBC drivers (both driver versions 10 and 11) against ColdFusion 8. We've been using the same Oracle thin JDBC driver since 2004 (version. Step 2: Copy the driver.jar file to your ColdFusion lib folder. Locate the DataDirect JDBC.jar file for the driver that you want to integrate with your Adobe ColdFusion environment by looking in the lib folder.

I am betting when you /*connected /*to non-RAC instances, you used the Oracle driver from the pulldown in the /*DSN section. When you connect to RAC instances, you have downloaded /*Oracle's /*thin client and are using Oracle jdbc string. [EMAIL PROTECTED]> wrote: /* /*> Hi everyone, /*> /*> I have an application that uses ColdFusion 8.

ODBC (the default)

Connect to the data source using anODBC driver.

  • If using ColdFusion MX 7.01 you may want to configure another datasource for comparison using the Driver Option listed as 'Oracle' in the drop down list. This will use the built-in driver supplied by ColdFusion that supports Oracle 10g.
  • Teradata JDBC Driver Supported Platforms. ColdFusion 10 with Oracle JRE 7. Generally, the Teradata JDBC Driver is tested in a particular operating environment before that operating environment is supported for use with the Teradata JDBC Driver.
OLEDB

Make the connection using an OLEDBdriver.

Oracle73

Connect using the Oracle 7.3 nativedriver. This requires the 7.3.4.0.0 or later client libraries beinstalled on the ColdFusion server.

Oracle80

Connect using the Oracle 8 native driver. This requires the 8.0 orlater client libraries be installed on the ColdFusion server.

Sybase11

Coldfusion 10 Oracle Jdbc Driver

Connect using the Sybase 11native driver. This requires the 11.1.1 or later client libraries beinstalled on the ColdFusion server.

DB2

Connect using the DB2 5.2 nativedriver.

Informix73

Connect usingthe Informix 7.3 native driver. This requires the Informix SDK 2.5 orlater or Informix-Connect 2.5 (or later) for Windows.

Query
Oracle

Specifies the query should use an already existing query as the datasource. If this option is used, you don’t need to specify avalue for DATASOURCE. The ability to query a querywas introduced in ColdFusion 5.0 and is discussed in Chapter 11.

Dynamic

Allows ColdFusion to make an ODBC connection to a data source withoutregistering the data source in the ColdFusion Administrator. Theability to make a dynamic data source connection was added inColdFusion 5.0. When making a dynamic connection, all informationnormally provided in the ColdFusion Administrator for the connectionmust be specified in the CONNECTSTRING attribute.

TheCONNECTSTRING attribute was introduced inColdFusion 5.0 and allows you to pass additional connectioninformation to an ODBC data source that can’t be passed via theColdFusion Administrator. CONNECTSTRING can alsooverride connection information set for a data source alreadyregistered in the ColdFusion Administrator. For example, if you useSQL Server as your database, there is no way to specify the name ofthe application connecting to the data source in the ColdFusionAdministrator. Using CONNECTSTRING, however, it ispossible to pass this additional bit of information:

For specific connection string options, you should consult thedocumentation for your particular database. There are a number ofadditional attributes that can be used with theCFQUERY tag. For a complete list, see its tagreference in Appendix A.

A newfeature in ColdFusion 5.0 is the ability to make a dynamic ODBCconnection to a data source that isn’t registered with theColdFusion Administrator. You make a dynamic connection by settingthe DBTYPE attribute of theCFQUERY tag to Dynamic andspecifying all the information required to connect to the data sourcein the CONNECTSTRING attribute. For example, tomake a dynamic connection to an Access database namedProgrammingColdFusion.mdb, you use thefollowing:

In this example, aconnection is made using the Microsoft Access ODBC driver to adatabase named ProgrammingColdFusion.mdb, storedin D:databases. The UID andPWD parameters specify the username and password,if any, for the database. Note that name/value pairs in theconnection string are delimited by semicolons. Additionally, nospaces should be present between the parameter name, the equal sign,and the value associated with the parameter. If you find yourselfencountering errors when trying to connect using aCONNECTSTRING, be sure each value is typed exactlyas it is expected by your driver. For example, specifying“Microsoft Access Driver(*.mdb)” causes an error, as thecorrect driver name is “Microsoft Access Driver (*.mdb)”(note the space before the open parenthesis). Connecting to anenterprise level database is just as simple. For example, aconnection to a SQL Server database looks something likethis:

By default, ColdFusion uses a special internally defined data source__dynamic__ to pool all dynamic connections.Connection pooling improves query performance as additional requeststo the same data source use the same connection. You can defineadditional connection pools for your dynamic connections in two ways:

  • Specify a name for the DATASOURCE attribute of theCFQUERY tag. Doing this whenDBTYPE is Dynamic causesColdFusion to create a new connection pool, usable by any dynamicconnections that use the same DATASOURCE name.

  • Create a bogus data source in the ColdFusion Administrator andreference it using the DATASOURCE attribute of theCFQUERY tag. To create a bogus data source in theColdFusion Administrator, you need to enter the name of a databasefile, hostname, or IP address. For consistency, I suggest you use“dynamic”. This method allows you to set default valuesfor your dynamic connections such as timeouts, passwords, restrictedSQL operations, etc.

    May 12, 2016  Buenas para los que no han podido obtener el zzkey ( Huawei Advanced Tool ) les aporto el links de descarga. Ojo: Solo para los que no han podido obtener el programa. ★★★ Links de descarga. You are about to download and install zzkey Huawei advanced tool latest updated version v2.7.2.9 full cracked setup for all Huawei smartphones and tablets. ZZ-Team recently released Huawei Advanced Tool 2.6.0.7 which now supports Huawei IMEI repair FREE, and also various models added in the latest version of zZ-Team Huawei Advanced Tool 2.6.0.7. Users can download Huawei Advanced Tool 2.6.0.7 Released by zZ-Team from the download link which is provided at the end of the article. Zz huawei advanced tool.

Due to the security risks ofallowing developers (especially in hosted environments) to makedynamic data-source connections and to pass additional connectionstring parameters, both actions can be disabled in the TagRestrictions section of the Security tab in the ColdFusionAdministrator.


[5] Although the NAMEattribute is required only for SQL SELECT statements, you may wish touse it with all your queries. It makes debugging easier, especiallyfor templates that contain multiple queries, because it allows you toidentify each query by name in the debug output.

Active5 years, 5 months ago

I have done a lot of searching about this, but cannot seem to get a clear list of the limitations of Macromedia versus thin Oracle JDBC drivers, because they have big differences that I'm not understanding.

I have two data sources connected to the same database, using the same credentials in CF 9.0.1:

  1. Thin

    • jdbc url = jdbc:oracle:thin
    • driver class = oracle.jdbc.OracleDriver
  2. Macromedia

    • jdbc url = jdbc:macromedia:oracle
    • driver class = macromedia.jdbc.MacromediaDriver

On an insert query

  • The Thin datasource Fails (giving error ROWID does not exist)

  • The Macromedia datasource is OK

On a dbinfo call

  • The Thin datasource is OK

  • The Macromedia datasource never processes, eventually gives a cfoutput timeout error

On a stored procedure with an RC1 cursor

  • The Thin datasource errors, wrong number or types of arguments in call to 'schema.myproc'

  • The Macromedia datasource is OK

Is there a list of differences or pros/cons that I can reference? Or is this just a trial error I get to enjoy? Should I just have two different datasources and call them as needed when one doesn't work? Any insight is appreciated.

Leigh
27.9k7 gold badges46 silver badges91 bronze badges
Jay RizziJay Rizzi
2,8914 gold badges30 silver badges56 bronze badges

1 Answer

Is there a list of differences or pros/cons that I can reference? - I suspect you will need to read the documentation for each driver to get that information. See the Oracle documentation for the particular version of the thin datasource driver that you installed. ColdFusion ships with DataDirect for it's drivers. ColdFusion 9.0.1 comes with DataDirect version 4.0 SP 1 drivers. See the DataDirect docs for 4.0.

My thoughts on the specific examples that you gave.

On an insert query

  • The Thin datasource Fails (giving error ROWID does not exist)

  • The Macromedia datasource is OK

Perhaps the thin datasource returns a different variable than ROWID. I would do a <cfdump var='#r#'> after your <cfquery> call to see what you have available.

On a dbinfo call

  • The Thin datasource is OK

  • The Macromedia datasource never processes, eventually gives a cfoutput timeout error

Not really sure what is happening here as you would expect that call to work. I would try a more generic (higher level) call to dbinfo and see what is available. Again, using <cfdump> to check returned values. Start with just dbnames() and see what you get. Then start digging into whatever is returned. This is really just informational for you and should not really affect your decision for production as you will not be using dbinfo there. Right?

On a stored procedure with an RC1 cursor

  • The Thin datasource errors, wrong number or types of arguments in call to 'schema.myproc'

  • The Macromedia datasource is OK

The thin datasource driver does not support reference cursors in packages or stored procedures. It says so in the ColdFusion docs.

CFML supports Oracle 8 and 9 Reference Cursor type, which passes a parameter by reference. Parameters that are passed this way can be allocated and deallocated from memory within the execution of one application. To use reference cursors in packages or stored procedures, use the cfprocresult tag. This causes the ColdFusion JDBC database driver to put Oracle reference cursors into a result set. (You cannot use this method with Oracle’s ThinClient JDBC drivers.)

I would recommend using the DataDirect drivers that are shipped with ColdFusion. At least until they don't provide some sort of functionality that you need. Not until that point would I start looking at other alternatives. This will keep you within Adobe's support. Once you start using third-party software they cannot support them.

Miguel-FMiguel-F

Oracle Driver Download

12.3k4 gold badges26 silver badges49 bronze badges

Java Download Windows 10 Oracle

Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.

Not the answer you're looking for? Browse other questions tagged oraclejdbccoldfusioncoldfusion-9 or ask your own question.

Coments are closed
Scroll to top