TimesTen与oracle数据交互的测试
--------------------------------------------测试cache connect oracle是否能成功--------------------------------------------------
-------1:在oracle的数据库里建立用户testuser
SQL> CREATE USER testuser IDENTIFIED BY mypsswrd;
User created
SQL> GRANT connect, resource, create any trigger TO testuser;
Grant succeeded
SQL> alter user testuser default tablespace ts_movie;
[root@dboracle linux86]# su - timesten
LD_LIBRARY_PATH set to /home/timesten/TimesTen/tt70/lib
ANT_HOME set to /home/timesten/TimesTen/tt70/3rdparty/ant
PATH set to
/home/timesten/TimesTen/tt70/bin:/home/timesten/TimesTen/tt70/demo/performance:/home/timesten/TimesTen/tt70/demo/ttclasses:/home/timesten/TimesTen/tt70/demo/xla:/home/timesten/T
imesTen/tt70/demo/xla/xlaPersistent:/home/timesten/TimesTen/tt70/demo/tutorial/java:/home/timesten/TimesTen/tt70/3rdparty/ant/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:
/home/timesten/bin
CLASSPATH set to /home/timesten/TimesTen/tt70/lib/classes14.jar:/home/timesten/TimesTen/tt70/lib/timestenjmsxla.jar:/home/timesten/TimesTen/tt70/3rdparty/jms1.1/lib/jms.jar:.
-------2:查看安装Timesten的基本信息
[timesten@dboracle ~]$ cd /etc/TimesTen/
[timesten@dboracle TimesTen]$ ll
total 8
-rw-rw-r-- 1 timesten timesten 231 Oct 14 15:43 instance_info
[timesten@dboracle TimesTen]$ cat instance_info
#SUM 14991 1
[ tt70 ]
Product=TimesTen7.0.5
InstallDir=/home/timesten/TimesTen/tt70
InstanceAdministrator=timesten
DaemonHome=/home/timesten/TimesTen/tt70/info
BitLevel=32
Component=Client/Server and DataManager
TT_PORT=17000
-------3:连接数据源TT_tt70,并建立用户testuser
[timesten@dboracle TimesTen]$ ttisql TT_tt70
Copyright (c) 1996-2008, Oracle. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
All commands must end with a semicolon character.
connect "DSN=TT_tt70";
Connection successful: DSN=TT_tt70;UID=timesten;DataStore=/home/timesten/TimesTen/tt70/info/TT_tt70;DatabaseCharacterSet=US7ASCII;
ConnectionCharacterSet=US7ASCII;DRIVER=/home/timesten/TimesTen/tt70/lib/libtten.so;TypeMode=0;
(Default setting AutoCommit=1)
Command> CREATE USER testuser IDENTIFIED BY 'mypsswrd';
Command> GRANT ADMIN, DDL TO testuser;
