Thread: JDBC example is not working with Kaffe 1.0b3
I tried to run a JDBC example that come with PostgreSQL 6.4.1 using Kaffe 1.0b3 on a RedHat 5.1 i386 Pentium machine The example was running fine using jdk 1.1.7 but got the following error using Kaffe : java.sql.SQLException: IOError while reading from backend: java.io.IOException: The backend has broken the connection. Possibly the action you have attempted has caused it to close. at java/lang/Throwable.<init>(37) at java/lang/Exception.<init>(21) at java/sql/SQLException.<init>(21) at java/sql/SQLException.<init>(32) at postgresql/PG_Stream.ReceiveIntegerR(237) at postgresql/Connection.ReceiveFields(761) at postgresql/Connection.ExecSQL(734) at postgresql/Statement.execute(259) at postgresql/Statement.executeQuery(46) at dbt.doexample(46) at dbt.<init>(17) at dbt.main(62) The example is creating a table, insert some records in it and try to query the table. The program is making ok the table, the records are inserted fine (checked with psql) but it crashes when trying to query the table. Does somebody knows what could happening? Best regards, -- Constantin Teodorescu FLEX Consulting Braila, ROMANIA
On Wed, 30 Dec 1998, Constantin Teodorescu wrote:
> I tried to run a JDBC example that come with PostgreSQL 6.4.1 using
> Kaffe 1.0b3 on a RedHat 5.1 i386 Pentium machine
>
> The example was running fine using jdk 1.1.7 but got the following error
> using Kaffe :
>
> java.sql.SQLException: IOError while reading from backend:
> java.io.IOException: The backend has broken the connection. Possibly the
> action you have attempted has caused it to close.
> at java/lang/Throwable.<init>(37)
> at java/lang/Exception.<init>(21)
> at java/sql/SQLException.<init>(21)
> at java/sql/SQLException.<init>(32)
> at postgresql/PG_Stream.ReceiveIntegerR(237)
> at postgresql/Connection.ReceiveFields(761)
> at postgresql/Connection.ExecSQL(734)
> at postgresql/Statement.execute(259)
> at postgresql/Statement.executeQuery(46)
> at dbt.doexample(46)
> at dbt.<init>(17)
> at dbt.main(62)
>
> The example is creating a table, insert some records in it and try to
> query the table.
> The program is making ok the table, the records are inserted fine
> (checked with psql) but it crashes when trying to query the table.
>
> Does somebody knows what could happening?
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?
--
Peter T Mount peter@retep.org.uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf
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, ROMANIAimport 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();
}
}
}
On Thu, 31 Dec 1998, Constantin Teodorescu wrote: > 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! I've just briefly read through your program, and it looks ok. When I get home from work, I'll try it there with kaffe & JDK 1.1 & JDK1.2 > > It's 10:30 in Romania. C ya in 1999 ! > I wish you A Happy New Year to all of you ! Happy New Year, although there's still 14 hours to go here in the UK ;-) -- Peter Mount, IT Section petermount@it.maidstone.gov.uk Anything I write here are my own views, and cannot be taken as being the official words of Maidstone Borough Council