Hi Hiranya,

You are absoluty right. The jar was not a OSGI bundle, my bad. Confusing
because of my recent work with Json  ...

Well, i put the jar in the repository/components/lib and it still gave me
the same error:

Error testing connection : Error during executing validation query : Cannot
create PoolableConnectionFactory (The connection attempt failed.)

On the log:

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (The connection attempt failed.)
...
Caused by: org.postgresql.util.PSQLException: The connection attempt failed.
.....
Caused by: javax.net.ssl.SSLHandshakeException:
sun.security.validator.ValidatorException: PKIX path building failed:
sun.security.provider.certpath.SunCertPathBuilderException: unable to find
valid certification path to requested target

Now this is "funny". Let me explain:

I copied my aar from WSAS(3.2.0) and deployed in to the ESB(3.0.1) and the
Web Services connection worked ( i have a java class that does the
connection for me) . Web services are returning equal like in the WSAS.

My ESB URL connection in Data sources :

jdbc:postgresql://
database-pgsql-d.corp.turismodeportugal.pt:5432/entitas?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory


I don't think it's a ssl problem because if it works on Java2WSDL on ESB.
Any thoughts?

2010/11/4 Hiranya Jayathilaka <[email protected]>

> Hi Victor,
>
> On Fri, Nov 5, 2010 at 12:09 AM, Vitor Rodrigues <
> [email protected]> wrote:
>
>> Hi all,
>>
>> Using WSO2 ESB 3.0.1 and droped jdbc postgreSQL jar [1] in
>> $ESB_HOME/repository/components/dropins/ , i'm tring to configure the Data
>> Sources in the ESB Console but it always give this error :
>>
>
> This jar doesn't appear to be an OSGi bundle. In that case you cannot drop
> it into dropins directory. Try putting it in repository/components/lib
> directory instead.
>
> Thanks,
> Hiranya
>
>
>>
>> *Error testing connection : Error during executing validation query :
>> Cannot create PoolableConnectionFactory (The connection attempt failed.)*
>>
>> Does anyone have a datasources.properties with postgreSQL?
>>
>>
>>
>>
>> [1] - http://jdbc.postgresql.org/download/postgresql-8.4-702.jdbc4.jar
>>
>>
>> _______________________________________________
>> Carbon-dev mailing list
>> [email protected]
>> https://wso2.org/cgi-bin/mailman/listinfo/carbon-dev
>>
>>
>
>
> --
> Hiranya Jayathilaka
> Senior Software Engineer;
> WSO2 Inc.;  http://wso2.org
> E-mail: [email protected];  Mobile: +94 77 633 3491
> Blog: http://techfeast-hiranya.blogspot.com
>
> _______________________________________________
> Carbon-dev mailing list
> [email protected]
> https://wso2.org/cgi-bin/mailman/listinfo/carbon-dev


 <https://wso2.org/cgi-bin/mailman/listinfo/carbon-dev>
_______________________________________________
Carbon-dev mailing list
[email protected]
https://wso2.org/cgi-bin/mailman/listinfo/carbon-dev

Reply via email to