Having trouble connecting jboss 3.2.2 to Oracle 10g

[seckley]

Hi ;
i'm trying to set up a copy of our development environment at work. we are using jboss3.2.2 and oracle 9i. However instead of Oracle 9i i am using Oracle10G. The problem i am having is when i submit a call to the database through our login page. i get an error stating that :

"java.lang.unsatisfiedlinkerror: no ocijdbc9 in java.library.path"

we use a file called "Oracle-ds.xml" to specifiy the database. the connection-url tag uses "jdbc:oracle:oci8:@xxxxx" to specify the DB. for Oracle 10g is 'oci8' proper? or is their another item to be used? any ideas how the connection should be done?

Thanks for any help.

[lafr]

You have to put the jdbc-driver for Oracle 10g in your $JBOSS_HOME/server/lib dir.
If you use oci-protocol, then you need at lesast an oracle client installation with the needed native shared libs.
If you would change protocol to thin, your problem should go away too, since you no longer need the native libs.

[seckley]

i have tried the 10g drivers in the lib dir of the server and i still got the same result. I have a full installation of Oracle 10g on the machine where
the server is. however the db i am connecting to is an oracle 9i db. I have tried the the thin statement in the Oracle-ds file but to no avail. I'm stumped.

[lafr]

Your configuration is not quiet clear to me.
On the box where jboss is running you have 10g installed ?
You use a 9i instance on another box ?

You should use oci instead of oci8 in your protocol definition.
Environment variable ORACLE_HOME must be set and point to the oracle 10g software dir.
Environment variable LD_LIBRARY_PATH must include the dir with libocijdbc9.so in it.
This is $ORACLE_HOME/lib or $ORACLE_HOME/lib32 depending if you have 32 or 64 bit version of oracle installed.