RE: ASKING AGAIN: problem in getting database connection from rem ote machine using JNDI

[Pe...@materna.de]

I dont know if it is required, but do you have a resource-ref
entry in your web.xml, something like this?

<resource-ref>
  <description>mySQL Datasource</description>
  <res-ref-name>jdbc/myAPP</res-ref-name> 
  <res-type>javax.sql.DataSource</res-type>
  <res-auth>Container</res-auth>
</resource-ref>

where res-ref-name has to be the same as in context.xml.

And perhaps your look-up-name might not be correct, but I am
not sure because I am using PostrgreSQL databse.

http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html
might help you out.

-----Ursprüngliche Nachricht-----
Von: rahul [mailto:rahul.joshi@amsoft.net]
Gesendet: Dienstag, 25. Oktober 2005 06:33
An: Tomcat Users List
Betreff: ASKING AGAIN: problem in getting database connection from
remote machine using JNDI



Is there anything else that is required for remote database?


> -----Original Message-----
> From: rahul [mailto:rahul.joshi@amsoft.net]
> Sent: Monday, October 24, 2005 7:56 PM
> To: Tomcat Users List
> Subject: problem in getting database connection from remote machine
> using JNDI
>
>
> Hi all,
>
> I am using tomcat JNDI for getting databse connection in my application
>
> For this I have created a context.xml file in myAPP/META-INF
> which looks like this:
>
> <?xml version="1.0" encoding="UTF-8"?>
> <Context path="/myAPP" docBase="myAPP" debug="5" reloadable="true"
>  privileged="true" crossContext="true">
>  <Resource name="jdbc/myAPP" auth="Container"
>   type="javax.sql.DataSource" maxActive="30" maxIdle="10" maxWait="6000"
>   username="user" password="password"
>   driverClassName="com.mysql.jdbc.Driver"
>   url="jdbc:mysql://localhost:3306/myDB" removeAbandoned="true"
>   autoReconnect="true"
>   validationQuery="select now()"
>   factory="org.apache.commons.dbcp.BasicDataSourceFactory"/>
> </Context>
>
>
> This works absolutely fine. But when I try to connect to a remote database
> by changing url in above
> file to "jdbc:mysql://192.168.5.65:3306/myDB" my application fails
> It creates following exception while retrieving a connection:
> org.apache.tomcat.dbcp.dbcp.SQLNestedException:
> Cannot create PoolableConnectionFactory (Unknown database 'myDB')
>
>
> code I have written for fetching connection is:
>
>
>    Context ctx = (Context) new InitialContext()
>      .lookup("java:comp/env");
>    if (ctx == null)
>    {
>     throw new Exception("No context available");
>    } else
>    {
>     dataSource = (DataSource) ctx.lookup("jdbc/icontact");
>     Connection connection = dataSource.getConnection();
>    }
>
>
> can anybody help?
>
>
> thanks in advance
> --RahulJoshi
>
>
>
>



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org