mainApache Derby-Off to the Races: Includes Details of IBM Cloudscape @Team DDU0131855255.hhc0131855255/main.htmlmainTable of ContentsCopyrightIBM PressPrefaceAcknowledgmentsAbout the AuthorsNone: Part 1None: Part 2None: Part 3None: Part 4None: Part 5indexDB2® BooksOn Demand Computing BooksRational® Software BooksWebSphere® BooksMore Books from IBM PressExecutive Letter from Bob Picciano (Vice President of Database Servers, IBM)About This BookChapter 1. On Your Marks ... Get Set ... Go!!! An Introduction to the Apache Derby and IBM Cloudscape CommunityChapter 2. Deployment Options for Apache Derby DatabasesChapter 3. Apache Derby DatabasesChapter 4. Installing Apache Derby and IBM Cloudscape on WindowsChapter 5. Installing Apache Derby and IBM Cloudscape on LinuxChapter 6. Managing an Apache Derby DatabaseChapter 7. SecurityChapter 8. SQLChapter 9. Developing Apache Derby Applications with JDBCChapter 10. Developing Apache Derby Applications with Perl, PHP, Python, and ODBCChapter 11. "Your Momma Loves Drama" in JDBCChapter 12. "Your Momma Loves Drama" in WindowsChapter 13. "Your Momma Loves Drama" in PHPChapter 14. "Your Momma Loves Drama" in PerlChapter 15. "Your Momma Loves Drama" in PythonAppendix A. Web Site ContentsAppendix B. Apache Derby and IBM Cloudscape ResourcesAppendix C. Troubleshooting Hints and Tipsindex_SYMBOLindex_Aindex_Bindex_Cindex_Dindex_Eindex_Findex_Gindex_Hindex_Iindex_Jindex_Lindex_Mindex_Nindex_Oindex_Pindex_Qindex_Rindex_Sindex_Tindex_Uindex_Vindex_Windex_Xindex_YIntroductionLet Me Get This Straight, Apache Derby Is IBM Cloudscape?Development of the Apache Derby Database-Who Can Contribute and How?How Can IBM Sell a Product for Profit and Contribute the Same Product to the Open Source Community?How an Open Source Database Like Apache Derby Can HelpWhy the Need for a Local Data Store?Why Use a Relational Database?How the Apache Derby Platform Can Help Your BusinessA High-Level View of the Apache Derby DatabaseThe Apache Derby ComponentsDeveloping Apache Derby ApplicationsUsing the Embedded Framework for Apache Derby ApplicationsUsing the Server Framework for Apache Derby ApplicationsIntroductionDatabase StructureDatabase ObjectsSummaryMigration from Previous Versions of CloudscapeBefore You BeginUsing the Windows Installer to Install IBM Cloudscape on Windows-Attention Developers!Installing Apache Derby or IBM Cloudscape on Windows ManuallyVerifying the InstallationTroubleshooting an InstallationOdds and Ends About Your InstallationMigration from Previous Versions of CloudscapeBefore You BeginUsing the Linux Installer to Install IBM Cloudscape on Linux-Attention Developers!Installing Apache Derby or IBM Cloudscape on Linux ManuallyVerifying the InstallationTroubleshooting an InstallationOdds and Ends About Your InstallationDisaster Prevention and RecoveryData MovementDatabase Maintenance and TuningSummaryIntroductionDatabase File SecurityDatabase File EncryptionUser AuthenticationDatabase AuthorizationSummaryIntroductionYour Momma Loves Drama DatabaseData Definition Language (DDL)Data RetrievalData ModificationDevelopment SQLSummaryIntroductionJBDC Program StructureJDBC ImportsUsing Embedded JDBC DriversIBM DB2 JDBC Universal Driver for DerbyEstablishing a Database ConnectionConnecting with DB2 JDBC DriversAllocating StatementsExecuting Dynamic SQLTrapping SQLExceptionsSQLWarnings Versus SQLExceptionsRetrieving Query ResultsRetrieving Column ValuesDynamically Determining Result SetsPrepared StatementsAUTOCOMMIT, COMMITs, and ROLLBACKsBatching RequestsUsing Result Sets to Modify DataSetting a Column to NullInserting and Updating Large ObjectsStored ProceduresUser-Defined FunctionsApache Derby AppletsLocking ConsiderationsSummaryCommunicating with an Apache Derby Network ServerInstalling the DB2 Runtime ClientCataloging Apache Derby Network ServersCataloging Apache Derby DatabasesTesting Your ConnectionUncataloged ConnectionsSummaryIntroductionYour MYour Momma Loves Drama DatabaseThe Your Momma Loves Drama ApplicationYMLD OverviewInstalling the YMLD ApplicationYMLD InitializationConnecting to the YMLD SystemCurrent Performances at the TheaterSeat PricingTheater Seat MapPurchase Tickets by PerformanceView Transaction LogExit RoutineSummaryIntroductionThe Your Momma Loves Drama ApplicationInstalling the YMLD ApplicationYMLD InitializationConnecting to the YMLD SystemCurrent Performances at the TheaterTry/Catch BlockSeat PricingTheater Seat MapPurchase Tickets by PerformanceView Transaction LogExit RoutineSummaryPHP OverviewLearning the PHP LanguageInstalling and Configuring PHPCreating Apache Derby Applications with PHPSummaryPerl OverviewInstalling and Configuring PerlCreating Apache Derby Applications with PerlSummaryPython OverviewLearning the Python LanguageInstalling and Configuring PythonCreating Apache Derby Applications with PythonSummaryIntroductionWeb Site ContentsSummaryGeneral InformationApplication DevelopmentGetting to Know the IBM Cloudscape and Apache Derby DatabasesSupportNewsgroups and Mailing ListsIntroductionInstallationPerformance TuningSecurityDatabase FeaturesSQLJDBC Application DevelopmentSummary