Hello Ranchers!! Here i'm doing a program in JSP oracle.. I'm using oracle8i as the database now.. After completing the project i tried to upload the war file to the server.. but the server is Redhat Linux Enterprise 4 with Oracle 10g Express Edition. The oracle database is installed recently only just for a trial. So i want to change the database connection in the program. how can i set the jdbc odbc bridge in the linux. operating system..
Ranchers please help me.. i've searched in google and failed to get a proper answer.. please help me ranchers..
Check the Oracle XE web site they have instructions on developing with Java and XE there should be information there. There is of course unix-odbc, for Linux not sure whether RH would have a package for you, which you can use but as mentioned using the driver, .jar file form oracle, is more than enough and unless you needed odbc for some other data source besides oracle xe I do not see a reason to set it up.
You need to use the Oracle drivers; either the Type 4 thin driver or the OCI driver. For what you're trying to do right now, the thin driver is best. If the Java application is running within Oracle, or on the same server as the Oracle database but outside of Oracle, or the database is a RAC cluster, then there are some special reasons to use the OCI driver, for functionality the tin driver doesn't provide, but it doesn't sound like your ready for that level of stuff yet, you just want to get it working.
You also need to stop using the JDBC-ODBC bridge in your Windows environment for Oracle.