PostgreSql - Table Error

Hi,

I am using PostgreSql 8.2 with Netbeans Visiual Pack. I am tring for three days to get vales from database and show them in the table with RowSet. As they say it is simply to show database tables in your web projects, it doesnt happen in my project. I get the following errors and it didnt work to drag and drop the database table to table in page.

java.lang.AbstractMethodError com.sun.sql.rowset.CachedRowSetXImpl.getMetaData(CachedRowSetXImpl.java:2346)

com.sun.data.provider.impl.CachedRowSetDataProvider.getMetaData(CachedRowSetDat aProvider.java:1318)

com.sun.data.provider.impl.CachedRowSetDataProvider.getFieldKeys(CachedRowSetDa taProvider.java:489)

And then I tried it with MSSql but it didnt work again. It only works with Derby database. What am I doing wrong?

Thanks all.

[832 byte] By [ali.kelesa] at [2007-11-26 12:20:03]
# 1

Hi Ali,

I have had problems like this when using PostgeSQL 8.2 with Creator2 and VWP, because thsi driver doesn't support all the JDBC 3.0 features that we need.

But MSSQL should work fine.

Use this Driver at:

o http://www.microsoft.com/downloads/details.aspx?FamilyId=6D483869-816A-44CB-978 7-A866235EFC7C&displaylang=en

* Driver version:

o Microsoft SQL Server 2005 JDBC Driver 1.1

o sqljdbc_1.1.1501.101_enu.tar.gz

* Driver jar files:

o sqljdbc.jar

* Driver classname:

o com.microsoft.sqlserver.jdbc.SQLServerDriver

* URL format:

o jdbc:sqlserver://<hostname>:1433;databaseName=<database>;selectMeth od=cursor

We have found this driver works fine.

HTH,

Sakthi

sakthivel.gopala at 2007-7-7 15:09:33 > top of Java-index,Archived Forums,Socket Programming...