Problem in fetching data from oracle database in Visual JSF with Netbeans

[minaljsoni]

I am using Netbeans 6.5 IDE to make Visual JSF web application..
My database is in Oracle..
In netbeans, oracle connection is done correctly but when I want to fetch data from tables of that schema...it does not fetch any data..
please tell me anyone to overcome this problem...

Thanks in advance....

[jyeary]

Did you create a page with a table on it, and drag-n-drop the table on it to auto-create the data mapping?

You really did not provide many details. You should check out the data bound components tutorials on the NetBeans site.

John

On Tue, Mar 3, 2009 at 4:00 AM, minaljsoni <address-removed ([email]address-removed[/email])> wrote:

[minaljsoni]

Yes,I have created a page with a table and drop down list on it...I have drag and drop table on page..It creates data provider of that table in sessionbeanpage.java of that page...now in table of page when I want to bind the data by that data provider I am getting error as below..

java.sql.SQLException: statement handle not executed: getMetaData
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1130)
at oracle.jdbc.driver.OracleResultSetImpl.getMetaData(OracleResultSetImpl.java:160)
at oracle.jdbc.driver.OraclePreparedStatement.getMetaData(OraclePreparedStatement.java:1141)
at com.sun.sql.rowset.CachedRowSetXImpl5.getMetaData(CachedRowSetXImpl5.java:2270)
at com.sun.data.provider.impl.CachedRowSetDataProvider.getMetaData(CachedRowSetDataProvider.java:1473)
Caused: java.lang.RuntimeException
at com.sun.data.provider.impl.CachedRowSetDataProvider.getMetaData(CachedRowSetDataProvider.java:1485)
at com.sun.data.provider.impl.CachedRowSetDataProvider.getFieldKeys(CachedRowSetDataProvider.java:563)
at org.netbeans.modules.visualweb.propertyeditors.binding.data.BindOptionsToDataProviderPanel.updateDataProvider(BindOptionsToDataProviderPanel.java:335)
at org.netbeans.modules.visualweb.propertyeditors.binding.data.BindOptionsToDataProviderPanel$1.run(BindOptionsToDataProviderPanel.java:170)
[catch] at java.lang.Thread.run(Thread.java:619)

and because of this error I can not see any columns of that table in Bind to Data property of any component of Visual JSF...

What I should I do to overcome this problem?

[roll7]

What version of Oracle are you using and especially which driver version?
NetBeans requires a JDBC 3 compliant driver. If you're using ojdbc14.jar,
ojdbc5.jar or ojdbc6.jar you should be fine.

Here's the supported Oracle drivers and their download locations
http://wiki.netbeans.org/DatabasesAndDrivers#section-DatabasesAndDrivers-OracleDriverForTheOracle10.xDatabase

ojdbc5 is for JDK 1.5
ojdbc6 is for JDK 1.6

/by John Baker/

[minaljsoni]

I am using Oracle 8i....I have tried all JDBC driver for this..but still I m getting error...What should I do?

[black_chang]

I have the same problem on this.
I try to change database driver from jdbc14.jar to jdbc6.jar.
It's work fine.
Thanks a lot.