Re: [JDBC] JDBC 2.0

[Heitzso]

>
>
>Could you please tell me if the Postgres JDBC driver supports JDBC 2.0,
>and if so at what version it was introduced?
>
>Thank you in anticipation
>Roger
>
(Someone correct me if I'm wrong )

Roger, much of jdbc 2 is implemented, much remains to be
implemented.

Best way to sort this out is to either try the methods
you're wanting to use or look through the source
code for the methods you'll be calling and check
out whether they are stubbed or real.

Heitzso



---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

[JDBC] JDBC 2.0

[Roger Oed]

Could you please tell me if the Postgres JDBC driver supports JDBC 2.0,
and if so at what version it was introduced?

Thank you in anticipation
Roger

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[JDBC] JDBC 2.0 conformance, documentation and todo list

[Rene Pijlman]

Hello,

I've created a web page that aims to document the level of
conformance of the JDBC driver to the JDBC 2.0 API. It also aims
to document any deviations from the JDBC standard that have been
found.
http://lab.applinet.nl/postgresql-jdbc/

No need to say its still far from complete. I just wrote the
sections on Array and Batch Updates. I'm volunteering to finish
and maintain this page if people find it useful. Any comments?

Any feedback or additions will be greatly appreciated. If you
know about a JDBC 2.0 feature that seems to be missing or a
feature you know is implemented, please post a message on this
list.

The reason I created this page is that I wanted to work on JDBC
2.0 conformance, and except for Blob/Clob support Barry Lind
wrote about a couple of days ago, it wasn't clear what needed to
be done. Investigating and documenting the conformance level and
known deficiencies seemed like a good place to start.

Regards,
René Pijlman

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

[JDBC] JDBC 2.0 Scrollable Result Sets -- Slightly going mad --

[kalexm]

Hi,
I'm new in the List. Hopefully Im at the right place for my question.

We use Tomcat 3.2., J2EE and J2SE on RedHat 7

We Set up a Postgres 7.0.3 with jdbc7.0-1.2.jar. Classpath is correct.

The Code looks like that

  Class.forName(context.getInitParameter("ClassForName"));
  url = context.getInitParameter("url");
  dataBaseUserId = context.getInitParameter("dataBaseUserId");
  dataBasePassWord =
context.getInitParameter("dataBasePassWord");
  Connection con = DriverManager.getConnection(url,
dataBaseUserId, dataBasePassWord);
  Statement stmt1 =
con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);

It worked fine with my development Plattform using JDBC-ODBC Bridge on
SQL-SERVER 7.0 as well as ACCESS 2000. Now deployed on the Linux machine the
exception is returned, that the function is not implemented.

I use rs.last();rs.absolute();rs.next();rs.getRow();

What can I do ?

Thanks in advance:

Knud Müller


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html