• 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 ...
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
  • Liutauras Vilda
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Frits Walraven
  • Piet Souris
  • Himai Minh

jdbc problems

Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
i installed wls6.2(sp2)and it is a download version, ON one box1 (HP MACHINE)and i have oracle 9i on another hp box2. i am able to connect to the hp box2(which oracle resides on) thru sqlplus. when i connect thru wls after configuration like:
url --- jdbc oracle:thin:@oraclemachineip:1521 bname
class name --- oracle.jdbc.driver.OracleDriver
i have problem says not enough space and bad liner.. but when i change class name to:
weblogic.jdbc.oci.Driver it gives me that i have bad drivers
when i used wls6.1 on nt box and oracle was on unix box i have to have oracle client on my nt box. and i have tnsname.ora file ? Do i need the same on my Hpbox1 which i have wls6.1 installed on and if so do i have to install oracle client?
any help is greatly appreciated
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Adam,
I am learning WebLogic and Oracle right now, and I went through a lot this week to figure things out. I am not an Oracle expert, but I have just a little ideas that might help you.
I am using
WebLogic 6.1 sp2
Oracle 9i Ent.
on the same machine. I use Oracle oci driver(JDriver for Oracle).
As far as I know,
you have three choises. 1.have tnsname.ora on each client. 2.use Oracle Names Service 3.use Oracle Internet Directory
So, if you choose the first one, you need tnsname.ora on your client.
I use Names Service. (which use Name Server automatically in order to locate database) The name of config file is names.ora which resides only on the server. You can configure it through Net Manager(Net8) If there is only one client, it is probably easier to have tnsname.ora on the client, though.
I am not sure about what the error messages mean. I think the second one is a bad driver because it's an oci driver(type 2).
I hope this helps

Shin Hashitani
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I think that you are trying to use the Oracle Thin driver (Type 4) for Oracle. This means that you don't need any other runtimes, other than the ones distributed with WLS.
It would be helpful for me to give a precise solution, if you dump the error messages that you are receiving.
You could try to use the following way of configuration in the config.xml :
<JDBCConnectionPool CapacityIncrement="1"
TestTableName="DUAL" URL="jdbc racle:thin:@(description=(address=(host=ServerIP)(protocol=tcp)(port==ListenerPort)))(connect_data=(sid==SID))))"/>
I have highlighted the ones that you might need to change. Let me know, if this works for you.
Looky! I'm being abducted by space aliens! Me and this tiny ad!
Free, earth friendly heat - from the CodeRanch trailboss
    Bookmark Topic Watch Topic
  • New Topic