Re: [INTERFACES] [Fwd: postgresql JDBC driver question
От | Peter Mount |
---|---|
Тема | Re: [INTERFACES] [Fwd: postgresql JDBC driver question |
Дата | |
Msg-id | Pine.LNX.4.10.9910121950180.32422-100000@maidast.retep.org.uk обсуждение исходный текст |
Ответ на | [INTERFACES] [Fwd: postgresql JDBC driver question (Lim Cheng Peck-A15349 <Lim.Cheng.Peck@motorola.com>) |
Список | pgsql-interfaces |
On Wed, 6 Oct 1999, Lim Cheng Peck-A15349 wrote: > Hi Peter T Mount , Murad Nayal and all, > Referring to the subject above on POSTGRESQL JDBC Interface mailing > list, I still > can't find any exact solution on how to solve the problem if we have the "No > suitable driver exception" error on > APPLET from IE5(Microsoft (R) VM for Java (tm), 4.0 Release 4.79.0.2339) and > Netscape 4.61 (Java1.1.5). > I did the Applet compilation (JAVAC) with JDK 1.2. Is this is the > main problem ?? IE only supports 1.1.x (I've seen some people say it won't support 1.2 ever, but I'm not sure). Peter > > > > Here is my HTML file for the applet > database.jar is included postgresql classes and VLookup classes. > > <HTML> > <BODY> > <APPLET CODE="VLookup.class" > archive="database.jar" > WIDTH=800 HEIGHT=800> > </APPLET> > </BODY> > </HTML> > > > > Thanks and hope to hear from you soon. > Best Regards, > CPLIM > > > > > Your QUESTION-ANSWER on Date: Thu, 29 Oct 1998 00:54:31 -0500 > > > Re: [INTERFACES] [Fwd: postgresql JDBC driver question] > > ---------------------------------------------------------------------------- > ---- > > From: Murad Nayal <murad@godel.bioc.columbia.edu> > To: Peter T Mount <peter@retep.org.uk> > Subject: Re: [INTERFACES] [Fwd: postgresql JDBC driver question] > Date: Thu, 29 Oct 1998 00:54:31 -0500 > > ---------------------------------------------------------------------------- > ---- > > Peter T Mount wrote: > > > > On Wed, 28 Oct 1998, Murad Nayal wrote: > > > > I am baffled: > > > > > > I wrote a small java program to test postgresql jdbc driver. the > applet > > > runs fine locally using applet viewer. indicating that the driver is > > > recognizing the url and responding to it correctly. however I get the > > > > message "NO suitable Driver" when the applet is run from a remote > > > browser. the Class.forName("postgresql.Driver"); does not produce an > > > exception leading me to believe that the Driver is found but it is > not > > > accepting the url (same one that worked locally)? > > Ok, applets can be horrible little things, and sometimes it's not their > fault. Nine times out of ten it's the sandbox (applet security), or a > browser not handling java 1.1 or jdbc (some don't know about jdbc :-( ) > > Your code looks ok. I placed your URL into an application here, and all I > > got was: > > Connection failed: java.net.UnknownHostException: > godel.bioc.columbia.edu > > which is ok, as I wasn't connected at the time ;-) > > > > <Applet code="JDBCtest.class" archive=postgresql.jar width=300 > > > height=300> </Applet> > > As far as I can see, your problem is here. > > First, don't put .class in the code argument. It can break some browsers. > > Technically it's the class name that goes here, not the file name. > > The main problem is the archive argument. The browser is loading the > postgresql.jar file, looking for the JDBCtest class. It fails, so it then > > looks at the directory that the html file is in. It find's JDBCtest, but > as it's not in the jar file, some browsers implementations of the > "Sandbox" prevents the driver to be found. > > There are two solutions: > > extract the files from postgresql.jar into your html directory > > or > > create a new jar file containing the contents of postgresql.jar > and your applet. > > Remember: it's important to keep the directory structure. > > > Thank you for your suggestions. I followed your directions by unzipping the > jar file in the html directory, removed the archive attribute from the > <applet> tag and remove the class extension from the code attribute in the > applet tag. Now netscape produces: user authentication failed exception > while > internet explorer produces No suitable driver exception. Mind you, the > connection works just fine if you do it using the appletviewer locally on > the > machine. I am including next a copy of the html and the java files with just > > the user password obsecured (you have to trust me it does work :-)). > > thanks indeed for any suggestions and help > > ************ > -- Peter T Mount peter@retep.org.uk Main Homepage: http://www.retep.org.uk PostgreSQL JDBC Faq: http://www.retep.org.uk/postgresJava PDF Generator: http://www.retep.org.uk/pdf
В списке pgsql-interfaces по дате отправления:
Следующее
От: "Israel Zavalza Bahena"Дата:
Сообщение: Re: [INTERFACES] Postgres ODBC and PostgreSQL 6.5.2