Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: changing database from MSAccess to oracle

    i am working on a project which has the following details :
    the client interface is in offers an opportunity to the user to upload the data ,entered by the user, which is stored in MSAccess(temporarily on the client side) to the server database which is also in, i have to change the server side database from MSAccess to Oracle.I am asked to make the necessary changes in the java files that provide the functionality for uploading.

    the new database structure for oracle wll be exactly same as that for MSAccess.from my study, i feel that there is only one place where change has to be made in the java code i.e in the name of the driver :

    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); should be changed to that for Oracle.can someone tell me what must be written for oracle?

    am i right or some other changes also need to be made in embedded sql statements like in date format etc.

    Please help.

  2. #2
    Join Date
    Jan 2004
    Sochaux (France)
    You have to change your data pool environment with oracle.jdbc.pool.OracleConnectionPoolDataSource.
    After that, you can use import oracle.sql.*; to use oracle objects

Posting Permissions

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