Firebird query to list out rows having duplicate values in columns

SELECT * FROM "TABLE1" t1 WHERE EXISTS (SELECT 1 FROM " TABLE1" t2 WHERE t1."COLUMN1" = t2."COLUMN1" AND t1.RDB$DB_KEY < t2.RDB$DB_KEY);

This query will list out only the rows from TABLE1 which have duplicate values in COLUMN1.

I moved my netbeans settings and projects to my new computer

1. Install netbeans and close netbeans if open. Before proceeding with any of the steps below, make sure you take zip/backup the necessary files/folders in the folders which you copy to.

2. Moving netbeans settings:
You will find the folder having netbeans settings within your windows user profile. I use windows 7. So I found this here : C:\Users\my-windows-user-name\.netbeans. To move your settings, just move the folder (under C:\Users\my-windows-user-name\.netbeans) with the name having your netbeans version (I use netbeans version 6.9 so the folder name was 69 without the dot in between).

3. Moving netbeans projects:
To know where netbeans creates project settings in your computer, just try creating a sample project. While creating your new sample project, the second step 'Name and Location' will show the default Project Folder. This is where you will have all your project settings, just move the folder to the new computer to the same directory.

For example the 'Name and Location' shows your project folder as C:\Users\ my-windows-user-name\MyDocuments\NetBeansProjects\JavaProject7, your projects will be found in just one folder under, that is here : C:\Users\ my-windows-user-name\MyDocuments\NetBeansProjects\

5. Move your source files to the same directories you had in your old computer.

4. Start netbeans to find your old settings in your new netbeans installation.

Hope this helps.

firebird.msg not found

D:\firebird\bin>isql -u sysdba -p masterkey D:\firebird\OpUtilsDB.fdb
can't format message 17:0 -- message file D:\firebird\firebird.msg not found
unavailable database
can't format message 17:3 -- message file D:\firebird\firebird.msg not found
SQL> exit;

To solve this problem,

1. Stop if you have any firebird instances running
2. Change the value of the var 'CreateInternalWindow' as 1 in firebird/firebird.conf
3. Start firebird (run fbserver -a from firebird/bin)
4. Then run the isql command

Setting character set for tomcat requests and responses

To set character set for your tomcat requests and responses, add param URIEncoding="UTF-8" (if you need your character set to be UTF-8) in the Connector tag of server.xml.

To start firebird in windows

Run command fbserver.exe -a from the firebird/bin directory (Note: firebird dir is the firebird installation dir - the name could differ with the version)

Call a js function using a string variable having the function name

Hope the following coding snippet helps to know how :

<script>
testFCall();
function testFCall()
{
setTimeout('testCall(109)',0);
}

function testCall(val)
{
alert('val : '+val);
}
<script>

Run os commands from java + print error messages

private void runProcess() throws Exception
{
try
{
Runtime rt = Runtime.getRuntime();
Process process = rt.exec("cmd /c cp C:\\work\\dev\\test.txt C:\\work\\dev\\test1.txt");
BufferedReader input = new BufferedReader(new InputStreamReader(process.getInputStream()));

String line = null;

while ((line = input.readLine()) != null)
{
System.out.println(line);
}

int exitVal = process.waitFor();
if (exitVal != 0)
{
input = new BufferedReader(new InputStreamReader(process.getErrorStream()));
line = null;

while ((line = input.readLine()) != null)
{
System.out.println(line);
}
}
}
catch (Exception e)
{
System.out.println(e.toString());
e.printStackTrace();
}
}