<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Luis,<div><br></div><div>Sandra is out today so I'll help.</div><div>I just tried what was sent to you for instructions and they worked, with</div><div>some modifications:</div><div><br></div><div>1. I added the db_sql_jdbc project and changed the Linker->General->Output File to $(OutDir)/sqlite_jni.dll</div><div>For good measure I also changed</div><div>Linker->Debugging->Generate Program Database File</div><div>and</div><div>Linker->Advanced->Import Library</div><div>similarly to add "sqlite_jni"</div><div>I don't think these are necessary but I did them.</div><div><br></div><div>2. I had to build the db library first in the solution (project "db"). At this time</div><div>the db_sql project depends on this so it's necessary. This step may have been missing</div><div>from your instructions.</div><div>3. I then built the db_sql project </div><div>4. I then built the db_sql_jdbc project</div><div>5. The command for testing is, in build_windows/Win32/Debug (or Release if you built that):</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>java -classpath jdbc.jar -Djava.library.path=. SQlite.Shell test.db</div><div><br></div><div><br></div><div>That worked. The test.db and test.db-journal were populated correctly.</div><div> I happen to be using Visual Studio 2008 Express on Windows 7 but if anything</div><div>VS2005 will be smoother since there are no project file conversions required.</div><div><br></div><div>If you start over you should start with a clean directory. Also make sure that your</div><div>PATH does not accidentally point to any old DB- or SQLite-related dlls.</div><div><br></div><div>Regards,</div><div>George</div><div><br></div><div><br><div><div>On Feb 25, 2010, at 6:47 AM, Luis Paolini wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div lang="PT-BR" link="blue" vlink="purple"><div class="Section1"><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; ">Hi Sandra,<o:p></o:p></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><o:p> </o:p></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "> <span lang="EN-US">Thanks for the detailed instructions.<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US">I followed the steps below and got an error on step 8 (building the solution).<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"> <o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"> Here are some details for each step.<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 53.25pt; font-size: 10.5pt; font-family: Consolas; text-indent: -18pt; "><span lang="EN-US"><span>0)<span style="font: normal normal normal 7pt/normal 'Times New Roman'; "> </span></span></span><span lang="EN-US">From the "Building the Java API" section of the Building Berkeley DB for Windows documentation:<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 35.25pt; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US">I configured the directories according to my java jdk installation.<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 35.25pt; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US">C:\Program Files\Java\jdk1.6.0_16\include, C:\Program Files\Java\jdk1.6.0_16\include\win32 and<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 35.25pt; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US">C:\Program Files\Java\jdk1.6.0_16\bin<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 35.25pt; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"> 2) Apply the attached patch 18298_win_jdbc.diff<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"> <o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"> I installed the patch application and executed the command:<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"> D:\Downloads\Oracle\Berkeley_Beta\db-5.0.11\db-5.0.11>"C:\Program Files\GnuWin32\bin\patch.exe" -p1 -i 18298_win_jdbc.diff<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"> I’m not sure if I had to modify the file 18298_win_jdbc.diff before running the patch. (Something related to </span>Windows end-of-line<o:p></o:p></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; ">Endings)<span lang="EN-US"><o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"> <o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"> 3) Copy the attached "Constants.java" file into the sql/jdbc/SQLite/ directory.<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"> <o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"> Just copied the file “Contants.java” into D:\Downloads\Oracle\Berkeley_Beta\db-5.0.11\db-5.0.11\sql\jdbc\SQLite<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"> 4) Open the build_windows/Berkeley_DB.sln file in Visual Studio<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"> Opened build_windows/Berkeley_DB.sln file in Visual Studio<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"> 5) Select "File->Add->Existing Project", and add "build_windows/db_sql_jdbc.vcproj" into the solution.<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"> Just added build_windows/db_sql_jdbc.vcproj" into the solution.<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US">6) Right-click db_sql_jdbc in the solution explorer, and select "Properties".<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US"><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US">Ok.<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US"><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US">7) In Linker->General. Set the "Output File" to be "$(OutDir)/sqlite_jni.dll" (it is "$(OutDir)/.dll" before you change it).<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US"><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US">Configured the “Output File” to be "$(OutDir)/sqlite_jni.dll"<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US">8) Either build the solution, or the "db_sql" project.<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US"><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US">After building the solution I got the following summary:<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US" style="font-size: 8pt; font-family: 'Courier New'; ">========== Build: 57 succeeded, 1 failed, 0 up-to-date, 10 skipped ==========<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US" style="font-size: 8pt; font-family: 'Courier New'; "><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US">Looking for the fail, I got this:<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; text-indent: 35.4pt; "><span lang="EN-US" style="font-size: 8pt; font-family: 'Courier New'; ">5>Linking...<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; text-indent: 35.4pt; "><span lang="EN-US" style="font-size: 8pt; font-family: 'Courier New'; ">5>LINK : fatal error LNK1181: cannot open input file 'libdb_sql50d.lib'<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; text-indent: 35.4pt; "><span lang="EN-US" style="font-size: 8pt; font-family: 'Courier New'; ">5>Build log was saved at "<a href="file:///d:\Downloads\Oracle\Berkeley_Beta\db-5.0.11\db-5.0.11\build_windows\Win32\Debug\db_sql_jdbc\BuildLog.htm" style="color: blue; text-decoration: underline; ">file://d:\Downloads\Oracle\Berkeley_Beta\db-5.0.11\db-5.0.11\build_windows\Win32\Debug\db_sql_jdbc\BuildLog.htm</a>"<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US" style="font-size: 8pt; font-family: 'Courier New'; ">5>db_sql_jdbc - 1 error(s), 1 warning(s)<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US"><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"> The BuildLog.htm file is attached.<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"> After that I tried to rebuild the “db_sql” project and I got the following summary:<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US" style="font-size: 8pt; font-family: 'Courier New'; ">========== Rebuild All: 2 succeeded, 0 failed, 0 skipped ==========<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US" style="font-size: 8pt; font-family: 'Courier New'; "><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US">9) Build the db_sql_jdbc project. The project assumes you have Java (1.6) installed in your path.<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US" style="font-size: 8pt; font-family: 'Courier New'; "><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US">Finally, I Built the db_sql_jdbc project and got the following summary</span><span lang="EN-US" style="font-size: 8pt; font-family: 'Courier New'; "><o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US" style="font-size: 8pt; font-family: 'Courier New'; "><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US" style="font-size: 8pt; font-family: 'Courier New'; ">========== Rebuild All: 1 succeeded, 0 failed, 0 skipped ==========<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US" style="font-size: 8pt; font-family: 'Courier New'; "><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US"><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US">Testing:<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US"> <o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US">I executed the command java -classpath jdbc.jar -Djava.library.path=. SQLite.Shell test.db<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US">The SQLite console was opened.<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US">The directory test.db-journal was created by it was empty.<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US"><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; text-indent: 35.4pt; "><span lang="EN-US"><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US">Regards,<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US">Luis<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 10.5pt; font-family: Consolas; "><span lang="EN-US"> </span></div></div></div></span></blockquote></div></div></body></html>