Wednesday, January 11, 2012

ODBC in Xpages (Javascript)

try
{
print("Testing");
java.lang.Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")
var con:java.sql.Connection=java.sql.DriverManager.getConnection("jdbc:odbc:Datasource1","","");
var stmt:java.sql.Statement=con.createStatement();
var re:java.sql.ResultSet=stmt.executeQuery("SELECT * FROM employee");
var t=null;
while (re.next()) {
t=t + "\n" + rec.getString(1) + "\t" + rec.getString(2);
}
st.close();
getComponent("Name").setValue(t)
}
catch(Exception)
{
getComponent("Name").setValue("Error on Java Script");

No comments:

Post a Comment