Re: Applet problems - Mailing list pgsql-jdbc

java is my codebase directory in relation to my directory structure.
When I attempt to run the applet in firefox, the pages are being served
by cherrypy. So my html looks like:

<applet code=MyClass.class codebase=java
archive="myjar.jar"
width=460 height=160>
</applet>

Therefore it searches java/org/...

On Fri, 2006-10-27 at 07:33 -0400, Dave Cramer wrote:
> On 26-Oct-06, at 11:04 PM, Morgan Kita wrote:
>
> > Hi,
> >
> > I am trying to use the jdbc drivers in a fairly simple applet in java
> > 1.5.0_03-b07 under linux. However, I am having problems with both
> > running from appletviewer and firefox. I can howerver run an
> > application
> > and connect and retireve information.
> >
> > My init function looks like this:
> >
> > public void init()
> > {
> >   String url = "jdbc:postgresql://server/dbase";
> >   try
> >       {
> >         Class.forName("org.postgresql.Driver");
> >         Properties props = new Properties();
> >         props.setProperty("user","myname");
> >         props.setProperty("password","secret");
> >         Connection conn = DriverManager.getConnection(url, props);
> >         Statement st = conn.createStatement();
> >         ResultSet rs = st.executeQuery(...some sql);
> >     ..... and so on
> >
> > As you can see this follows the info doc for JDBC pretty closely. As I
> > said it works fine in an application. However, when I try to load
> > it in
> > appletviewer it throws the following exception:
> >
> > "Method CalledCaught SQL Exception: Something unusual has occured to
> > cause the driver to fail. Please report this exception."
> >
> > It seems like some non-sql related function barfed up an exception.
> >
> > Anyways, no idea there.
> >
> > When I tried to run this within a page generated by CherryPy in
> > firefox
> > 2.0, it loads the applet in the background but then fails when it
> > tries
> > to perform Class.forName. Looking in my CherryPy log file I saw the
> > following errors:
> >
> > "The path '/java/org/postgresql/driverconfig.properties' was not
> > found."
> > "The path '/java/org/postgresql/translation/messages.class' was not
> > found."
> > "The path '/java/org/postgresql/translation/messages.properties'
> > was not
> > found."
> > "The path
> > '/java/org/postgresql/translation/messages.properties_en.class' was
> > not
> > found."
> > "The path
> > '/java/org/postgresql/translation/
> > messages.properties_en.properties' was
> > not found."
> > "The path
> > '/java/org/postgresql/translation/messages.properties_en_US.class' was
> > not found."
> > "The path
> > '/java/org/postgresql/translation/
> > messages.properties_en_US.properties'
> > was not found."
> The classpath shouldn't include /java in front of /org....
>
>
> >
> > What the heck? Its right none of those files do exist in the jar
> > archive. I see a reference to driverconfig.properties when trying load
> > default parameters... but I don't even see references to those other
> > files anywhere in the source.
> >
> > I also tried putting everything in jar archive and loading that in the
> > html with no effect.
> >
> > Please .... any ideas? I have no idea how to proceed.
> >
> > Thanks,
> > Morgan
> >
> > Please
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 4: Have you searched our list archives?
> >
> >                http://archives.postgresql.org
> >
>