NetBeans Forums

FAQ

Memberlist

Profile

Oracle data source Table is not binding with drop-down list control using Netbeans 6.1 - JDBC driver - still error

NetBeans Forums -> Java EE Users

View previous topic :: View next topic

Author

Message

HASSAN Kamrul
Posted via mailing list.

Posted: Fri Oct 31, 2008 4:16 am Post subject: Oracle data source Table is not binding with drop-down list control using Netbeans 6.1 - JDBC driver - still error

Thanks, Rick,

If I drag & drop a Derby DB (already installed in Netbeans 6.1) table
into a drop-down list, it works fine.
Could you tell me if I could do (behind stuff that when drag & drop a
table into a drop-down list) table association with the drop-down list
manually.

So that I can pin point the issue while trying to do the same for Oracle
DB (as I have been trying to figure with your help)

Kam.

-----Original Message-----
From: Rick Fincher [mailto:address-removed]
Sent: Thursday, October 30, 2008 5:05 PM
To: HASSAN Kamrul
Subject: Re: Oracle data source Table is not binding with drop-down list
control using Netbeans 6.1 - JDBC driver - still error

Hi Kam,

Sounds like you have done everything right. I'm not an Oracle user, so
I can't test this out, but there has to be a solution.

Rick

HASSAN Kamrul wrote:

Quote:

Thanks, Rick,

I tried it with completely new project and still does not see the
table and drop-down list association.
Please attached email, sorry! Little big size email because I put an
print screen

Thank you.

Kamrul Hassan
Alcatel-Lucent
GNOC IT Development and Architecture
(972) 477 8792
address-removed

-----Original Message-----
From: Rick Fincher [mailto:address-removed]
Sent: Thursday, October 30, 2008 3:44 PM
To: address-removed
Subject: Re: [nbusers] Oracle data source Table is not binding with
drop-down list control using Netbeans 6.1 - JDBC driver - still error

Hi Kam,

The first line in the log is the clue:

SEVERE: Page1 Initialization Failure
javax.faces.el.PropertyNotFoundException:
javax.el.PropertyNotFoundException: Property 'vuiRowSet' not found on
type webapplication5.SessionBean1

The RowSet 'vuiRowSet' is not in the session bean. When you drag an
SQL table onto a component a RowSet is created in the session bean
that is named like the table. A DataProvider is created in your
page. In the init code of the page the DataProvider is linked to the
rowset in the session bean.

If you drag a table from a different DataSource with the same table
name it creates a RowSet with the same name with a number after it.
There is probably a 'vuiRowSet1' in the session bean somewhere, if the

Quote:

Oracle table had the same name as the Access table. Otherwise there
should be a RowSet in the session bean with the new table's name.

If you copied over the info, the DataProvider in your page will still
refer to 'vuiRowSet' instead of the new RowSet Name.

If you deleted the old RowSet you'll get this error because it is not
in the session bean.

You can probably just change the DataProvider to link to the right
RowSet but this is tricky because of all the stuff the visual editor
does with this.

Your bet option is to preserve any custom code you have written, then
delete the RowSets in the session bean and the DataProviders in your
page. Re drag the table onto your dropdown, then put your custom code

Quote:

back in and change the DataProvider and RowSet names to the new ones.

BE CAREFUL that you don't delete RowSets in the session bean that are
used by other pages.

You may also want to check your context.xml file to remove references
to the Access database. You might end up accidentally referencing
that database.

The visual editor is pretty intolerant of changing DataSources in
existing pages, so you are better off to start over, unless the
database table schema is identical.

Rick

Each RowSet has the name of the DataSource bound to it, so if your
DataSource name changes, you'll have to update this in the beans
(usually)

You also have to be careful

HASSAN Kamrul wrote:

Quote:

Thanks, Rick,

I tried with Driver for JDK 1.4 [ojdbc14.jar] and still could not get

Quote:

work.
Refer attached Tomcatlog.txt file

Thank you.

kam

-----Original Message-----
From: Rick Fincher [mailto:address-removed]
Sent: Wednesday, October 29, 2008 3:49 PM
To: HASSAN Kamrul
Subject: Re: Oracle data source Table is not binding with drop-down

list

Quote:

control using Netbeans 6.1 - JDBC driver

Hi Kam,

The JDK is usually backwards compatible so the JDK 1.4 drivers for
Oracle 9 should work with JDK 1.6.

Here a page for Oracle drivers:

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.ht
ml

Quote:

Rick

HASSAN Kamrul wrote:

Quote:

Thanks, Rick.

I think the problem is the JDBC driver, Let correct me if I am

wrong.

Quote:

I have Netbeans 6.1 with JEE 5 and JDK 1.6 but Oracle release is
9.2.0.7.0.
So, I would need a JDBC driver (I am getting table from this Oracle
DB) for Oracle release 9.2.0.7.0 (for JDK 1.6), I could not find one

Quote:

in oracle.com.
Is there any other way I can by pass this, any suggestion.

Please give me some feedback on above.

Note:
** I found line (IDE_log.txt) as
"WARNING

[org.netbeans.modules.openide.loaders.DataObjectEncodingQueryImplement

Quote:

at
ion]: Invalid DataObject"

Thank you.

Kam

-----Original Message-----
From: Rick Fincher [mailto:address-removed]
Sent: Wednesday, October 29, 2008 2:33 PM
To: address-removed
Subject: Re: [nbusers] Oracle data source Table is not binding with
drop-down list control using Netbeans 6.1

Hi,

Is the Oracle Table the same as the Access table?

Are you getting any errors when you run the program?

If the dropdown was previously bound to an Access database, this

might

Quote:

help: Drag a new dropdown onto the page, bind the Oracle table to

it,

Quote:

copy any info you need from the old dropdown then delete it.

Rick

HASSAN Kamrul wrote:

Quote:

Correction.

I meant different table not from Oracle but local DB (ex. MS
Access)

Thank you.

Kamrul Hassan
Alcatel-Lucent
GNOC IT Development and Architecture
(972) 477 8792
address-removed

-----Original Message-----
From: HASSAN Kamrul
Sent: Tuesday, October 28, 2008 10:09 PM
To: 'address-removed'; 'address-removed'
Subject: Oracle data source Table is not binding with drop-down
list

Quote:

control using Netbeans 6.1

Please assist.

I developing a Web app (in my desktop pc, Apache Tomcat 6.0) using
Netbeans 6.1 in Java.
Trying create a drop-down list and binding it with Oracle data

table.

Quote:

I drag and drop an Oracle table into this drop-down list then build

Quote:

and run but result query is not in the drop-down list (empty) But
if

Quote:

use different table it works.

Please advise.

Thank you.

Kamrul Hassan
Alcatel-Lucent
GNOC IT Development and Architecture
(972) 477 8792
address-removed

----------------------------------------------------------------------
--

Subject:
JDBC with oracle in netbeans 6.1 - Table does not associate with
drop-down list control
From:
"HASSAN Kamrul" <address-removed>
Date:
Thu, 30 Oct 2008 14:45:59 -0500
To:
<address-removed>, <address-removed>

To:
<address-removed>, <address-removed>

I have a similar issue.

* I put Oracle9i 9.2.0.8 JDBC Drivers for use with JDK 1.4
(ojdbc14.jar) [driver for JDK 1.5/1.6 is not listed]
into C:../JDBC/oracle/ojdbc14.jar then I created DB connection as
you mentioned below. I see all table and views and etc.

But when drop a table into drop-down list control it does not
associate it,
when (after dropping table) right-click then Bind to Data.. I see
blank on Value and Display field

My data source is Oracle Release 9.2.0.7.0 and I am using Netbeans
6.1 (with JDK 1.6)

Picture (Device Independent Bitmap)

Thank you.

Kamrul Hassan
Alcatel-Lucent
GNOC IT Development and Architecture
(972) 477 8792
address-removed

-----Original Message-----
From: address-removed [_mailto:John.Baker@Sun.COM_]
Sent: Thursday, October 30, 2008 11:59 AM
To: address-removed
Subject: Re: [nbj2ee] jdbc with oracle in netbeans

The supported driver is ojdbc14.jar available from this page from
_http://wiki.netbeans.org/DatabasesAndDrivers#section-DatabasesAndDriv
ers-OracleDriverForTheOracle10.xDatabase_

To register a driver, in the Services tab, expand Databases,
right-click on Drivers and choose New Driver.

In the New Driver dialog, the driver class is oracle.jdbc.OracleDriver

Quote:

and the name is Oracle Thin

John

fish1ric wrote:

Quote:

I also can not connect to Oracle 10G via Netbeans 6.1 or 6.5RC2.

I have tried several Oracle driver versions (ojdbc14.jar,
ojdbc6_g.jar*)

* ojdbc6 has a broken manifest file that you must fix first.

The error is that it can't find the listener.

Put the Oracle jar files in the NetBeans 6.5 RC2\ide10\modules\ext

and added it to the path and classpath.

Quote:

I initially tried using the ojdbc14.jar that all the other apps
point to on my local Oracle client install.
(C:\oracle\ora10g\jdbc\lib)

I have no trouble connecting with TOAD, Sql*Plus, SQuirreL SQL
Client

(jdbc java db client), Eclipse etc.

Quote:

Can someone please tell me how to make this work in Netbeans.

jdbc:oracle:thin:@oradbtgd:1521:tgd is the format of the connection

string.

Quote:

I have also tried the IP address of the db server as well as

tgd.world for the SID.

Quote:

Thanks

Display posts from previous:

	NetBeans Forums -> Java EE Users	All times are GMT
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum