Applet problems

From: Morgan Kita <mkita(at)verseon(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Applet problems
Date: 2006-10-27 03:04:36
Message-ID: 1161918276.30127.12.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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."

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Stefano B. 2006-10-27 06:57:23 JTable and ResultSet TableModel with big resultset
Previous Message Bendik Rognlien Johansen 2006-10-26 15:30:54 Re: Retrieving arrays