JVM Crashes when using getTimestamp on java.sql.ResultSet, about pljava HOT 3 CLOSED

Hi @paulbrasted

I don't know whether you are still in a position to give more details on this issue, but I have tried to construct a test case based on what you've reported. Here's what I came up with. The trouble is, in my environment it works as expected and doesn't crash. I wonder if you could try it in an empty db in yours.

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;

import java.util.logging.Logger;

import org.postgresql.pljava.annotation.SQLAction;
import org.postgresql.pljava.annotation.SQLActions;
import org.postgresql.pljava.annotation.Function;

@SQLActions({
  @SQLAction(provides="invoice_batch table", install=
    "CREATE TABLE invoice_batch AS " +
    "SELECT now() AS time_created, 42 AS id", remove=
    "DROP TABLE invoice_batch"
  ),
  @SQLAction(requires={"invoice_batch table","whenCreated fn"}, install=
    "SELECT whenCreated(42)"
  )
})
public class ttest
{
  @Function(provides="whenCreated fn")
  public static void whenCreated(Integer batch)
  throws SQLException
  {
    Timestamp createTimeStamp = null;
    java.sql.Connection sqlConnection =
      DriverManager.getConnection("jdbc:default:connection");
    String sql = "SELECT time_created FROM invoice_batch where id = "
      + batch.toString();
    ResultSet result = sqlConnection.createStatement().executeQuery(sql);
    if (result.next()) {
      createTimeStamp = result.getTimestamp("time_created");
    }
    Logger.getAnonymousLogger().warning(String.valueOf(createTimeStamp));
  }
}

If you build a jar from the above, say ttest.jar, you can run the test simply with SELECT sqlj.install_jar('file:///path/to/ttest.jar', 'ttest', true); and if things are working it should produce a WARNING with the timestamp value. In your case, I guess it should crash. Or if it doesn't crash, perhaps you could look for how it is different from your first example and what needs to be changed until it does crash?

Thanks,
-Chap

from pljava.

Hi Chap
Thanks for response. Give me a couple of days
Paul
On 5 Oct 2015 04:51, "Chapman Flack" [email protected] wrote:

Hi @paulbrasted https://github.com/paulbrasted

I don't know whether you are still in a position to give more details on
this issue, but I have tried to construct a test case based on what you've
reported. Here's what I came up with. The trouble is, in my environment it
works as expected and doesn't crash. I wonder if you could try it in an
empty db in yours.

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Timestamp;
import java.util.logging.Logger;
import org.postgresql.pljava.annotation.SQLAction;import org.postgresql.pljava.annotation.SQLActions;import org.postgresql.pljava.annotation.Function;

@SQLActions({
@SQLAction(provides="invoice_batch table", install=
"CREATE TABLE invoice_batch AS " +
"SELECT now() AS time_created, 42 AS id", remove=
"DROP TABLE invoice_batch"
),
@SQLAction(requires={"invoice_batch table","whenCreated fn"}, install=
"SELECT whenCreated(42)"
)
})public class ttest
{
@function(provides="whenCreated fn")
public static void whenCreated(Integer batch)
throws SQLException
{
Timestamp createTimeStamp = null;
java.sql.Connection sqlConnection =
DriverManager.getConnection("jdbc:default:connection");
String sql = "SELECT time_created FROM invoice_batch where id = "
+ batch.toString();
ResultSet result = sqlConnection.createStatement().executeQuery(sql);
if (result.next()) {
createTimeStamp = result.getTimestamp("time_created");
}
Logger.getAnonymousLogger().warning(String.valueOf(createTimeStamp));
}
}

If you build a jar from the above, say ttest.jar, you can run the test
simply with SELECT sqlj.install_jar('file:///path/to/ttest.jar', 'ttest',
true); and if things are working it should produce a WARNING with the
timestamp value. In your case, I guess it should crash. Or if it doesn't
crash, perhaps you could look for how it is different from your first
example and what needs to be changed until it does crash?

Thanks,
-Chap

—
Reply to this email directly or view it on GitHub
#47 (comment).

from pljava.

Have not heard from Paul since October, but noticing this involved timestamps and Windows gives it a very strong smell of the MSVC global-variable mislinkage business and I would bet it is fixed by 1f1e8fe.

Closing.

from pljava.