What are we doing wrong ?????

We have a fairly simple use of jconnect / JAVA (JDK 1.2.2)in that we are
accessesing a small database (500) records , which when you access the data
in SQL Advantage , brings back resullts in less than .5 sec , but when JDBC
is fired against it it can take upto 15 secs to retrive that data to the
screen (host is e450 , client is 500 Mhz Pentium with 128MB Memory) .

The basic logic of the program is something like this :-

1. Obtain Connection to sysbase using

connection = DriverManager.getConnection(url, user, passwd);


2. Create a Prepared Statement

static public PreparedStatement createPositionStatement( Connection con )
{
String sqlStatement = new String( "select wf.Counterparty," +
"wf.Entity,"+
"wf.TransactionId,"+
UserTypes ut where "+
"wf.PositionName = ? " +
"and ut.UserName = ?"
etc etc

then
);
try {
psq = con.prepareStatement(sqlStatement);
}
catch ( SQLException e )
{
System.err.println("SQLException in WflowData.createPositionData
");
System.err.println(e.getMessage());
return (null);
}
return(psq);