Flavors of CRUD Tutorial projects against all Supported Databases

The purpose of this blog item is to share the Creator 2 projects built while exercising the Performing Inserts Updates and Deletes Tutorial against all of the supported databases using the bundled Sun JDBC Drivers. Check out the Creator 2 system requirments for Supported Database Servers and JDBC Drivers.

Note: You will need to setup the travel schema on your database and add a datasource for it in Servers window. You could use the exported_datasources_travel_sample.xml for importing/creating your datasource. Change $hostname, port# and validation table appropriately.

Database Type Schema/SQL files, Creator 2 Project
PointBase 5.2 (bundled)

$Creator_install/rave2.0/startup/samples/ create-schema-travel.sql and create-Travel.sql

DataSource Name: Travel

InsertUpdateDelete_PointBase.zip

MySQL 5.x/4.x

create-Travel-MySQL.sql

DataSource Name: mysql_travel

InsertUpdateDelete_MySQL.zip

Oracle 9i/10g

OraCreateTravelDB.sql

DataSource Name:ora10g_travel

InsertUpdateDelete_Oracle.zip

MS SQL Server 2000

create-Travel-SQLServer.sql

DataSource Name:mssql_travel

InsertUpdateDelete_MSSQL.zip

Sybase ASE 12.5

create-Travel-Sybase.sql

DataSource Name: sybase_travel

InsertUpdateDelete_Sybase.zip

IBM DB2 8.1

create-Travel-DB2.sql

DataSource Name:db2_travel

InsertUpdateDelete_DB2.zip


Comments:

Post a Comment:
Comments are closed for this entry.
About

sakthi

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today