On 30 December 2012 09:43, Pid * <p...@pidster.com> wrote:
> On 29 Dec 2012, at 13:21, Mauro <mrsan...@gmail.com> wrote:
>
>> On 29 December 2012 13:04, Konstantin Kolinko <knst.koli...@gmail.com> wrote:
>>> 2012/12/29 Mauro <mrsan...@gmail.com>:
>>>> Hello.
>>>> I've various web applications running under tomcat6.
>>>
>>> Which one of many 6.0.x versions?
>>
>> 6.0.35
>>
>>>
>>>> One of those use jndi, say the name of webapp is my_app.
>>>> I put a my_app.xml under Catalina/localhost/ with a context section in
>>>> which I put:
>>>>
>>>> <Resource name="jdbc/my_app" auth="Container" type="javax.sql.DataSource"
>>>> maxActive="100" maxIdle="30" maxWait="10000"
>>>> username="xxx" password="xxx"
>>>> driverClassName="org.postgresql.Driver"
>>>>
>>>> url="jdbc:postgresql://svsopsql01.comune.cagliari.loc:5432/my_app"/>
>>>>
>>>> The jndi connection work well but........
>>>> I deploy another web application that uses jndi, say my_app1.
>>>> Put a my_app1.xml under Catalina/localhost/
>>>>
>>>>
>>>> <Resource name="jdbc/my_app1" auth="Container" type="javax.sql.DataSource"
>>>> maxActive="100" maxIdle="30" maxWait="10000"
>>>> username="xxx" password="xxx"
>>>> driverClassName="org.postgresql.Driver"
>>>>
>>>> url="jdbc:postgresql://svsopsql01.comune.cagliari.loc:5432/my_app1"/>
>>>>
>>>>
>>>> This second application does not work and I must investigate on it but
>>>> the problem is that also the jndi connection of the first application,
>>>> my_app, does not work.
>>>> Why?
>>>> I'm correct on putting my_app.xml and my_app1.xml under Catalina/localhost?
>>>
>>> So, if it is one application then it works. If you deploy the second
>>> application then both the first and the second do not work?
>>
>> Yes, the second application has a problem and I must investigate on it
>> but it is strange to me that also the first application doesn't work.
>> Here what I do:
>> Deploy the second application, it does not work, the first application works.
>> To connect the second application via jndi I create my_app1.xml with a
>> resource section and put under Catalina/localhost.
>> So under Catalina/localhost i have my_app.xml and my_app1.xml.
>> Redeploy the second and the forst applications, the second still does
>> not work but now does not work also the first application.
>>
>>
>>> What do you mean by "does not work"?
>>> What are the symptoms, messages etc.
>>
>> Here is the message error of the first application:
>>
>> org.jruby.rack.RackInitializationException: The driver encountered an
>> unknown error: Cannot create JDBC driver of class
>> 'org.postgresql.Driver' for connect URL
>>
>>
>>>
>>> Where did you place your JDBC drivers?
>>> I'd say that they should be in $CATALINA_BASE/lib, and NOT in any of your
>>> wars.
>>
>> My drivers are under $CATALINA_BASE/lib, I use only postgres.
>
> Are you setting path or docBase in your Context XML?
>
> Can you post the exact file content, password redacted etc?
Here is my_app.xml:
<Context path="/myapp>
<Resource name="jdbc/myapp" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="mauro" password="xxx" driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://svsopsql01.mydomain.com:5432/my_app"/>
</Context>
and here is my_app1.xml
<Context path="/myapp1>
<Resource name="jdbc/myapp1" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="mauro" password="xxx" driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://svsopsql01.mydomain.com:5432/my_app1"/>
</Context>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
