API tools faq
paste
Guest User

Untitled

a guest
Jun 10th, 2018
133
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 97.82 KB | None | 0 0
raw download clone embed print report
  1. CFIDE.adminapi.datasource
  2. Component datasource (datasource)
  3.  
  4.  
  5. Add, modify, and delete ColdFusion data sources.
  6.  
  7.  
  8. hierarchy: WEB-INF.cftags.component
  9. CFIDE.adminapi.base
  10. CFIDE.adminapi.datasource
  11. serializable: Yes
  12. properties:
  13. methods: checkAllowedFileExtensions, deleteDatasource, formatJdbcURL*, getAccessDefaultsFromRegistry*, getCFSettingDefaults*, getDatasourceDefaults*, getDatasources, getDriverDefaults*, getDriverDetails, getNewDSNDefaults*, getODBCDatasources, getSlsAgentServiceName*, getSlsServerPath*, getSlsServerServiceName*, getURLDefaults*, installOdbcService, removeOdbcService, setDB2, setDerbyClient, setDerbyEmbedded, setInformix, setJNDI, setMSAccess, setMSAccessUnicode, setMSSQL, setMySQL5, setMySQL_DD, setODBCSocket, setOracle, setOther, setPostGreSQL, setSlsServerServiceName*, setSybase, sl54Add*, sl54Del*, sl54displ*, sl54mlog*, sl54mod*, startOdbcService, stopOdbcService, updateODBCServerDSN*, upgradeOdbcService*, verifyDsn
  14. inherited methods: dump, getEdition, getInstallType, isAdminUser, logaudit
  15. * - private method
  16.  
  17. checkAllowedFileExtensions
  18. public any checkAllowedFileExtensions ( required string ext )
  19.  
  20. Checks if extension is allowed or not.
  21.  
  22. Output: suppressed
  23. Parameters:
  24. ext: string, required, ext
  25.  
  26. deleteDatasource
  27. public void deleteDatasource ( required dsnname )
  28.  
  29. Deletes the specified data source.
  30.  
  31. Output: suppressed
  32. Parameters:
  33. dsnname: any, required, dsnname - The name of the data source to be deleted.
  34.  
  35. formatJdbcURL*
  36. private formatJdbcURL ( required driver, host, port, dsn, database, datasource, args, informixServer, selectMethod, SID, MaxPooledStatements, isnewdb, qTimeout, applicationintent )
  37.  
  38. Formats the JDBC URL.
  39.  
  40. Output: suppressed
  41. Parameters:
  42. driver: any, required, driver - JDBC driver.
  43. host: any, optional, host - Machine to connect to.
  44. port: any, optional, port - Port number on which the server is listening.
  45. dsn: any, optional, dsn - Name that ColdFusion uses to connect to the data source.
  46. database: any, optional, database - Name of database to access.
  47. datasource: any, optional, datasource - Actual name of data source.
  48. args: any, optional, args - Semicolon-separated list of arguments.
  49. informixServer: any, optional, informixServer - Informix server name.
  50. selectMethod: any, optional, selectMethod - Name of method for SELECT statement.
  51. SID: any, optional, SID - Database system ID name.
  52. MaxPooledStatements: any, optional, MaxPooledStatements - Maximum number of database statements to pool.
  53. isnewdb: any, optional, isnewdb
  54. qTimeout: any, optional, qTimeout - Query timeout value for all the statements created by the connection.
  55. applicationintent: any, optional, applicationintent - Query timeout value for all the statements created by the connection.
  56.  
  57. getAccessDefaultsFromRegistry*
  58. private getAccessDefaultsFromRegistry ( required scope, required dsn )
  59.  
  60. Retrieves Microsoft Access default values from Windows registry.
  61.  
  62. Output: suppressed
  63. Parameters:
  64. scope: any, required, scope - Arguments scope to receive default values.
  65. dsn: any, required, dsn - Name that ColdFusion uses to connect to the data source.
  66.  
  67. getCFSettingDefaults*
  68. private getCFSettingDefaults ( required scope )
  69.  
  70. Gets the cfsetting defaults to the arguments scope that is passed.
  71.  
  72. Output: suppressed
  73. Parameters:
  74. scope: any, required, scope - Scope - any structure (user-defined, form, URL, etc.)
  75.  
  76. getDatasourceDefaults*
  77. private getDatasourceDefaults ( required scope, required dsn )
  78.  
  79. Gets the DSN defaults to the arguments scope that is passed in.
  80.  
  81. Output: suppressed
  82. Parameters:
  83. scope: any, required, scope - Scope - any structure (user-defined, form, URL, etc.)
  84. dsn: any, required, dsn - Data source name.
  85.  
  86. getDatasources
  87. public any getDatasources ( dsnname )
  88.  
  89. Returns a structure containing all data sources or a specified data source.
  90.  
  91. Output: suppressed
  92. Parameters:
  93. dsnname: any, optional, dsnname - The name of the data source for which a structure is returned.
  94.  
  95. getDriverDefaults*
  96. private getDriverDefaults ( required scope )
  97.  
  98. Gets the driver defaults to the arguments scope that is passed in.
  99.  
  100. Output: suppressed
  101. Parameters:
  102. scope: any, required, scope - Scope - any structure (user-defined, form, URL, etc.)
  103.  
  104. getDriverDetails
  105. public struct getDriverDetails ( String driverName="" )
  106.  
  107. Returns a structure containing all drivers
  108.  
  109. Output: suppressed
  110. Parameters:
  111. driverName: String, optional, driverName - Name of the driver, if this is passed details of only that driver is returned
  112.  
  113. getNewDSNDefaults*
  114. private getNewDSNDefaults ( required scope )
  115.  
  116. Gets the data source defaults to the arguments scope that is passed in.
  117.  
  118. Output: suppressed
  119. Parameters:
  120. scope: any, required, scope - Scope - Any structure (user-defined, form, URL, etc.)
  121.  
  122. getODBCDatasources
  123. public any getODBCDatasources ( )
  124.  
  125. Returns a query object that contains one row for each ODBC data source.
  126.  
  127. Output: suppressed
  128.  
  129. getSlsAgentServiceName*
  130. private String getSlsAgentServiceName ( )
  131.  
  132. Returns the name of the ODBC server agent.
  133.  
  134. Output: suppressed
  135.  
  136. getSlsServerPath*
  137. private String getSlsServerPath ( )
  138.  
  139. Returns the path/filename of the ODBC Sequelink INI file.
  140.  
  141. Output: suppressed
  142.  
  143. getSlsServerServiceName*
  144. private String getSlsServerServiceName ( )
  145.  
  146. Returns the ODBC Server service name.
  147.  
  148. Output: suppressed
  149.  
  150. getURLDefaults*
  151. private getURLDefaults ( required scope, driver="", required delims )
  152.  
  153. Returns URL default values.
  154.  
  155. Output: suppressed
  156. Parameters:
  157. scope: any, required, scope - Arguments scope to receive URL default values.
  158. driver: any, optional, driver - Driver name,
  159. delims: any, required, delims - Delimiters.
  160.  
  161. installOdbcService
  162. public void installOdbcService ( )
  163.  
  164. Installs ODBC service.
  165.  
  166. Output: suppressed
  167.  
  168. removeOdbcService
  169. public void removeOdbcService ( )
  170.  
  171. Removes ODBC service.
  172.  
  173. Output: suppressed
  174.  
  175. setDB2
  176. public void setDB2 ( required string name, required string host, required string database, string originaldsn="", string port="50000", string driver="DB2", string class="macromedia.jdbc.MacromediaDriver", string username="", string password="", boolean encryptpassword="true", string description="", string initargs="", string args="", numeric MaxPooledStatements, numeric timeout, numeric interval, numeric login_timeout, numeric buffer, numeric blob_buffer, boolean enablemaxconnections, numeric maxconnections, boolean pooling, boolean disable, boolean disable_clob, boolean disable_blob, boolean disable_autogenkeys, boolean select, boolean create, boolean grant, boolean insert, boolean drop, boolean revoke, boolean update, boolean alter, boolean storedproc, string vendor="db2", string type="ddtek", string validationQuery="", numeric qTimeout, boolean delete, boolean useSpyLog, string spyLogFile, boolean validateConnection, boolean clientHostName, boolean clientuser, boolean applicationName, string applicationNamePrefix )
  177.  
  178. Creates or modifies a DB2 data source. Refer to the ColdFusion documentation or ColdFusion Administrator online Help for a list of supported DB2 versions.
  179.  
  180. Output: suppressed
  181. Parameters:
  182. name: string, required, name - ColdFusion data source name.
  183. host: string, required, host - Database server host name or IP address.
  184. database: string, required, database - Name of database on the server.
  185. originaldsn: string, optional, originaldsn - Original ColdFusion data source name (use if you are renaming this data source).
  186. port: string, optional, port - Port used to access the database server. The default is 50000.
  187. driver: string, optional, driver - JDBC driver.
  188. class: string, optional, class - Fully qualified JDBC driver class name.
  189. username: string, optional, username - Database username.
  190. password: string, optional, password - Database password.
  191. encryptpassword: boolean, optional, encryptpassword - Indicates whether to encrypt the password when storing it in the neo-query.xml file:
  192. True – Encrypt the password before storing it.
  193. False - Store the password in clear text.
  194.  
  195. Note: If you are updating a data source that already has an encrypted password, you must set this argument to false to avoid re-encrypting an encrypted password.
  196.  
  197. description: string, optional, description - Data source description.
  198. initargs: string, optional, initargs - Initialization connection string arguments, formatted (arg1=arg1value;arg2=arg2value).
  199. args: string, optional, args - Connection string arguments, formatted (arg1=arg1value;arg2=arg2value).
  200. MaxPooledStatements: numeric, optional, MaxPooledStatements - The maximum number of pooled statements.
  201. timeout: numeric, optional, timeout - The number of seconds that ColdFusion maintains an unused connection before destroying it.
  202. interval: numeric, optional, interval - The time (in seconds) that the server waits between cycles to check for expired data source connections to close.
  203. login_timeout: numeric, optional, login_timeout - The number of seconds before ColdFusion times out the data source connection login attempt.
  204. buffer: numeric, optional, buffer - The default buffer size, used if disable_clob is not specified or True. Default is 64000 bytes.
  205. blob_buffer: numeric, optional, blob_buffer - The default buffer size, used if disable_blob is not specified or True. Default is 64000 bytes.
  206. enablemaxconnections: boolean, optional, enablemaxconnections - Limit the number of data source connections to the value specified in the maxconnections argument.
  207. maxconnections: numeric, optional, maxconnections - The maximum number of data source connections; used if you specify True for the enablemaxconnections argument.
  208. pooling: boolean, optional, pooling - Enable server connection pooling for the data source.
  209. disable: boolean, optional, disable - Disable connections to data sources.
  210. disable_clob: boolean, optional, disable_clob - Specify False to return the entire contents of any CLOB/Text columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the buffer argument.
  211. disable_blob: boolean, optional, disable_blob - Specify False to return the entire contents of any BLOB/Image columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the blob_buffer setting.
  212. disable_autogenkeys: boolean, optional, disable_autogenkeys - Specify true to disable retrieval of autogenerated keys
  213. select: boolean, optional, select - Allow SQL SELECT statements.
  214. create: boolean, optional, create - Allow SQL CREATE statements.
  215. grant: boolean, optional, grant - Allow SQL GRANT statements.
  216. insert: boolean, optional, insert - Allow SQL INSERT statements.
  217. drop: boolean, optional, drop - Allow SQL DROP statements.
  218. revoke: boolean, optional, revoke - Allow SQL REVOKE statements.
  219. update: boolean, optional, update - Allow SQL UPDATE statements
  220. alter: boolean, optional, alter - Allow SQL ALTER statements.
  221. storedproc: boolean, optional, storedproc - Allow SQL stored procedure calls.
  222. vendor: string, optional, vendor - Always DB2.
  223. type: string, optional, type - Always ddtek.
  224. validationQuery: string, optional, validationQuery - Validation Query used by Coldfusion for validating the connection state when removing connections from the connection pool.
  225. qTimeout: numeric, optional, qTimeout - Sets the default query timeout for statements created by a connection. Default is 0 which means that the query doesnt timeout.
  226. delete: boolean, optional, delete - Allow SQL DELETE statements.
  227. useSpyLog: boolean, optional, useSpyLog - Specify true to log the activity with this datasource
  228. spyLogFile: string, optional, spyLogFile - Sets the log file for this datasource
  229. validateConnection: boolean, optional, validateConnection - Should the connection be validated before using from pool. If JDBC 4.0 is being used, isValid() api will be called else Validation Query if specified will be called.
  230. clientHostName: boolean, optional, clientHostName - If client host name client info should be set before using connection.
  231. clientuser: boolean, optional, clientuser - If client user name client info should be set before using connection.
  232. applicationName: boolean, optional, applicationName - If application name client info should be set before using connection.
  233. applicationNamePrefix: string, optional, applicationNamePrefix - Prefix to use for application name, if application name is checked.
  234.  
  235. setDerbyClient
  236. public void setDerbyClient ( required string name, required string host, required string database, string originaldsn="", string driver="Apache Derby Client", string class="org.apache.derby.jdbc.ClientDriver", string username="", string password="", boolean encryptpassword="true", string description="", string args, numeric timeout, numeric interval, numeric login_timeout, numeric buffer, numeric blob_buffer, boolean enablemaxconnections, numeric maxconnections, boolean pooling, boolean disable, boolean disable_clob, boolean disable_blob, boolean disable_autogenkeys, boolean select, boolean create, boolean grant, boolean insert, boolean drop, boolean revoke, boolean update, boolean alter, boolean storedproc, boolean delete, string validationQuery="", string port="1527", boolean validateConnection, boolean clientHostName, boolean clientuser, boolean applicationName, string applicationNamePrefix )
  237.  
  238. Creates or modifies an Apache Derby Client data source.
  239.  
  240. Output: suppressed
  241. Parameters:
  242. name: string, required, name - ColdFusion datasource name.
  243. host: string, required, host - Database server host name or IP address.
  244. database: string, required, database - Database name that corresponds to the data source.
  245. originaldsn: string, optional, originaldsn - Original ColdFusion datasource name, if you are renaming this dsn.
  246. driver: string, optional, driver - JDBC driver.
  247. class: string, optional, class - JDBC class file.
  248. username: string, optional, username - Database username.
  249. password: string, optional, password - Database password.
  250. encryptpassword: boolean, optional, encryptpassword - Indicates whether to encrypt the password when storing it in the neo-query.xml file:
  251. True – Encrypt the password before storing it.
  252. False - Store the password in clear text.
  253.  
  254. Note: If you are updating a data source that already has an encrypted password, you must set this argument to false to avoid re-encrypting an encrypted password.
  255.  
  256. description: string, optional, description - A description of this data source connection.
  257. args: string, optional, args - Connection string arguments, formatted (arg1=argvalue;arg2=argvalue).
  258. timeout: numeric, optional, timeout - The number of seconds that ColdFusion maintains an unused connection before destroying it.
  259. interval: numeric, optional, interval - The time (in seconds) that the server waits between cycles to check for expired data source connections to close.
  260. login_timeout: numeric, optional, login_timeout - The number of seconds before ColdFusion times out the data source connection login attempt.
  261. buffer: numeric, optional, buffer - The default buffer size, used if disable_clob is not specified or True. Default is 64000 bytes.
  262. blob_buffer: numeric, optional, blob_buffer - The default buffer size, used if disable_blob is not specified or True. Default is 64000 bytes.
  263. enablemaxconnections: boolean, optional, enablemaxconnections - Enables the maxconnections setting.
  264. maxconnections: numeric, optional, maxconnections - Limit connections to this maximum amount.
  265. pooling: boolean, optional, pooling - Enable server connection pooling for your data source.
  266. disable: boolean, optional, disable - Suspends all client connections to the data source.
  267. disable_clob: boolean, optional, disable_clob - Specify False to return the entire contents of any CLOB/Text columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the buffer argument.
  268. disable_blob: boolean, optional, disable_blob - Specify False to return the entire contents of any BLOB/Image columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the blob_buffer setting.
  269. disable_autogenkeys: boolean, optional, disable_autogenkeys - Specify true to disable retrieval of autogenerated keys
  270. select: boolean, optional, select - Allow SQL SELECT statements.
  271. create: boolean, optional, create - Allow SQL CREATE statements.
  272. grant: boolean, optional, grant - Allow SQL GRANT statements.
  273. insert: boolean, optional, insert - Allow SQL INSERT statements.
  274. drop: boolean, optional, drop - Allow SQL DROP statements.
  275. revoke: boolean, optional, revoke - Allow SQL REVOKE statements.
  276. update: boolean, optional, update - Allow SQL UPDATE statements.
  277. alter: boolean, optional, alter - Allow SQL ALTER statements.
  278. storedproc: boolean, optional, storedproc - Allow SQL stored procedure calls.
  279. delete: boolean, optional, delete - Allow SQL DELETE statements.
  280. validationQuery: string, optional, validationQuery - Validation Query used by Coldfusion for validating the connection state when removing connections from the connection pool.
  281. port: string, optional, port
  282. validateConnection: boolean, optional, validateConnection - Should the connection be validated before using from pool. If JDBC 4.0 is being used, isValid() api will be called else Validation Query if specified will be called.
  283. clientHostName: boolean, optional, clientHostName - If client host name client info should be set before using connection.
  284. clientuser: boolean, optional, clientuser - If client user name client info should be set before using connection.
  285. applicationName: boolean, optional, applicationName - If application name client info should be set before using connection.
  286. applicationNamePrefix: string, optional, applicationNamePrefix - Prefix to use for application name, if application name is checked.
  287.  
  288. setDerbyEmbedded
  289. public void setDerbyEmbedded ( required string name, required string database, string originaldsn="", string driver="Apache Derby Embedded", string class="org.apache.derby.jdbc.EmbeddedDriver", string username="", string password="", boolean encryptpassword="true", string description="", string args, boolean isnewdb="false", numeric timeout, numeric interval, numeric login_timeout, numeric buffer, numeric blob_buffer, boolean enablemaxconnections, numeric maxconnections, boolean pooling, numeric maxpooledstatements, boolean disable, boolean disable_clob, boolean disable_blob, boolean disable_autogenkeys, boolean select, boolean create, boolean grant, boolean insert, boolean drop, boolean revoke, boolean update, boolean alter, boolean storedproc, boolean delete, string validationQuery="", boolean validateConnection, boolean clientHostName, boolean clientuser, boolean applicationName, string applicationNamePrefix )
  290.  
  291. Creates or modifies an Apache Derby Embedded data source.
  292.  
  293. Output: suppressed
  294. Parameters:
  295. name: string, required, name - ColdFusion datasource name.
  296. database: string, required, database - Fully qualified path to the folder containing the Derby database.
  297. originaldsn: string, optional, originaldsn - Original ColdFusion datasource name, if you are renaming this dsn.
  298. driver: string, optional, driver - JDBC driver.
  299. class: string, optional, class - JDBC class file.
  300. username: string, optional, username - Database username.
  301. password: string, optional, password - Database password.
  302. encryptpassword: boolean, optional, encryptpassword - Indicates whether to encrypt the password when storing it in the neo-query.xml file:
  303. True – Encrypt the password before storing it.
  304. False - Store the password in clear text.
  305.  
  306. Note: If you are updating a data source that already has an encrypted password, you must set this argument to false to avoid re-encrypting an encrypted password.
  307.  
  308. description: string, optional, description - A description of this data source connection.
  309. args: string, optional, args - Connection string arguments, formatted (arg1=argvalue;arg2=argvalue).
  310. isnewdb: boolean, optional, isnewdb - Indicates whether the database needs to be created
  311. timeout: numeric, optional, timeout - The number of seconds that ColdFusion maintains an unused connection before destroying it.
  312. interval: numeric, optional, interval - The time (in seconds) that the server waits between cycles to check for expired data source connections to close.
  313. login_timeout: numeric, optional, login_timeout - The number of seconds before ColdFusion times out the data source connection login attempt.
  314. buffer: numeric, optional, buffer - The default buffer size, used if disable_clob is not specified or True. Default is 64000 bytes.
  315. blob_buffer: numeric, optional, blob_buffer - The default buffer size, used if disable_blob is not specified or True. Default is 64000 bytes.
  316. enablemaxconnections: boolean, optional, enablemaxconnections - Enables the maxconnections setting.
  317. maxconnections: numeric, optional, maxconnections - Limit connections to this maximum amount.
  318. pooling: boolean, optional, pooling - Enable server connection pooling for your data source.
  319. maxpooledstatements: numeric, optional, maxpooledstatements - Maximum number of pooled statements.
  320. disable: boolean, optional, disable - Suspends all client connections to the data source.
  321. disable_clob: boolean, optional, disable_clob - Specify False to return the entire contents of any CLOB/Text columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the buffer argument.
  322. disable_blob: boolean, optional, disable_blob - Specify False to return the entire contents of any BLOB/Image columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the blob_buffer setting.
  323. disable_autogenkeys: boolean, optional, disable_autogenkeys - Specify true to disable retrieval of autogenerated keys
  324. select: boolean, optional, select - Allow SQL SELECT statements.
  325. create: boolean, optional, create - Allow SQL CREATE statements.
  326. grant: boolean, optional, grant - Allow SQL GRANT statements.
  327. insert: boolean, optional, insert - Allow SQL INSERT statements.
  328. drop: boolean, optional, drop - Allow SQL DROP statements.
  329. revoke: boolean, optional, revoke - Allow SQL REVOKE statements.
  330. update: boolean, optional, update - Allow SQL UPDATE statements.
  331. alter: boolean, optional, alter - Allow SQL ALTER statements.
  332. storedproc: boolean, optional, storedproc - Allow SQL stored procedure calls.
  333. delete: boolean, optional, delete - Allow SQL DELETE statements.
  334. validationQuery: string, optional, validationQuery - Validation Query used by Coldfusion for validating the connection state when removing connections from the connection pool.
  335. validateConnection: boolean, optional, validateConnection - Should the connection be validated before using from pool. If JDBC 4.0 is being used, isValid() api will be called else Validation Query if specified will be called.
  336. clientHostName: boolean, optional, clientHostName - If client host name client info should be set before using connection.
  337. clientuser: boolean, optional, clientuser - If client user name client info should be set before using connection.
  338. applicationName: boolean, optional, applicationName - If application name client info should be set before using connection.
  339. applicationNamePrefix: string, optional, applicationNamePrefix - Prefix to use for application name, if application name is checked.
  340.  
  341. setInformix
  342. public void setInformix ( string vendor="informix", string type="ddtek", required string name, required string host, required string database, required string InformixServer, string originaldsn="", string port="1526", string driver="Informix", string class="macromedia.jdbc.MacromediaDriver", string username="", string password="", boolean encryptpassword="true", string description="", string args, numeric MaxPooledStatements, numeric timeout, numeric interval, numeric login_timeout, numeric buffer, numeric blob_buffer, boolean enablemaxconnections, numeric maxconnections, boolean pooling, boolean disable, boolean disable_clob, boolean disable_blob, boolean disable_autogenkeys, boolean select, boolean create, boolean grant, boolean insert, boolean drop, boolean revoke, boolean update, boolean alter, boolean storedproc, boolean delete, string validationQuery="", numeric qTimeout, boolean useSpyLog, string spyLogFile, boolean validateConnection, boolean clientHostName, boolean clientuser, boolean applicationName, string applicationNamePrefix )
  343.  
  344. Creates or modifies an Informix data source.
  345.  
  346. Output: suppressed
  347. Parameters:
  348. vendor: string, optional, vendor - Always Informix.
  349. type: string, optional, type - Always ddtek.
  350. name: string, required, name - ColdFusion data source name.
  351. host: string, required, host - Database server host name or IP address.
  352. database: string, required, database - Name of database on the server.
  353. InformixServer: string, required, InformixServer - Name of the Informix server that corresponds to the data source.
  354. originaldsn: string, optional, originaldsn - Original ColdFusion data source name (use if you are renaming this data source).
  355. port: string, optional, port - Port used to access the database server. The default is 1526.
  356. driver: string, optional, driver - JDBC driver.
  357. class: string, optional, class - JDBC driver class file.
  358. username: string, optional, username - Database username.
  359. password: string, optional, password - Database password.
  360. encryptpassword: boolean, optional, encryptpassword - Indicates whether to encrypt the password when storing it in the neo-query.xml file:
  361. True – Encrypt the password before storing it.
  362. False - Store the password in clear text.
  363.  
  364. Note: If you are updating a data source that already has an encrypted password, you must set this argument to false to avoid re-encrypting an encrypted password.
  365.  
  366. description: string, optional, description - Data source description.
  367. args: string, optional, args - Connection string arguments, formatted (arg1=argvalue;arg2=argvalue).
  368. MaxPooledStatements: numeric, optional, MaxPooledStatements - The maximum number of pooled statements.
  369. timeout: numeric, optional, timeout - The number of seconds that ColdFusion maintains an unused connection before destroying it.
  370. interval: numeric, optional, interval - The time (in seconds) that the server waits between cycles to check for expired data source connections to close.
  371. login_timeout: numeric, optional, login_timeout - The number of seconds before ColdFusion times out the data source connection login attempt.
  372. buffer: numeric, optional, buffer - The default buffer size, used if disable_clob is not specified or True. Default is 64000 bytes.
  373. blob_buffer: numeric, optional, blob_buffer - The default buffer size, used if disable_blob is not specified or True. Default is 64000 bytes.
  374. enablemaxconnections: boolean, optional, enablemaxconnections - Limit the number of data source connections to the value specified in the maxconnections argument.
  375. maxconnections: numeric, optional, maxconnections - The maximum number of data source connections; used if you specify True for the enablemaxconnections argument.
  376. pooling: boolean, optional, pooling - Enable server connection pooling for the data source.
  377. disable: boolean, optional, disable - Disable connections to data sources.
  378. disable_clob: boolean, optional, disable_clob - Specify False to return the entire contents of any CLOB/Text columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the buffer argument.
  379. disable_blob: boolean, optional, disable_blob - Specify False to return the entire contents of any BLOB/Image columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the blob_buffer setting.
  380. disable_autogenkeys: boolean, optional, disable_autogenkeys - Specify true to disable retrieval of autogenerated keys
  381. select: boolean, optional, select - Allow SQL SELECT statements.
  382. create: boolean, optional, create - Allow SQL CREATE statements.
  383. grant: boolean, optional, grant - Allow SQL GRANT statements.
  384. insert: boolean, optional, insert - Allow SQL INSERT statements.
  385. drop: boolean, optional, drop - Allow SQL DROP statements.
  386. revoke: boolean, optional, revoke - Allow SQL REVOKE statements.
  387. update: boolean, optional, update - Allow SQL UPDATE statements.
  388. alter: boolean, optional, alter - Allow SQL ALTER statements.
  389. storedproc: boolean, optional, storedproc - Allow SQL stored procedure calls.
  390. delete: boolean, optional, delete - Allow SQL DELETE statements.
  391. validationQuery: string, optional, validationQuery - Validation Query used by Coldfusion for validating the connection state when removing connections from the connection pool.
  392. qTimeout: numeric, optional, qTimeout - Sets the default query timeout for statements created by a connection. Default is 0 which means that the query doesnt timeout.
  393. useSpyLog: boolean, optional, useSpyLog - Specify true to log the activity with this datasource
  394. spyLogFile: string, optional, spyLogFile - Sets the log file for this datasource
  395. validateConnection: boolean, optional, validateConnection - Should the connection be validated before using from pool. If JDBC 4.0 is being used, isValid() api will be called else Validation Query if specified will be called.
  396. clientHostName: boolean, optional, clientHostName - If client host name client info should be set before using connection.
  397. clientuser: boolean, optional, clientuser - If client user name client info should be set before using connection.
  398. applicationName: boolean, optional, applicationName - If application name client info should be set before using connection.
  399. applicationNamePrefix: string, optional, applicationNamePrefix - Prefix to use for application name, if application name is checked.
  400.  
  401. setJNDI
  402. public void setJNDI ( required string name, required string jndiname, string driver="jndi", string type="j2ee", string originaldsn="", string username="", string password="", boolean encryptpassword="true", string description="", string jndienv="", numeric buffer, numeric blob_buffer, boolean disable_clob, boolean disable_blob, boolean disable_autogenkeys, boolean select, boolean create, boolean grant, boolean insert, boolean drop, boolean revoke, boolean update, boolean alter, boolean storedproc, boolean delete )
  403.  
  404. Creates a ColdFusion datasource that points to an already exsiting JNDI datasource
  405.  
  406. Output: suppressed
  407. Parameters:
  408. name: string, required, name - ColdFusion datasource name.
  409. jndiname: string, required, jndiname - URL of the JNDI datasource
  410. driver: string, optional, driver
  411. type: string, optional, type - J2EE datasource
  412. originaldsn: string, optional, originaldsn - Original ColdFusion datasource name, if you are renaming this dsn.
  413. username: string, optional, username - Database username.
  414. password: string, optional, password - Database password.
  415. encryptpassword: boolean, optional, encryptpassword - Indicates whether to encrypt the password when storing it in the neo-query.xml file:
  416. True – Encrypt the password before storing it.
  417. False - Store the password in clear text.
  418.  
  419. Note: If you are updating a data source that already has an encrypted password, you must set this argument to false to avoid re-encrypting an encrypted password.
  420.  
  421. description: string, optional, description - Description of this data source connection.
  422. jndienv: string, optional, jndienv - JNDI environment settings
  423. buffer: numeric, optional, buffer - The default buffer size, used if disable_clob is not specified or True. Default is 64000 bytes.
  424. blob_buffer: numeric, optional, blob_buffer - The default buffer size, used if disable_blob is not specified or True. Default is 64000 bytes.
  425. disable_clob: boolean, optional, disable_clob - Specify False to return the entire contents of any CLOB/Text columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the buffer argument.
  426. disable_blob: boolean, optional, disable_blob - Specify False to return the entire contents of any BLOB/Image columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the blob_buffer setting.
  427. disable_autogenkeys: boolean, optional, disable_autogenkeys - Specify true to disable retrieval of autogenerated keys
  428. select: boolean, optional, select - Allow SQL SELECT statements.
  429. create: boolean, optional, create - Allow SQL CREATE statements.
  430. grant: boolean, optional, grant - Allow SQL GRANT statements.
  431. insert: boolean, optional, insert - Allow SQL INSERT statements.
  432. drop: boolean, optional, drop - Allow SQL DROP statements.
  433. revoke: boolean, optional, revoke - Allow SQL REVOKE statements.
  434. update: boolean, optional, update - Allow SQL UPDATE statements.
  435. alter: boolean, optional, alter - Allow SQL ALTER statements.
  436. storedproc: boolean, optional, storedproc - Allow SQL stored procedure calls.
  437. delete: boolean, optional, delete - Allow SQL DELETE statements.
  438.  
  439. setMSAccess
  440. public void setMSAccess ( required string name, required string databasefile, string originaldsn="", string driver="MSAccess", string class="macromedia.jdbc.MacromediaDriver", string port="20004", string username="System", string password="", boolean encryptpassword="true", string description="", string args, string systemDatabaseFile, boolean UseTrustedConnection="true", string defaultusername="", numeric maxBufferSize, numeric pageTimeout="600", boolean TimeStampAsString="no", numeric timeout, numeric interval, numeric login_timeout, numeric buffer, numeric blob_buffer, boolean enablemaxconnections, numeric maxconnections, boolean pooling, boolean disable, boolean disable_clob, boolean disable_blob, boolean disable_autogenkeys, boolean select, boolean create, boolean grant, boolean insert, boolean drop, boolean revoke, boolean update, boolean alter, boolean storedproc, boolean delete, string validationQuery="", string defaultpassword="", boolean validateConnection, boolean clientHostName, boolean clientuser, boolean applicationName, string applicationNamePrefix )
  441.  
  442. Creates or modifies a Microsoft Access data source.
  443.  
  444. Output: suppressed
  445. Parameters:
  446. name: string, required, name - ColdFusion data source name.
  447. databasefile: string, required, databasefile - Fully qualified path to the file containing the Access MDB file.
  448. originaldsn: string, optional, originaldsn - Original ColdFusion data source name (use if you are renaming this data source).
  449. driver: string, optional, driver - JDBC driver.
  450. class: string, optional, class - Fully qualified JDBC driver class name.
  451. port: string, optional, port - Port used to access the database server. The default is 20004.
  452. username: string, optional, username - Database username.
  453. password: string, optional, password - Database password.
  454. encryptpassword: boolean, optional, encryptpassword - Indicates whether to encrypt the password when storing it in the neo-query.xml file:
  455. True – Encrypt the password before storing it.
  456. False - Store the password in clear text.
  457.  
  458. Note: If you are updating a data source that already has an encrypted password, you must set this argument to false to avoid re-encrypting an encrypted password.
  459.  
  460. description: string, optional, description - Data source description.
  461. args: string, optional, args - Connection string arguments, formatted (arg1=arg1value;arg2=arg2value).
  462. systemDatabaseFile: string, optional, systemDatabaseFile - For secure access to the database file, specify the fully qualified path name of the database that contains database security information. The system database is usually located in winnt\system32\system.mdw.
  463. UseTrustedConnection: boolean, optional, UseTrustedConnection - If selected, causes ODBC driver to use the credentials specified in the ODBC connection or the network login id.
  464. defaultusername: string, optional, defaultusername - The user name that the driver uses to connect to the data source if an application requests a connection without supplying a user name.
  465. maxBufferSize: numeric, optional, maxBufferSize - The total number of bytes that ColdFusion uses to cache application pages. Enter a value to optimize ColdFusion performance.
  466. pageTimeout: numeric, optional, pageTimeout - The number of milliseconds before a request for a ColdFusion page times out. The default is 600. If you observe excessive network activity when using this driver, increase the page timeout value.
  467. TimeStampAsString: boolean, optional, TimeStampAsString - Enable this setting if your application retrieves Date/Time data and then re-uses it in SQL statements without applying formatting (using functions such as DateFormat, TimeFormat, and CreateODBCDateTime). Specify True or False.
  468. timeout: numeric, optional, timeout - The number of seconds that ColdFusion maintains an unused connection before destroying it.
  469. interval: numeric, optional, interval - The time (in seconds) that the server waits between cycles to check for expired data source connections to close.
  470. login_timeout: numeric, optional, login_timeout - The number of seconds before ColdFusion times out the data source connection login attempt.
  471. buffer: numeric, optional, buffer - The default buffer size, used if disable_clob is not specified or True. Default is 64000 bytes.
  472. blob_buffer: numeric, optional, blob_buffer - The default buffer size, used if disable_blob is not specified or True. Default is 64000 bytes.
  473. enablemaxconnections: boolean, optional, enablemaxconnections - Limit the number of data source connections to the value specified in the maxconnections argument.
  474. maxconnections: numeric, optional, maxconnections - The maximum number of data source connections; used if you specify True for the enablemaxconnections argument.
  475. pooling: boolean, optional, pooling - Enable server connection pooling for the data source.
  476. disable: boolean, optional, disable - Disable connections to data sources.
  477. disable_clob: boolean, optional, disable_clob - Specify False to return the entire contents of any CLOB/Text columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the buffer argument.
  478. disable_blob: boolean, optional, disable_blob - Specify False to return the entire contents of any BLOB/Image columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the blob_buffer setting.
  479. disable_autogenkeys: boolean, optional, disable_autogenkeys - Specify true to disable retrieval of autogenerated keys
  480. select: boolean, optional, select - Allow SQL SELECT statements.
  481. create: boolean, optional, create - Allow SQL CREATE statements.
  482. grant: boolean, optional, grant - Allow SQL GRANT statements.
  483. insert: boolean, optional, insert - Allow SQL INSERT statements.
  484. drop: boolean, optional, drop - Allow SQL DROP statements.
  485. revoke: boolean, optional, revoke - Allow SQL REVOKE statements.
  486. update: boolean, optional, update - Allow SQL UPDATE statements.
  487. alter: boolean, optional, alter - Allow SQL ALTER statements.
  488. storedproc: boolean, optional, storedproc - Allow SQL stored procedure calls.
  489. delete: boolean, optional, delete - Allow SQL DELETE statements.
  490. validationQuery: string, optional, validationQuery - Validation Query used by Coldfusion for validating the connection state when removing connections from the connection pool.
  491. defaultpassword: string, optional, defaultpassword - The password that the driver uses to connect to the data source if an application requests a connection without supplying a user name.
  492. validateConnection: boolean, optional, validateConnection - Should the connection be validated before using from pool. If JDBC 4.0 is being used, isValid() api will be called else Validation Query if specified will be called.
  493. clientHostName: boolean, optional, clientHostName - If client host name client info should be set before using connection.
  494. clientuser: boolean, optional, clientuser - If client user name client info should be set before using connection.
  495. applicationName: boolean, optional, applicationName - If application name client info should be set before using connection.
  496. applicationNamePrefix: string, optional, applicationNamePrefix - Prefix to use for application name, if application name is checked.
  497.  
  498. setMSAccessUnicode
  499. public void setMSAccessUnicode ( required string name, required string databasefile, string originaldsn="", string driver="MSAccessJet", string class="com.inzoom.jdbcado.Driver", string username="", string password="", boolean encryptpassword="true", string description="", string args, numeric pageTimeout="600", numeric maxBufferSize, numeric timeout, numeric interval, numeric login_timeout, numeric buffer, numeric blob_buffer, boolean enablemaxconnections, numeric maxconnections, boolean pooling, boolean disable, boolean disable_clob, boolean disable_blob, boolean disable_autogenkeys, boolean select, boolean create, boolean grant, boolean insert, boolean drop, boolean revoke, boolean update, boolean alter, boolean storedproc, boolean delete, string validationQuery="", boolean validateConnection, boolean clientHostName, boolean clientuser, boolean applicationName, string applicationNamePrefix )
  500.  
  501. Creates or modifies a Microsoft Access Unicode data source.
  502.  
  503. Output: suppressed
  504. Parameters:
  505. name: string, required, name - ColdFusion datasource name.
  506. databasefile: string, required, databasefile - database name that corresponds to the data source.
  507. originaldsn: string, optional, originaldsn - original ColdFusion datasource name, if you are renaming this dsn.
  508. driver: string, optional, driver - JDBC driver.
  509. class: string, optional, class - JDBC class file.
  510. username: string, optional, username - Database username.
  511. password: string, optional, password - Database password.
  512. encryptpassword: boolean, optional, encryptpassword - Indicates whether to encrypt the password when storing it in the neo-query.xml file:
  513. True – Encrypt the password before storing it.
  514. False - Store the password in clear text.
  515.  
  516. Note: If you are updating a data source that already has an encrypted password, you must set this argument to false to avoid re-encrypting an encrypted password.
  517.  
  518. description: string, optional, description - Data source description.
  519. args: string, optional, args - Connection string arguments, formatted (arg1=argvalue;arg2=argvalue).
  520. pageTimeout: numeric, optional, pageTimeout - The number of milliseconds before a request for a ColdFusion page times out. The default is 600. If you observe excessive network activity when using this driver, increase the page timeout value.
  521. maxBufferSize: numeric, optional, maxBufferSize - The total number of bytes that ColdFusion uses to cache application pages. Enter a value to optimize ColdFusion performance.
  522. timeout: numeric, optional, timeout - The number of seconds that ColdFusion maintains an unused connection before destroying it.
  523. interval: numeric, optional, interval - The time (in seconds) that the server waits between cycles to check for expired data source connections to close.
  524. login_timeout: numeric, optional, login_timeout - The number of seconds before ColdFusion times out the data source connection login attempt.
  525. buffer: numeric, optional, buffer - The default buffer size, used if disable_clob is not specified or True. Default is 64000 bytes.
  526. blob_buffer: numeric, optional, blob_buffer - The default buffer size, used if disable_blob is not specified or True. Default is 64000 bytes.
  527. enablemaxconnections: boolean, optional, enablemaxconnections - Enables the maxconnections setting.
  528. maxconnections: numeric, optional, maxconnections - Limit connections to this maximum amount.
  529. pooling: boolean, optional, pooling - Enable server connection pooling for your data source.
  530. disable: boolean, optional, disable - Suspends all client connections to the data source.
  531. disable_clob: boolean, optional, disable_clob - Specify False to return the entire contents of any CLOB/Text columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the buffer argument.
  532. disable_blob: boolean, optional, disable_blob - Specify False to return the entire contents of any BLOB/Image columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the blob_buffer setting.
  533. disable_autogenkeys: boolean, optional, disable_autogenkeys - Specify true to disable retrieval of autogenerated keys
  534. select: boolean, optional, select - Allow SQL SELECT statements.
  535. create: boolean, optional, create - Allow SQL CREATE statements.
  536. grant: boolean, optional, grant - Allow SQL GRANT statements.
  537. insert: boolean, optional, insert - Allow SQL INSERT statements.
  538. drop: boolean, optional, drop - Allow SQL DROP statements.
  539. revoke: boolean, optional, revoke - Allow SQL REVOKE statements.
  540. update: boolean, optional, update - Allow SQL UPDATE statements.
  541. alter: boolean, optional, alter - Allow SQL ALTER statements.
  542. storedproc: boolean, optional, storedproc - Allow SQL stored procedure calls.
  543. delete: boolean, optional, delete - Allow SQL DELETE statements.
  544. validationQuery: string, optional, validationQuery - Validation Query used by Coldfusion for validating the connection state when removing connections from the connection pool.
  545. validateConnection: boolean, optional, validateConnection - Should the connection be validated before using from pool. If JDBC 4.0 is being used, isValid() api will be called else Validation Query if specified will be called.
  546. clientHostName: boolean, optional, clientHostName - If client host name client info should be set before using connection.
  547. clientuser: boolean, optional, clientuser - If client user name client info should be set before using connection.
  548. applicationName: boolean, optional, applicationName - If application name client info should be set before using connection.
  549. applicationNamePrefix: string, optional, applicationNamePrefix - Prefix to use for application name, if application name is checked.
  550.  
  551. setMSSQL
  552. public void setMSSQL ( string vendor="sqlserver", string type="ddtek", required string name, required string host, required string database, string originaldsn="", string port="1433", string driver="MSSQLServer", string class="macromedia.jdbc.MacromediaDriver", string username="", string password="", boolean encryptpassword="true", string description="", string args, boolean sendStringParametersAsUnicode, required string selectmethod="cursor", numeric MaxPooledStatements, numeric timeout, numeric interval, numeric login_timeout, numeric buffer, numeric blob_buffer, boolean enablemaxconnections, numeric maxconnections, boolean pooling, boolean disable, boolean disable_clob, boolean disable_blob, boolean disable_autogenkeys, boolean select, boolean create, boolean grant, boolean insert, boolean drop, boolean revoke, boolean update, boolean alter, boolean storedproc, boolean delete, string validationQuery="", numeric qTimeout, string applicationintent="readwrite", boolean useSpyLog, string spyLogFile, boolean validateConnection, boolean clientHostName, boolean clientuser, boolean applicationName, string applicationNamePrefix )
  553.  
  554. Creates or modifies a Microsoft SQL Server data source.
  555.  
  556. Output: suppressed
  557. Parameters:
  558. vendor: string, optional, vendor - Always Microsoft.
  559. type: string, optional, type - Always ddtek.
  560. name: string, required, name - ColdFusion datasource name.
  561. host: string, required, host - Database server host name or IP address.
  562. database: string, required, database - Database name that corresponds to the data source.
  563. originaldsn: string, optional, originaldsn - original ColdFusion datasource name, if you are renaming this dsn.
  564. port: string, optional, port - Port that is used to access the database server. (default 1433)
  565. driver: string, optional, driver - JDBC driver.
  566. class: string, optional, class - JDBC class file.
  567. username: string, optional, username - Database username
  568. password: string, optional, password - Database password.
  569. encryptpassword: boolean, optional, encryptpassword - Indicates whether to encrypt the password when storing it in the neo-query.xml file:
  570. True – Encrypt the password before storing it.
  571. False - Store the password in clear text.
  572.  
  573. Note: If you are updating a data source that already has an encrypted password, you must set this argument to false to avoid re-encrypting an encrypted password.
  574.  
  575. description: string, optional, description - A description for this data source connection.
  576. args: string, optional, args - Connection string arguments, formatted (arg1=argvalue;arg2=argvalue).
  577. sendStringParametersAsUnicode: boolean, optional, sendStringParametersAsUnicode - Enable Unicode for data sources configured for non-Latin characters
  578. selectmethod: string, required, selectmethod - Select Method (direct or cursor)
  579. MaxPooledStatements: numeric, optional, MaxPooledStatements - The maximum number of pooled statements.
  580. timeout: numeric, optional, timeout - The number of seconds that ColdFusion maintains an unused connection before destroying it.
  581. interval: numeric, optional, interval - The time (in seconds) that the server waits between cycles to check for expired data source connections to close.
  582. login_timeout: numeric, optional, login_timeout - The number of seconds before ColdFusion times out the data source connection login attempt.
  583. buffer: numeric, optional, buffer - The default buffer size, used if disable_clob is not specified or True. Default is 64000 bytes.
  584. blob_buffer: numeric, optional, blob_buffer - The default buffer size, used if disable_blob is not specified or True. Default is 64000 bytes.
  585. enablemaxconnections: boolean, optional, enablemaxconnections - Enables the maxconnections setting.
  586. maxconnections: numeric, optional, maxconnections - Limit connections to this maximum amount.
  587. pooling: boolean, optional, pooling - Enable server connection pooling for your data source.
  588. disable: boolean, optional, disable - Suspends all client connections to the data source.
  589. disable_clob: boolean, optional, disable_clob - Specify False to return the entire contents of any CLOB/Text columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the buffer argument.
  590. disable_blob: boolean, optional, disable_blob - Specify False to return the entire contents of any BLOB/Image columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the blob_buffer setting.
  591. disable_autogenkeys: boolean, optional, disable_autogenkeys - Specify true to disable retrieval of autogenerated keys
  592. select: boolean, optional, select - Allow SQL SELECT statements.
  593. create: boolean, optional, create - Allow SQL CREATE statements.
  594. grant: boolean, optional, grant - Allow SQL GRANT statements.
  595. insert: boolean, optional, insert - Allow SQL INSERT statements.
  596. drop: boolean, optional, drop - Allow SQL DROP statements.
  597. revoke: boolean, optional, revoke - Allow SQL REVOKE statements.
  598. update: boolean, optional, update - Allow SQL UPDATE statements.
  599. alter: boolean, optional, alter - Allow SQL ALTER statements.
  600. storedproc: boolean, optional, storedproc - Allow SQL stored procedure calls.
  601. delete: boolean, optional, delete - Allow SQL DELETE statements.
  602. validationQuery: string, optional, validationQuery - Validation Query used by Coldfusion for validating the connection state when removing connections from the connection pool.
  603. qTimeout: numeric, optional, qTimeout - Sets the default query timeout for statements created by a connection. Default is 0 which means that the query doesnt timeout.
  604. applicationintent: string, optional, applicationintent - Sets the default query timeout for statements created by a connection. Default is 0 which means that the query doesnt timeout.
  605. useSpyLog: boolean, optional, useSpyLog - Specify true to log the activity with this datasource
  606. spyLogFile: string, optional, spyLogFile - Sets the log file for this datasource
  607. validateConnection: boolean, optional, validateConnection - Should the connection be validated before using from pool. If JDBC 4.0 is being used, isValid() api will be called else Validation Query if specified will be called.
  608. clientHostName: boolean, optional, clientHostName - If client host name client info should be set before using connection.
  609. clientuser: boolean, optional, clientuser - If client user name client info should be set before using connection.
  610. applicationName: boolean, optional, applicationName - If application name client info should be set before using connection.
  611. applicationNamePrefix: string, optional, applicationNamePrefix - Prefix to use for application name, if application name is checked.
  612.  
  613. setMySQL5
  614. public void setMySQL5 ( required string name, required string host, required string database, string originaldsn="", string port="3306", string driver="MySQL5", string class="com.mysql.jdbc.Driver", string username="", string password="", boolean encryptpassword="true", string description="", string args, numeric timeout, numeric interval, numeric login_timeout, numeric buffer, numeric blob_buffer, boolean enablemaxconnections, numeric maxconnections, boolean pooling, boolean disable, boolean disable_clob, boolean disable_blob, boolean disable_autogenkeys, boolean select, boolean create, boolean grant, boolean insert, boolean drop, boolean revoke, boolean update, boolean alter, boolean storedproc, boolean delete, string validationQuery="", boolean validateConnection, boolean clientHostName, boolean clientuser, boolean applicationName, string applicationNamePrefix )
  615.  
  616. Creates or modifies a MySQL 4 or MySQL 5 data source.
  617.  
  618. Output: suppressed
  619. Parameters:
  620. name: string, required, name - ColdFusion datasource name.
  621. host: string, required, host - Database server host name or IP address.
  622. database: string, required, database - Database name that corresponds to the data source.
  623. originaldsn: string, optional, originaldsn - Original ColdFusion datasource name, if you are renaming this dsn.
  624. port: string, optional, port - Port that is used to access the database server. (default 3306)
  625. driver: string, optional, driver - JDBC driver.
  626. class: string, optional, class - JDBC class file.
  627. username: string, optional, username - Database username.
  628. password: string, optional, password - Database password.
  629. encryptpassword: boolean, optional, encryptpassword - Indicates whether to encrypt the password when storing it in the neo-query.xml file:
  630. True – Encrypt the password before storing it.
  631. False - Store the password in clear text.
  632.  
  633. Note: If you are updating a data source that already has an encrypted password, you must set this argument to false to avoid re-encrypting an encrypted password.
  634.  
  635. description: string, optional, description - A description of this data source connection.
  636. args: string, optional, args - Connection string arguments, formatted (arg1=argvalue;arg2=argvalue).
  637. timeout: numeric, optional, timeout - The number of seconds that ColdFusion maintains an unused connection before destroying it.
  638. interval: numeric, optional, interval - The time (in seconds) that the server waits between cycles to check for expired data source connections to close.
  639. login_timeout: numeric, optional, login_timeout - The number of seconds before ColdFusion times out the data source connection login attempt.
  640. buffer: numeric, optional, buffer - The default buffer size, used if disable_clob is not specified or True. Default is 64000 bytes.
  641. blob_buffer: numeric, optional, blob_buffer - The default buffer size, used if disable_blob is not specified or True. Default is 64000 bytes.
  642. enablemaxconnections: boolean, optional, enablemaxconnections - Enables the maxconnections setting.
  643. maxconnections: numeric, optional, maxconnections - Limit connections to this maximum amount.
  644. pooling: boolean, optional, pooling - Enable server connection pooling for your data source.
  645. disable: boolean, optional, disable - Suspends all client connections to the data source.
  646. disable_clob: boolean, optional, disable_clob - Specify False to return the entire contents of any CLOB/Text columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the buffer argument.
  647. disable_blob: boolean, optional, disable_blob - Specify False to return the entire contents of any BLOB/Image columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the blob_buffer setting.
  648. disable_autogenkeys: boolean, optional, disable_autogenkeys - Specify true to disable retrieval of autogenerated keys
  649. select: boolean, optional, select - Allow SQL SELECT statements.
  650. create: boolean, optional, create - Allow SQL CREATE statements.
  651. grant: boolean, optional, grant - Allow SQL GRANT statements.
  652. insert: boolean, optional, insert - Allow SQL INSERT statements.
  653. drop: boolean, optional, drop - Allow SQL DROP statements.
  654. revoke: boolean, optional, revoke - Allow SQL REVOKE statements.
  655. update: boolean, optional, update - Allow SQL UPDATE statements.
  656. alter: boolean, optional, alter - Allow SQL ALTER statements.
  657. storedproc: boolean, optional, storedproc - Allow SQL stored procedure calls.
  658. delete: boolean, optional, delete - Allow SQL DELETE statements.
  659. validationQuery: string, optional, validationQuery - Validation Query used by Coldfusion for validating the connection state when removing connections from the connection pool.
  660. validateConnection: boolean, optional, validateConnection - Should the connection be validated before using from pool. If JDBC 4.0 is being used, isValid() api will be called else Validation Query if specified will be called.
  661. clientHostName: boolean, optional, clientHostName - If client host name client info should be set before using connection.
  662. clientuser: boolean, optional, clientuser - If client user name client info should be set before using connection.
  663. applicationName: boolean, optional, applicationName - If application name client info should be set before using connection.
  664. applicationNamePrefix: string, optional, applicationNamePrefix - Prefix to use for application name, if application name is checked.
  665.  
  666. setMySQL_DD
  667. public void setMySQL_DD ( required string name, required string host, required string database, string originaldsn="", string port="3306", string driver="MySQL_DD", string class="macromedia.jdbc.MacromediaDriver", string username="", string password="", boolean encryptpassword="true", string description="", string args, numeric timeout, numeric interval, numeric login_timeout, numeric buffer, numeric blob_buffer, boolean enablemaxconnections, numeric maxconnections, boolean pooling, numeric maxpooledstatements, boolean disable, boolean disable_clob, boolean disable_blob, boolean disable_autogenkeys, boolean select, boolean create, boolean grant, boolean insert, boolean drop, boolean revoke, boolean update, boolean alter, boolean storedproc, boolean delete, string validationQuery="", numeric qTimeout, boolean useSpyLog, string spyLogFile, boolean validateConnection, boolean clientHostName, boolean clientuser, boolean applicationName, string applicationNamePrefix )
  668.  
  669. Creates or modifies a MySQL 5 datasource using drivers provided by DataDirect.
  670.  
  671. Output: suppressed
  672. Parameters:
  673. name: string, required, name - ColdFusion datasource name.
  674. host: string, required, host - Database server host name or IP address.
  675. database: string, required, database - Database name that corresponds to the data source.
  676. originaldsn: string, optional, originaldsn - Original ColdFusion datasource name, if you are renaming this dsn.
  677. port: string, optional, port - Port that is used to access the database server. (default 3306)
  678. driver: string, optional, driver - JDBC driver.
  679. class: string, optional, class - JDBC class file.
  680. username: string, optional, username - Database username.
  681. password: string, optional, password - Database password.
  682. encryptpassword: boolean, optional, encryptpassword - Indicates whether to encrypt the password when storing it in the neo-query.xml file:
  683. True – Encrypt the password before storing it.
  684. False - Store the password in clear text.
  685.  
  686. Note: If you are updating a data source that already has an encrypted password, you must set this argument to false to avoid re-encrypting an encrypted password.
  687.  
  688. description: string, optional, description - A description of this data source connection.
  689. args: string, optional, args - Connection string arguments, formatted (arg1=argvalue;arg2=argvalue).
  690. timeout: numeric, optional, timeout - The number of seconds that ColdFusion maintains an unused connection before destroying it.
  691. interval: numeric, optional, interval - The time (in seconds) that the server waits between cycles to check for expired data source connections to close.
  692. login_timeout: numeric, optional, login_timeout - The number of seconds before ColdFusion times out the data source connection login attempt.
  693. buffer: numeric, optional, buffer - The default buffer size, used if disable_clob is not specified or True. Default is 64000 bytes.
  694. blob_buffer: numeric, optional, blob_buffer - The default buffer size, used if disable_blob is not specified or True. Default is 64000 bytes.
  695. enablemaxconnections: boolean, optional, enablemaxconnections - Enables the maxconnections setting.
  696. maxconnections: numeric, optional, maxconnections - Limit connections to this maximum amount.
  697. pooling: boolean, optional, pooling - Enable server connection pooling for your data source.
  698. maxpooledstatements: numeric, optional, maxpooledstatements - Maximum number of pooled statements.
  699. disable: boolean, optional, disable - Suspends all client connections to the data source.
  700. disable_clob: boolean, optional, disable_clob - Specify False to return the entire contents of any CLOB/Text columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the buffer argument.
  701. disable_blob: boolean, optional, disable_blob - Specify False to return the entire contents of any BLOB/Image columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the blob_buffer setting.
  702. disable_autogenkeys: boolean, optional, disable_autogenkeys - Specify true to disable retrieval of autogenerated keys
  703. select: boolean, optional, select - Allow SQL SELECT statements.
  704. create: boolean, optional, create - Allow SQL CREATE statements.
  705. grant: boolean, optional, grant - Allow SQL GRANT statements.
  706. insert: boolean, optional, insert - Allow SQL INSERT statements.
  707. drop: boolean, optional, drop - Allow SQL DROP statements.
  708. revoke: boolean, optional, revoke - Allow SQL REVOKE statements.
  709. update: boolean, optional, update - Allow SQL UPDATE statements.
  710. alter: boolean, optional, alter - Allow SQL ALTER statements.
  711. storedproc: boolean, optional, storedproc - Allow SQL stored procedure calls.
  712. delete: boolean, optional, delete - Allow SQL DELETE statements.
  713. validationQuery: string, optional, validationQuery - Validation Query used by Coldfusion for validating the connection state when removing connections from the connection pool.
  714. qTimeout: numeric, optional, qTimeout - Sets the default query timeout for statements created by a connection. Default is 0 which means that the query doesnt timeout.
  715. useSpyLog: boolean, optional, useSpyLog - Specify true to log the activity with this datasource
  716. spyLogFile: string, optional, spyLogFile - Sets the log file for this datasource
  717. validateConnection: boolean, optional, validateConnection - Should the connection be validated before using from pool. If JDBC 4.0 is being used, isValid() api will be called else Validation Query if specified will be called.
  718. clientHostName: boolean, optional, clientHostName - If client host name client info should be set before using connection.
  719. clientuser: boolean, optional, clientuser - If client user name client info should be set before using connection.
  720. applicationName: boolean, optional, applicationName - If application name client info should be set before using connection.
  721. applicationNamePrefix: string, optional, applicationNamePrefix - Prefix to use for application name, if application name is checked.
  722.  
  723. setODBCSocket
  724. public void setODBCSocket ( required string name, required string datasource, string useTrustedConnection, string username="", string password="", boolean encryptpassword="true", string host="localhost", string originaldsn="", string port="20004", string driver="ODBCSocket", string class="macromedia.jdbc.MacromediaDriver", string description="", string args, boolean TimeStampAsString="no", numeric timeout, numeric interval, numeric login_timeout, numeric buffer, numeric blob_buffer, boolean enablemaxconnections, numeric maxconnections, boolean pooling, boolean disable, boolean disable_clob, boolean disable_blob, boolean disable_autogenkeys, boolean select, boolean create, boolean grant, boolean insert, boolean drop, boolean revoke, boolean update, boolean alter, boolean storedproc, boolean delete, string validationQuery="", boolean validateConnection, boolean clientHostName, boolean clientuser, boolean applicationName, string applicationNamePrefix )
  725.  
  726. Creates or modifies an ODBC socket data source.
  727.  
  728. Output: enabled
  729. Parameters:
  730. name: string, required, name - ColdFusion datasource name.
  731. datasource: string, required, datasource - name of ODBC datasource, defined in the server control panel.
  732. useTrustedConnection: string, optional, useTrustedConnection - If selected, causes ODBC driver to use the credentials specified in the ODBC connection or the network login id.
  733. username: string, optional, username - Database username.
  734. password: string, optional, password - Database password.
  735. encryptpassword: boolean, optional, encryptpassword - Indicates whether to encrypt the password when storing it in the neo-query.xml file:
  736. True – Encrypt the password before storing it.
  737. False - Store the password in clear text.
  738.  
  739. Note: If you are updating a data source that already has an encrypted password, you must set this argument to false to avoid re-encrypting an encrypted password.
  740.  
  741. host: string, optional, host - Database server host name or IP address.
  742. originaldsn: string, optional, originaldsn - Original ColdFusion datasource name, if you are renaming this dsn.
  743. port: string, optional, port - Port that is used to access the database server. (default 20004)
  744. driver: string, optional, driver - JDBC driver.
  745. class: string, optional, class - JDBC class file.
  746. description: string, optional, description - A description of this data source connection.
  747. args: string, optional, args - Connection string arguments, formatted (arg1=argvalue;arg2=argvalue).
  748. TimeStampAsString: boolean, optional, TimeStampAsString - Enable this setting if your application retrieves Date/Time data and then re-uses it in SQL statements without applying formatting (using functions such as DateFormat, TimeFormat, and CreateODBCDateTime). Specify True or False.
  749. timeout: numeric, optional, timeout - The number of seconds that ColdFusion maintains an unused connection before destroying it.
  750. interval: numeric, optional, interval - The time (in seconds) that the server waits between cycles to check for expired data source connections to close.
  751. login_timeout: numeric, optional, login_timeout - The number of seconds before ColdFusion times out the data source connection login attempt.
  752. buffer: numeric, optional, buffer - The default buffer size, used if disable_clob is not specified or True. Default is 64000 bytes.
  753. blob_buffer: numeric, optional, blob_buffer - The default buffer size, used if disable_blob is not specified or True. Default is 64000 bytes.
  754. enablemaxconnections: boolean, optional, enablemaxconnections - Enables the maxconnections setting.
  755. maxconnections: numeric, optional, maxconnections - Limit connections to this maximum amount.
  756. pooling: boolean, optional, pooling - Enable server connection pooling for your data source.
  757. disable: boolean, optional, disable - Suspends all client connections to the data source.
  758. disable_clob: boolean, optional, disable_clob - Specify False to return the entire contents of any CLOB/Text columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the buffer argument.
  759. disable_blob: boolean, optional, disable_blob - Specify False to return the entire contents of any BLOB/Image columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the blob_buffer setting.
  760. disable_autogenkeys: boolean, optional, disable_autogenkeys - Specify true to disable retrieval of autogenerated keys
  761. select: boolean, optional, select - Allow SQL SELECT statements.
  762. create: boolean, optional, create - Allow SQL CREATE statements.
  763. grant: boolean, optional, grant - Allow SQL GRANT statements.
  764. insert: boolean, optional, insert - Allow SQL INSERT statements.
  765. drop: boolean, optional, drop - Allow SQL DROP statements.
  766. revoke: boolean, optional, revoke - Allow SQL REVOKE statements.
  767. update: boolean, optional, update - Allow SQL UPDATE statements.
  768. alter: boolean, optional, alter - Allow SQL ALTER statements.
  769. storedproc: boolean, optional, storedproc - Allow SQL stored procedure calls.
  770. delete: boolean, optional, delete - Allow SQL DELETE statements.
  771. validationQuery: string, optional, validationQuery - Validation Query used by Coldfusion for validating the connection state when removing connections from the connection pool.
  772. validateConnection: boolean, optional, validateConnection - Should the connection be validated before using from pool. If JDBC 4.0 is being used, isValid() api will be called else Validation Query if specified will be called.
  773. clientHostName: boolean, optional, clientHostName - If client host name client info should be set before using connection.
  774. clientuser: boolean, optional, clientuser - If client user name client info should be set before using connection.
  775. applicationName: boolean, optional, applicationName - If application name client info should be set before using connection.
  776. applicationNamePrefix: string, optional, applicationNamePrefix - Prefix to use for application name, if application name is checked.
  777.  
  778. setOracle
  779. public void setOracle ( string vendor="oracle", string type="ddtek", required string name, required string host, required string sid, string originaldsn="", string port="1521", string driver="Oracle", string class="macromedia.jdbc.MacromediaDriver", string username="", string password="", boolean encryptpassword="true", string description="", string args, numeric MaxPooledStatements, numeric timeout, numeric interval, numeric login_timeout, numeric buffer, numeric blob_buffer, boolean enablemaxconnections, numeric maxconnections, boolean pooling, boolean disable, boolean disable_clob, boolean disable_blob, boolean disable_autogenkeys, boolean select, boolean create, boolean grant, boolean insert, boolean drop, boolean revoke, boolean update, boolean alter, boolean storedproc, boolean delete, string validationQuery="", numeric qTimeout, boolean useSpyLog, string spyLogFile, boolean supportLinks, boolean validateConnection, boolean clientHostName, boolean clientuser, boolean applicationName, string applicationNamePrefix )
  780.  
  781. Creates or modifies an Oracle data source.
  782.  
  783. Output: suppressed
  784. Parameters:
  785. vendor: string, optional, vendor - Always Oracle.
  786. type: string, optional, type - Always ddtek.
  787. name: string, required, name - ColdFusion datasource name.
  788. host: string, required, host - Database server host name or IP address.
  789. sid: string, required, sid - The Oracle System Identifier that refers to the instance of the Oracle database software running on the server. ORCL is the default.
  790. originaldsn: string, optional, originaldsn - Original ColdFusion datasource name, if you are renaming this dsn.
  791. port: string, optional, port - Port that is used to access the database server. (default 1521)
  792. driver: string, optional, driver - JDBC driver.
  793. class: string, optional, class - JDBC class file.
  794. username: string, optional, username - Database username.
  795. password: string, optional, password - Database password.
  796. encryptpassword: boolean, optional, encryptpassword - Indicates whether to encrypt the password when storing it in the neo-query.xml file:
  797. True – Encrypt the password before storing it.
  798. False - Store the password in clear text.
  799.  
  800. Note: If you are updating a data source that already has an encrypted password, you must set this argument to false to avoid re-encrypting an encrypted password.
  801.  
  802. description: string, optional, description - A description of this data source connection.
  803. args: string, optional, args - Connection string arguments, formatted (arg1=argvalue;arg2=argvalue).
  804. MaxPooledStatements: numeric, optional, MaxPooledStatements - The maximum number of pooled statements.
  805. timeout: numeric, optional, timeout - The number of seconds that ColdFusion maintains an unused connection before destroying it.
  806. interval: numeric, optional, interval - The time (in seconds) that the server waits between cycles to check for expired data source connections to close.
  807. login_timeout: numeric, optional, login_timeout - The number of seconds before ColdFusion times out the data source connection login attempt.
  808. buffer: numeric, optional, buffer - The default buffer size, used if disable_clob is not specified or True. Default is 64000 bytes.
  809. blob_buffer: numeric, optional, blob_buffer - The default buffer size, used if disable_blob is not specified or True. Default is 64000 bytes.
  810. enablemaxconnections: boolean, optional, enablemaxconnections - Enables the maxconnections setting.
  811. maxconnections: numeric, optional, maxconnections - Limit connections to this maximum amount.
  812. pooling: boolean, optional, pooling - Enable server connection pooling for your data source.
  813. disable: boolean, optional, disable - Suspends all client connections to the data source.
  814. disable_clob: boolean, optional, disable_clob - Specify False to return the entire contents of any CLOB/Text columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the buffer argument.
  815. disable_blob: boolean, optional, disable_blob - Specify False to return the entire contents of any BLOB/Image columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the blob_buffer setting.
  816. disable_autogenkeys: boolean, optional, disable_autogenkeys - Specify true to disable retrieval of autogenerated keys
  817. select: boolean, optional, select - Allow SQL SELECT statements.
  818. create: boolean, optional, create - Allow SQL CREATE statements.
  819. grant: boolean, optional, grant - Allow SQL GRANT statements.
  820. insert: boolean, optional, insert - Allow SQL INSERT statements.
  821. drop: boolean, optional, drop - Allow SQL DROP statements.
  822. revoke: boolean, optional, revoke - Allow SQL REVOKE statements.
  823. update: boolean, optional, update - Allow SQL UPDATE statements.
  824. alter: boolean, optional, alter - Allow SQL ALTER statements.
  825. storedproc: boolean, optional, storedproc - Allow SQL stored procedure calls.
  826. delete: boolean, optional, delete - Allow SQL DELETE statements.
  827. validationQuery: string, optional, validationQuery - Validation Query used by Coldfusion for validating the connection state when removing connections from the connection pool.
  828. qTimeout: numeric, optional, qTimeout - Sets the default query timeout for statements created by a connection. Default is 0 which means that the query doesnt timeout.
  829. useSpyLog: boolean, optional, useSpyLog - Specify true to log the activity with this datasource
  830. spyLogFile: string, optional, spyLogFile - Sets the log file for this datasource
  831. supportLinks: boolean, optional, supportLinks - Enables Oracle Linked Servers support
  832. validateConnection: boolean, optional, validateConnection - Should the connection be validated before using from pool. If JDBC 4.0 is being used, isValid() api will be called else Validation Query if specified will be called.
  833. clientHostName: boolean, optional, clientHostName - If client host name client info should be set before using connection.
  834. clientuser: boolean, optional, clientuser - If client user name client info should be set before using connection.
  835. applicationName: boolean, optional, applicationName - If application name client info should be set before using connection.
  836. applicationNamePrefix: string, optional, applicationNamePrefix - Prefix to use for application name, if application name is checked.
  837.  
  838. setOther
  839. public void setOther ( required string name, required string url, required string class, string driver, string originaldsn="", string port="1433", string username="", string password="", boolean encryptpassword="true", string description="", string args, required string selectmethod="cursor", numeric MaxPooledStatements, numeric timeout, numeric interval, numeric login_timeout, numeric buffer, numeric blob_buffer, boolean enablemaxconnections, numeric maxconnections, boolean pooling="false", boolean disable, boolean disable_clob, boolean disable_blob, boolean disable_autogenkeys, boolean select, boolean create, boolean grant, boolean insert, boolean drop, boolean revoke, boolean update, boolean alter, boolean storedproc, boolean delete, string validationQuery="", boolean validateConnection, boolean clientHostName, boolean clientuser, boolean applicationName, string applicationNamePrefix )
  840.  
  841. Creates or modifies a user-defined data source
  842.  
  843. Output: enabled
  844. Parameters:
  845. name: string, required, name - ColdFusion datasource name.
  846. url: string, required, url - The JDBC Connection URL for this data source.
  847. class: string, required, class - JDBC class file.
  848. driver: string, optional, driver - JDBC driver.
  849. originaldsn: string, optional, originaldsn - Original ColdFusion datasource name, if you are renaming this dsn.
  850. port: string, optional, port - port that is used to access the database server. (default 1433)
  851. username: string, optional, username - Database username.
  852. password: string, optional, password - Database password.
  853. encryptpassword: boolean, optional, encryptpassword - Indicates whether to encrypt the password when storing it in the neo-query.xml file:
  854. True – Encrypt the password before storing it.
  855. False - Store the password in clear text.
  856.  
  857. Note: If you are updating a data source that already has an encrypted password, you must set this argument to false to avoid re-encrypting an encrypted password.
  858.  
  859. description: string, optional, description - A description of this data source connection.
  860. args: string, optional, args - Connection string arguments, formatted (arg1=argvalue;arg2=argvalue).
  861. selectmethod: string, required, selectmethod - Select Method (direct or cursor).
  862. MaxPooledStatements: numeric, optional, MaxPooledStatements - The maximum number of pooled statements.
  863. timeout: numeric, optional, timeout - The number of seconds that ColdFusion maintains an unused connection before destroying it.
  864. interval: numeric, optional, interval - The time (in seconds) that the server waits between cycles to check for expired data source connections to close.
  865. login_timeout: numeric, optional, login_timeout - The number of seconds before ColdFusion times out the data source connection login attempt.
  866. buffer: numeric, optional, buffer - The default buffer size, used if disable_clob is not specified or True. Default is 64000 bytes.
  867. blob_buffer: numeric, optional, blob_buffer - The default buffer size, used if disable_blob is not specified or True. Default is 64000 bytes.
  868. enablemaxconnections: boolean, optional, enablemaxconnections - Enables the maxconnections setting.
  869. maxconnections: numeric, optional, maxconnections - Limit connections to this maximum amount.
  870. pooling: boolean, optional, pooling - Enable server connection pooling for your data source.
  871. disable: boolean, optional, disable - Suspends all client connections to the data source.
  872. disable_clob: boolean, optional, disable_clob - Specify False to return the entire contents of any CLOB/Text columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the buffer argument.
  873. disable_blob: boolean, optional, disable_blob - Specify False to return the entire contents of any BLOB/Image columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the blob_buffer setting.
  874. disable_autogenkeys: boolean, optional, disable_autogenkeys - Specify true to disable retrieval of autogenerated keys
  875. select: boolean, optional, select - Allow SQL SELECT statements.
  876. create: boolean, optional, create - Allow SQL CREATE statements.
  877. grant: boolean, optional, grant - Allow SQL GRANT statements.
  878. insert: boolean, optional, insert - Allow SQL INSERT statements.
  879. drop: boolean, optional, drop - Allow SQL DROP statements.
  880. revoke: boolean, optional, revoke - Allow SQL REVOKE statements.
  881. update: boolean, optional, update - Allow SQL UPDATE statements.
  882. alter: boolean, optional, alter - Allow SQL ALTER statements.
  883. storedproc: boolean, optional, storedproc - Allow SQL stored procedure calls.
  884. delete: boolean, optional, delete - Allow SQL DELETE statements.
  885. validationQuery: string, optional, validationQuery - Validation Query used by Coldfusion for validating the connection state when removing connections from the connection pool.
  886. validateConnection: boolean, optional, validateConnection - Should the connection be validated before using from pool. If JDBC 4.0 is being used, isValid() api will be called else Validation Query if specified will be called.
  887. clientHostName: boolean, optional, clientHostName - If client host name client info should be set before using connection.
  888. clientuser: boolean, optional, clientuser - If client user name client info should be set before using connection.
  889. applicationName: boolean, optional, applicationName - If application name client info should be set before using connection.
  890. applicationNamePrefix: string, optional, applicationNamePrefix - Prefix to use for application name, if application name is checked.
  891.  
  892. setPostGreSQL
  893. public void setPostGreSQL ( required string name, required string host, required string database, string originaldsn="", string port="5432", string driver="PostgreSQL", string class="org.postgresql.Driver", string username="", string password="", boolean encryptpassword="true", string description="", string args, numeric timeout, numeric interval, numeric login_timeout, numeric buffer, numeric blob_buffer, boolean enablemaxconnections, numeric maxconnections, boolean pooling, boolean disable, boolean disable_clob, boolean disable_blob, boolean disable_autogenkeys, boolean select, boolean create, boolean grant, boolean insert, boolean drop, boolean revoke, boolean update, boolean alter, boolean storedproc, boolean delete, string validationQuery="", boolean validateConnection, boolean clientHostName, boolean clientuser, boolean applicationName, string applicationNamePrefix )
  894.  
  895. Creates or modifies a PostGreSQL data source.
  896.  
  897. Output: suppressed
  898. Parameters:
  899. name: string, required, name - ColdFusion datasource name.
  900. host: string, required, host - Database server host name or IP address.
  901. database: string, required, database - Database name that corresponds to the data source.
  902. originaldsn: string, optional, originaldsn - original ColdFusion datasource name, if you are renaming this dsn.
  903. port: string, optional, port - Port that is used to access the database server. (default 5432)
  904. driver: string, optional, driver - JDBC driver.
  905. class: string, optional, class - JDBC class file.
  906. username: string, optional, username - Database username
  907. password: string, optional, password - Database password.
  908. encryptpassword: boolean, optional, encryptpassword - Indicates whether to encrypt the password when storing it in the neo-datasource.xml file:
  909. True – Encrypt the password before storing it.
  910. False - Store the password in clear text.
  911.  
  912. Note: If you are updating a data source that already has an encrypted password, you must set this argument to false to avoid re-encrypting an encrypted password.
  913.  
  914. description: string, optional, description - A description for this data source connection.
  915. args: string, optional, args - Connection string arguments, formatted (arg1=argvalue;arg2=argvalue).
  916. timeout: numeric, optional, timeout - The number of seconds that ColdFusion maintains an unused connection before destroying it.
  917. interval: numeric, optional, interval - The time (in seconds) that the server waits between cycles to check for expired data source connections to close.
  918. login_timeout: numeric, optional, login_timeout - The number of seconds before ColdFusion times out the data source connection login attempt.
  919. buffer: numeric, optional, buffer - The default buffer size, used if disable_clob is not specified or True. Default is 64000 bytes.
  920. blob_buffer: numeric, optional, blob_buffer - The default buffer size, used if disable_blob is not specified or True. Default is 64000 bytes.
  921. enablemaxconnections: boolean, optional, enablemaxconnections - Enables the maxconnections setting.
  922. maxconnections: numeric, optional, maxconnections - Limit connections to this maximum amount.
  923. pooling: boolean, optional, pooling - Enable server connection pooling for your data source.
  924. disable: boolean, optional, disable - Suspends all client connections to the data source.
  925. disable_clob: boolean, optional, disable_clob - Specify False to return the entire contents of any CLOB/Text columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the buffer argument.
  926. disable_blob: boolean, optional, disable_blob - Specify False to return the entire contents of any BLOB/Image columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the blob_buffer setting.
  927. disable_autogenkeys: boolean, optional, disable_autogenkeys - Specify true to disable retrieval of autogenerated keys
  928. select: boolean, optional, select - Allow SQL SELECT statements.
  929. create: boolean, optional, create - Allow SQL CREATE statements.
  930. grant: boolean, optional, grant - Allow SQL GRANT statements.
  931. insert: boolean, optional, insert - Allow SQL INSERT statements.
  932. drop: boolean, optional, drop - Allow SQL DROP statements.
  933. revoke: boolean, optional, revoke - Allow SQL REVOKE statements.
  934. update: boolean, optional, update - Allow SQL UPDATE statements.
  935. alter: boolean, optional, alter - Allow SQL ALTER statements.
  936. storedproc: boolean, optional, storedproc - Allow SQL stored procedure calls.
  937. delete: boolean, optional, delete - Allow SQL DELETE statements.
  938. validationQuery: string, optional, validationQuery - Validation Query used by Coldfusion for validating the connection state when removing connections from the connection pool.
  939. validateConnection: boolean, optional, validateConnection - Should the connection be validated before using from pool. If JDBC 4.0 is being used, isValid() api will be called else Validation Query if specified will be called.
  940. clientHostName: boolean, optional, clientHostName - If client host name client info should be set before using connection.
  941. clientuser: boolean, optional, clientuser - If client user name client info should be set before using connection.
  942. applicationName: boolean, optional, applicationName - If application name client info should be set before using connection.
  943. applicationNamePrefix: string, optional, applicationNamePrefix - Prefix to use for application name, if application name is checked.
  944.  
  945. setSlsServerServiceName*
  946. private String setSlsServerServiceName ( required serviceName )
  947.  
  948. Adds a new SequeLink service name
  949.  
  950. Output: suppressed
  951. Parameters:
  952. serviceName: any, required, serviceName - SequeLink service name
  953.  
  954. setSybase
  955. public void setSybase ( string vendor="sybase", string type="ddtek", required string name, required string host, required string database, string originaldsn="", string port="5000", string driver="Sybase", string class="macromedia.jdbc.MacromediaDriver", string username="", string password="", boolean encryptpassword="true", string description="", string args, string selectmethod="direct", numeric MaxPooledStatements, numeric timeout, numeric interval, numeric login_timeout, numeric buffer, numeric blob_buffer, boolean enablemaxconnections, numeric maxconnections, boolean pooling, boolean disable, boolean disable_clob, boolean disable_blob, boolean disable_autogenkeys, boolean select, boolean create, boolean grant, boolean insert, boolean drop, boolean revoke, boolean update, boolean alter, boolean storedproc, boolean delete, string validationQuery="", numeric qTimeout, boolean useSpyLog, string spyLogFile, boolean validateConnection, boolean clientHostName, boolean clientuser, boolean applicationName, string applicationNamePrefix )
  956.  
  957. Creates or modifies a Sybase data source.
  958.  
  959. Output: suppressed
  960. Parameters:
  961. vendor: string, optional, vendor - Always Sybase.
  962. type: string, optional, type - Always ddtek.
  963. name: string, required, name - ColdFusion datasource name.
  964. host: string, required, host - Database server host name or IP address.
  965. database: string, required, database - Database name that corresponds to the data source.
  966. originaldsn: string, optional, originaldsn - Original ColdFusion datasource name, if you are renaming this dsn.
  967. port: string, optional, port - Port that is used to access the database server. (default 5000)
  968. driver: string, optional, driver - JDBC driver.
  969. class: string, optional, class - JDBC class file.
  970. username: string, optional, username - Database username.
  971. password: string, optional, password - Database password.
  972. encryptpassword: boolean, optional, encryptpassword - Indicates whether to encrypt the password when storing it in the neo-query.xml file:
  973. True – Encrypt the password before storing it.
  974. False - Store the password in clear text.
  975.  
  976. Note: If you are updating a data source that already has an encrypted password, you must set this argument to false to avoid re-encrypting an encrypted password.
  977.  
  978. description: string, optional, description - Description of this data source connection.
  979. args: string, optional, args - Connection string arguments, formatted (arg1=argvalue;arg2=argvalue).
  980. selectmethod: string, optional, selectmethod - Select Method (direct or cursor).
  981. MaxPooledStatements: numeric, optional, MaxPooledStatements - The maximum number of pooled statements.
  982. timeout: numeric, optional, timeout - The number of seconds that ColdFusion maintains an unused connection before destroying it.
  983. interval: numeric, optional, interval - The time (in seconds) that the server waits between cycles to check for expired data source connections to close.
  984. login_timeout: numeric, optional, login_timeout - The number of seconds before ColdFusion times out the data source connection login attempt.
  985. buffer: numeric, optional, buffer - The default buffer size, used if disable_clob is not specified or True. Default is 64000 bytes.
  986. blob_buffer: numeric, optional, blob_buffer - The default buffer size, used if disable_blob is not specified or True. Default is 64000 bytes.
  987. enablemaxconnections: boolean, optional, enablemaxconnections - Enables the maxconnections setting.
  988. maxconnections: numeric, optional, maxconnections - Limit connections to this maximum amount.
  989. pooling: boolean, optional, pooling - Enable server connection pooling for your data source.
  990. disable: boolean, optional, disable - Suspends all client connections to the data source.
  991. disable_clob: boolean, optional, disable_clob - Specify False to return the entire contents of any CLOB/Text columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the buffer argument.
  992. disable_blob: boolean, optional, disable_blob - Specify False to return the entire contents of any BLOB/Image columns in the database. If you specify False, ColdFusion retrieves up to the amount specified in the blob_buffer setting.
  993. disable_autogenkeys: boolean, optional, disable_autogenkeys - Specify true to disable retrieval of autogenerated keys
  994. select: boolean, optional, select - Allow SQL SELECT statements.
  995. create: boolean, optional, create - Allow SQL CREATE statements.
  996. grant: boolean, optional, grant - Allow SQL GRANT statements.
  997. insert: boolean, optional, insert - Allow SQL INSERT statements.
  998. drop: boolean, optional, drop - Allow SQL DROP statements.
  999. revoke: boolean, optional, revoke - Allow SQL REVOKE statements.
  1000. update: boolean, optional, update - Allow SQL UPDATE statements.
  1001. alter: boolean, optional, alter - Allow SQL ALTER statements.
  1002. storedproc: boolean, optional, storedproc - Allow SQL stored procedure calls.
  1003. delete: boolean, optional, delete - Allow SQL DELETE statements.
  1004. validationQuery: string, optional, validationQuery - Validation Query used by Coldfusion for validating the connection state when removing connections from the connection pool.
  1005. qTimeout: numeric, optional, qTimeout - Sets the default query timeout for statements created by a connection. Default is 0 which means that the query doesnt timeout.
  1006. useSpyLog: boolean, optional, useSpyLog - Specify true to log the activity with this datasource
  1007. spyLogFile: string, optional, spyLogFile - Sets the log file for this datasource
  1008. validateConnection: boolean, optional, validateConnection - Should the connection be validated before using from pool. If JDBC 4.0 is being used, isValid() api will be called else Validation Query if specified will be called.
  1009. clientHostName: boolean, optional, clientHostName - If client host name client info should be set before using connection.
  1010. clientuser: boolean, optional, clientuser - If client user name client info should be set before using connection.
  1011. applicationName: boolean, optional, applicationName - If application name client info should be set before using connection.
  1012. applicationNamePrefix: string, optional, applicationNamePrefix - Prefix to use for application name, if application name is checked.
  1013.  
  1014. sl54Add*
  1015. private sl54Add ( required dsn, required odbcdsn, connectString, boolean TimeStampAsString="no" )
  1016.  
  1017. Adds a datasource to the SequeLink configuration.
  1018.  
  1019. Available only for users in one of the roles: admin
  1020. Output: suppressed
  1021. Parameters:
  1022. dsn: any, required, dsn - Name that ColdFusion uses to connect to the data source.
  1023. odbcdsn: any, required, odbcdsn - Name of the ODBC data source that ColdFusion is to connect to.
  1024. connectString: any, optional, connectString - Passes database-specific parameters, such as login credentials, to the data source.
  1025. TimeStampAsString: boolean, optional, TimeStampAsString - Enable this setting if your application retrieves Date/Time data and then re-uses it in SQL statements without applying formatting (using functions such as DateFormat, TimeFormat, and CreateODBCDateTime). Specify True or False.
  1026.  
  1027. sl54Del*
  1028. private sl54Del ( required dsn )
  1029.  
  1030. Removes a data source from the SequeLink configuration.
  1031.  
  1032. Available only for users in one of the roles: admin
  1033. Output: suppressed
  1034. Parameters:
  1035. dsn: any, required, dsn - Name that ColdFusion uses to connect to the data source.
  1036.  
  1037. sl54displ*
  1038. private sl54displ ( required dsn )
  1039.  
  1040. Available only for users in one of the roles: admin
  1041. Output: suppressed
  1042. Parameters:
  1043. dsn: any, required, dsn
  1044.  
  1045. sl54mlog*
  1046. private sl54mlog ( required odbcdsn, logonmethod="OSIntegrated" )
  1047.  
  1048. Modifies the DBMS logon for the data source to SequeLink configuration.
  1049.  
  1050. Available only for users in one of the roles: admin
  1051. Output: suppressed
  1052. Parameters:
  1053. odbcdsn: any, required, odbcdsn - Name of the ODBC data source that ColdFusion is to connect to.
  1054. logonmethod: any, optional, logonmethod - When anonymous: OSIntegrated; when not anonymous DBMSLOGON(userid, password)
  1055.  
  1056. sl54mod*
  1057. private sl54mod ( required dsn, required odbcdsn, connectString, boolean TimeStampAsString="no" )
  1058.  
  1059. Modifies an ODBC data source connection string in the SequeLink configuration.
  1060.  
  1061. Available only for users in one of the roles: admin
  1062. Output: suppressed
  1063. Parameters:
  1064. dsn: any, required, dsn - Name that ColdFusion uses to connect to the data source.
  1065. odbcdsn: any, required, odbcdsn - Name of the ODBC data source that ColdFusion is to connect to.
  1066. connectString: any, optional, connectString - Passes database-specific parameters, such as login credentials, to the data source.
  1067. TimeStampAsString: boolean, optional, TimeStampAsString - Enable this setting if your application retrieves Date/Time data and then re-uses it in SQL statements without applying formatting (using functions such as DateFormat, TimeFormat, and CreateODBCDateTime). Specify True or False.
  1068.  
  1069. startOdbcService
  1070. public startOdbcService ( )
  1071.  
  1072. Starts ODBC service.
  1073.  
  1074. Output: suppressed
  1075.  
  1076. stopOdbcService
  1077. public void stopOdbcService ( )
  1078.  
  1079. Stops ODBC service.
  1080.  
  1081. Output: suppressed
  1082.  
  1083. updateODBCServerDSN*
  1084. private updateODBCServerDSN ( required dsn, required odbcdsn, required connectstring, required TimeStampAsString, required LOGONMETHOD )
  1085.  
  1086. Updates an ODBC server data source name.
  1087.  
  1088. Output: suppressed
  1089. Parameters:
  1090. dsn: any, required, dsn - Name that ColdFusion uses to connect to the data source.
  1091. odbcdsn: any, required, odbcdsn - The ODBC data source name to which ColdFusion is to connect.
  1092. connectstring: any, required, connectstring - Passes database-specific parameters, such as login credentials, to the data source.
  1093. TimeStampAsString: any, required, TimeStampAsString - Enable this setting if your application retrieves Date/Time data and then re-uses it in SQL statements without applying formatting (using functions such as DateFormat, TimeFormat, and CreateODBCDateTime). Specify True or False.
  1094. LOGONMETHOD: any, required, LOGONMETHOD - Internal method called to the register the database.
  1095.  
  1096. upgradeOdbcService*
  1097. private upgradeOdbcService ( odbcserver="[runtime expression]", odbcagent="[runtime expression]" )
  1098.  
  1099. Upgrade ODBC service.
  1100.  
  1101. Output: suppressed
  1102. Parameters:
  1103. odbcserver: any, optional, odbcserver - Name of ODBC server service.
  1104. odbcagent: any, optional, odbcagent - Name of ODBC agent service.
  1105.  
  1106. verifyDsn
  1107. public Any verifyDsn ( required dsn, boolean returnMsgOnError="false" )
  1108.  
  1109. Verifies a given data source name.
  1110.  
  1111. Output: suppressed
  1112. Parameters:
  1113. dsn: any, required, dsn - Name that ColdFusion uses to connect to the data source.
  1114. returnMsgOnError: boolean, optional, returnMsgOnError - The function returns the error message on any error if this parameter is true
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!