Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.2K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 436 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Need help for the sqlite to BerkleyDB migration

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.
Best Answer
-
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
Answers
-
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
-
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.
-
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!