Thread: JDBC issue

JDBC issue

From
Joel Alejandro Espinosa Carra
Date:
Hi all.

I searched at google and did not find any answer. I have an older JDCB
driver in my java web application, if I update the driver to the 7.4
build 216 version some of the querys like the next show no results in
the ResultSet object:

SELECT a.reg_users_id_user AS id, a.first_name AS fn, a.last_name AS ln,
a.sur_name AS sn, ar.name AS area, u.email AS email FROM reg_aspirants a
INNER JOIN areas ar ON a.areas_id_area1 = ar.id_area INNER JOIN
reg_schools s ON a.reg_schools_id_school = s.id_school INNER JOIN
reg_users u ON a.reg_users_id_user = u.id_user INNER JOIN
reg_tests_aspirants ta ON a.reg_users_id_user = ta.reg_id_aspirant INNER
JOIN reg_tests t ON ta.reg_id_test = t.id_test INNER JOIN reg_calendars
c ON t.reg_calendars_id_calendar = c.id_calendar AND c.is_active AND
t.test_type = 'p' AND a.status = 'ap' GROUP BY a.reg_users_id_user,
a.first_name, a.last_name, a.sur_name, ar.name, s.name, u.email ORDER BY
a.last_name, a.sur_name, a.first_name ASC

but the same querys are working well if they are runned at pgsql, is
there something to I must to know in the newer version's API?.
I need to update the driver in order to use iBATIS because the older one
throw an exception: "java.sql.SQLException: ERROR:  SET AUTOCOMMIT TO
OFF is no longer supported.".

Thanks in advance.
Best regards.

ps. please tell me if it is the wrong mailing list for this issue.

--
Ing. Joel Alejandro Espinosa Carra
CINVESTAV CTS - Centro de Tecnología de Semiconductores
Tel. +52 (33) 3770-3700 ext. 1049
http://www.cts-design.com


--
Este mensaje ha sido analizado por MailScanner
en busca de virus y otros contenidos peligrosos,
y se considera que está limpio.
MailScanner agradece a transtec Computers por su apoyo.


Re: JDBC issue

From
Kris Jurka
Date:

On Tue, 23 May 2006, Joel Alejandro Espinosa Carra wrote:

> I searched at google and did not find any answer. I have an older JDCB driver
> in my java web application, if I update the driver to the 7.4 build 216
> version some of the querys like the next show no results in the ResultSet
> object:

I have no idea why the JDBC driver would cause any sort of difference in
the results of a query.  Are you sure you're connecting to the same server
and running the exact same query when you get results in psql?

If you can send a self contained reproducible example I'll take a look at
it, but I've got to guess it's something wrong with your code or your
connection.  You could also try updating to a newer JDBC driver, the 7.4
series is not maintained any longer.

> ps. please tell me if it is the wrong mailing list for this issue.
>

You should ask JDBC questions on the pgsql-jdbc list.

Kris Jurka

Re: JDBC issue

From
Joel Alejandro Espinosa Carra
Date:
Kris Jurka wrote:

>
>
> On Tue, 23 May 2006, Joel Alejandro Espinosa Carra wrote:
>
>> I searched at google and did not find any answer. I have an older
>> JDCB driver in my java web application, if I update the driver to the
>> 7.4 build 216 version some of the querys like the next show no
>> results in the ResultSet object:
>
>
> I have no idea why the JDBC driver would cause any sort of difference
> in the results of a query.  Are you sure you're connecting to the same
> server and running the exact same query when you get results in psql?

Yes I'm pretty sure, the same server, the same code, the same version of
postgres server (7.4), the only thing i did was replacing the jdbc jar
in the /common/lib/ tomcat directory.

>
> If you can send a self contained reproducible example I'll take a look
> at it, but I've got to guess it's something wrong with your code or
> your connection.  You could also try updating to a newer JDBC driver,
> the 7.4 series is not maintained any longer.
>
The java code is pretty ugly, (i did not wrote it, BTW), in order to
reproduce the error I had had send you the entire web application :-(

>> ps. please tell me if it is the wrong mailing list for this issue.
>>
>
> You should ask JDBC questions on the pgsql-jdbc list.

I will try it.

>
> Kris Jurka
>
Thank you very much.
Best regards.

--
Ing. Joel Alejandro Espinosa Carra
CINVESTAV CTS - Centro de Tecnología de Semiconductores
Tel. +52 (33) 3770-3700 ext. 1049
http://www.cts-design.com


--
Este mensaje ha sido analizado por MailScanner
en busca de virus y otros contenidos peligrosos,
y se considera que está limpio.
MailScanner agradece a transtec Computers por su apoyo.