Ad:

JSP Discussion Thread
Unsolved
Views: 9413

Mar 14th, 2007

JSP using Oracle Database

Expand Post »

Hi all ..

this jsp code when we use database access, to get the information by entering the price , my problem is that now iam using oracle as database and i dont know what are the changes that can be made here only ofcorse the path of database this i have , but string will it change because in oracle its varchar ? .. !! .. plz help.. its my first time to do this ..

Thanks

Similar Threads

Pinky.Rozita

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Mar 2007

Permalink

Mar 14th, 2007

Re: JSP using Oracle Database

No. The query and setString statements can remain the same. It is, however, not recommended to use scriptlets this way. The DB code should be moved out to a bean. Scriptlets, AFAIK, are only still supported for backwards compatability reasons.

You don't want to be backwards do you? ;-)

masijade

Moderator

Reputation Points: 1471

Solved Threads: 490

Industrious Poster

Offline

4,043 posts
since Feb 2006

Permalink

Mar 14th, 2007

Re: JSP using Oracle Database

Thanks masijade

...

hehe no i dont want

.. but this what they taught us in college !! ... basic things ..

however the most important thing is that the code doesnt fully change ... we have 4 weeks to finish the project

..

thanks again

Pinky.Rozita

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Mar 2007

Permalink

Mar 14th, 2007

Re: JSP using Oracle Database

tough luck. If they teach you to do it like that ask for your money back.

jwenting

Team Colleague

Reputation Points: 1658

Solved Threads: 331

duckman

Offline

7,719 posts
since Nov 2004

Permalink

Mar 18th, 2007

Re: JSP using Oracle Database

well jwenting im still in a level they dont teach us advanced things

..

Thanks

Pinky.Rozita

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Mar 2007

Permalink

Mar 18th, 2007

Re: JSP using Oracle Database

they don't teach you the basics either the way they should.
What they are teaching you is the way things were done nearly 10 years ago which has been recognised as exactly the wrong way to do them for the last 7 or so.
If they insist in teaching it like that the course isn't worth the time and money you invest in it.

jwenting

Team Colleague

Reputation Points: 1658

Solved Threads: 331

duckman

Offline

7,719 posts
since Nov 2004

Permalink

Mar 19th, 2007

Re: JSP using Oracle Database

Aha, well you know better than me

..
Thanks for your consideration.. i will talk to my supervisor about it

Pinky.Rozita

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Mar 2007

Permalink

Oct 2nd, 2007

Re: JSP using Oracle Database

any sample codes on how to do this?

awsl

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Oct 2007

Permalink

Oct 2nd, 2007

Re: JSP using Oracle Database

Hi,

You are using jdbc-odbc bridge to connect to Oracle db here

JSP Syntax (Toggle Plain Text)
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:prodDSN");
st = con.createStatement();
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:prodDSN");
st = con.createStatement();

You might have successfully created the odbc data source. But it is the Tomcat runtime that needs to know about the odbc datasource. You'll have a tough time configuring it on Tomcat as you are still a student and migh not have played much with the Tomcat configuration files. I would suggest you to use Pure JDBC driver to connect to Oracle database. You can find the Oracle JDBC driver in the Oracle installation folder under jdbc directory. You can find some zip and jar files with name like oci12.zip oci12.jar, etc (Can't remember the names properly so you can send me the names which you find there if you are not sure which one to use). Copy the oci12.jar to either the lib directory of Tomcat Installation ("C:\Program Files\Apache Software Foundation\Apache Tomcat 6.0\lib") or to your web applications WEB-INF\lib (best practice to copy here) directory. Why we are doing it? The runtime environment of Tomcat i.e., the Tomcat's JVM needs the information at runtime about the Oracle related Jdbc drivers (remember the CLASSPATH setting you might have done earlier so that your program knows at runtime where to find specific classes). If you don't do this Tomcat will throw ClassNotFoundException at runtime.

Now, the JDBC specific parameters are need to be passed while establishing the Connection. So you'll have to make the following code changes

JSP Syntax (Toggle Plain Text)
try {
              Class.forName ("oracle.jdbc.driver.OracleDriver");//pure jdbc driver
        } catch (ClassNotFoundException e) {
              e.printStackTrace();
        }
 
        Connection conn = DriverManager.getConnection
             ("jdbc:oracle:thin:@localhost:1526:orcl", "scott", "tiger");
                             // @machineName:port:SID,   userid,  password
 
        Statement stmt = conn.createStatement();
try {
              Class.forName ("oracle.jdbc.driver.OracleDriver");//pure jdbc driver
        } catch (ClassNotFoundException e) {
              e.printStackTrace();
        }

        Connection conn = DriverManager.getConnection
             ("jdbc:oracle:thin:@localhost:1526:orcl", "scott", "tiger");
                             // @machineName:port:SID,   userid,  password

        Statement stmt = conn.createStatement();

Please refer the following FAQ on more information
http://www.orafaq.com/faqjdbc.htm

lookof2day

Reputation Points: 16

Solved Threads: 11

Junior Poster in Training

Offline

83 posts
since Aug 2007

Permalink

Oct 2nd, 2007

Re: JSP using Oracle Database

I'm sorry for my earlier reply, I thought you r facing Connectivity issues so please ignore it.

According to ur post, the price field is a VARCHAR in Oracle (Correct me if I'm wrong). In that case, the code will change to

JSP Syntax (Toggle Plain Text)
int price;
 
price= Integer.parseInt(request.getParameter("price"));
 
sql = "SELECT * FROM itemTBL where price = "+ "'"+price+"'";
int price;

price= Integer.parseInt(request.getParameter("price"));

sql = "SELECT * FROM itemTBL where price = "+ "'"+price+"'";

You will have to convert price to a String(VARCHAR/CHAR format) for comparison to a String (VARCHAR) in database. To avoid the "'" + field + "'", use PreparedStatements. Or JDBC 2.0 features.

lookof2day

Reputation Points: 16

Solved Threads: 11

Junior Poster in Training

Offline

83 posts
since Aug 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in JSP Forum Timeline: Help needed in JSP project-Online Examination

Next Thread in JSP Forum Timeline: Incomplete Loading of JSP page

DaniWeb Message

Cancel Changes

User Name
Password