jdbc problems

[Adam Adams]

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

[Shin Hashitani]

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

[Venkatraman Balasubramanian]

Hi,
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"
DriverName="oracle.jdbc.driver.OracleDriver"
Name="MyConnectionPool"
Properties="user=scott;password=tiger;dll=ocijdbc8;protocol=thin"
Targets="ServerName"
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.