|
Home > Archive > PostgreSQL JDBC > November 2005 > SQLJ, any plans?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Jaime Casanova 2005-11-25, 1:24 pm |
| Hello all,
are there any plans to get embedded SQL (SQLJ) to work with the jdbc
in postgres?
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
| |
| Oliver Jowett 2005-11-25, 8:24 pm |
| Jaime Casanova wrote:
> are there any plans to get embedded SQL (SQLJ) to work with the jdbc
> in postgres?
What fails with the current driver?
-O
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
| |
| Jaime Casanova 2005-11-26, 3:23 am |
| On 11/25/05, Oliver Jowett <oliver@opencloud.com> wrote:
> Jaime Casanova wrote:
>
>
> What fails with the current driver?
>
> -O
>
The driver works fine, AFAIK... but it can use the SQLJ syntax?
#sql { SELECT campo INTO :var FROM tabla WHERE id = :id_var; }
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
| |
| Oliver Jowett 2005-11-26, 7:23 am |
| Jaime Casanova wrote:
> On 11/25/05, Oliver Jowett <oliver@opencloud.com> wrote:
>
>
> The driver works fine, AFAIK... but it can use the SQLJ syntax?
Uh.. from my limited knowledge of SQLJ, isn't it like "embedded SQL" in
the C world? i.e. you have a translator (the equivalent to ecpg) that
takes annotated source with SQLJ syntax and turns it into a regular Java
source file that uses standard JDBC? So the driver itself never sees the
SQLJ syntax..
Sounds like what you are looking for is a SQLJ translator? I don't know
of any plans to write a postgresql-specific translator .. aren't there
generic ones available, since the DB-level interface (JDBC) is standardized?
-O
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
|
|
|
|
|