Re: PostgreSQL + SSL - sun.security.validator.ValidatorException - Mailing list pgsql-jdbc

Ok,

I need to explain my setup here. I'm running a website via Jboss
application server. I have specified in Jboss, via an postgres-ds.xml
map, my jdbc connection like so:


<<datasources>

  <<local-tx-datasource>

    <<jndi-name>PostgresDS<</jndi-name>

    <<connection-url>jdbc:postgresql://localhost:5432/mydatabase?ssl<</connection-url>

    <<driver-class>org.postgresql.Driver<</driver-class>

    <<user-name>x<</user-name>

    <<password>x<</password>

  <</local-tx-datasource>

<</datasources>


Via jndi, I have a number of hibernate persistence classes, none of
which have a main(), which have access to the driver. I launch jboss
like so:


>cd /jboss/bin

/jboss/bin>  ./run.sh


So how do I tell the driver where to find the keystore in this
instance, as I am not running a stand alone java application?


regards


Andrew<fixed><color><param>0000,0000,E1E1</param><x-tad-bigger>


</x-tad-bigger></color></fixed>

On 7 Dec 2004, at 09:58, Andrew M wrote:


<excerpt>Ok,

I need to specify a class with property. What class!!??


java -Djavax.net.ssl.trustStore=/library/java/home/lib/security/cacert
<bold>class</bold>


I am using OS X java 1.4.2


regards


Andrew


On 7 Dec 2004, at 08:52, Andrew M wrote:


<excerpt>Vadim,


i'm doing exactly as you mentioned, but only get presented with a
usage list:


root# java
-Djavax.net.ssl.trustStore=/library/java/home/lib/security/cacert


Usage: java [-options] class [args...]

           (to execute a class)

   or  java [-options] -jar jarfile [args...]

           (to execute a jar file)


where options include:

.......

   -D<<name>=<<value>

                  set a system property


I can't see what the problem is here.


regards


Andrew


On 7 Dec 2004, at 02:05, Vadim Nasardinov wrote:


<excerpt>On Monday 06 December 2004 20:07, Andrew M wrote:

<excerpt>typing the following:


$ java -D javax.net.ssl.trustStore =

/library/java/home/lib/security/cacert


gives me the following error message


Exception in thread "main" java.lang.NoClassDefFoundError:

javax/net/ssl/trustStore


How do I resolve this issue?

</excerpt>

There should be no space between "-D" and "javax.net.ssl.trustStore".

Likewise for the equal sign: there should be no space on either side
of it.

Like so:


java -Djavax.net.ssl.trustStore=/library/java/home/lib/security/cacert



---------------------------(end of
broadcast)---------------------------

TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org


</excerpt>


---------------------------(end of
broadcast)---------------------------

TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org


</excerpt></excerpt>
Ok,
I need to explain my setup here. I'm running a website via Jboss
application server. I have specified in Jboss, via an postgres-ds.xml
map, my jdbc connection like so:

<datasources>
   <local-tx-datasource>
     <jndi-name>PostgresDS</jndi-name>
    <connection-url>jdbc:postgresql://localhost:5432/mydatabase?ssl</
connection-url>
     <driver-class>org.postgresql.Driver</driver-class>
     <user-name>x</user-name>
     <password>x</password>
   </local-tx-datasource>
</datasources>

Via jndi, I have a number of hibernate persistence classes, none of
which have a main(), which have access to the driver. I launch jboss
like so:

 >cd /jboss/bin
/jboss/bin>  ./run.sh

So how do I tell the driver where to find the keystore in this
instance, as I am not running a stand alone java application?

regards

Andrew


On 7 Dec 2004, at 09:58, Andrew M wrote:

> Ok,
> I need to specify a class with property. What class!!??
>
> java -Djavax.net.ssl.trustStore=/library/java/home/lib/security/cacert
> class
>
> I am using OS X java 1.4.2
>
> regards
>
> Andrew
>
> On 7 Dec 2004, at 08:52, Andrew M wrote:
>
>> Vadim,
>>
>> i'm doing exactly as you mentioned, but only get presented with a
>> usage list:
>>
>> root# java
>> -Djavax.net.ssl.trustStore=/library/java/home/lib/security/cacert
>>
>> Usage: java [-options] class [args...]
>>            (to execute a class)
>>    or  java [-options] -jar jarfile [args...]
>>            (to execute a jar file)
>>
>> where options include:
>> .......
>>    -D<name>=<value>
>>                   set a system property
>>
>> I can't see what the problem is here.
>>
>> regards
>>
>> Andrew
>>
>> On 7 Dec 2004, at 02:05, Vadim Nasardinov wrote:
>>
>>> On Monday 06 December 2004 20:07, Andrew M wrote:
>>>> typing the following:
>>>>
>>>> $ java -D javax.net.ssl.trustStore =
>>>> /library/java/home/lib/security/cacert
>>>>
>>>> gives me the following error message
>>>>
>>>> Exception in thread "main" java.lang.NoClassDefFoundError:
>>>> javax/net/ssl/trustStore
>>>>
>>>> How do I resolve this issue?
>>>
>>> There should be no space between "-D" and "javax.net.ssl.trustStore".
>>> Likewise for the equal sign: there should be no space on either side
>>> of it.
>>> Like so:
>>>
>>> java
>>> -Djavax.net.ssl.trustStore=/library/java/home/lib/security/cacert
>>>
>>>
>>> ---------------------------(end of
>>> broadcast)---------------------------
>>> TIP 1: subscribe and unsubscribe commands go to
>>> majordomo@postgresql.org
>>>
>>
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 1: subscribe and unsubscribe commands go to
>> majordomo@postgresql.org
>>