JCCL: JDBC - MS_SQL Server Interface Tips
Each computer in JCCL has an independent configuration.
All JCCL computers have been installed with SQL 2000 Client,
Service Pack 3, and MS_JDBC driver.
The following steps need to be performed after login to any JCCL computer.:
- Ensure TEACHSQL is registered as a database server
Start -> All Programs -> Microsoft SQL Server -> Enterprise Manager
expand Microsoft SQL Servers; RightClick on SQL Server Group; select "New SQL Server Registration..."; Next
add TEACHSQL to right pane(Added servers); Next
select SQL Server login for Authentication mode; Next
select Prompt for the SQL Server account information; Next
select Add the SQL Server to an existing ...; Next
select TeachSQL; Finish; Close
expand SQL Server Group; RightClick TEACHSQL; select Properties
enter Login name and password for teachsql server (may be different from windows password); Connect
Security tab; select "SQL Server and Windows" for Authenitication; OK
- Create tables and load values for two databases:
(needs to be performed one time only)
DoubleClick on TEACHSQL; expand Databases; select your database (your username)
From Tools menu click on "SQL Query Analyzer"
Click on "Load SQL Script" icon (second icon on the icon bar)
Browse and choose removeCompany.sql -> Open; Click "Execute Query" icon
Browse and choose setupCompany.sql -> Open; Click "Execute Query" icon
Browse and choose delMarket.sql -> Open; Click "Execute Query" icon
Browse and choose genMarket.sql -> Open; Click "Execute Query" icon
Close "SQL Query Analyzer" window
- Check JCreator Configuration:
Download all four jar (Java Archive) files from jarFiles folder to U: drive
Download all sample Java programs files folder to U: drive
Right click on the first sample Java program, and open with Jcreator Pro
edit url (replace localhost with teachsql), username, password values appropriately on the Java Source
From "Configure" menu, select "Options..." and Click on "JDK Profiles"
Select JDK version 142... shown on the box and click "Edit"
Click "Add", select "Add Archive...", and select all four jar files, Open, OK, OK
Compile and Execute the program.
If encounter any error, make sure that you followed all the above steps carefully.
Remember to edit url value in all other test programs correctly.
--Prabu