Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes BEA/Weblogic and the fly likes jdbc  problems Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "jdbc  problems" Watch "jdbc  problems" New topic

jdbc problems

Adam Adams
Ranch Hand

Joined: Nov 28, 2001
Posts: 60
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
Ranch Hand

Joined: Dec 04, 2001
Posts: 54
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

/*<br /> * Quants Inc.<br /> * Engineer<br /> *<br /> * Shin Hashitani<br /> *<br /> * <a href="" target="_blank" rel="nofollow"></a><br />*/
Venkatraman Balasubramanian
Ranch Hand

Joined: Feb 14, 2002
Posts: 34
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.

Venkatraman Balasubramanian<br />SCJP2, SCWCD, SCEA Part I<br />BEA System Certified jCert Enterprise Developer (WLS 6.0).<br />MCSD, MCAD, OCA (Oracle 9i), OCP (JDeveloper R3)
I agree. Here's the link:
subject: jdbc problems
jQuery in Action, 3rd edition