how to connect to a oracle database

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

how to connect to a oracle database

Amine Hanoun
hi
a have a problem to connect to a oracle 10g database
a see the exemple " sql-address-book " and i change the datasource.xml like thse
 

##################

<datasource>

<!-- Specify the driver for the database -->

<driver-class-name>oracle.jdbc.driver.OracleDriver</driver-class-name>

<!-- This causes the use of the embedded database -->

<uri>jdbc:oracle:thin:@172.42.172.135:1521:xe</uri>

<!-- Optional username and password -->

<username>amine</username>

<password>amine</password>

</datasource>

 #############################
 
 
i also put the driver oracle jdbc in
.....\Tomcat 5.5\common\lib
......\Tomcat 5.5\webapps\orbeon\WEB-INF\lib
 
 
 
but it dosn't work  i have the exeption :
java.sql.SQLException: Exception d'E/S: The Network Adapter could not establish the connection


--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: how to connect to a oracle database

Nikola Radic
The reported exception may be due to invalid port.
Have you tried to connect to the db using SQL client, using same params?



Amine Hanoun wrote:

> hi
> a have a problem to connect to a oracle 10g database
> a see the exemple " *sql*-address-book " and i change the
> datasource.xml like thse
>  
>
> ##################
>
> <datasource>
>
> <!-- Specify the driver for the database -->
>
> <driver-class-name>oracle.jdbc.driver.OracleDriver</driver-class-name>
>
> <!-- This causes the use of the embedded database -->
>
> <uri>jdbc:oracle:thin:@172.42.172.135:1521:xe</uri>
>
> <!-- Optional username and password -->
>
> <username>amine</username>
>
> <password>amine</password>
>
> </datasource>
>
>  #############################
>  
>  
> i also put the driver oracle jdbc in
> .....\Tomcat 5.5\common\lib
> ......\Tomcat 5.5\webapps\orbeon\WEB-INF\lib
>  
>  
>  
> but it dosn't work  i have the exeption :
> java.sql.SQLException: Exception d'E/S: The Network Adapter could not
> establish the connection

--

*P/ Please consider the environment before deciding to print this e-mail/*



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: Re: how to connect to a oracle database

Amine Hanoun
yes ,but it dosn't work
pleah help

2008/11/25 Nikola Radic <[hidden email]>
The reported exception may be due to invalid port.
Have you tried to connect to the db using SQL client, using same params?




Amine Hanoun wrote:
hi
a have a problem to connect to a oracle 10g database
a see the exemple " *sql*-address-book " and i change the datasource.xml like thse
 
##################

<datasource>

<!-- Specify the driver for the database -->

<driver-class-name>oracle.jdbc.driver.OracleDriver</driver-class-name>

<!-- This causes the use of the embedded database -->

<uri>jdbc:oracle:thin:@172.42.172.135:1521:xe</uri>

<!-- Optional username and password -->

<username>amine</username>

<password>amine</password>

</datasource>

 #############################
  i also put the driver oracle jdbc in
.....\Tomcat 5.5\common\lib
......\Tomcat 5.5\webapps\orbeon\WEB-INF\lib
   but it dosn't work  i have the exeption :
java.sql.SQLException: Exception d'E/S: The Network Adapter could not establish the connection


--

*P/ Please consider the environment before deciding to print this e-mail/*



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws




--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws