Java Mailing List Archive

http://www.junlu.com/

Home » Home (12/2007) » JBoss User »

Re: [JBoss-user] url string for connecting jboss to oracle

Holger Baxmann

2003-09-03

Replies:

hi amit,

you should read the docus for the _oci_ jdbc url carefully: there is no
need for the 1526 port part, you have to put a TNS name of the oracle
service descriptor (have a look at listener.ora in network/admin on the
server and the tnsnames.ora on the client - but this depends on the oracle
naming service you are using) into it.

HTH

bax
PS: BTW: the 'message not found' point to a problem with you oracle
environment config - do you have a ora client on your machine (enterprise
manager or something ) up and running?

On Wed, 3 Sep 2003 22:34:59 +0530, Amit Ashok <AmitAshok@(protected):

> Hi ,
> I am trying for the last 2 days to connect jboss 3.2.1 to oracle 9i using
> OCI client as thin client is not giving me the required output .
> I have modified oracle-ds.xml
> <datasources>
> <local-tx-datasource>
> <jndi-name>CLKS1</jndi-name>
> <connection-url>jdbc:oracle:oci:@(protected)>
> <!--
> <connection-url>jdbc:oracle:thin:@(protected)-
> url>
> -->
> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
> <user-name>jb</user-name>
> <password>jb</password>
> <exception-sorter-class-
> name>org.jboss.resource.adapter.jdbc.vendor.OracleEx
> ceptionSorter</exception-sorter-class-name>
> </local-tx-datasource>
> </datasources>
>
> I have tried oci , oci8 ,oci9 but in all the cases I have been denied
> connection . in case of oci8 with oracle 8i server I got the following
> error
> message
>
>
> at java.lang.Thread.run (Thread.java:479)
> org.jboss.util.NestedSQLException: Could not create connection; - nested
> throwable: (java.sql.SQLException: Error w
> hile trying to retrieve text for error ORA-06401
> ); - nested throwable: (org.jboss.resource.JBossResourceException: Could
> not
> create connection; - nested throwable:
> (java.sql.SQLException: Error while trying to retrieve text for error
> ORA-06401
> ))
> while with oracle 9i and 9i drivers I keep getting
>
>
> com.niit.cliks.control.common.GeneralFailureException: null;
> CausedByException is:
> Could not create connection; - nested throwable:
> (java.sql.SQLException: ORA-06401: NETCMN: invalid driver
> designator
> ); - nested throwable: (org.jboss.resource.JBossResourceException: Could
> not
> create connection; - nested throwable:
> (java.sql.SQLException: ORA-06401: NETCMN: invalid driver designator
> ))
>
> my url string was <connection-
> url>jdbc:oracle:oci:@(protected)>
>
>
> then i changed the url string to <connection-
> url>jdbc:oracle:oci9:@(protected)>
> the exception changed to
> com.niit.cliks.control.common.GeneralFailureException: null;
> CausedByException is:
> Apparently wrong driver class specified for URL: class:
> oracle.jdbc.driver.OracleDriver, url: jdbc:oracle:o
> ci9:@(protected):
> (org.jboss.resource.JBossResourceException: Apparently wrong dri
> ver class specified for URL: class: oracle.jdbc.driver.OracleDriver, url:
> jdbc:oracle:oci9:@(protected)
> 1)
> can some one help me .
>
>
>
> ----------------------------------------------------------- NOTICE
> ------------------------------------------------------------ This email
> and any files transmitted with it are confidential and are solely
> for the use of the individual or entity to which it is addressed. Any
> use,
> distribution, copying or disclosure by any other person is strictly
> prohibited. If you receive this transmission in error, please notify the
> sender by reply email and then destroy the message. Opinions, conclusions
> and other information in this message that do not relate to official
> business of NIIT shall be understood to be neither given nor endorsed by
> NIIT. Any information contained in this email, when addressed to NIIT
> Clients is subject to the terms and conditions in governing client
> contract.
>



--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
JBoss-user@(protected)
https://lists.sourceforge.net/lists/listinfo/jboss-user


©2008 junlu.com - Jax Systems, LLC, U.S.A.