Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Java > [newbie] Netbeans and Oracle 11g jdbc driver

Reply
Thread Tools

[newbie] Netbeans and Oracle 11g jdbc driver

 
 
zzzato@gmail.com
Guest
Posts: n/a
 
      05-31-2012
Hi, all.
I'm a newbie in java but I work in borland delphi since 1997.
Now, I'm learning java.
I'm using netbeans, oracle 11g 64bit database and glassfish.
I'm sorry if my question is OT or it's too simple for this ng...

I've a simple jsp project made with netbeans.
I've just only one jsp page to show data from a db table with a simple select statement.
Netbeans connects database fine but when my project starts, response is an exception related to "database driver not found":


http status 500
no suitable driver found for jdbc/qweb

Jdbc driver is present in glassfish\domains\domain1\lib

I tried to add c:\app......\dbhome_1\jdbc\lib in prj-options-lib: non changes.

There are other settings about jdbc driver? And, WHERE?


I apologize for this (stupid) question.

TIA

A.Salvati
 
Reply With Quote
 
 
 
 
markspace
Guest
Posts: n/a
 
      05-31-2012
On 5/31/2012 12:41 AM, http://www.velocityreviews.com/forums/(E-Mail Removed) wrote:
> http status 500
> no suitable driver found for jdbc/qweb
>
> Jdbc driver is present in glassfish\domains\domain1\lib



I guess Oracle might be shipping their own drivers with Glassfish now,
but I'd also be kinda surprised, since drivers need to be matched to an
installation, and are frequently updated. Just for kicks, please
download a new driver that matches your Oracle db version and such-like.
Searching the web for "Oracle jdbc", I find this:

<http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html>


>
> I tried to add c:\app......\dbhome_1\jdbc\lib in prj-options-lib: non changes.
>
> There are other settings about jdbc driver? And, WHERE?



On your Projects tab, expand your web app project. There are items like
Web Pages, Source Packages, Test Packages, Libraries, etc. Right click
on Libraries, choose "Add Folder/Jar..." and browse to the Oracle driver
you just downloaded.

For example, for my web app I'm looking at right now, I had to add both
derby.jar and mysql-connector-java-5.1.20-bin.jar (both are other
vendor's database drivers). Your IDE doesn't know about extra .jar
files unless you point it at the Jar file.

 
Reply With Quote
 
 
 
 
John B. Matthews
Guest
Posts: n/a
 
      05-31-2012
In article <jq7sk8$dr4$(E-Mail Removed)>, markspace <-@.> wrote:

> On 5/31/2012 12:41 AM, (E-Mail Removed) wrote:
> > http status 500
> > no suitable driver found for jdbc/qweb
> >
> > Jdbc driver is present in glassfish\domains\domain1\lib

>
> I guess Oracle might be shipping their own drivers with Glassfish
> now, but I'd also be kinda surprised, since drivers need to be
> matched to an installation, and are frequently updated. Just for
> kicks, please download a new driver that matches your Oracle db
> version and such-like. Searching the web for "Oracle jdbc", I find
> this:
>
> <http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html>
>
> > I tried to add c:\app......\dbhome_1\jdbc\lib in prj-options-lib: non
> > changes.
> >
> > There are other settings about jdbc driver? And, WHERE?

>
> On your Projects tab, expand your web app project. There are items
> like Web Pages, Source Packages, Test Packages, Libraries, etc.
> Right click on Libraries, choose "Add Folder/Jar..." and browse to
> the Oracle driver you just downloaded.
>
> For example, for my web app I'm looking at right now, I had to add
> both derby.jar and mysql-connector-java-5.1.20-bin.jar (both are
> other vendor's database drivers). Your IDE doesn't know about extra
> .jar files unless you point it at the Jar file.


zzzato: As you're using NetBeans, the illustrations here may help:

<http://stackoverflow.com/q/1975973/230513>

--
John B. Matthews
trashgod at gmail dot com
<http://sites.google.com/site/drjohnbmatthews>
 
Reply With Quote
 
Alberto Salvati
Guest
Posts: n/a
 
      06-01-2012
First, many thanks for the answers.

I know that my question is a stupid question.
I've not experience in java and web.


I'm already using jdbc driver suggested by you.
I see in netbeans I'm using jdk 1.7.....and oracle jdbc driver is for jdk 1.6....

.....maybe jdbc for 1.7 is not good for 1.6?

I'll install jdk 1.6 and create a new prj in netbeans.

 
Reply With Quote
 
Alberto Salvati
Guest
Posts: n/a
 
      06-01-2012
Hi, John.
Many thanks for your useful link.
I had already made this attempt.

As reply of other response, I'll try to use jdk 1.6.

Many thanks.
SYL

A.
 
Reply With Quote
 
Lew
Guest
Posts: n/a
 
      06-01-2012
Alberto Salvati wrote:
> First, many thanks for the answers.
>
> I know that my question is a stupid question.


There is absolutely nothing stupid about your question.

In fact, even experienced developers have trouble with JDBC sometimes.

> I've not experience in java and web.


You should practice correct upper- and lower-case to get your
mind used to the rigor of Java conventions.

> I'm already using jdbc driver suggested by you.
> I see in netbeans I'm using jdk 1.7.....and oracle jdbc driver is for jdk 1.6....
>
> ....maybe jdbc for 1.7 is not good for 1.6?


It's the other way around - you are using JDBC for 1.6 under Java 7.

That should not be any problem.

> I'll install jdk 1.6 and create a new prj in netbeans.


That will not be the answer, most likely.

How are you setting up your JDBC driver? You only say
you "tried to add" it, but not how you did that.

The rules changed with Java 6.

--
Lew
 
Reply With Quote
 
Lew
Guest
Posts: n/a
 
      06-01-2012
Alberto Salvati wrote:
> Many thanks for your useful link.
> I had already made this attempt.
>
> As reply of other response, I'll try to use jdk 1.6.


That is unlikely to get to the root of the problem.

--
Lew
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: [JDBC] JDBC Driver and timezones Lew Java 0 05-19-2010 03:33 PM
install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified procedure could not be found at C:/Perl/lib/DynaLoader.pm line 230. Feyruz Perl Misc 4 10-14-2005 06:47 PM
oracle.jdbc.OracleDriver vs oracle.jdbc.driver.OracleDriver Betty Java 1 05-21-2005 05:15 PM
802.11g router / 1 x 802.11b device / 1 x 802.11g device Oli Wireless Networking 3 09-27-2004 11:56 PM
NetBeans and MySQL-JDBC-Driver Konrad Piersdorfer Java 0 09-01-2003 01:11 PM



Advertisments