f



RE: [Info-ingres] Scheduled SQL Job pulling from Ingres Fails #2

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------=_NextPartTM-000-73fefadc-1b08-404c-8090-16c589692b7e
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C66850.CD0AFE80"

------_=_NextPart_001_01C66850.CD0AFE80
Content-Type: text/plain


Thinking about it, Would this be of issue, as our Data Source is setup via
ODBC with the credentials in there, so whether the job was scheduled or not,
I would have thought that the user running the actual job would only make a
difference on the database the data is being imported to, not where it's
coming from, as that's taken care of by ODBC?

-----Original Message-----
From: Wooton, Geoffrey (NESL-IT) [mailto:Geoffrey.Wooton@npower.com] 
Sent: 25 April 2006 11:07
To: 'Steve'; info-ingres@cariboulake.com
Subject: RE: [Info-ingres] Scheduled SQL Job pulling from Ingres Fails

Check the SQL Server Agent account has permission to access your database.
Running from enterprise manager could run using a different user context to
scheduling via SQL Agent depending on the accounts configured to run the SQL
Server Service and that of the SQL Agent..

Geoff

-----Original Message-----
From: Steve [mailto:SMaxwell@NationalExpress.com]
Sent: Tuesday, April 25, 2006 10:45 AM
To: info-ingres@cariboulake.com
Subject: [Info-ingres] Scheduled SQL Job pulling from Ingres Fails


Hi All,

I have a DTS job to pull data out of an ingres database. When I run
this job manually through enterprise manager, it runs perfectly, when I
schedule it, it fails.

I've found a Microsoft KB on a similar problem that didnt help.

Has anyone had this before? What did you do to resolve this?

Cheers,

Steve


Technical Bumf:

Intel Ingres II running on Windows 2003 Server, SQL Server 2000, SP3.

_______________________________________________
Info-ingres mailing list
Info-ingres@cariboulake.com
http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres


**********************************************************************
 
The information contained in this e-mail is confidential and intended only
for the use of the addressee. If the reader of this message is not the
addressee, you are hereby notified that you have received this e-mail in
error and you must not copy, disseminate, distribute, use or take any action
as a result of the information contained in it.
    
If you have any queries, please contact the IT Service Desk on 1870
(01384-275454).
    
postmaster@npower.com

**********************************************************************


**********************************************************************

This e-mail is provided for general information purposes only and does not
constitute investment or transactional advice. For  the avoidance of doubt
the contents of this email are subject to contract and will not constitute a
legally binding contract.

The information contained in this e-mail is confidential and intended only
for the use of the addressee. If the reader of this message is not the
addressee, you are hereby notified that you have received this e-mail in
error and you must not copy, disseminate, distribute, use or take any action
as a result of the information contained in it.
    
If you have received this e-mail in error, please notify
postmaster@npower.com (UK 01384 275454) and delete it immediately from your
system.
    
Neither Npower nor any of the other companies in the RWE Npower group from
whom this e-mail originates accept any responsibility for losses or damage
as a result of any viruses and it is your responsibility to check
attachments (if any) for viruses.
Npower Limited Registered office: Windmill Hill Business Park, Whitehill
Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277.  This
e-mail may be sent on behalf of a member of the RWE Npower group of
companies.

**********************************************************************

------_=_NextPart_001_01C66850.CD0AFE80
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>RE: [Info-ingres] Scheduled SQL Job pulling from Ingres =
Fails</TITLE>
</HEAD>
<BODY>
<BR>

<P><FONT SIZE=3D2>Thinking about it, Would this be of issue, as our =
Data Source is setup via ODBC with the credentials in there, so whether =
the job was scheduled or not, I would have thought that the user =
running the actual job would only make a difference on the database the =
data is being imported to, not where it's coming from, as that's taken =
care of by ODBC?</FONT></P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Wooton, Geoffrey (NESL-IT) [<A =
HREF=3D"mailto:Geoffrey.Wooton@npower.com">mailto:Geoffrey.Wooton@npower=
..com</A>] </FONT>
<BR><FONT SIZE=3D2>Sent: 25 April 2006 11:07</FONT>
<BR><FONT SIZE=3D2>To: 'Steve'; info-ingres@cariboulake.com</FONT>
<BR><FONT SIZE=3D2>Subject: RE: [Info-ingres] Scheduled SQL Job pulling =
from Ingres Fails</FONT>
</P>

<P><FONT SIZE=3D2>Check the SQL Server Agent account has permission to =
access your database.</FONT>
<BR><FONT SIZE=3D2>Running from enterprise manager could run using a =
different user context to</FONT>
<BR><FONT SIZE=3D2>scheduling via SQL Agent depending on the accounts =
configured to run the SQL</FONT>
<BR><FONT SIZE=3D2>Server Service and that of the SQL Agent..</FONT>
</P>

<P><FONT SIZE=3D2>Geoff</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Steve [<A =
HREF=3D"mailto:SMaxwell@NationalExpress.com">mailto:SMaxwell@NationalExp=
ress.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, April 25, 2006 10:45 AM</FONT>
<BR><FONT SIZE=3D2>To: info-ingres@cariboulake.com</FONT>
<BR><FONT SIZE=3D2>Subject: [Info-ingres] Scheduled SQL Job pulling =
from Ingres Fails</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Hi All,</FONT>
</P>

<P><FONT SIZE=3D2>I have a DTS job to pull data out of an ingres =
database. When I run</FONT>
<BR><FONT SIZE=3D2>this job manually through enterprise manager, it =
runs perfectly, when I</FONT>
<BR><FONT SIZE=3D2>schedule it, it fails.</FONT>
</P>

<P><FONT SIZE=3D2>I've found a Microsoft KB on a similar problem that =
didnt help.</FONT>
</P>

<P><FONT SIZE=3D2>Has anyone had this before? What did you do to =
resolve this?</FONT>
</P>

<P><FONT SIZE=3D2>Cheers,</FONT>
</P>

<P><FONT SIZE=3D2>Steve</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Technical Bumf:</FONT>
</P>

<P><FONT SIZE=3D2>Intel Ingres II running on Windows 2003 Server, SQL =
Server 2000, SP3.</FONT>
</P>

<P><FONT =
SIZE=3D2>_______________________________________________</FONT>
<BR><FONT SIZE=3D2>Info-ingres mailing list</FONT>
<BR><FONT SIZE=3D2>Info-ingres@cariboulake.com</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres" =
TARGET=3D"_blank">http://mailman.cariboulake.com/mailman/listinfo.py/inf=
o-ingres</A></FONT>
</P>
<BR>

<P><FONT =
SIZE=3D2>***************************************************************=
*******</FONT>
<BR><FONT SIZE=3D2>&nbsp;</FONT>
<BR><FONT SIZE=3D2>The information contained in this e-mail is =
confidential and intended only</FONT>
<BR><FONT SIZE=3D2>for the use of the addressee. If the reader of this =
message is not the</FONT>
<BR><FONT SIZE=3D2>addressee, you are hereby notified that you have =
received this e-mail in</FONT>
<BR><FONT SIZE=3D2>error and you must not copy, disseminate, =
distribute, use or take any action</FONT>
<BR><FONT SIZE=3D2>as a result of the information contained in =
it.</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; </FONT>
<BR><FONT SIZE=3D2>If you have any queries, please contact the IT =
Service Desk on 1870</FONT>
<BR><FONT SIZE=3D2>(01384-275454).</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; </FONT>
<BR><FONT SIZE=3D2>postmaster@npower.com</FONT>
</P>

<P><FONT =
SIZE=3D2>***************************************************************=
*******</FONT>
</P>
<BR>

<P><FONT =
SIZE=3D2>***************************************************************=
*******</FONT>
</P>

<P><FONT SIZE=3D2>This e-mail is provided for general information =
purposes only and does not constitute investment or transactional =
advice. For&nbsp; the avoidance of doubt the contents of this email are =
subject to contract and will not constitute a legally binding =
contract.</FONT></P>

<P><FONT SIZE=3D2>The information contained in this e-mail is =
confidential and intended only for the use of the addressee. If the =
reader of this message is not the addressee, you are hereby notified =
that you have received this e-mail in error and you must not copy, =
disseminate, distribute, use or take any action as a result of the =
information contained in it.</FONT></P>

<P><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; </FONT>
<BR><FONT SIZE=3D2>If you have received this e-mail in error, please =
notify postmaster@npower.com (UK 01384 275454) and delete it =
immediately from your system.</FONT></P>

<P><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; </FONT>
<BR><FONT SIZE=3D2>Neither Npower nor any of the other companies in the =
RWE Npower group from whom this e-mail originates accept any =
responsibility for losses or damage as a result of any viruses and it =
is your responsibility to check attachments (if any) for =
viruses.</FONT></P>

<P><FONT SIZE=3D2>Npower Limited Registered office: Windmill Hill =
Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England =
and Wales: number 3653277.&nbsp; This e-mail may be sent on behalf of a =
member of the RWE Npower group of companies.</FONT></P>

<P><FONT =
SIZE=3D2>***************************************************************=
*******</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C66850.CD0AFE80--


------=_NextPartTM-000-73fefadc-1b08-404c-8090-16c589692b7e
Content-Type: text/plain;
	name="InterScan_Disclaimer.txt"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
	filename="InterScan_Disclaimer.txt"

********************************************************************************
This document is intended for, and should only be read by, those persons
to whom it is addressed. Its contents are confidential and if you have
received this message in error, please notify us immediately by telephone 
on 0121 450 8477 and delete all records of the message from your computer.
Any form of reproduction, dissemination, copying, disclosure,
modification, distribution and / or publication of this message without our
prior written consent is strictly prohibited.
Neither the author of this message nor their employers
accept legal responsibility for the contents of the message. Any views or
opinions presented are solely those of the author.

*********************************************************************************

------=_NextPartTM-000-73fefadc-1b08-404c-8090-16c589692b7e--

0
Steve
4/25/2006 10:12:47 AM
comp.databases.ingres 5857 articles. 0 followers. specially (35) is leader. Post Follow

0 Replies
371 Views

Similar Articles

[PageSpeed] 37

Reply:

Similar Artilces:

RE: [Info-ingres] Scheduled SQL Job pulling from Ingres Fails
Check the SQL Server Agent account has permission to access your database. Running from enterprise manager could run using a different user context to scheduling via SQL Agent depending on the accounts configured to run the SQL Server Service and that of the SQL Agent.. Geoff -----Original Message----- From: Steve [mailto:SMaxwell@NationalExpress.com] Sent: Tuesday, April 25, 2006 10:45 AM To: info-ingres@cariboulake.com Subject: [Info-ingres] Scheduled SQL Job pulling from Ingres Fails Hi All, I have a DTS job to pull data out of an ingres database. When I run this job manually through enterprise manager, it runs perfectly, when I schedule it, it fails. I've found a Microsoft KB on a similar problem that didnt help. Has anyone had this before? What did you do to resolve this? Cheers, Steve Technical Bumf: Intel Ingres II running on Windows 2003 Server, SQL Server 2000, SP3. _______________________________________________ Info-ingres mailing list Info-ingres@cariboulake.com http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres ********************************************************************** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of ...

[Info-ingres] RE: [ingres] [Info-ingres] Dates users were created in Ingres #2
Hi Troy, iidbdb journals are not that big. In one of my larger installations, 3 days worth of journals takes 112Mb for the transaction database and 200Kb for iidbdb. I think in Ingres 2.6 you can keep 100 checkpoints in the history. Paul -----Original Message----- From: Anderson, Troy E. [mailto:AndersonTE@bvsg.com] Sent: Monday, 17 January 2005 3:57 PM To: Paul Mason Cc: info-ingres@cariboulake.com Subject: RE: [ingres] [Info-ingres] Dates users were created in Ingres Hi Paul, Thanks for the information! I do have a question: I checkpoint the iidbdb daily with th...

RE: [Info-ingres] Re: Ingres stand-by database #2
Well aware of the -b bugs. We have filed many issues and have them all resolved on our version. We don't xfer the ckp's because it is 60GB over a WAN. We also "zero-out" the .jnl files before and after the ones we want to rollforward. We do NOT monkey with the .cnf file, just transfer it. -----Original Message----- From: martin.bowes@ctsu.ox.ac.uk [mailto:martin.bowes@ctsu.ox.ac.uk] Sent: Thursday, June 09, 2005 4:13 AM To: Kale, Mark (STP) Cc: info-ingres@cariboulake.com Subject: Re: [Info-ingres] Re: Ingres stand-by database Hi Mark I think I may hav...

[Info-ingres] RE: [ingres] [Info-ingres] Dates users were created in Ingres
Hi Paul, Thanks for the information! I do have a question: I checkpoint the iidbdb daily with the -d flag, so the journal files don't exist for me that far back (to cover all of 2004). If I weren't using the -d flag, how far back would Ingres track Journal/Checkpoint information? Indefinitely? I have a limited amount of space in my jnl file system, so I doubt I could keep a year's work of jnl files for that database even if I weren't using the -d flag. Thanks, Troy -----Original Message----- From: Paul Mason [mailto:latepaul@gmail.com] Sent: Sunday, Jan...

Re: [Info-Ingres] Upgrading from Ingres 2.6 to Ingres 2006- version9.2
I will be out of the office now until Wednesday 25th March, and will respond to your e-mail as soon as I can upon my return. If the matter is urgent, please raise a call via the ICT Helpdesk. This e-mail and any files transmitted with it are the property of the London Borough of Havering, are confidential, may be subject to legal privilege and are intended only for the person(s) or organisation(s) named above. Any unauthorised use, retention, distribution, copying or disclosure is strictly prohibited. If you receive this email in error, please notify the sender immediately and delete this e-mail from your system. WARNING: It is your responsibility to take all necessary steps to ensure this e-mail and any attachments to it are free from viruses. ...

RE: [Info-ingres] Ingres stand-by database #2
I am not doing a creeping one. It just allows a copy of the up-to-date journals and last ckp file etc. to be ready for A rollforward when required. -----Original Message----- From: martin.bowes@ctsu.ox.ac.uk [mailto:martin.bowes@ctsu.ox.ac.uk] Sent: Wednesday, 8 June 2005 8:12 p.m. To: Robert Allely; 'chloe.crowder@bl.uk' Cc: info-ingres@cariboulake.com Subject: Re: [Info-ingres] Ingres stand-by database Hi Robert, Chloe etc. I'm not sure if I have a full grasp on whether or not Robert was doing a 'creeping' rollforward or not, but just in case, I'd like to get on the Ol' Soap Box for a moment. Its one thing to set up a DR system using rollforwarddb from a checkpoint/journal etc. Thats a perfectly simple and natural thing to do. But Its quite another to use rollforwarddb from some point and then transfer over more journals and do a 'creeping' rollforwarddb -c +j '#f' - b... [-norollback] ....And then automate the process, ....allowing for errors such as: * the rollforwarddb being locked out by another process, * the possibility of a database being flagged as inconsistent on the DR site - which is very probable. * A breakdown in the transport of a journal or other essential file between the hosts. scp/rcp/ftp failure. * A journal being written to by the primary host archiver as it was transferred to the DR host. Whats that (unsupported) trace point to force ...

[Info-ingres] RES: [Info-ingres] Re: What animal should Ingres be?
Hi Paul, I agree totally with you Ingres needs a promotion strategy (urgently). For me the one of the main issue to try change this "perception" is to promote the use of Ingres for ISVs. There are many of then adapting their software to use open source technology (OS, Database, Development tools, etc.), and this is a great opportunity to grow up the use of Ingres. Here I know around ten software vendors (medium size) which are doing this move. And most of then are moving to use MySQL, PostgreSQL and Firebird. Unhappily, Ingres is so unknown it is not being considered a...

[Info-ingres] SV: [Info-ingres] Re: Ingres in the news
Well in the updated profile for Mark Berrenchea (www.ingres.com Board of Directors) after he switched from CA to Garnett & Helfrich, and Sam Greenblatt takes over of CA's Board membership it says that he's now responsible for Europe, Asia so hopefully something will happen in the close future, But as all others we're waiting. Mark Barrenechea joined Garnett & Helfrich Capital as a director effective June 19, 2006. Barrenechea will help expand the firm's investments into Europe and Asia in the emerging segment of Venture Buyouts, partnering with large technology co...

[Info-ingres] RES: [Info-ingres] Ingres Resources #2
Hi all, Good news, the knowledge base is back. It is within Ingres Service Desk. http://servicedesk.ingres.com:8080/CAisd/pdmweb.ingres Many thanks to the folks who did this job. Leandro Fava DBA-SINF-UNISC http://www.unisc.br Presidente IUG-BR http://www.iug-br.org Fone: +55 51 3717 7636 > -----Mensagem original----- > De: info-ingres-admin@cariboulake.com > [mailto:info-ingres-admin@cariboulake.com] Em nome de Paul Blondel > Enviada em: Thursday, April 13, 2006 6:16 PM > Para: info-ingres@cariboulake.com > Assunto: Re: [Info-ingres] Ingres Resources > > Leandro Pinto Fava wrote: > > where can I search in a knowledge base for Ingres solutions? It > > seems the knowledge base in service desk at ingres.com does not have > > info. > > Unfortunately it does not work at all. Keep an eye on it and > it may burst into life in the next little while. > _______________________________________________ > Info-ingres mailing list > Info-ingres@cariboulake.com > http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres > ...

RE: [Info-ingres] Re: Ingres/ICE (3.0.2) and Apache 2.0.54 #2
The example PHP file is available via http://www.ingres.co.uk/files/php/blob_read.phps and not the url posted earlier. ...

RE: [Info-ingres] Re: What animal should Ingres be? #2
Can't agree more with you Paul. I would be sceptical of something that is billed as rising from the ashes as it implies it was a pile of crud in the first place, and yes, it's very cheesy too. If Ingres Corp are serious about this animal logo then they should be thinking clearly what message they want it to portrait. Is it to symbolise the product ethos? Is it to align the product within an industry sector? Or maybe they want it to capture the public imagination? It should also be tightly integrated into Ingres Corp's marketing strategy, which makes me think that this ...

Re: [Info-ingres] Re: What animal should Ingres be? #2
Hello Mikey, SQL/J. Again. Gawd ... Michael Leo <mleo@cariboulake.com> wrote: >Mike Schilling wrote: > >>"Michael Leo" <mleo@cariboulake.com> wrote in message >>news:mailman.1133916120.16345.info-ingres@cariboulake.com... >> >> >>>Emiliano wrote: >>> >>> >>> >>>>On 2005-12-06, Paul Andrews <ac297@dial.pipex.commmmm> wrote: >>>> >>>> >>>> >>>> >>>> >>>>>I assume roy is thinking a...

Re: [Info-ingres] Re: What animal should Ingres be? #2
Hi there, Michael Leo <mleo@cariboulake.com> wrote: >Sorry. I lied. Not my last word. The missile missed. Packer >fans are happy in heaven. > Given the Packers' performances this season ... >Roy Hann wrote: > >>"Michael Leo" <mleo@cariboulake.com> wrote in message >>news:mailman.1134079081.15832.info-ingres@cariboulake.com... >> >> >> [snip] >> >>I am sure that happened, but my recollection of the same era is that it was >>the lack of row-level locking that got everyone all twi...

Re: [Info-ingres] Re: What animal should Ingres be? #2
Hi Mike, Michael Leo <mleo@cariboulake.com> wrote: [ lots of very true stuff about Java snipped ] A lot of what you say about Java is very true; in our shop, we have Java bytecode bouncing between Windows, Solaris, AIX and Linux. Any issues we've bumped into have been JVM implementation issues, not problems with the bytecode itself. And a JVM might open up some other interesting possibilities for sickos like me - JIProlog, anybody, or maybe even ML/J ? However, for the task at hand, my main gripes can be enumerated as : - the core Java language is weak (generally, and ...

RE: [Info-ingres] Re: Ingres stand-by database
This is a multi-part message in MIME format. ------=_NextPartTM-000-bba2044a-af8b-45e6-a531-d80e6c174589 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C56CF8.D5A2691A" ------_=_NextPart_001_01C56CF8.D5A2691A Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <?xml version=3D"1.0" ?> Yes, auditdb binary output is piped into the Java program the builds the = JDBC commands to execute them. A unique key is required. -----Original Message----- From: martin.bowes@ctsu.ox.ac.uk [m...

RE: [Info-ingres] Re: Ingres article #2
At 9:59 AM +1100 2/3/2006, Paul White wrote: >When CA announced they were moving their internal systems to SAP the >obvious question was asked - are they going to run SAP over ingres? I >wonder if this is one of the drivers. >Paul > This is strictly hearsay, but I seem to recall hearing that CA decided to run SAP on DB/2. They have some hard time constraints with very VERY severe penalties for missing deadlines. I have no idea how seriously SAP on Ingres was discussed at the time. Even if Ingres were a drop-in, I can't imagine a CA executive deciding to start...

RE: [Info-ingres] Re: How Different is Ingres? #2
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C5820F.3450AD70 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit > -----Original Message----- > From: David Richard [mailto:Richard.David@aah.co.uk] > Sent: 06 July 2005 09:49 > To: info-ingres@cariboulake.com > Subject: RE: [Info-ingres] Re: How Different is Ingres? > > Postgres' Multi Version Concurrency Control (MVCC) is explained here http://www.develope...

Re: [Info-ingres] Re: What animal should Ingres be? #2
Hi there, I wasn't going to respond to this point by point, but my general point in this discussion is based on choices. Some people want to be able to use Java in the server. Other people want to be able to use C# in the server. I want to be able to use R (say), and others may want to use Foolang, whatever they like. I don't think we should, at this point, be going down a "any colour you like, so long as it's black" route for this. We all agree it's going to be a hang of a lot of work to do *anything* in this area; I'd just like to make that load of work as ge...

Re: [Info-ingres] Re: What animal should Ingres be? #2
Hi there, "Paul Andrews" <ac297@dial.pipex.commmmm> wrote: >Oops, the database procedural language debate has turned into some kind of >academic discussion and is in danger of dissappearing up it's own posterior. > Isn't that pretty much what these types of discussions are for ? >Here's some ill-informed thoughts of my own. > >We're debating something, not even sanctioned by ingres corp. Welcome to open source. With the source available, we don't really need to ask for permission about this sort of stuff. The open sourc...

Re: [Info-ingres] Re: What animal should Ingres be? #2
Hi there, "Roy Hann" <specially@processed.almost.meat> wrote: >"Emiliano" <Emiliano@Iris-Advies.nl> wrote in message >news:d395$43973fce$3ec29f9d$4203@news.chello.nl... >> Tonyd08068@netscape.net wrote: >> >> > If we're going to go to all that hassle, why not take a leaf out of the >PostgreSQL book and > >> I don't really care whether it's java, or python, or C#, or Tcl or even >> lisp; it's just that many of the developers around me that have grown up >> on the 'regular' ...

Re: [Info-ingres] Re: What animal should Ingres be? #2
Hi there, Emiliano <Emiliano@Iris-Advies.nl> wrote: >I don't really care whether it's java, or python, or C#, or Tcl or even >lisp; it's just that many of the developers around me that have grown up > on the 'regular' procedural and/or OO languages find Ingres' SP >language arcane. > I don't really care what language folks want to use either; that's why I think the choice should be left open. Individual sites will no doubt choose a standard, but that standard may vary. I've never found the syntax of the procedure lan...

Re: [Info-ingres] Re: What animal should Ingres be? #2
Hi Mike, Michael Leo <mleo@cariboulake.com> wrote: [ snippage ] >Tony, > >You inspired me to look at how PostgreSQL does it. >I'm liking what I see, but I can't seem to find anything about >a Java binding. > The two I had a brief look at were PL/Java - http://gborg.postgresql.org/project/pljava/projdisplay.php PL-J - http://plj.codehaus.org Both seem to be reasonably current, so there is very probably some horrible, wrinkly difference between the two - otherwise they wouldn't have any justification for hanging around. PL/Java seems t...

RE: [Info-ingres] Re: What animal should Ingres be? #2
I've been following it all the way, it's great but it's missing something?! Imagine a thread this long and Marty hasn't said anything! C'mon Marty, lets hear something incisive and witty on this topic!!! ;-) Finn -----Original Message----- From: Roy Hann [mailto:specially@processed.almost.meat] Sent: 13 December 2005 08:55 To: info-ingres@cariboulake.com Subject: Re: [Info-ingres] Re: What animal should Ingres be? ************************************* This e-mail has been received by the Revenue Internet e-mail service. ************************...

RE: [Info-ingres] Re: How Different is Ingres? #2
Hi there, >I can't see why a similar locking option couldn't be added to Ingres in >time?? > Hmmm.... way back when, Postgres had a feature called "time travel", where you could consciously step back to older versions of rows of data to see how it used to look. At this time, it still used conventional locks. Around version 6.5 (6.5.2 ?) the time travel feature was dropped and converted into MVCC, and traditional spinlocks were dropped as the default mechanism (you can still get them by doing "select for update", IIRC) The thing is that Postgres ...

Web resources about - RE: [Info-ingres] Scheduled SQL Job pulling from Ingres Fails #2 - comp.databases.ingres

Resources last updated: 2/20/2016 3:25:30 PM