In OD 7, Whenever I add Data node, It always coming up with line Local variables by default? is this for any special purpose? How to avoid this?
Attached the screenshot FYR.

Please I do not understand. This means, Can I get logs with old jar files (db.jar & dbui.jar), since the exception was coming earlier.

Wonderful :) It is working now as expected. I modified the Java version in the environment variables for jdk 1.7.
Thanks for your great help. Attached the screenshot.
But now I did not see any message like sucess or error in case of changing to wrong URL) in the /metadata/.log file. Can you please help on this.

I updated with JAR that you have provided earlier. I revert it back with old sqljdbc4.jar file and tested again.
Attached the current jar, .log file and jdk compiler setting screen.

This is Jar file you provided earlier. Now I revert with old sqljdbc4.jar file and tested the same.
JDK version used is 1.7. OD 7 and Tomcat 7.
Attached the current sqljdbc4.jar file and jdk used.

Ctrl+A, Select All option is not working in Orchestration designer workspace in .java file. Please advice.

I have added db and dbui jar files. Also I deleted old .log file and tried to create Oracle DBOF and then SQL DS.
I got message like !MESSAGE database connected for ORACLE DS and the below error messages for SQL DS.

!MESSAGE Unhandled event loop exception
!STACK 0
java.lang.UnsupportedClassVersionError: Bad version number in .class file

Attached the .log file.

I did not get any error pop up message so far. And nothing is written to .log file related to database.

Kindly find the attached DS files related to Oracle.

Thanks for your comments.
1. I was mistakenly put URL without //. Just I tried alternate options. But updating URL does not give any effect on the issue.
2. I have increased to Xmx to 512m now
3. yes. I added for alternate options to give a try. But no luck.

I created application on today 21 Oct. But the log fles contains data till yesterday only. No logs written for today.
Also Attached the new application(SqlDBTest) and Preferences screen and then other suport files like
DataSource_Created screen, JavaBuildPath screen, DBOF_Creation with error. Please check.

I downloaded latest jar file. But getting same error.

No. I am getting only the error No Database Connection established in the same screen as shown in th SQL error attachment.

Attached the screen shots FYR.

I already tried creating new application with new datasources for Oracle and SQL connection. Both are valid DB URLs. There also I faced the same problem like Oracle is working fine to create new DB objects with existing tables. But SQL is showing same "No database connections established" error. As I said already It is working fine in runtime for both oracle & SQL. SO the workaround I did was, first I created DB objects with ORACLE Datasiurce and after successfull creation of DB object I changed the datasource to SQL DS. Then it is working fine in runtime in Orchestartion designer simulator. So I understood that it is giving problem only in creating DB object using SQL Datasource during development.

The same data source is working for other existing DB operations and I have only one DS. I am just selecting the same data resource to create new DB operations.
Also If I change to Oracle connection, it is working fine. But If I connect to SQL DB only, it is showing this exception. Please note that during run time, it is working fine for existing Database objects even with SQL DB.