CFBuilder Beta2 will expire on January 1st.Please plan your upgrade to Beat3 so that you don’t have to do the upgrade on an extremely busy day.Last time we noticed many were affected because we didn’t notify in advance that CFBuilder will expire and were forced to do the upgrade in a hurry. You can download beta3 from here
- SQL editor now has the tab for executing a query. Currently, you can execute only a ‘select’ statement in the SQL editor and it fetches all records at once.
- Code assist has been added for Select, Insert, Update and Delete statements .
- More intelligence have been added to SQL code assist to ensure that code assist for appropriate tables and columns are displayed only at relevant places while typing.
Do let us know if you like what you see in SQL code assist and also what enhancements you would like to see in future releases.
Beta3 build of CFBuilder has some handy datasource specific code assist:
- As the ‘datasource’ attribute of tag is no longer mandatory, if this.datasource is specified in Application.cfc, CFBuilder intelligently picks that up and shows appropriate assist for tables and columns
- this.datasource in Application.cfc shows the available datasources
- <cfdbinfo> tag also shows code assist on tables and columns wherever applicable based on the datasource specified
Please note that CF server needs to be associated with your project in order to get datasource specific code assist.
Code assist now has a brand new addition under its umbrella – ORM code assist! Do try your hands on them and let us know your feedback.
Couple of ORM specific code assist that CFBuilder provides:
- for This.ormsettings in Application.cfc
- for entity names in entityLoad(), entityNew() and entityFindByPK() functions and method names for variables created in relevant cases
- for methods and properties returned by entityLoad(), entityNew() and entityFindByPK() functions
- for attributes table, discriminatorcolumn and joincolumn of cfcomponent tag
- if entity name is not speficied for ORM cfc, it is considered to be same as cfc name
- for code hyperlinks for entity names and methods
- for attributes of cfproperty – name, fieldtype, linktable, fkcolumn, inversejoincolumn, cfc, column, structkeycolumn and elementcolumn
CFBuilder Beta3 is Live on labs.
Please go through the release notes and Installation Instructions before you upgrade the build.We have noticed that those who upgrade from plug-in Installation usually face some issues in upgrade.So when you are upgrading the plug-in Installation we request you to follow the install Instructions properly.The most common cause of hiccup while upgrading a plug-in installation is that many users keep the ColdFusion/ColdFusion Debug Perspective open in eclipse and then try to uninstall and install the new build and things go wrong.You can close these perspectives by right clicking on the perspective buttons and choosing close as shown in the screen shot.In Windows use the Uninstaller application present in the uninstall directory to uninstall CFB.In mac use the uninstall_cfbuilder script present in the eclipse directory to uninstall CFBuilder.
Do start eclipse in a -clean mode before you install the latest build so that we can make sure that all the files are cleared from the eclipse cache.Now Install the latest beta and you should get your perspectives properly.
Many users on Mac have been reporting weird performance issues post Beta2 though we had done much work around performance improvement. Here’s a workaround to get rid of the unexplained CFB slowdown issues that you have been facing. Internal browser is created in Eclipse with SWT.MOZILLA type. We added this in beta2. There is a bug logged with Eclipse at https://bugs.eclipse.org/bugs/show_bug.cgi?id=287416. As per the bug report, SWT.MOZILLA type causes windowserver process of Mac to go crazy. So, what you can do now is disable Firefox preview option in CFB.
Go to Preferences->HTML->Editors->HTML->Preview. At the bottom you will see browser type listed. Uncheck Firefox, restart CFB. You might also need to uncheck Preferences->ColdFusion->Extensions->Use Mozilla browser for Extensions just in case you have it checked. Let me know if you still experience the gradual slowdown issue.
Open SQL Editor:
You can right-click in the CFML editor, and select SQL Editor.
Or, you can use the keyboard shortcut Ctrl+Alt+S (Windows) or Command_Alt+S (Mac OS).
Using SQL Editor to write and edit SQL statements:
In the SQL Editor, select a server from the Server drop-down list and a database from the Datasources drop-down list.
Enter the SQL statement and click OK. The SQL statement is inserted in the CFML editor at the current caret position.
You can also copy SQL code blocks from the SQL Editor directly into the CFML editor by selecting the code block and pressing Shift+Enter.
To edit a SQL code block in the CFML editor, select the code block, right-click, and select SQL Editor. The selected code block appears in the SQL Editor.
Code Assist for SQL statements:
Code Assist is available only for database table names and field names in the SQL statement.
For code hints to appear, begin entering the SQL statement in the SQL editor, and press Ctrl+<Space> to display the database table names or field names.
Navigate through the list of table names or field names using the Up Arrow and Down Arrow keys.
Select a table name or field name and press Enter. The selected table or field is added to the SQL statement.
Prior to Public Beta Non-JRun based servers could not be added in CFB. That is if your ColdFusion is running on WAS or JBOSS, you couldn’t add the server in Builder and work on it.
We have now implemented this support. In your Public beta 2 build you will see that while adding the server the Application Server field as a combo-box, If you are working with non JRun Server you should select the option ‘Other’ so that on the second page you just need to enter the Document root.
The only thing you cannot do while adding a non- Jrun server is starting-stopping the server hence you will be prompted about that message when you select the option ‘Other’.
However you can associate this server with a project and preview and debug files. Infact if you have a virtual host for the server you can add that as well.
Working on all kinds of Application servers is now supported with ColdFusion Builder.
Looking forward for your feedback about the same…
For those of you facing CFB performance and stability issues on Snow Leopard or on Mac in general, can you please try the following and let us know if you see any difference?
1. Uncheck ‘Use Mozilla browser for Extensions’ in Preferences->ColdFusion->Extensions
2. Turn off ‘Time Machine’ in System Preferences
Adobe ColdFusion QE Team
This is the key area we are trying to focus on for our next release. We had done considerable work on performance improvements for the previous Beta. But, we do understand that there is scope of improvement. We have gathered a mixed feedback from various forums, surveys, interaction in conferences, bugs reported etc, whereby we found that some users see the improvements whereas some still face serious issues with performance. For example, many of you reported issues with editor once you upgraded to Snow Leopard. There are many editor issues discussed like the ones on Snow Leopard, editing being slow even with small files, huge startup time, CFB becoming unusable, unstable build, system slowing down on using CFB etc, the repro cases for which are not straightforward. We do not hit upon them when we try out the reported cases here. The issues users face could be due to various reasons like improper installation, jvm.config tuning, server settings collection, system environment etc. So, we need more help and specific inputs from you in order to know what exactly is going wrong when user is trying to do a particular operation in CFB.
If you have been facing any of the issues mentioned above or something even remotely similar to them, please take the stack trace using the handy tool at
All you need to do is to select the CFBuilder process id from the current list of processes and get the thread dump.
The tool is free if you use Java Web Start to download it. And works on MAC, Linux & Windows.
I urge each one of you who are facing or have already reported any of these issues to please use the tool and send us the thread dump as soon as you hit upon them. You can email it to me directly at email@example.com with a crisp description of the issue. Users on Snow Leopard who have reported that they find CFB unstable on this platform, please send us the details as and when you face them using this tool. This will help us to resolve your painpoints.
For free evaluation license, Go to Help->License, pick up the System Id from there. Then register yourself and provide the System ID. You will get an evaluation license with expiry date through email.