Results 1 to 3 of 3

Thread: JSP or PHP for connecting to Oracle

  1. #1
    Join Date
    Feb 2007
    Posts
    1

    JSP or PHP for connecting to Oracle

    Hi everyone.

    My client is very pro JSP; however, I would prefer to use PHP to connect to an Oracle DB, as I am more familiar with it. What advantages, if any, does JSP offer over PHP, specifically with regard to connecting to an Oracle DB?

    Thanks.

  2. #2
    Join Date
    Mar 2007
    Posts
    16
    None that I am aware of. But beware of the platform you are developing on. Your client might only have a JSP available hosting environment, in which case your choice is made for you.

    Both PHP and JSP have libraries to deal with Oracle connections but I believe that they are much of a muchness. Ultimately you will be designing queries in stored procedures in Oracle anyway and connection and querying is going to be relevantly similar in both JSP and PHP. Each requiring a connection string in the same format "dsn: oracle; username=blah;password=blah;database=blah;" or something thereabouts. I expect JSP has better grounding in active data objects than PHP but unless you're going to be using AJAX given that websites essentially use a stateless protocol I recommend you do it in whatever language you are more fluent in.

    I would like to point out that I have limited knowledge of connecting to Oracle using PHP and make no guarantees regarding my OPINIONS here.

  3. #3
    Join Date
    Apr 2007
    Posts
    1
    How To Get The Date Difference In Sql Query Using Oracle Database

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •