Stack Overflow
Stack Overflow

Questions tagged [extensible-storage-engine]

The Extensible Storage Engine (ESENT) is an embeddable, transactional database engine built into Microsoft Windows. The API documentation is available on MSDN.

33 questions
4
votes
2 answers

Inserting a million small records into Extensible Storage Engine (JetBlue) - quickly

I'm hoping Laurion Burchall reads this :-) I need to insert a million tiny records as quickly as possible. Right now I'm in a very tight loop where, for every record, I a) start a transaction (JetBeginTransaction) b) prepare an update…
stuck
  • 2,264
  • 2
  • 28
  • 62
4
votes
2 answers

how to get AutoIncrement value after JetUpdate() in Extensible Storage Engine (JetBlue)

after calling JetSetColumns() and then JetUpdate() how do I retrieve the values for any freshly assigned autoincrement values?
stuck
  • 2,264
  • 2
  • 28
  • 62
3
votes
1 answer

Is there an ORM out there that supports ESE?

Well, I started writing a managed ORM for ESE based on the ESE interop project. I was wondering if anyone knows of any other ORMs out there that support ESE?
Sam Saffron
  • 128,308
  • 78
  • 326
  • 506
3
votes
1 answer

Restore full external ESENT backup

I've wrote the code that creates full backups of my ESENT database, using JetBeginExternalBackup API. Following the MSDN guidelines, I backed up every file returned by JetGetAttachInfo and JetGetLogInfo. I've made the backup, erased old database,…
Soonts
  • 20,079
  • 9
  • 57
  • 130
2
votes
0 answers

How to quickly store large records in Extensible Storage Engine

I'm using Extensible Storage Engine to cache a number of large records - these records tend to be about 2MB in size (each) Often they will be deleted within a few hours, it's rare that they live for more than this amount of time I'm in a tight loop…
stuck
  • 2,264
  • 2
  • 28
  • 62
2
votes
1 answer

How to make Extensible Storage Engine Database Shrink? - the database should not have much data inside?

Hoping Laurion Burchall is listening :) My database has a longbinary field that is used to temporarily cache some data. The data may not actually be needed for very long. Typical sizes range from 1k to 3MB I've noticed the size of the database…
stuck
  • 2,264
  • 2
  • 28
  • 62
2
votes
1 answer

ESE column type to XmlSerialize arbitrary objects

What's the best ESE column type to XmlSerialize an object to my ESE DB? Both "long binary" and "long ASCII text" work OK. Reason for long binary: absolutely sure there's no characters conversation. Reason for long text: the XML is text. It seems…
Soonts
  • 20,079
  • 9
  • 57
  • 130
1
vote
0 answers

JET/Esent: SeekEQ finds no matches with multi-column index and wildcards

I have a 5-column table with a 2-column primary index. Let's say the index is defined as (Col1, Col2). In the the following snippet, Api.TrySeek returns false and I'm not sure why: Api.JetSetCurrentIndex(session, table, null); // this should match…
anonymous38912
  • 31
  • 4
1
vote
1 answer

What to do with JET_errVersionStoreOutOfMemory on JetUpdate

When I call JetUpdate() I sometimes get either JET_errVersionStoreOutOfMemory or JET_errVersionStoreOutOfMemoryAndCleanupTimedOut. The machine has plenty of free RAM and disk space, what does this error mean - and more important, what do I do about…
stuck
  • 2,264
  • 2
  • 28
  • 62
1
vote
2 answers

How to read columns names in table in ESE using C language and esent.lib?

I need a code example. I'd like to see how we can enumerate columns names in table. (It's essential for me to use esent.dll/esent.lib and C language) I tried to use attached code (found a guide but it doesn't work as I expect). JET_COLUMNLIST…
Roma
  • 55
  • 8
1
vote
1 answer

can JetSetColumns be used to replace JET_coltypLongBinary values?

if I call JetSetColumn() to replace the contents of a JET_coltypLongBinary value the operation works as I expect - the value is replaced however, if I call JetSetColumns() the value is not replaced - instead the value remains at its old value. …
stuck
  • 2,264
  • 2
  • 28
  • 62
1
vote
1 answer

How to restore / recover ESE DB using Microsoft's API

What I'm basically trying to achieve here is a proper way to restore a dirty DB. esentutl /mh db.dat yields the following output which is fine because i took a copy of the DB while being opened by another program. is it possible to open the DB…
igal k
  • 1,883
  • 2
  • 28
  • 57
1
vote
1 answer

ODBC drivers to access ESE edb file

are their any odbc drivers to access edb file on Windows 7. I am trying to access edb file from Query Tool ODBC tool.But until i am not able to connect to the db. Please let me know how to connect to edb file .Where can i find ODBC drivers for edb…
Chips
  • 65
  • 1
  • 9
1
vote
1 answer

in ESE (JetBlue) is there a way to limit a search with multiple keys?

In Extensbile Strage Engine (ESE/JetBlue) I've got a table that contains data I'd like to locate using two indexes assuming that each row has three integers X, Y, and Z. I'd like to quickly locate all the rows where X=10 and Y=20 (for example) the…
stuck
  • 2,264
  • 2
  • 28
  • 62
1
vote
1 answer

Can I access an ESE database that is already in use?

The windows ESE engine API call JetAttachDatabase have a readonly option. Can I use this to mount a database that is already mounted by another process?
Hannes de Jager
  • 2,903
  • 6
  • 37
  • 57
1
2 3