Load Oracle Data to Grid

Suite and Optimus Suite 5
#1

It’s my first try at testing hmlxgrid.

I’m trying to load data from a Oracle table. but it works wrong.

In server side, I use a Java-connector.
In the java file, I wrote this :

Connection conn= ( new DBConnection()).getConnection();
GridConnector c = new GridConnector(conn, DBType.Oracle);

c.servlet(req, res);
c.dynamic_loading(100);
c.render_table(“ipa.sb_etc_code”, “code”, “category,item,desci”);

I got 100 rows but in the cdata section, there are no data like this:

<?xml version="1.0" encoding="UTF-8"?>

-
-
-
+

+
+
-
…

and the grid show no data.

In the html file, I wrote like this:

var contactsGrid = layout.cells(“a”).attachGrid();
contactsGrid.setHeader(“Code,Category,Item,Description”);
contactsGrid.setColumnIds(“code,category,item,desci”);
…
contactsGrid.init();

contractsGrid.load(“/Sel_etc_code_grid_01”);

Any idea what I should look for?

Thank you for any help.

#2

Try to change the code like next

c.render_table("ipa.sb_etc_code", "CODE", "CATEGORY,ITEM_DESCRI");

Oracle data driver returns all fields in upper case.

#3

Thanks for your reply.

After applying, it works successfully.