Current Position:Home > TimesTen and Eclipse java development problem

TimesTen and Eclipse java development problem

Update:11-30Source: network consolidation
Hello all
Using TimesTen with JDBC in from a Java code developed on Eclipse I encounter a problem: when running the program in debug mode, everything works fine. Running without debug, or outside Eclipse, results in the following error:
java.sql.SQLException: [TimesTen][TimesTen ODBC Driver][TimesTen]TT0837: Cannot attach data store shared-memory segment, error 8 -- file "db.c", lineno 7891, procedure "sbDbCreate"
Does anyone know the cause of this, or can point me to logs or other resources I can look into?
Shaul Peled
Nuance Communication Inc.

The Best Answer

Okay, it is almost certainly an address space issue. Unfortunately 32-bit Windows is about the most problematic platform from this perspective. A TimesTen datastore is a single, contiguous memory region of size approximating PermSize+TempSize+LogBuffSize+DS header. In your case that will be about 1098 Mb. To 'connect' to this datastore, it is necessary to map the datastore memory (it is a shared mapping allocated from the Windows paging file) into your process (in this case the JVM) as a single region. Unfortunately, unlike most O/S, in Windows shared libraries (DLLs) have to be loaded at fixed locations in the address space defined when the DLL was linked. This means that although your process has a 4 GB address space (with quite a bit reserved for WIndows and other uses) that space is often highly fragmented with various DLLs (system and application) located all over the place. This means that often it is hard to find a single contiguous address space region to map a large datastore.
To verify that this is the issue, could you try reducing the datastore size to say PermSize=128, TempSize=64 and see if you can connect then. If you can then you will have to experiment by slowly increasing Perm and Temp until you find the maximum size store you can accomodate. If you are using no logging (Are you sure that is what you want? You will end up with a single threaded datastore if you do that...) you could reduce LogBuffSize to the smallest allowed value (128 Kb).
If it does turn out to be an address space issue then you have 3 options:
1. Live with a smaller datastore size.
2. Try and re-arrange the memory map by rebasing DLLs to create a larger contiguous region. Note that ijn any event it is very unlikely you will ever be able to exceed ~1.5 Gb for a datastore.
3. Switch to 64-bit Windows, 64-bit TimesTen and a 64-bit JVM. Then the only limit on datastore size is available RAM.
Let me know the outcome.
  • TimesTen and Eclipse java development problem Update:11-30

    Hello all Using TimesTen with JDBC in from a Java code developed on Eclipse I encounter a problem: when running the program in debug mode, everything works fine. Running without debug, or outside Eclipse, results in the following error: java.sql.SQLE

  • [SOLVED] Unable to install "Eclipse Java Developers" Update:11-30

    Hey everyone, I am setting up a new dev machine and need to install Eclipse (java developer version).  From what I can tell the Eclipse Classic does not include the Marketplace and I need it to install the Emacs+ plugin (I have a hard time typing wit

  • Error while installing SAP Widget Developer on Eclipse Java EE IDE Update:10-11

    Hello,           I am new to SAP widget. I hav installed "Eclipse Java EE IDE for Web Developers" from and now when i was trying to install SAP Widget Developer add-on as stated in the SAP Enterprise Widget Development Guide

  • Is Eclipse (java viewer) for CR still being developed? Update:11-30

    Hello, Is the Eclipse (Crystal java viewer) still being invested in from a development perspective? I'm currently using the .NET (HTML) viewer because of two reasons: 1. The Java viewer has embedded flash functions which render it useless on Apple de

  • Hiring JAVA Developer for Eclipse, Czech republic - BRNO Update:11-30

    For our client we are looking for a passionate Java developer. This position is for experienced developers. Our client in Brno develops software tools for programming microcontrollers (Kinetis Design Studio). JAVA developer will be responsible for so

  • Java Development Role problems! Update:10-11

    I have tried to add the java development role to a users account. I have added the following roles: SAP_JAVA_NWADMIN_CENTRAL SAP_JAVA_NWADMIN_LOCAL Apparently they are meant to get a new tab but it does not appear. Am I adding the right roles?Hi Phil

  • How to plugin oracle 10g express edition in Eclipse Java EE Update:10-11

    Hi guys, I have downloaded Eclipse Java EE and also downloaded Oracle 10g express edition. Please some one guide me how do I plugin the database in Eclipse and use DTP in Eclipse. I am new to Oracle and Java, Please help me. ThanksHi, I have installe

  • Flex / Java Developer Needed Update:11-30

    Brilig ( is a fun and exciting startup who are changing the world of online advertising. We are currently looking for a talented and energetic Flex/Java developer to join our team for the key role of front end interface developer. We a

  • Flex for Java Developer? Update:10-11

    I am working on flex 1.5 from last 7 months.Ealier i hv worked on Java (1.5 Yr) I hv created an application in flex sucessfully. My Qtn is: Whether i have to continue with flex or move to another technologies like Struts etc. Because i have nil knowl

  • Oracle Database Express Edition 2 Day Plus Java Developer Guide?? Update:10-11

    I posted in the JDeveloper forum, as well as sending email via your feedback link found on the tutorial but I am a little disappointed by this: The Oracle® Database Express Edition 2 Day Plus Java Developer Guide has some errors in it. in Windows, I