unable to load data from oracle database


#1

i have a grid which uses oracle database…while loading it showing null even though if there is data in data base…total number of rows in database is same as number of rows displayed but with all null values…plz help me out[code]
try {
Class.forName (“oracle.jdbc.driver.OracleDriver”).newInstance ();
conn = DriverManager.getConnection(“jdbc:oracle:thin:@192.168.68.234:1521:testsvr”,“example”,“test”);

	} catch (Throwable e) {
		e.printStackTrace();
	}

          
	GridConnector c = new GridConnector(conn,DBType.Oracle);
	c.enable_log("dhtmlconnectorlog.txt",true);

	c.render_table("product","product_id","product_name,version,app_url,db_url");[/code]



#2

Try use names of fields in the upper case , in the render_table command.

 c.render_table("PRODUCT","PRODUCT_ID","PRODUCT_NAME,VERSION,APP_URL,DB_URL");

#3

thank q it worked for me


#4

I’ve done a test on my laptop here that lets me load about 900,000 rows per second into a standard help table.

You need to give us (a lot) more information and context around what you are doing and what you want to achieve

MongoDB Tutorial