Обсуждение: 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