Stack Overflow
Stack Overflow

Questions tagged [timesten]

TimesTen is a high performance event-processing software component that enables applications to capture, store, use, and distribute information in real-time, while preserving transactional integrity and continuous availability.

TimesTen is designed to operate most efficiently in an application’s address space. Using standard interfaces, TimesTen can be integrated into an application to serve as either a stand-alone relational database management system (RDBMS) or an application-tier cache that works in conjunction with a traditional disk-based RDBMS, such as the Oracle database. TimesTen can be configured to operate entirely in memory, or it can be configured for disk-based environments to log and checkpoint data to disk.

TimesTen is available in a specially-licensed edition, TimesTen for Exalytics, to support Oracle's Exalytics BI Machine. This version of TimesTen makes available various analytic functions, as well as columnar compression. These features are not available in standard TimesTen.

75 questions
0
votes
1 answer

Times Ten LOB support

I have a passthrough connection in my c# application and I'm trying to do a select on a clob column which is in the database but not in-memory. But I get the following error, any ideas what I'm missing? ORA-57000: TT5187: Caching LOBs from Oracle…
Nikhil
  • 181
  • 3
  • 12
0
votes
1 answer

Times Ten user privs

We have a times ten instance created by another user on a windows server 2008 r2 standard. I've created a dsn but when I try to connect it gives me a 7001:User authentication failed On investigating some more, I understand that as the instance…
Nikhil
  • 181
  • 3
  • 12
0
votes
2 answers

ORA-29158: Unable to open library

I'm using the times ten demo odp on a windows 7 box and have followed all the steps. I have a tnsnames.ora entry as follows sampledb_1122 =(DESCRIPTION= (CONNECT_DATA = (SERVICE_NAME = sampledb_1122) (SERVER = timesten_direct) ) ) The…
Nikhil
  • 181
  • 3
  • 12
0
votes
2 answers

Using Pro*C to access a TimesTen database

I am trying to use Pro*C to access a TimesTen database. The code to create a table in TimesTen is create table testtable(id number(4) not null primary key, ename char(10)); I use Pro*C to fetch data from this table. When I use this SQL: select *…
sky蓝色
  • 1
  • 2
0
votes
0 answers

How to fetch data recursively from a timesten DB

I have a table which will have hierarchical data as given below: **childtype chidvalue parenttype parentvalue** 1001, child1, 1000, testParent 1001, child2, 1000, testParent 1002, child3, 1000, testParent 1003, child4, 1002, child3 …
user1407668
  • 587
  • 5
  • 20
  • 35
0
votes
1 answer

query to find out count of rows in a particular instance of time

Is it possible to find out the count of rows in all tables at a particular instance of time (not depends on any column values)? Thanks!
Chris
  • 541
  • 1
  • 4
  • 11
0
votes
1 answer

In Memory Cache Database for MS SQL

Is there a in-memory database that can be coupled with an Ms sql server.ie i will use an in memory database system as a cache and the ms sql as my main backend database. forexample- Timesten integration with oracle. Thanx.
Joe Dominic Valluvassery
  • 131
  • 4
  • 11
0
votes
2 answers

performance issue in find() method after migration to Hibernate 4.0 from OpenJPA 1.2

I migrate from OpenJPA 1.2 to Hiberante 4.0 I'm using TimesTen DB I'm doing a native query to get id's of object's that I need , and then perform find on each on of them. In OpenJPA instead of find I used findCache() method and if it return null I…
eitann
  • 1,203
  • 10
  • 23
0
votes
1 answer

How to redirect 'dbms_output.put_line content' to log file from a TimesTen Stored Procedure

See the sample Timesten procedure below. CREATE OR REPLACE PROCEDURE test_proc(employee_id IN NUMBER) AS salary NUMBER; BEGIN SELECT emp_sal INTO salary FROM employee where emp_id = employee_id; DBMS_OUTPUT.PUT_LINE('Employee Id:' || employee_id ||…
Dhiraj Neve
  • 235
  • 2
  • 4
  • 11
0
votes
1 answer

How to get all cachegroup names in TimesTen IMDB?

We can get all cache groups names and their status from cachegroups command. Is there any system/user tables exist from which we can query cache group names ?
udr1990
  • 265
  • 1
  • 3
  • 11
0
votes
1 answer

ERROR [HY010] [Microsoft][ODBC Driver Manager]

I get this error: ERROR [HY010] [Microsoft][ODBC Driver Manager] The driver is incapable of supporting the current environment attributes. when making a IDbConnection.Open() My machine is Win 7 64, the ODBC is configured as a System DSN using…
MadCatPT
  • 1
  • 1
  • 2
0
votes
1 answer

Dump all schemas and triggers and import them into another Oracle database

Is there anyway to grab the schemas and triggers from an oracle database and import them into another oracle database(an Oracle TimesTen inmemory db to be precise)? I'm trying to setup an in memory database for testing purposes and need to replicate…
AgentRegEdit
  • 1,089
  • 2
  • 16
  • 32
-1
votes
1 answer

replicating different data model

I have an application A which has around 100+ tables and uses Oracle DB. There is another application B which uses this data stored in its timesten DB with less number of tables. Given 2 different types of databases with different data models…
recipe4Life
  • 1
  • 1
-1
votes
1 answer

What about problems with loading native library/missing methods: libttJdbc.so, libtten.so

java.sql.SQLException: Problems with loading native library/missing methods: /home/timesten/TimesTen/tt1122/lib/libttJdbc.so: libtten.so: cannot open shared object file: No such file or directory at…
user2986897
  • 51
  • 3
  • 8
-1
votes
2 answers

java.sql.SQLException: No suitable driver found for com.timesten.jdbc.TimesTenDriver

I am getting an exception: java.sql.SQLException: No suitable driver found for com.timesten.jdbc.TimesTenDriver while trying to connect to Timesten DB installed in my system. The code is given below: Connection conn = null; try { …
user1407668
  • 587
  • 5
  • 20
  • 35
1 2 3 4
5