Connecting to SQL 2005 Server from the Java Studio Creator - Modifying a configured data source
(Page 5 of 5 )
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.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
