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
