Yes. I verified within the GetRslt() that there are rows being returned.
I did a System.out.println(rslt.getRow())
John
-----Original Message-----
From: Bernd Bohmann [mailto:[EMAIL PROTECTED]
Sent: Monday, March 06, 2006 12:01 PM
To: MyFaces Discussion
Subject: Re: Tobago sheet using jdbc ResultSet example request
Are you sure that getRslt() returns not null?
And can you check that the resultSet contains rows?
John schrieb:
No change except no rows found is not reported.
package com.pop3gateway;
import com.pop3gateway.MessageObject.*; import java.util.HashMap;
import java.util.*; import java.io.Serializable; import java.io.*;
import java.sql.*;
/**
* <p>Title: Extensible Messaging Platform</p>
* <p>Description: Enterprise Anti-spam Filter</p>
* <p>Copyright: Copyright (c)1997-2004</p>
* <p>Company: J.A. Korsmeyer, Inc.</p>
* @author J.A. Korsmeyer, Inc.
* @version 5.5
*/
public class Quarantine extends DatabaseServer {
//static final long serialVersionUID = -3537385394408850867L;
//protected QuarantineRec QuarantineRec = null;
protected boolean hit = false;
protected boolean success = true;
File messageFile = null;
File messageFile2 = null;
PreparedStatement stQuerySenderRecipient = null;
PreparedStatement stQuerySender = null;
PreparedStatement stQueryRecipient = null;
PreparedStatement stQueryRecipientLike = null;
PreparedStatement stInsertRec = null;
PreparedStatement stDeleteRec = null;
String quarantine = System.getProperty("EMP.home") +
File.separatorChar +
"Data"
+ File.separatorChar + "RouterProcessorEngines" +
File.separatorChar
+ "0" + File.separatorChar + "Quarantine";
String msgObjs = System.getProperty("EMP.home") + File.separatorChar
+
"Data"
+ File.separatorChar + "RouterProcessorEngines" +
File.separatorChar
+ "0" + File.separatorChar + "MessageObjects";
public Quarantine() {
this(System.getProperty("EMP.home") + File.separatorChar + "Db");
System.out.println("we ran the beans constructor");
//super();
}
public Quarantine(String databaseDir) {
super(databaseDir);
System.out.println("We're ready to test if Quarantine tables
exist");
if(!quarantineTablesExist()) {
//System.out.println("They don't so create");
try {
Statement createTableStatement =
dbConnection.createStatement();
System.err.println("create table statement");
Statement createIE1Statement = dbConnection.createStatement();
Statement createIE2Statement = dbConnection.createStatement();
System.err.println("create table");
createTableStatement.execute("CREATE CACHED TABLE
quarantine(FILENAME CHAR(64), SENDER CHAR(128), RECIPIENT CHAR(128),
SUBJECT CHAR(128), FILTEREDBY CHAR(24), MATCHTEXT CHAR(128),
CONSTRAINT cQuarPRI PRIMARY KEY (FILENAME))");
createIE1Statement.execute("CREATE INDEX IEQ1 ON
quarantine(SENDER)");
createIE2Statement.execute("CREATE INDEX IEQ2 ON
quarantine(RECIPIENT)");
}
catch (SQLException sqlCreateQuarantineE) {
System.err.println("ERROR: unable to create table
quarantine");
sqlCreateQuarantineE.printStackTrace();
}
}
// prepare statements for later use
initQuarantine();
}
private String test = "beginning value";
private Object sheetState;
private ResultSet rslt = null;
boolean more = false;
String returnSender = null;
File dbDirPath = null;
QuarantineRec quarantineRec = null;
public void initQuarantine() {
dbDirPath = new File(System.getProperty("EMP.home") +
File.separatorChar + "Db");
//System.out.println("just entered init");
quarantineRec = new QuarantineRec();
try {
setDatabaseDir(dbDirPath.getCanonicalPath());
dbConnect();
stQuerySenderRecipient = dbConnection.prepareStatement(
"SELECT * FROM quarantine WHERE sender=? AND recipient=?",
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
//System.out.println("just prepared
stQuerySenderRecipient");
stQuerySender = dbConnection.prepareStatement(
"SELECT * FROM quarantine WHERE sender=?",
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
//System.out.println("just prepared stQuerySender");
stQueryRecipient = dbConnection.prepareStatement(
"SELECT * FROM quarantine WHERE recipient=?",
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
stQueryRecipientLike = dbConnection.prepareStatement(
"SELECT * FROM quarantine WHERE recipient LIKE ?",
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
//System.out.println("just prepared stQueryRecipient");
stInsertRec = dbConnection.prepareStatement("INSERT INTO
quarantine VALUES(?,?,?,?,?,?)");
stDeleteRec = dbConnection.prepareStatement("DELETE FROM
quarantine WHERE filename = ?");
messagesList("[EMAIL PROTECTED]");
System.out.println("just called messagesList()");
} catch (SQLException stmtPrepE) {
System.err.println("ERROR: Couldn't prepare statements");
}
catch ( IOException dbPathE ) {
System.err.println("ERROR: Couldn't find path to DB directory");
}
}
public boolean quarantined(String sender, String recipient) {
hit = false;
if( sender != null && recipient != null ) {
try {
stQuerySenderRecipient.setString(1,
deFocus(sender).toLowerCase());
stQuerySenderRecipient.setString(2, recipient.toLowerCase());
rslt = stQuerySenderRecipient.executeQuery();
if (rslt != null && rslt.next()) {
hit = true;
}
}
catch (SQLException queryE) {}
}
return hit;
}
public boolean quarantined(SMTPMessageObject mo) {
hit = false;
if (mo.getSender() != null) {
try {
stQuerySender.setString(1,
deFocus(mo.getSender().toLowerCase()));
//System.out.println("getSender= " + deFocus(mo.getSender()));
//System.out.println("recipientsString= " +
mo.getRecipientsAsString());
rslt = stQuerySender.executeQuery();
if (rslt != null) more = rslt.next();
while (more && rslt != null) {
//System.out.println("recipient=" + rslt.getString(2));
//System.out.println("recipString=" +
mo.getRecipientsAsString());
if
(mo.getRecipientsAsString().toLowerCase().indexOf(rslt.getString(2).
toLowerCase()) > -1) {
//System.out.println("matched");
hit = true;
break;
}
more = rslt.next();
}
}
catch (SQLException queryE) {}
}
return hit;
}
public void messagesList(String recipient) {
if( recipient != null ) {
try {
stQueryRecipientLike.setString(1, "%" +
recipient.toLowerCase()
+ "%");
rslt = stQueryRecipientLike.executeQuery();
System.out.println("result set=" + rslt);
if(rslt.last()) {
System.out.println("Number of records: " + rslt.getRow());
} else {
System.out.println("No records returned");
}
} catch (SQLException queryE) { queryE.printStackTrace(); }
}
}
boolean tryAgain = true;
public QuarantineRec getNextRec() {
tryAgain = true;
try {
if( rslt != null && rslt.next() ) {
while(tryAgain) {
messageFile = new File(quarantine + File.separatorChar +
rslt.getString("FILENAME"));
if (messageFile.exists()) {
//System.out.println("sender=" + rslt.getString(1));
quarantineRec.filename = rslt.getString("FILENAME");
quarantineRec.sender = rslt.getString("SENDER");
quarantineRec.recipient =
truncate(rslt.getString("RECIPIENT"), 64);
quarantineRec.subject =
truncate(rslt.getString("SUBJECT"),
64);
quarantineRec.filteredby = rslt.getString("FILTEREDBY");
quarantineRec.matchtext =
truncate(rslt.getString("MATCHTEXT"), 64);
tryAgain = false;
}
else {
deleteRec(rslt.getString("FILENAME")); // cleanup database
record for deleted message
if(! rslt.next()) { break; }
}
}
}
else {
return null;
}
}catch (SQLException getNextE) {}
return quarantineRec;
}
public String displayMessage(String filename) {
String messageText = null;
String tempLine;
int lineNum = 0;
try {
BufferedReader bufMessageReader = new BufferedReader(new
FileReader(quarantine + File.separatorChar + filename));
while( (tempLine = bufMessageReader.readLine()) != null ) {
//System.out.println("(" + tempLine + ")");
messageText += tempLine + "\n";
lineNum++;
if(lineNum > 100) { break; }
}
bufMessageReader.close();
}
catch( Exception e) {
e.printStackTrace();
}
return messageText;
}
public boolean insertRec(String filename, String sender, String
recipient, String subject, String filteredby, String matchtext) {
success = false;
if( sender != null && recipient != null ) {
try {
success = true;
stInsertRec.setString(1, filename);
stInsertRec.setString(2, deFocus(sender.toLowerCase()));
stInsertRec.setString(3, recipient.toLowerCase());
stInsertRec.setString(4, subject);
stInsertRec.setString(5, filteredby);
stInsertRec.setString(6, matchtext);
stInsertRec.execute();
}
catch (SQLException insertE) {}
}
return success;
}
public boolean deleteRec(String filename) {
try {
success = true;
stDeleteRec.setString(1, filename);
stDeleteRec.execute();
// Delete from Quarantine directory
messageFile = new File(quarantine + File.separatorChar +
filename);
if(messageFile.exists()) {
messageFile.delete();
}
} catch(SQLException deleteE) { success = false; }
return success;
}
public boolean deliver(String filename) {
boolean success = true;
try {
stDeleteRec.setString(1, filename);
stDeleteRec.execute();
messageFile = new File(quarantine + File.separatorChar +
filename);
messageFile2 = new File(msgObjs + File.separatorChar +
filename);
messageFile.renameTo(messageFile2);
} catch(SQLException deleteE) { success = false; }
return success;
}
public boolean messageFileExists(String filename) {
boolean exists = false;
messageFile = new File(quarantine + File.separatorChar +
filename);
if(messageFile.exists()) { exists = true; }
return exists;
}
protected boolean quarantineTablesExist() {
boolean exists = true;
// String[] types = {"TABLE"};
try {
Statement statement = dbConnection.createStatement();
ResultSet rs = statement.executeQuery("SELECT * FROM
quarantine");
/*
DatabaseMetaData metaData = dbConnection.getMetaData();
ResultSet rs = metaData.getTables(null, null, "whitelist", //
2nd null would be schemapattern
null);
if(rs.next()) { //the table exists
exists = true;
}
*/
}catch (Exception e) { e.printStackTrace(); exists = false; }
return exists;
}
public void quarantineDirectoryCleanup() {
// Delete from database if not in Quarantine directory
//
}
public void close() {
try {
dbConnection.commit();
dbConnection.close();
} catch (SQLException sqlClose) {
System.err.println("ERROR: closing connection into
statistics database");
sqlClose.printStackTrace();
}
}
protected String deFocus(String str) {
String returnToken = ""; // probably should be null but we need to
fix in full path (SMTPmsgObject + output portal
StringTokenizer tokenizer = new StringTokenizer(str, "<>");
if( tokenizer.hasMoreTokens()) {
returnToken = tokenizer.nextToken();
}
return returnToken;
}
public String truncate(String string, int maxChars) {
String returnString = string;
if(string != null && string.length() > maxChars) {
returnString = string.substring(0, maxChars);
}
return returnString;
}
public ResultSet getRslt() {
System.out.println("just called getRslt()");
return rslt;
}
public void setRslt(ResultSet rslt) { this.rslt = rslt; }
//void getInitQuarantine() { initQuarantine(); }
//void setInitQuarantine() { initQuarantine(); }
public Object getSheetState() {
return sheetState;
}
public void setSheetState(Object sheetState) {
this.sheetState = sheetState;
}
public void setTest(String teststring) {
this.test = teststring;
System.out.println("just setTest to " + this.test);
this.test = "this is what we hard setTest to"; } public String
getTest() { return this.test; } }
-----Original Message-----
From: Bernd Bohmann [mailto:[EMAIL PROTECTED]
Sent: Monday, March 06, 2006 11:27 AM
To: MyFaces Discussion
Subject: Re: Tobago sheet using jdbc ResultSet example request
Please remove the state attribute it should be a ref to a SheetState
Instance.
Please remove showRowRage, showDirectLinks and directLinkCount
attributes they make no sense for a dataModel for a resultSet because
the dataModel returns rowCount -1 for a resultSet.
Can you send me the ManagedBean code, please.
Bernd
John schrieb:
That's what I thought - so I changed it to uppercase. Didn't affect
the results.
createTableStatement.execute("CREATE CACHED TABLE quarantine(FILENAME
CHAR(64), SENDER CHAR(128), RECIPIENT CHAR(128), SUBJECT CHAR(128),
FILTEREDBY CHAR(24), MATCHTEXT CHAR(128), CONSTRAINT cQuarPRI PRIMARY
KEY (FILENAME))");
<t:sheet
value="#{quarantine.rslt}"
id="sheet"
columns="3*;1*;3*;3*;3*"
var="quarantineRec"
state="1"
showRowRange="left"
showPageRange="right"
showDirectLinks="center"
pagingLength="7"
directLinkCount="5">
<t:column label="From" id="name" sortable="true">
<t:out value="#{quarantineRec.SENDER}" />
</t:column>
<t:column label="To" id="number" sortable="false"
align="center">
<t:out value="#{quarantineRec.RECIPIENT}" />
</t:column>
<t:column label="Subject" sortable="true">
<t:out value="#{quarantineRec.SUBJECT}" />
</t:column>
<t:column label="Matched" sortable="true">
<t:out value="#{quarantineRecr.MATCHTEXT}" />
</t:column>
<t:column label="Filtered" sortable="true" align="right">
<t:out value="#{quarantineRec.FILTEREDBY}" />
</t:column>
</t:sheet>
-----Original Message-----
From: Bernd Bohmann [mailto:[EMAIL PROTECTED]
Sent: Monday, March 06, 2006 11:02 AM
To: MyFaces Discussion
Subject: Re: Tobago sheet using jdbc ResultSet example request
John,
please send the sheet jsp and the definition of the table.
Maybe a case-sensitive problem.
Bernd
John schrieb:
Ok.
My bean is retrieving 2 rows, but they are not being displayed.
In the definition of the tobago sheet, the var definition: It's
arbitrary, I'm assuming and doesn't map to any real variables in any
beans.
Ok. So assuming a var definition of: QuarantineRec Then in the
t:outs
if I'm using: quarantineRec.SENDER where SENDER is a database
column
in the returned ResultSet.........
Does Tobago automatically know that SENDER is a db column?
No data showing in the Tobago sheet.
John
-----Original Message-----
From: Bernd Bohmann [mailto:[EMAIL PROTECTED]
Sent: Monday, March 06, 2006 1:28 AM
To: MyFaces Discussion
Subject: Re: Tobago sheet using jdbc ResultSet example request
John schrieb:
Thank you very much for the example.
The trick seems to be having a function called 'select' within the
backing bean, which tobago's sheet looks for to return data into the
resultSet which has been provided within the sheet's value.
Yes?
No, the select method is for the detail page.
The getSolarObjects() method is for the sheet.
The other get methods are for the detail page.
Bernd
--
Dipl.-Ing. Bernd Bohmann - Atanion GmbH - Software Development
Bismarckstr. 13, 26122 Oldenburg, http://www.atanion.com
phone: +49 441 4082312, mobile: +49 173 8839471, fax: +49 441 4082333
--
Dipl.-Ing. Bernd Bohmann - Atanion GmbH - Software Development
Bismarckstr. 13, 26122 Oldenburg, http://www.atanion.com
phone: +49 441 4082312, mobile: +49 173 8839471, fax: +49 441 4082333
--
Dipl.-Ing. Bernd Bohmann - Atanion GmbH - Software Development
Bismarckstr. 13, 26122 Oldenburg, http://www.atanion.com
phone: +49 441 4082312, mobile: +49 173 8839471, fax: +49 441 4082333
