Win a copy of Head First Android this week in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Rob Spoor
  • Bear Bibeault
Saloon Keepers:
  • Jesse Silverman
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Al Hobbs
  • salvin francis

JDBC in Linux

 
Ranch Hand
Posts: 265
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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..

regards!!
Aravind Prasad
 
Ranch Hand
Posts: 381
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 94
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.

Regards,
George
 
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic