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
1
vote
1 answer

Does TimesTen support high availability? If so, how do I configure it?

I am considering using the TimesTen In-Memory Database for my application but I need high-availability. Can TimesTen provide this and if so how?
Chris J
  • 81
  • 5
1
vote
0 answers

java.sql.SQLException: [TimesTen]Cannot find the requested DSN (ormb_ttdb) in ODBCINI /var/TimesTen/tt1122/sys.odbc.ini or /var/TimesTen/sys.odbc.ini

I have setup a Timesten client(11.2.2.8.0) on my unix machine. I have setup a Timesten server on different machine. After setup is complete I am trying to connect to Timesten database using JDBC from my spark code written in java. I am getting below…
Curious Techie
  • 185
  • 2
  • 15
1
vote
1 answer

Is Times Ten Dialect supported by Hibernate

Trying to use Oracle's Times Ten db instead of hsqldb for performance reasons. I read where you need to create a new hibernate.jar file using times ten sql dialect class file. This is proving to be a little challenging. Does hibernate now work…
Trevor
  • 163
  • 1
  • 2
  • 7
1
vote
0 answers

can a timesten replication agent hold deadlock to itself?

I am experiencing a strange issue, where the timesten subdaemon core dumped, and in analysing the tterrors log, I find a stream of lock errors, where the replication agent is trying to obtain a lock held by itself(see the pids in below log message),…
gnawiyiz
  • 21
  • 2
1
vote
3 answers

Redirect ttisql output to file

I am using Oracle Timesten ttIsql utility for query execution. I want to check how much time it takes to execute Select statement using "timing" function. For large data set, the utility takes some time to display records on screen. Is there a way…
MIK
  • 392
  • 3
  • 19
1
vote
1 answer

Sorting DB tables from least dependent to most dependent

I'm performing a data migration and the database I'm using only allows to export and import each table separately. In such a setup importing becomes a problem since the order in which tables are imported is important (you have to import referenced…
Sergey Mikhanov
  • 8,880
  • 9
  • 44
  • 54
1
vote
1 answer

TimesTen Dialect Hibernate 3

I am trying to use hibernate with a TimesTen database. I have the correct dialect: TimesTenDialect1122.java but I am unsure of how to add this to my project within Eclipse. The package in the file is declared as: package org.hibernate.dialect; So…
Simon Nicholls
  • 635
  • 1
  • 9
  • 31
1
vote
1 answer

TimesTen 11.2.2 Hibernate 4 Dialect

I've been trying to use TimesTen 11.2.2.5 as a provider for Hibernate. In order to do so I had to download some custom made Dialect but then I realized that it is meant for Hibernate 3.5 (which is quite different from Hibernate 4.X). Hibernate's…
1
vote
1 answer

java.sql.SQLException: Problems with loading native library/missing methods: no ttJdbc1121 in java.library.path

I am getting this error while trying to connect to timesten DB configured in my system: java.sql.SQLException: Problems with loading native library/missing methods: no ttJdbc1121 in java.library.path Here is my code: try { …
user1407668
  • 587
  • 5
  • 20
  • 35
1
vote
2 answers

how to get limited number of rows from combination of 2 queries

Iam facing some logical issues.Hope that someone can find me a solution to it Iam having a query select FirstName||'|'||LastName||to_char(salary) from (select FirstName,LastName,salary from subs_tbl where salary=24000) union all select…
Meera
  • 11
  • 4
1
vote
1 answer

GlassFish V3 Cluster + TimesTen strange behavior

i have a very strange problem with GlassFish V3 + TimesTen. My configuration is: GlassFish Server Open Source Edition 3.1.2.2 (build 5) TimesTen Release 11.2.2.2.0 Java(TM) SE Runtime Environment (build 1.6.0_31-b04) Java HotSpot(TM) 64-Bit Server…
VooDoo
  • 11
  • 2
1
vote
1 answer

TimesTen: Cannot connect to TimesTen daemon

I'm trying to create a prototype application using TimesTen insted of home written IMDB. When I install TimesTen, TimesTen Data Manager service is hosted and also few subdaemons and server. Everything seems fine, but ttDaemonAdmin refuse to connect…
johnny88
  • 11
  • 2
1
vote
2 answers

Oracle Timesten source language

Anyone knows what is the source language used for Oracle TimesTen? Is it C++ or Java? Cannot find the answer for that anywhere.
donjenya
  • 11
  • 2
1
vote
2 answers

How do I show a table's foreign key's in TimesTen?

How do I show a table's foreign key's in TimesTen?
Gambit
  • 537
  • 1
  • 5
  • 14
0
votes
2 answers

Too much connections to db using DataReader

Every time i get a value from a response from a odbcconnection by datareader, i made a connection to the database (if i have a query that return 9 fields, i have 9 connection to db), and i want to do only 1 connection and retrieve all information.…