We're in the process in moving to Postgres and have seen some of this ourselves. I have also seen it from time to time in mysql.
I think there is case sensitivity in Postgres. what is the table named? companies or Companies. Turn on debugging like so: (Table is the class that I think contains the select query for a DbForm tag) log4j.category.org.dbforms.event.InsertEvent=INFO log4j.category.org.dbforms.event.UpdateEvent=INFO log4j.category.org.dbforms.event.DeleteEvent=INFO log4j.category.org.dbforms.util.SQLUtil=INFO log4j.category.org.dbforms.Table=INFO log4j.category.org.dbforms.taglib.DbFormTag=INFO use a file log like so: #### Second appender writes to a file log4j.appender.R=org.apache.log4j.RollingFileAppender log4j.appender.R.File=testapp.log and check out the select query that results in that log. Then try running that query. I have once found that if I take out the number of isKey=true fields then I am more likely to see data. Double check the naming and types of all the fields and the dbconfig file for exactness in data types and case sensitivity. Dbforms seems mysql-ish in its treatment of types. (I've yet to see a doc that explains what to put in the type attribute but it seems forgiving) I think there might be a bug in Table for large quantities of keys or other special cases. Are you linking to it with a dbform link? ----------------------------------------------- I have set up DbForms to work with PostgreSQL but when I try to select records from a table I am getting a blank page, though the table has records. My DbForms tag is : <db:dbform tableName="Companies" maxRows="20" followUp="/admin/companies/companies.jsp" autoUpdate="false" captionResource="true"> .... </db:dbform> The PostgreSQL log is showing the following: ERROR: Relation "companies" does not exist DEBUG: pq_recvbuf: recv() failed: The connection was aborted What could be the problem? I will really appreciate any clue. Thanks in advance. ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
