Обсуждение: applet

Hi,
I'm writing un applet for my application with postgres but it don't load (I
think) jdbc driver.
I add in .hotjava/properties jdbc.drivers=postgresql.Driver.




            try{
                    resultsTextArea.setText("elaborazione in corso");

                    Class.forName("postgresql.Driver");

                    String url = "jdbc:postgres:tesi";
                    String usr = "andrea";
                    String pwd = "";


                    db = DriverManager.getConnection(url, usr, pwd);

                    st = db.createStatement();

                    ....
                    ....
            }


It jump this try block.
What I can do?

Three things here:

1) The Class.forName() line isn't needed if you use the jdbc.drivers
property. It doesn't hurt, but not required.

2) The JDBC Url is wrong. it should read jdbc:postgresql:tesi

3) You may be having problems with the null password. If you are using
trust, or ident authentication (set in pg_hba.conf), then you could put
anything in here. Otherwise, use "Alter user" to set yourself a password,
and put it in here.

On Wed, 14 Oct 1998, Andrea Antibo wrote:

> Hi,
> I'm writing un applet for my application with postgres but it don't load (I
> think) jdbc driver.
> I add in .hotjava/properties jdbc.drivers=postgresql.Driver.
>
>             try{
>                     resultsTextArea.setText("elaborazione in corso");
>
>                     Class.forName("postgresql.Driver");
>
>                     String url = "jdbc:postgres:tesi";
>                     String usr = "andrea";
>                     String pwd = "";
>
>
>                     db = DriverManager.getConnection(url, usr, pwd);
>
>                     st = db.createStatement();
>
>                     ....
>                     ....
>             }
>
>
> It jump this try block.
> What I can do?
>
>

--
       Peter T Mount peter@retep.org.uk
      Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
 Java PDF Generator: http://www.retep.org.uk/pdf

On 14-Oct-98 Peter T Mount wrote:
>
> Three things here:
>
> 1) The Class.forName() line isn't needed if you use the jdbc.drivers
> property. It doesn't hurt, but not required.


if I cut the line from source code or from .hotjava/properties file I have this
error:

File not found when looking for: postgresql.Driver



> 3) You may be having problems with the null password. If you are using
> trust, or ident authentication (set in pg_hba.conf), then you could put
> anything in here. Otherwise, use "Alter user" to set yourself a password,
> and put it in here.

Ok, but when I wrote a application like basic.java exemple without password it
worked fine.


>
> On Wed, 14 Oct 1998, Andrea Antibo wrote:
>
>> Hi,
>> I'm writing un applet for my application with postgres but it don't load (I
>> think) jdbc driver.
>> I add in .hotjava/properties jdbc.drivers=postgresql.Driver.
>>
>>             try{
>>                     resultsTextArea.setText("elaborazione in corso");
>>
>>                     Class.forName("postgresql.Driver");
>>
>>                     String url = "jdbc:postgres:tesi";
>>                     String usr = "andrea";
>>                     String pwd = "";
>>
>>
>>                     db = DriverManager.getConnection(url, usr, pwd);
>>
>>                     st = db.createStatement();
>>
>>                     ....
>>                     ....
>>             }
>>
>>
>> It jump this try block.
>> What I can do?
>>
>>
>
> --
>        Peter T Mount peter@retep.org.uk
>       Main Homepage: http://www.retep.org.uk
> PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
>  Java PDF Generator: http://www.retep.org.uk/pdf