Re: Applet problems - Mailing list pgsql-jdbc

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
>