From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | mkita(at)verseon(dot)com |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Applet problems |
Date: | 2006-10-27 11:33:31 |
Message-ID: | 001C0190-33CB-4A1C-ADDD-AF505452B728@fastcrypt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Morgan Kita | 2006-10-27 17:54:54 | Re: Applet problems |
Previous Message | Stefano B. | 2006-10-27 06:57:23 | JTable and ResultSet TableModel with big resultset |