Connecting to SQL 2005 Server from the Java Studio Creator

In this section a similarly configured data source named 2K5Java which also had a warning as to the size of the validation table will be modified. The plan is to create a validation table that will make the warning received go away. Right click the 2K5Java node and pick Modify Data Source... to display this next window which shows that the data source 2K5Java is being modified with an existing table, Argentina.

Although a table with no rows is also acceptable, a table called TestValid with just one row as shown was created in the SQL 2005 Server.

This appears in the Sun Java Studio Creator as shown here.

In the Modify Data Source window, click on the Select button which brings up the window Select Validation Table with two tables as shown.

Select TestValid and click on the button Select. The Modify Data Source pops up showing that the validation table now points to the table TestValid instead of Argentina (this screen shot is not shown).

Now test this connection and you see the following display.

Summary

Connecting to SQL Server 2005 from the Sun Java Studio Creator 2 is just as easy as it was from the "Early Access" edition to SQL 200 Server. The Validation Feature did not exist in the previous version in the build used at that time. Now there is an added requirement to create a validation table in the target database. This may however improve the overall performance.