From: Constantin Teodorescu <teo@flex.ro>
To: Peter T Mount <peter@retep.org.uk>
Cc: PostgreSQL Interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] JDBC example is not working with Kaffe 1.0b3
Date: Thu, 31 Dec 1998 10:26:56 +0200
Message-ID: <368B3550.D79D8323@flex.ro> (raw)
References: <Pine.LNX.4.04.9812301858230.542-100000@maidast.retep.org.uk>
Peter T Mount wrote:
>
> It looks like Kaffe is having problems with it's IO. I have Redhat 5.2
> here, so I'll try it's Kaffe, and see if it has the same problem.
> Which one of the examples are you using?
I am using a simple program derived from example basic.java.
There are no significant changes inside, just the database name, name of
table and fields and maybe their types.
But the main idea is the same. Create a table, put some records inside
and select them.
I am attaching the java source to this e-mail. You should replace
"contabil" database name with your own.
Just a moment please, I want to verify if the original basic example is
working with kaffe.
...
SURPRISE !!!! The original basic.java is working good also with jdk
1.1.7 and with kaffe !!!!
But why it crashes with my program ? This would be more interesting to
see it!
It's 10:30 in Romania. C ya in 1999 !
I wish you A Happy New Year to all of you !
--
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA
Attachments:dbt.java (text/plain, 1.7K) download
import java.io.*;
import java.sql.*;
import java.text.*;
public class dbt
{
Connection db;
Statement st;
public dbt(String args[]) throws ClassNotFoundException, FileNotFoundException, IOException, SQLException
{
Class.forName("postgresql.Driver");
db = DriverManager.getConnection("jdbc:postgresql:contabil", "postgres", "postgres");
st = db.createStatement();
cleanup();
doexample();
//cleanup();
System.out.println("Now closing the connection");
st.close();
db.close();
}
public void cleanup()
{
try {
st.executeUpdate("drop table teste");
} catch(Exception ex) {
// We ignore any errors here
}
}
public void doexample() throws SQLException
{
System.out.println("\nRunning tests:");
st.executeUpdate("create table teste (id int2,nume text)");
st.executeUpdate("insert into teste values (1,'vasile')");
st.executeUpdate("insert into teste values (2,'ion')");
st.executeUpdate("insert into teste values (3,'gelu')");
System.out.println("performing a query");
//ResultSet rs = st.executeQuery("select * from teste");
System.out.println("Facem selectul ...");
ResultSet rs = st.executeQuery("select nume from teste");
System.out.println("L-am facut");
if(rs!=null) {
while(rs.next()) {
//int a = rs.getInt("id");
String b = rs.getString(1);
//System.out.println(" id="+a+" nume="+b);
System.out.println("nume="+b);
}
rs.close();
}
}
public static void main(String args[])
{
// Now run the tests
try {
dbt test = new dbt(args);
} catch(Exception ex) {
System.err.println("Exception caught.\n"+ex);
ex.printStackTrace();
}
}
}
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: teo@flex.ro, peter@retep.org.uk
Subject: Re: [INTERFACES] JDBC example is not working with Kaffe 1.0b3
In-Reply-To: <368B3550.D79D8323@flex.ro>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox