Adobe Community : All Content - All Communities

Change Default Connection Properties for SQL Server / ColdFusion 7

forums_noreply@adobe.com — Wed, 25 Jun 2008 13:49:40 GMT

Change Default Connection Properties for SQL Server / ColdFusion 7

I've started working with indexed views in my Microsoft SQL Server 2005 database. Whenever a SQL statement alters a field ( INSERT, UPDATE, DELETE ) used by the index on an indexed view certain connection settings must be set.

SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
SET CONCAT_NULL_YIELDS_NULL ON
SET NUMERIC_ROUNDABORT OFF
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON

When ColdFusion connects to SQL server the ARIHABORT setting is OFF causing SQL statements to fail.

I currently have two workarounds for this:

1. Use a stored procedure created with the required settings.

2. Run a cfquery containing the required settings before the UPDATE, INSERT, or DELETE cfquery statement.

Questions:

1. Is it possible to configure ColdFusion's connection to set ARITHABORT ON by default?

2. Does Microsoft's JDBC driver use this setting by default?

My environment:
Microsoft SQL Server 2005
ColdFusion 7.0.2
Windows 2003
Using the SQL Server drivers bundled with CF7

References:
Improving Performance with SQL Server 2005 Indexed Views
http://www.microsoft.com/technet/prodtechnol/sql/2005/impprfiv.mspx

PRB: Error "INSERT Failed" When You Update Table Referenced in an Indexed View
http://support.microsoft.com/kb/305333

Any help is appreciated.

Unable to Consume Windows Communication Foundation Web Service with Basic Authentication

forums_noreply@adobe.com — Wed, 19 May 2010 15:50:17 GMT

I have a problem when trying to consume a web service based on the Windows Communication Foundation (WCF) using ColdFusion 8.0.1 on Windows 2003/IIS.  The web service in question requires basic authentication.  Both the CF and WCF web service servers are in house.  My goal is to expose some business logic written in WCF to my CF web site.

I receive the following ColdFusion error message when attempting to consume the service:
Cannot generate stub objects for web service invocation.
Name: http://example.com/MyService.svc?wsdl. WSDL: http://example.com/MyService.svc?wsdl. java.io.IOException: Server returned HTTP response code: 401 for URL: http://example.com/MyService.svc?xsd=xsd0 It is recommended that you use a web browser to retrieve and examine the requested WSDL document to ensure it is correct. If the requested WSDL document cannot be retrieved or is dynamically generated, it is likely that the target web service has programming errors. 



I have examined the web logs from the web service machine and it appears that the request to the WSDL URL specified in the CFOBJECT tag includes the required basic authentication user name and password.  WCF web service WSDL information is not contained in a single file.  The WSDL contains multiple import instructions that require additional URLs to be requested.  For example MyService.svc?wsdl would contain an instruction to import a file at MyService.svc?xsd=xsd0. This appears to be the cause of the failure.  The username and password is not being supplied to the requests for the additional files.


Here are snippets from the IIS logs on the WCF web serivce machine:

This request succeeded, the "200" is HTTP OK:
2010-05-19 16:49:16 W3SVC1 10.10.10.10 GET /MyService.svc wsdl 80 my_user_name 10.10.10.11 - 200 0 0

This request failed, the "401" indicates that the request did not include the required authentication info:
2010-05-19 16:49:16 W3SVC1 10.10.10.10 GET /MyService.svc xsd=xsd0 80 - 10.10.10.11 Java/1.6.0_04 401 2 2148074254


I have attempted to use the wsdl2javaArgs attribute of the CFOBJECT tag to specify the username and password but this does not change CF's behavior.  Here is my CF code:



Has anyone run into this before and have a solution or workaround?  Is there any additional information I can provide?

Thanks.

Exceptions Trying to Consume Web Service

forums_noreply@adobe.com — Wed, 06 Aug 2008 14:48:43 GMT

My ColdFusion web site consumes ASP.NET web services to access some .NET business objects. I am seeing some exceptions intermittently. See sample error message below. Note that "UploadDocument" is the web method I am trying to invoke.

The part of the error message "java.net.SocketException: Connection reset" leads me to think there may be a comminication failure, possibly indicating a DNS problem. I have changed my CF code to reference the ASP.NET web service WSDL by IP address but this has not solved my problem.

Error message:
Could not perform web service invocation "UploadDocument". Here is the fault returned when invoking the web service operation:<br> <pre>AxisFault faultCode: { http://schemas.xmlsoap.org/soap/envelope/}Server.userException faultSubcode: faultString: java.net.SocketException: Connection reset faultActor: faultNode: faultDetail: { http://xml.apache.org/axis/}stackTrace:java.net.SocketException: Connection reset at java.net.SocketInputStream.read(SocketInputStream.java:168) at java.io.BufferedInputStream.fill(BufferedInputStream.java:183) at java.io.BufferedInputStream.read(BufferedInputStream.java:201) at org.apache.axis.transport.http.HTTPSender.readHeadersFromSocket(HTTPSender.java:583) at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:143) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165) at org.apache.axis.client.Call.invokeEngine(Call.java:2765) at org.apache.axis.clie... </pre> <br>The error occurred on line 100.

My Environment:
Both the CF and ASP.NET web sites are on the same physical server, but different IP addresses.
ColdFusion: version 7.0.2 Enterprise
JVM: Sun 1.4.2_15
OS: Windows 2003 R2, Service Pack 2

Any help is resolving this issue is appreciated.

System Requirements for Flex Builder 3

forums_noreply@adobe.com — Tue, 11 Mar 2008 15:08:25 GMT

I am confused about system requirements for Flex Builder 3.

Adobe’s website ( http://www.adobe.com/products/flex/systemreqs/ ) lists the following requirements for Flex Builder:

* Intel® Pentium® 4 processor
* Microsoft® Windows® XP with Service Pack 2 or Windows Vista® Home Premium
* 1GB of RAM (2GB recommended)
* 500MB of available hard-disk space (additional 500MB required for plug-in configuration)
* Java™ Virtual Machine: Sun™ JRE 1.4.2, Sun JRE 1.5 (included), IBM® JRE 1.5, or Sun JRE 1.6
* Eclipse™ 3.2.2 or higher for plug-in configuration (Eclipse 3.3 recommended for Windows Vista)
* Adobe® Flash® Player 9 software*
* BEA Workshop 10.1
* IBM Rational Software Architect 7.0.0.3 (Eclipse 3.3 plug-in configuration only)

As I understand it BEA Workshop and IBM Rational Software Architect are both Eclipse based IDEs.

Do I need Eclipse and BEA Workshop and IBM Rational Software to use Flex Builder, or just one Eclipse based IDE?

Use CFLDAP to Determine Groups a User is a Member Of

forums_noreply@adobe.com — Thu, 13 Dec 2007 16:55:42 GMT

I have a website where users login with basic authentication against Windows 2003 Active Directory. The login name, cgi.auth_user is an account user name, sAMAccountName, in active directory.

The active directory structure has organizational unit "Unit2" as a member of organizational unit "Unit1". The user is a member of one or more groups in Unit2.
I need to be able to query for the groups that the user is a member of in Unit2. Groups will be added and removed over time so I do not have a static list of groups to query against.

The following cfldap query returns the desired results however I need a filter value where I can pass the users login (sAMAccountName) instead of the fully quailified member name.
<cfldap action="query" name="membersData" attributes="name" filter="member=CN=Joe Smith,OU=Unit2,DC=mydomain,DC=com" start="ou=Unit2,ou=Unit1,dc=mydomain,dc=com" server="#servername#" username="#ldapuid#" password="#ldappwd#" separator=";" />

I would like to be able to use something like:
<cfldap action="query" name="membersData" attributes="name" filter="member=sAMAccountName=#cgi.auth_user#" start="ou=Unit2,ou=Unit1,dc=mydomain,dc=com" server="#servername#" username="#ldapuid#" password="#ldappwd#" separator=";" />

What can I use for the filter attribute that will return groups in Unit2 for which cgi.auth_user is a member?

I am using CF7 on Windows 2003.

CFPRINT Fonts

forums_noreply@adobe.com — Thu, 23 Aug 2007 13:44:02 GMT

I am having a issue using CFPRINT. I have a pdf file which uses three fonts: Arial, ArialBold, and ArialNarrow. Note that ArialNarrow is an "Embedded Subset", the other fonts are not. When printing using CFPRINT the ArialNarrow text prints rectangles instead of text. The file prints correctly using Adobe Reader 8. I have verified that the ArialNarrow font appears in the "Font Management" page of the CF administrator. I am using Windows 2003 with Service Pack 2 and ColdFusion 8 trial.

Any help in getting files to print correctly is appreciated.

Errors Creating Java Stub for COM Object

forums_noreply@adobe.com — Thu, 14 Dec 2006 22:42:07 GMT

I have a .NET assembly that I have exposed through COM. I am able to use the object with cfobject. I would like to create a java stub for ColdFusion 7. I have used the com2java tool to create the .java files from the .tlb for the com object, but am recieving error messages when I try to compile them.

Command used: javac -J-mx100m -J-ms100m *.java -classpath C:\CFusionMX7\lib\jintegra.jar

_ConnectProxy.java:26: illegal start of expression
static { .JIntegraInit.init(); }
^
IeConnectHelperProxy.java:26: illegal start of expression
static { .JIntegraInit.init(); }
^
2 errors

My platform is Windows 2003, ColdFusion 7.02

Any help is appreciated.

Error using web service setup in CFIDE

forums_noreply@adobe.com — Tue, 23 Jan 2007 00:27:49 GMT

I am consuming an ASP.NET web service with ColdFusion 7. The first time I invoke the service after starting the CF service I get the error message "Could not generate stub objects for web service invocation"

To fix this error I log into the CFIDE and click "Update Web Service". Calls to the service will work work until the next restart the ColdFusion MX 7 Application Server service

I have deleted the service from the CFIDE and moved the WSDL URL, username, and password to the attributes of the cfinvoke tag. Consuming the service then works consistently even after a re-start.

I would rather setup web services in the CFIDE. Has anyone else had this issue or have a solution?

Accesss violation error

forums_noreply@adobe.com — Mon, 04 Dec 2006 17:14:24 GMT

I am receiving the following error message in Homesite 5.5 on Windows:

Access violation at address 00403A2B in module ‘HomeSite5.Exe’. Read of address 00000000.

The error occurs intermittently while editing files.

Any help to resolve this issue is appreciated.

Has anyone been able to use the Microsoft Dynamics GP eConnect 9 COM object in ColdFusion?

forums_noreply@adobe.com — Sat, 18 Nov 2006 01:00:14 GMT

Has anyone been able to use the eConnect 9 COM object in ColdFusion?

I have attempted this but been unable to make it work.

Thanks in advance for any help.