Обсуждение: Re: Application compile file using Embeded SQL in P

Paul

I've just checked and they're const char*.

I also commented out my original EXEC SQL line and re wrote it as an
explicit connect and it compiled, so I started adding the variables back  in
and it still compiles.

I don't understand :-[ And I haven't changed the Makefile either.

Kevin Cowley
R&D
Tel: 0118 902 9099 (direct line)
Email: kevin.cowley@alchemetrics.co.uk
Web: http://www.alchemetrics.co.uk

-----Original Message-----
From: Paul Breen [mailto:pbreen@computerpark.co.uk] 
Sent: 27 April 2004 16:37
To: Kevin Cowley
Cc: 'pgsql-interfaces@postgresql.org'
Subject: Re: [INTERFACES] Application compile file using Embeded SQL in
Postgres4.7.2

Hello Kevin,

Are you sure that target & user are declared as string pointers (char *)?

The only way I could get similar errors to those you describe was by
declaring target & user as simple char variables in ECPG's declare
section.

I'm using gcc 3.3, Postgres 7.3.2 on SuSE 8.2.

Regards - Paul

>
> I'm trying to build an embedded SQL app in Postgres 4.7.2 and failing at
> the
> first hurdle - Postgres itself compiles, starts, executes with no
> problems.
>
> We're using gcc 3.2.2 on SLES 8
>
> The problem I'm getting is that ecpg doesn't appear to able to generate
> compilable code for  something as simple as
>
> EXEC SQL CONNECT TO :target USER :user;
>
> /sandbox/cowleyke/src/SQL_Benchmarks/tst_postgres.pgc: In function
> `Connect':
> /sandbox/cowleyke/src/SQL_Benchmarks/tst_postgres.pgc:378: warning:
> passing
> arg 2 of `ECPGconnect' makes integer from pointer without a cast
> /sandbox/cowleyke/src/SQL_Benchmarks/tst_postgres.pgc:378: too few
> arguments
> to function `ECPGconnect'
>
> This is not the only place this type of error occurs. Elsewhere I have
>
> EXCE SQL IMMEDIATE :stmt;
>
> Which gives
>
> /sandbox/cowleyke/src/SQL_Benchmarks/tst_postgres.pgc: In function
> `ExecuteQuery':
> /sandbox/cowleyke/src/SQL_Benchmarks/tst_postgres.pgc:447: warning:
> passing
> arg 2 of `ECPGdo' makes integer from pointer without a cast
> /sandbox/cowleyke/src/SQL_Benchmarks/tst_postgres.pgc:447: warning:
> passing
> arg 3 of `ECPGdo' makes integer from pointer without a cast
> /sandbox/cowleyke/src/SQL_Benchmarks/tst_postgres.pgc:447: warning:
> passing
> arg 4 of `ECPGdo' makes pointer from integer without a cast
>
> Kevin Cowley
> R&D
>
> Tel: 0118 902 9099 (direct line)
> Email: kevin.cowley@alchemetrics.co.uk
> Web: http://www.alchemetrics.co.uk
>
>
>
>
****************************************************************************
**********
> ALCHEMETRICS LIMITED (ALCHEMETRICS)
> Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX
> Tel:  +44 (0) 118 902 9000    Fax:  +44 (0) 118 902 9001
> This e-mail is confidential and is intended for the use of the addressee
> only.
> If you are not the intended recipient, you are hereby notified that you
> must
> not use, copy, disclose, otherwise disseminate or take any action based on
> this e-mail or any information herein.
> If you receive this transmission in error, please notify the sender
> immediately by reply e-mail or by using the contact details above and then
> delete this e-mail.
> Please note that e-mail may be susceptible to data corruption,
> interception
> and unauthorised amendment.  Alchemetrics does not accept any liability
> for
> any such corruption, interception, amendment or the consequences thereof.
>
****************************************************************************
**********
>
>


-- 
Paul M. Breen, Software Engineer - Computer Park Ltd.

Tel:   (01536) 417155
Email: pbreen@computerpark.co.uk
---------------------------------------------------------

This private and confidential e-mail has been sent to you 
by Computer Park Ltd. 

If you are not the intended recipient of this e-mail and 
have received it in error, please notify us via the email 
address or telephone number below, and then delete it from 
your mailbox.

Email: mailbox@computerpark.co.uk

Tel: +44 (0) 1536 417155
Fax: +44 (0) 1536 417566

Head Office:
Computer Park Ltd, Broughton Grange, Headlands, Kettering
Northamptonshire NN15 6XA

Registered in England: 3022961. 

Registered Office:
6 North Street, Oundle, Peterborough PE8 4AL 

=========================================================


**************************************************************************************
ALCHEMETRICS LIMITED (ALCHEMETRICS)
Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX
Tel:  +44 (0) 118 902 9000    Fax:  +44 (0) 118 902 9001
This e-mail is confidential and is intended for the use of the addressee only.
If you are not the intended recipient, you are hereby notified that you must 
not use, copy, disclose, otherwise disseminate or take any action based on 
this e-mail or any information herein.
If you receive this transmission in error, please notify the sender
immediately by reply e-mail or by using the contact details above and then
delete this e-mail.
Please note that e-mail may be susceptible to data corruption, interception 
and unauthorised amendment.  Alchemetrics does not accept any liability for 
any such corruption, interception, amendment or the consequences thereof.
**************************************************************************************

I don't think that's what Paul was asking... It might help if you post
a small example program. I think you're talking about something like:
int main(int argc, char **argv){  EXEC SQL BEGIN DECLARE SECTION;  const char *target = "db";  const char *user   =
"username"; EXEC SQL END DECLARE SECTION;
 
  EXEC SQL CONNECT TO :target USER :user;  printf("sqlca.sqlcode: %ld\n", sqlca.sqlcode);
  return( 0 );}

which gives the following:
lkind@kelvin:~% ecpg test.pgclkind@kelvin:~% gcc -Wall -lecpg test.clkind@kelvin:~% ./a.outsqlca.sqlcode: -402

So, if that's not what you have...

L.

Kevin Cowley writes:> Paul> > I've just checked and they're const char*.> > I also commented out my original EXEC SQL
lineand re wrote it as an> explicit connect and it compiled, so I started adding the variables back  in> and it still
compiles.>> I don't understand :-[ And I haven't changed the Makefile either.> > -----Original Message-----> From: Paul
Breen[mailto:pbreen@computerpark.co.uk] > Sent: 27 April 2004 16:37> To: Kevin Cowley> Cc:
'pgsql-interfaces@postgresql.org'>Subject: Re: [INTERFACES] Application compile file using Embeded SQL in>
Postgres4.7.2>> Hello Kevin,> > Are you sure that target & user are declared as string pointers (char *)?> > The only
wayI could get similar errors to those you describe was by> declaring target & user as simple char variables in ECPG's
declare>section.> > I'm using gcc 3.3, Postgres 7.3.2 on SuSE 8.2.> > Regards - Paul> > >> > I'm trying to build an
embeddedSQL app in Postgres 4.7.2 and failing at> > the> > first hurdle - Postgres itself compiles, starts, executes
withno> > problems.> >> > We're using gcc 3.2.2 on SLES 8> >> > The problem I'm getting is that ecpg doesn't appear to
ableto generate> > compilable code for  something as simple as> >> > EXEC SQL CONNECT TO :target USER :user;> >> >
/sandbox/cowleyke/src/SQL_Benchmarks/tst_postgres.pgc:In function> > `Connect':> >
/sandbox/cowleyke/src/SQL_Benchmarks/tst_postgres.pgc:378:warning:> > passing> > arg 2 of `ECPGconnect' makes integer
frompointer without a cast> > /sandbox/cowleyke/src/SQL_Benchmarks/tst_postgres.pgc:378: too few> > arguments> > to
function`ECPGconnect'> >> > This is not the only place this type of error occurs. Elsewhere I have> >> > EXCE SQL
IMMEDIATE:stmt;> >> > Which gives> >> > /sandbox/cowleyke/src/SQL_Benchmarks/tst_postgres.pgc: In function> >
`ExecuteQuery':>> /sandbox/cowleyke/src/SQL_Benchmarks/tst_postgres.pgc:447: warning:> > passing> > arg 2 of `ECPGdo'
makesinteger from pointer without a cast> > /sandbox/cowleyke/src/SQL_Benchmarks/tst_postgres.pgc:447: warning:> >
passing>> arg 3 of `ECPGdo' makes integer from pointer without a cast> >
/sandbox/cowleyke/src/SQL_Benchmarks/tst_postgres.pgc:447:warning:> > passing> > arg 4 of `ECPGdo' makes pointer from
integerwithout a cast