5426l1.txt100664 2046 330 550 7343756033 11130 0ustar jillljedit5426l1 Listing 1. Welcome.html, the XMLC Input File We<\#146>ll Use to Display Our Weblog Weblog

Weblog

Welcome to our Weblog! Here is the latest entry:

Date

Text

5426l2.txt100664 2046 330 1204 7343756033 11146 0ustar jillljedit5426l2 Listing 2: blog.doml, the Automatically Generated File that DODS Creates
5426l3.txt100664 2046 330 3546 7343756033 11162 0ustar jillljedit5426l3 Listing 3: WelcomePresentation.java, the Java Class that Displays Our HTML with Input from the Database /* * blog * * Enhydra super-servlet presentation object * */ package il.co.lerner.presentation; // Enhydra SuperServlet imports import com.lutris.appserver.server.httpPresentation.HttpPresentation; import com.lutris.appserver.server.httpPresentation.HttpPresentationComms; import com.lutris.appserver.server.httpPresentation.HttpPresentationException; // The following two lines import our specific data objects import blog.*; import com.lutris.dods.builder.generator.query.*; // We will use a Vector to build our query import java.util.Vector; // Standard imports import java.io.IOException; import java.util.Date; import java.text.DateFormat; public class WelcomePresentation implements HttpPresentation { public void run(HttpPresentationComms comms) throws HttpPresentationException, IOException, NonUniqueQueryException, DataObjectException, QueryException { // Get the HTML from the Welcome page as an object WelcomeHTML welcome = (WelcomeHTML)comms.xmlcFactory.create(WelcomeHTML.class); // Create a new query object BlogEntriesQuery blogq = new BlogEntriesQuery(); // Retrieve entries that came before now -- this lets us write // blog entries with future dates, which comes on-line // automatically at a certain point blogq.setQueryEntrydate("NOW()", QueryBuilder.LESS_THAN); // Indicate that we want DESC order blogq.addOrderByEntrydate(false); // Execute our query, returning an array of blog entries BlogEntriesDO[] blogEntries = blogq.getDOArray(); // Put the first text and date entries in the text welcome.setTextDate(blogEntries[0].getEntrydate()); welcome.setTextText(blogEntries[0].getText()); // Send the HTML back to the user's browser comms.response.writeDOM(welcome); } } 5426l4.txt100664 2046 330 4312 7343756033 11153 0ustar jillljedit5426l4 Listing 4: The <\#147>database<\#148> Section from blog.conf, which Needs to Be Modified for PostgreSQL to Work #----------------------------------------------------------------------------- # Database Manager Configuration #----------------------------------------------------------------------------- # # DatabaseManager.Databases[] = "blog" # # The default database used in this application. # DatabaseManager.DefaultDatabase = "blog" # # Turn on/off debugging for transactions or queries. Valid values # are "true" or "false". # DatabaseManager.Debug = "true" # # The type of database. Normally this is "Standard". # DatabaseManager.DB.blog.ClassType = "Standard" # # The jdbc driver to use. # DatabaseManager.DB.blog.JdbcDriver = "org.postgresql.Driver" # # Database url. # DatabaseManager.DB.blog.Connection.Url = "jdbc:odbc:blog" # # Database user name. All connection are allocated by this user. # DatabaseManager.DB.blog.Connection.User = "reuven" # # Database user password. # DatabaseManager.DB.blog.Connection.Password = "" # # The maximum number of connections that a connection # pool will hold. If set to zero, then connections # are allocated indefinitly or until the database # refuses to allocate any new connections. # DatabaseManager.DB.blog.Connection.MaxPoolSize = 30 # # Maximum amount of time that a thread will wait for # a connection from the connection pool before an # exception is thrown. This will prevent possible dead # locks. The time out is in milliseconds. If the # time out is <= zero, the allocation of connections # will wait indefinitely. # DatabaseManager.DB.blog.Connection.AllocationTimeout = 10000 # # Used to log database (SQL) activity. # DatabaseManager.DB.blog.Connection.Logging = true # # The number of object identifiers that are allocated # as a group and held in memory. These identifiers # are assigned to new data objects that are inserted # into the database. # DatabaseManager.DB.blog.ObjectId.CacheSize = 20 DatabaseManager.DB.blog.ObjectId.MinValue = 1000000 # # Following two lines must be added for PostgreSQL, # since oID can't be used for column name # DatabaseManager.ObjectIdColumnName = "ObjectId" DatabaseManager.VersionColumnName = "ObjectVersion"