Orsburn (Static Content)

Pardon the confusion with all the freely flung usage of the term SQL coupled with the vaguely descriptive "developer" and "server" terms.  This article describes the requirements for getting Oracle 's SQL Developer client to work with Microsoft 's SQL Server database manager. SQL Developer supports connections to SQL Server, but in spite of Microsoft providing its own JDBC driver , SQL Developer will only work with the jTDS driver.  Download that and point SQL Developer to it via: Tools | Preferences… Database | Third Party JDBC Drivers Point SQL Developer to the jTDS driver to use with SQL Server. If connections are being made from the Windows version and Windows authentication will be necessary, then the ntlmauth.dll library will need to be copied into the JDK directory: Copy from PATH_TO_JTDS\jtds-VERSION\PLATFORM\SSO\ntlmauth.dll Copy to JAVA_JDK_DIRETORY\jre\bin\ntlmauth.dll

Use the filter option to show binary files to make the files available. Right + click in the File Browser tab's file listing area Select Filter | Show Binary Gedit , the open source text editor for Gnome , has a view in the side panel to browse the local file system.  It appears that the Windows version of the application has a bug that assumes all files to be binary, even if they carry a .txt filename suffix. The expected behavior is that text and source code files will be listed by default, and that this option will allow items like pictures and executable files to be shown as well.  Setting this flag can serve as a workaround.  Without it, only folders and files without filename suffixes will be shown. Gnome Bugzilla ( 578829 ) File Browser plugin can only show files with no extension on Win32 https://bugzilla.gnome.org/show_bug.cgi?id=578829

The params argument of the queryExecute() function can be passed in a number of forms.  Using an object or a structure will allow named query parameters, while the array method necessitates the question mark (?) placeholders. Because of this difference, the SQL variable has been defined twice, once in each manner.  The query is run and the result is dumped in the final example. Object and structure methods // Params definition option 1. var sqlParams =     {         firstParam: "FIELD VALUE",         secondParam: "FIELD VALUE"     } // Params definition option 2. var sqlParams = structNew (); sqlParams . firstParam = "FIELD VALUE" ; sqlParams . secondParam = "FIELD VALUE" ; // Params definition option 3. var sqlParams = structNew (); sqlParams [ "firstParam" ] = "FIELD VALUE" ; sqlParams [ "secondParam" ] = "FIELD VALUE" ; var sql = "     declare @retur...

Eclipse maintains a directory at the root of a project with the name ".settings."  If, for whatever reason, Eclipse can't seem to find this directory, or the files in it, Eclipse will report an error vaguely stating a problem "Detecting library folders."  Removing the .settings directory will solve the problem. Presumably, Eclipse rebuilds any information it maintains in that directory, though it's not clear what the information is.  Assume that any arbitrary details that seem off might be associated with removing this folder. The "Detecting library folders" error dialogue window. Due to the non sequitur nature of the error, there isn't much context to work off of other than the "org.eclipse.wst.validation" identifier, and the "detecting library folders" pseudo-clue.  As such, there isn't much that comes back from searches around the web for solutions to the issue, but the combination of the three references...

Eclipse PDT (PHP Development Tools) has the ability to quickly show the definitions of functions and methods by hovering the cursor over the parentheses of a reference.  This feature is an extension of the typical docblock or signature reveal when hovering over a method or function call itself. It's not as easy to hover over a parenthesis as it is to hover over a function reference, so invoking the tip can be a little clumsy.  And there's another peculiarity with the feature too.  Typically, the inline popups like this are "focusable" by moving the mouse from a hover into the pop-up.  For these pop-ups though, they immediately disappear when moving away from the parentheses.  Instead, use the F2 key to focus the pop-up.  In spite of these usability matters, the feature is handy as a quick reference and is welcome. It's possible that other Eclipse plug-ins have a similar feature to, so in order to get an idea as to whether or not this is a featur...

It's not immediately clear how to differentiate between public and private properties in CFML CFC s (ColdFusion Components, which in turn are classes).  Defining methods is more straightforward, in that they provide for public and private keywords to signal their scope.  It would stand to reason that these scoping keywords might also be applicable for properties as well.  After all, this is the approach taken with other languages such as Java and PHP . Alas, it is not the case.  And to compound matters, searching the Web doesn't really provide much clarification on the matter either.  Answers range from, it's just not possible, to initializing variables in the constructor to make them act like private properties. The examples provided here bear out that, CFML, at least running on Railo / Lucee , do in fact, support the scoping of properties.  It works like this.  Properties intitialized using the this.variableName form are public.  Simply i...

Preface To begin with, the operation described here is something that falls outside of the way Eclipse is meant to be worked with.  Eclipse has a concept of "Workspaces" to allow the IDE to be completely reconfigured for the type of development that is being done. This is a great idea in theory, but in practice it can be quite cumbersome and off-putting.  Off-putting simply because changing a Workspace means that everything needs to be reconfigured again.  Font colors, view locations, and who knows what else. It's true that creating a new Workspace allows the Workbench Layout and Working Sets to be copied.  And the settings can be exported from one Workspace to the next.  Still, once all of this is done, if changes are made in one, they would have to be applied to any of the other Workspaces that have been create as well, if one wants to maintain a consistent environment across all projects.  Plus, it doesn't really work anyway.  All Views still...