Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 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
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 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!