Need help for the sqlite to BerkleyDB migration

4234721

Hi All,

I''m from OIT team of Oracle. Currently we are migrating from sqlite to Berkley DB. I'm facing few issues this. We make use of CMake to build code. So I have built the Berkley source code standalone and making use of the .lib for our application consumption.

After the integration I get the below errors when I build the code.

Error    1    error C2065: 'sqlite3_stmt' : undeclared identifier (C:\ADE\anushas_anu_main_pop\outsidein\OIT_CVOB\win32v\wvcore\fs\comQuery.cpp)    C:\ADE\anushas_anu_main_pop\outsidein\TOOLS\CPPUtil\Source\db\AliasElemSqlite.h    18    1    wv_core

Error    2    error C2059: syntax error : ',' (C:\ADE\anushas_anu_main_pop\outsidein\OIT_CVOB\win32v\wvcore\fs\comQuery.cpp)    C:\ADE\anushas_anu_main_pop\outsidein\TOOLS\CPPUtil\Source\db\AliasElemSqlite.h    18    1    wv_core

Error    3    error C2065: 'sqlite3_stmt' : undeclared identifier (C:\ADE\anushas_anu_main_pop\outsidein\OIT_CVOB\win32v\wvcore\fs\comQuery.cpp)    C:\ADE\anushas_anu_main_pop\outsidein\TOOLS\CPPUtil\Source\db\AliasElemSqlite.h    19    1    wv_core

Error    4    error C2059: syntax error : ',' (C:\ADE\anushas_anu_main_pop\outsidein\OIT_CVOB\win32v\wvcore\fs\comQuery.cpp)    C:\ADE\anushas_anu_main_pop\outsidein\TOOLS\CPPUtil\Source\db\AliasElemSqlite.h    19    1    wv_core

Error    5    error C2065: 'sqlite3_stmt' : undeclared identifier (C:\ADE\anushas_anu_main_pop\outsidein\OIT_CVOB\win32v\wvcore\fs\comQuery.cpp)    C:\ADE\anushas_anu_main_pop\outsidein\TOOLS\CPPUtil\Source\db\AliasElemSqlite.h    20    1    wv_core

Error    6    error C2059: syntax error : ',' (C:\ADE\anushas_anu_main_pop\outsidein\OIT_CVOB\win32v\wvcore\fs\comQuery.cpp)    C:\ADE\anushas_anu_main_pop\outsidein\TOOLS\CPPUtil\Source\db\AliasElemSqlite.h    20    1    wv_core

Error    7    error C2065: 'sqlite3_stmt' : undeclared identifier (C:\ADE\anushas_anu_main_pop\outsidein\OIT_CVOB\win32v\wvcore\fs\comQuery.cpp)    C:\ADE\anushas_anu_main_pop\outsidein\TOOLS\CPPUtil\Source\db\AliasElemSqlite.h    21    1    wv_core

Error    8    error C2059: syntax error : ',' (C:\ADE\anushas_anu_main_pop\outsidein\OIT_CVOB\win32v\wvcore\fs\comQuery.cpp)    C:\ADE\anushas_anu_main_pop\outsidein\TOOLS\CPPUtil\Source\db\AliasElemSqlite.h    21    1    wv_core

Error    9    error C2146: syntax error : missing ';' before identifier 'pTxtAlias' (C:\ADE\anushas_anu_main_pop\outsidein\OIT_CVOB\win32v\wvcore\fs\comQuery.cpp)    C:\ADE\anushas_anu_main_pop\outsidein\TOOLS\CPPUtil\Source\db\AliasElemSqlite.h    49    1    wv_core

Error    10    error C4430: missing type specifier - int assumed. Note: C++ does not support default-int (C:\ADE\anushas_anu_main_pop\outsidein\OIT_CVOB\win32v\wvcore\fs\comQuery.cpp)    C:\ADE\anushas_anu_main_pop\outsidein\TOOLS\CPPUtil\Source\db\AliasElemSqlite.h    49    1    wv_core

Error    11    error C2146: syntax error : missing ';' before identifier 'pIntAlias' (C:\ADE\anushas_anu_main_pop\outsidein\OIT_CVOB\win32v\wvcore\fs\comQuery.cpp)    C:\ADE\anushas_anu_main_pop\outsidein\TOOLS\CPPUtil\Source\db\AliasElemSqlite.h    69    1    wv_core

Error    12    error C4430: missing type specifier - int assumed. Note: C++ does not support default-int (C:\ADE\anushas_anu_main_pop\outsidein\OIT_CVOB\win32v\wvcore\fs\comQuery.cpp)    C:\ADE\anushas_anu_main_pop\outsidein\TOOLS\CPPUtil\Source\db\AliasElemSqlite.h    69    1    wv_core

Error    13    error C2146: syntax error : missing ';' before identifier 'pNullAlias' (C:\ADE\anushas_anu_main_pop\outsidein\OIT_CVOB\win32v\wvcore\fs\comQuery.cpp)    C:\ADE\anushas_anu_main_pop\outsidein\TOOLS\CPPUtil\Source\db\AliasElemSqlite.h    82    1    wv_core

Error    14    error C4430: missing type specifier - int assumed. Note: C++ does not support default-int (C:\ADE\anushas_anu_main_pop\outsidein\OIT_CVOB\win32v\wvcore\fs\comQuery.cpp)    C:\ADE\anushas_anu_main_pop\outsidein\TOOLS\CPPUtil\Source\db\AliasElemSqlite.h    82    1    wv_core

Error    15    error C2146: syntax error : missing ';' before identifier 'pDblAlias' (C:\ADE\anushas_anu_main_pop\outsidein\OIT_CVOB\win32v\wvcore\fs\comQuery.cpp)    C:\ADE\anushas_anu_main_pop\outsidein\TOOLS\CPPUtil\Source\db\AliasElemSqlite.h    97    1    wv_core

Error    16    error C4430: missing type specifier - int assumed. Note: C++ does not support default-int (C:\ADE\anushas_anu_main_pop\outsidein\OIT_CVOB\win32v\wvcore\fs\comQuery.cpp)    C:\ADE\anushas_anu_main_pop\outsidein\TOOLS\CPPUtil\Source\db\AliasElemSqlite.h    97    1    wv_core

Error    17    error C2065: 'sqlite3_stmt' : undeclared identifier (C:\ADE\anushas_anu_main_pop\outsidein\OIT_CVOB\win32v\wvcore\fs\fsRecSet.cpp)    C:\ADE\anushas_anu_main_pop\outsidein\TOOLS\CPPUtil\Source\db\AliasElemSqlite.h    18    1    wv_core

Error    18    error C2059: syntax error : ',' (C:\ADE\anushas_anu_main_pop\outsidein\OIT_CVOB\win32v\wvcore\fs\fsRecSet.cpp)    C:\ADE\anushas_anu_main_pop\outsidein\TOOLS\CPPUtil\Source\db\AliasElemSqlite.h    18    1    wv_core

Error    19    error C2065: 'sqlite3_stmt' : undeclared identifier (C:\ADE\anushas_anu_main_pop\outsidein\OIT_CVOB\win32v\wvcore\fs\fsRecSet.cpp)    C:\ADE\anushas_anu_main_pop\outsidein\TOOLS\CPPUtil\Source\db\AliasElemSqlite.h    19    1    wv_core

Error    20    error C2059: syntax error : ',' (C:\ADE\anushas_anu_main_pop\outsidein\OIT_CVOB\win32v\wvcore\fs\fsRecSet.cpp)    C:\ADE\anushas_anu_main_pop\outsidein\TOOLS\CPPUtil\Source\db\AliasElemSqlite.h    19    1    wv_core

Error    21    error C2065: 'sqlite3_stmt' : undeclared identifier (C:\ADE\anushas_anu_main_pop\outsidein\OIT_CVOB\win32v\wvcore\fs\fsRecSet.cpp)    C:\ADE\anushas_anu_main_pop\outsidein\TOOLS\CPPUtil\Source\db\AliasElemSqlite.h    20    1    wv_core

Error    22    error C2059: syntax error : ',' (C:\ADE\anushas_anu_main_pop\outsidein\OIT_CVOB\win32v\wvcore\fs\fsRecSet.cpp)    C:\ADE\anushas_anu_main_pop\outsidein\TOOLS\CPPUtil\Source\db\AliasElemSqlite.h    20    1    wv_core

It says the that the API's and structs in sqlite3.c file is not found. I'm not sure what I'm missing, or any other better approach if you people can suggest would be of great help.

Laurenfoutz-Oracle

I believe you have to build both Berkeley DB library and the SQL API as a library (comes out as libdb_sql*) as standalone libraries then link that up with your program.  Unlike non-Berkeley DB sqlite you cannot just include the sqlite3.c file in your build while building with it.

Lauren Foutz

Laurenfoutz-Oracle

I believe you have to build both Berkeley DB library and the SQL API as a library (comes out as libdb_sql*) as standalone libraries then link that up with your program.  Unlike non-Berkeley DB sqlite you cannot just include the sqlite3.c file in your build while building with it.

Lauren Foutz

4323903

Did you could make this work? I would like to know the steps to achieve this, I want to do the same with an app in C# using SQLite  i want to use berkeley db to be able to allow multiple users to write to the database at same time, hope you can help me.

AndyGlick

I suppose you are attempting to build the latest version 18.1.40?

Between the 18.1.32 release and 18.1.40 all of the sqlite c code was stripped out of the distribution.

Some months ago I figured this out and actually found an oracle page somewhere that actually stated that support for the sqlite implementation has been cancelled.

Suffice it to say that looking for such a message now I am unable to find any announcement.

Hurray for Oracle!