Populate a Table from a List

Seems like this should be easy...

I need to populate an html table with data from the database. The examples show 2 ways to do this. 1) use a table provider, 2) use an EJB. Unfortunately, EJBs are not an option at this installation.

At my installation, the infrastructure folks insist that the jdbc driver we have to use is the generic one from Sybase JConnect version5.x. I've had problems in the past with Sybase not implementing all the methods. What's happening is I can't get any of the table data providers to work once the application is deployed to the BEA server. Note that the problem is NOT BEA. If I use BEA's driver, everything works great. But when I use the Sybase driver I get this error

"The method com.sybase.jdbc2.tds.RowFormatToken.getSchemaName has not been completed and should not be called."

So I need to find a way to get a result set (possibly in a List) and populate a table object.

Any clues, folks?

[969 byte] By [ITWorker] at [2007-11-26 9:20:25]
# 1
Not sure what might solve is, but this is surely a driver issue not anything to do with the Creator IDE right?maybe another sybase driver might help!K
kish@sun at 2007-7-6 23:51:34 > top of Java-index,Development Tools,Java Tools...
# 2
Eventhough BEA driver supports CachedRowSet, It dosent support reading the alias name. For eg: select as_of_date aDate from Branch. In this case CachedRowSet can not read cachedRow.getString("aDate"); It says column not found.
mekamath at 2007-7-6 23:51:34 > top of Java-index,Development Tools,Java Tools...