It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes JDBC in Linux Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC in Linux" Watch "JDBC in Linux" New topic

JDBC in Linux

Aravind Prasad
Ranch Hand

Joined: Dec 28, 2005
Posts: 265
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..

Aravind Prasad
Maximilian Xavier Stocker
Ranch Hand

Joined: Sep 20, 2005
Posts: 381
Do not use the bridge driver!

Use a proper type 4 driver. There is no reason for you not to do this. Attempting to use the odbc bridge driver on a non ODBC platform (not Windows) is a really poor idea.
George Stoianov
Ranch Hand

Joined: Jan 15, 2006
Posts: 94
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.

stu derby
Ranch Hand

Joined: Dec 15, 2005
Posts: 333
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.
I agree. Here's the link:
subject: JDBC in Linux
It's not a secret anymore!