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

How to set Timing on Times Ten from a stored function?

I want to enable TIMING on oracle TimesTen. Its working if i execute TIMING 1 from ttsql command prompt but when I tried the command EXECUTE IMMEDIATE 'TIMING 1' from a function, i got the error ORA-06512 Syntax error in SQL statement before or…
Chris
  • 541
  • 1
  • 4
  • 11
0
votes
0 answers

error shows when executing stored procedure using odbc

My powerbuilder application connect to Oracle timesten database using odbc. The application can connect to the databse and do dml (select, insert, update, delete) successfully. But when I executie a stored procedure, an error is shown "driver not…
Nazim Fathi
  • 1
0
votes
1 answer

Oracle TimesTen random string

i want to select a random string in oracle TimesTen (in memory database), im EXEC query like this : select DBMS_RANDOM.string('A', 6) AS "rnd" from dual but the error code raised : TT1001: Syntax error in SQL statement before or at: "(" Error…
Hamidreza Shahmoradi
  • 31
  • 1
  • 7
0
votes
1 answer

Unable to Connect Sqoop to Oracle TimesTen through JDBC on Linux

I have installed Timesten database (full version) on linux (Linux is guest OS installed through Oracle viritual box with cloudera VM) I am trying to run following sqoop command on linux and getting below errors command sqoop list-tables --connect…
CP Sinh
  • 1
  • 1
0
votes
1 answer

TimesTen database connection issue in python

I have 2 machines setup: RDP terminal with timesten client 11.2.1 and pyodbc==3.0.7 and works great. I use this connection string: cnxn = pyodbc.connect('DSN=myhostip;UID=myusername;PWD=mypass') local machine with timesten client 11.2.2 and…
povar
  • 11
  • 4
0
votes
2 answers

Which is the right choice to accelerate the search operation - Lucene based platform or in memory database like oracle TimesTen

My application is a data retrieval platform. We are planning to cache the data from oracle database into either an in-memory-database or to one of the 'lucene' based platforms. My data is rapidly changing. So the cache should also be refreshed fast…
Chris
  • 541
  • 1
  • 4
  • 11
0
votes
1 answer

hash indexes on replicated times ten db

I have have a replicated times ten database. I need to reset the page size of a number of hash indexes. when I update the page sizes it breaks replication and takes 10 hours to rebuild replicated databases. There has to be some way to up update…
peter cooke
  • 987
  • 3
  • 10
  • 28
0
votes
1 answer

connecting to oracle timesten via cx_oracle in sqlalchemy

I can connect to oracle via cx_Oracle in sqlalchemy by this connection string: connection_string = 'oracle+cx_oracle://user:pass@127.0.0.1/orcl' and also i can connect TimesTen by cx_Oracle using this: con =…
Thomas Anderson
  • 74
  • 1
  • 1
  • 9
0
votes
1 answer

Cannot unwrap TmesTen datasource JDBC object in JBoss EAP 6

I tried to get a TimesTenDataSource from JNDI loopup on JBoss EAP 6.4. I have the database configured in standalone.xml for timesten. If I use the Standard Jdbc objects i.e, DataSource, Connection, PreparedStatement then it all works. For some…
Ram C
  • 173
  • 3
  • 12
0
votes
1 answer

ODP.NET: Error when load data from Timesten refCursor to DataTable

I want to load data from Timesten DB to datatable, but i get error Here is my code Script: create or replace FUNCTION APITT_tbl_request(prefix_db IN VARCHAR2) RETURN SYS_REFCURSOR AS res SYS_REFCURSOR; BEGIN OPEN res FOR SELECT * FROM…
Nguyen Anh Duc
  • 45
  • 1
  • 1
  • 12
0
votes
1 answer

ODP.NET: How can i get data from dynamic sql to dataset

My application using TimesTen DB to store data. Below is my code to update data and return a updated row. conn = new OracleConnection("My Connection"); conn.Open(); OracleTransaction tran =…
Nguyen Anh Duc
  • 45
  • 1
  • 1
  • 12
0
votes
0 answers

Convert script from Postgre to Oracle

I have a query in postgre, i convert it to oracle but it's can not run update APITT_tbl_in set status ='Processing' where id = (select id from APITT_tbl_in where upper(status)='PENDING' and ROWNUM <= 1 order by priority, id FOR update)…
Nguyen Anh Duc
  • 45
  • 1
  • 1
  • 12
0
votes
1 answer

Multiple Maven Plugin Dependencies - Native library already loaded in another class loader

I am trying to write a maven script that drops and recreates an Oracle TimesTen database using sql-maven-plugin, and then apply a number of database migration scripts using dbdeploy during the pre-integration-test phase. Both of these plugins…
curtisjk
  • 1
  • 2
0
votes
3 answers

2222: Index name is not unique (TimesTen)

I have created two indexes on different materialized views with the same name in TimesTen and now cannot drop neither of them. If try to I get the following error message: 2222: Index name is not unique Could you please advise me how could I get…
M T
  • 968
  • 1
  • 8
  • 24
0
votes
2 answers

How to call Oracle TimesTen from JDBC in MaxOSX

I have installed Oracle TimesTen client on my Mac and Oracle TimesTen Server on a RedHat machine which I can connect remotely from command line connect "dsn=TT1122;UID=uid;PWD=pwd"; I got successful connection back. Now I want to use JDBC to try…
toy
  • 11,711
  • 24
  • 93
  • 176
1 2 3
4
5