What user do you use for connection? Try something like the following
Java code something as Connection Conn = DriverManager.getConnection("jdbc:timesten:dsn=DataBaseName"); PreparedStatement PrepStmt = Conn.prepareStatement("insert into oratt.Writetab values (104,'test')); SQLException: java.sql.SQLException: [TimesTen][TimesTen 188.8.131.52.0 ODBC Driver][TimesTen]TT2206: Table oratt.Writetab not found -- file "comp.c", lineno 2808, procedure "sbCompCacheTbl()"
Connection Conn = DriverManager.getConnection("jdbc:timesten:dsn=DataBaseName", "oratt","your_PWD");
Yes I did the Commit;I suppose the problem was because of the primary key was updated, but I can be wrong. I'll check later today.
My Question is say suppose if we have 3 rows in Oracle and in TT cacheYes, you are able to get the rows. If you dont run DML in TimesTen level you should create Read only Cache group and specify autorefresh interval. Read only cache groups are used for transferring data from Oracle to TimesTen.
if i deleted 1 row in Oracle and inserted 5 rows in Oracle can i be able to get the new 5 rows in TT cache.
If you have a complex workload with multiple tables being updated in TimesTen then you may see better replication performance by enabling parallel AWT (i.e. setting CacheAWTParallelism > 1). You should also check that your log buffer is large enough in TimesTen; the default size is too small for a heavy write workload.
You should also check that your log buffer is large enough in TimesTen;For my database i have set 400 PermSize + 40 TempSize
The only way that rows could 'vanish' from TimesTen like this yet still be present in Oracle is (a) if you have data aging configured for the cache group (the rows may have been aged out) or (b) if you have executed some UNLOAD CACHE GROUP operation. TimesTen does not 'lose' rows for no reason.I have not set any thing
the rows may have been aged outIf so how in between rows will be aged out.