Thread: Application compile file using Embeded SQL in Postgres4.7.2
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">I'm trying to build an embedded SQL app in <span class="SpellE">Postgres</span> 4.7.2 and failing at thefirst hurdle - <span class="SpellE">Postgres</span> <span class="GramE">itself</span> compiles, starts, executes withno problems.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">We're using <span class="SpellE">gcc</span> 3.2.2 on SLES 8</span></font><p class="MsoNormal"><font face="Arial"size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">The problem I'm getting is that <span class="SpellE">ecpg</span> doesn't appear to able to generate <spanclass="SpellE">compilable</span> code <span class="GramE">for<span style="mso-spacerun:yes"> </span>something</span>as simple as</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">EXEC SQL CONNECT <span class="GramE">TO :target</span> USER :user;</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">/sandbox/<span class="SpellE">cowleyke/src/SQL_Benchmarks/tst_postgres.pgc</span>: In function `Connect':</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">/sandbox/cowleyke/src/SQL_Benchmarks/tst_postgres.pgc:378: warning: passing <span class="SpellE">arg</span>2 of `<span class="SpellE">ECPGconnect</span>' makes integer from pointer without a cast</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">/sandbox/cowleyke/src/SQL_Benchmarks/tst_postgres.pgc:378: too few arguments to function `<span class="SpellE">ECPGconnect</span>'</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">This is not the only place this type of error occurs. Elsewhere I have</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">EXCE SQL <span class="GramE">IMMEDIATE :stmt</span>;</span></font><p class="MsoNormal"><font face="Arial"size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><span class="GramE"><font face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial">Whichgives</span></font></span><font face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial"></span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">/sandbox/<span class="SpellE">cowleyke/src/SQL_Benchmarks/tst_postgres.pgc</span>: In function `<spanclass="SpellE">ExecuteQuery</span>':</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">/sandbox/cowleyke/src/SQL_Benchmarks/tst_postgres.pgc:447: warning: passing <span class="SpellE">arg</span>2 of `<span class="SpellE">ECPGdo</span>' makes integer from pointer without a cast</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">/sandbox/cowleyke/src/SQL_Benchmarks/tst_postgres.pgc:447: warning: passing <span class="SpellE">arg</span>3 of `<span class="SpellE">ECPGdo</span>' makes integer from pointer without a cast</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">/sandbox/cowleyke/src/SQL_Benchmarks/tst_postgres.pgc:447: warning: passing <span class="SpellE">arg</span>4 of `<span class="SpellE">ECPGdo</span>' makes pointer from integer without a cast</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="section1" style="margin:0cm;margin-bottom:.0001pt"><font face="Times New Roman"size="3"><span lang="EN-GB" style="font-size:12.0pt;mso-ansi-language:EN-GB;mso-no-proof:yes">Kevin Cowley</span></font><spanlang="EN-GB" style="mso-ansi-language:EN-GB;mso-no-proof:yes"></span><p class="section1" style="margin:0cm;margin-bottom:.0001pt"><fontface="Times New Roman" size="3"><span lang="EN-GB" style="font-size:12.0pt;mso-ansi-language: EN-GB;mso-no-proof:yes">R&D</span></font><p class="section1" style="margin:0cm;margin-bottom:.0001pt"><font face="TimesNew Roman" size="3"><span lang="EN-GB" style="font-size:12.0pt;mso-ansi-language: EN-GB;mso-no-proof:yes"> </span></font><p class="section1" style="margin:0cm;margin-bottom:.0001pt"><font face="Times NewRoman" size="2"><span lang="EN-GB" style="font-size:10.0pt;mso-ansi-language: EN-GB;mso-no-proof:yes">Tel: 0118 902 9099 (direct line)</span></font><p class="section1" style="margin:0cm;margin-bottom:.0001pt"><fontface="Times New Roman" size="2"><span lang="EN-GB" style="font-size:10.0pt;mso-ansi-language: EN-GB;mso-no-proof:yes">Email: </span></font><span class="MsoHyperlink"><u><font color="blue" size="2"><span style="font-size:10.0pt;mso-no-proof:yes">kevin.cowley@alchemetrics.co.uk</span></font></u></span><fontsize="2"><span lang="EN-GB"style="font-size:10.0pt;mso-ansi-language:EN-GB; mso-no-proof:yes"></span></font><p class="section1" style="margin:0cm;margin-bottom:.0001pt"><font face="Times New Roman"size="2"><span lang="EN-GB" style="font-size:10.0pt;mso-ansi-language: EN-GB;mso-no-proof:yes">Web: </span></font><span class="MsoHyperlink"><u><font color="blue" size="2"><span style="font-size:10.0pt;mso-no-proof:yes">http://www.alchemetrics.co.uk</span></font></u></span><fontsize="2"><span lang="EN-GB"style="font-size:10.0pt;mso-ansi-language:EN-GB"></span></font><p class="MsoNormal"><font face="Times New Roman"size="3"><span style="font-size: 12.0pt"> </span></font></div><font size="3"><br /><br /> **************************************************************************************<br/> ALCHEMETRICS LIMITED (ALCHEMETRICS)<br/> Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX<br /> Tel: +44 (0) 118 902 9000 Fax: +44(0) 118 902 9001<br /> This e-mail is confidential and is intended for the use of the addressee only.<br /> If you arenot the intended recipient, you are hereby notified that you must <br /> not use, copy, disclose, otherwise disseminateor take any action based on <br /> this e-mail or any information herein.<br /> If you receive this transmissionin error, please notify the sender<br /> immediately by reply e-mail or by using the contact details above andthen<br /> delete this e-mail.<br /> Please note that e-mail may be susceptible to data corruption, interception <br />and unauthorised amendment. Alchemetrics does not accept any liability for <br /> any such corruption, interception, amendmentor the consequences thereof.<br /> **************************************************************************************<br/></font>
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 =========================================================
On Tue, Apr 27, 2004 at 01:51:56PM +0100, Kevin Cowley wrote: > > 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. > ... Well it seems to me that there is also a problem in ecpg itself, namely that it accepts a singleton char as database name where only a string makes sense. I've fixed that in CVS. Michael -- Michael Meskes Email: Michael at Fam-Meskes dot De ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!