Installing and using Ingres Eclipse DTP Bundle (again)

DATABASE

Installing and using Ingres Eclipse DTP Bundle (again)

Postby Roy Hann » Sat, 07 Feb 2009 05:22:27 GMT

[This got badly mangled in transit the first time, so I'm re-posting,
and adding a bit more detail.]

I've made a couple of attempts to install the Ingres Eclipse DTP Bundle
on a machine that already has a working Ingres Database 9.2
installation (not 9.3 as stated before).  I seem to be doing something
wrong.  When I set up the data source and test the jdbc properties,
iigcd starts using 50% of the CPU and Eclipse hangs waiting for it.

FWIMBW, here's a stack trace of iigcd:

USER32.dll!GetWindowLongW+0x34
ntdll.dll!RtlInitializeCriticalSection+0x89c
ntdll.dll!RtlTimeToTimeFields+0x19
kernel32.dll!GetSystemTime+0x2f
iilibcompat.dll!TMget_stamp+0x94
iilibcompat.dll!TMnow+0xc
iilibcompat.dll!ERslookup+0x87
iilibcompat.dll!ERlookup+0x3a
iilibgcf.dll!gcu_erfmt+0x13b
iilibgcf.dll!gcu_erlog+0xa9
iigcd.exe+0x835d
iigcd.exe+0x8214
iigcd.exe+0x941e
iilibcompat.dll!GCc_callback_driver+0x6e
iilibcompat.dll!GCexec+0x11d
iigcd.exe+0x1244
iigcd.exe+0x1d69f
kernel32.dll!RegisterWaitForInputIdle+0x49

FYI this is Ingres 2006 Release 3 Microsoft Windows Version II
9.2.0 (int.w32/115).

As you can probably guess from the stack trace, the error log fills up
with error messages, all of which look like: GCD Server internal error:
Invalid state transition in TL FSM. Input = 5, state = 0

It's got to be a bug, but have I provoked it by doing something silly?

-- 
Roy

UK Ingres User Association Conference 2009 will be on Tuesday June 9,
2009
Go to  http://www.**--****.com/ 




Re: Installing and using Ingres Eclipse DTP Bundle (again)

Postby seanjand » Sat, 07 Feb 2009 05:51:14 GMT

I found this link, which mentions the same error (though on release
9.1, and involving Hibernate - not sure if you're using that in you
app, or straight JDBC connections), but it mentions some amendments to
parameters which I got the impression helped...

 http://www.**--****.com/ 

Sean

Re: Installing and using Ingres Eclipse DTP Bundle (again)

Postby seanjand » Sat, 07 Feb 2009 06:01:33 GMT

One other thing I've found with JDBC in the past is how you create
your Statement...

This was way back in the days of "R3", but I found I needed to create
the statement as follows:

Statement statement = connection.createStatement
(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY,
 
ResultSet.HOLD_CURSORS_OVER_COMMIT);

It's the TYPE_SCROLL_INSENSITIVE bit that's important, but I think the
way the method takes parameters means you had to declare all three
just to get that one in!

Hope that helps - apologies if you already know this and have been
doing it for years, but it's often the simplest thing.... :o)

Cheers,

Sean.

Re: Installing and using Ingres Eclipse DTP Bundle (again)

Postby Roy Hann » Sat, 07 Feb 2009 16:47:55 GMT




Thanks Sean.  Yes, that thread reports the same error (amongst others). 

Unfortunately none of the config changes mentioned seem relevant in any
way.

All I was doing was using Eclipse Data Source set-up and its built-in
JDBC Test function. I have no idea what that does; probably just
connects to the JDBC server to prove the connection URL is right, then
disconnects.  I assume.  

Anyway, it looks like a bug.  I am hoping that it's just reacting badly
to something I've done wrong, and when I do it right the whole problem
will go away.

-- 
Roy

UK Ingres User Association Conference 2009 will be on Tuesday June 9, 2009
Go to  http://www.**--****.com/ 



Re: Installing and using Ingres Eclipse DTP Bundle (again)

Postby Kristoff » Sat, 07 Feb 2009 16:58:17 GMT




This matches a known problem actually caused by a configuration error.
Could you check whether the wintcp and the tcp_ip protocoll are both
enabled and are listening at the same port? In 9.0.4 this miss-
configuration caused exactly the problem you describe. This bug
(118003) is fixed even in 9.2, but  9.2.0 (int.w32/115) is a very
early (alpha?) release, it is not fixed there. Simply disabling the
wintcp protocoll should solve the problem(or if really needed change
the listen address), but you really should use the actual 9.2 release.

Kristoff

Re: Installing and using Ingres Eclipse DTP Bundle (again)

Postby Roy Hann » Sat, 07 Feb 2009 19:13:13 GMT





[snip]
[snip]

Thanks Kristoff; I wouldn't have thought of that.  That did the trick
and the JDBC test in Eclipse now works (after deleting errlog.log, which
had grown to fill an entire disk drive).


I think it might be worth asking whoever looks after the community
download page to add a note about this.  It seems this was bound to
happen because win_tcp and tcp_ip both default to ON in the alpha
release of 9.2 and that is the only GPL 9.2 executable; there is no
community update.  All you can do is upgrade to 9.3.

This seems like a good moment to ask if there's anyone on this list who
is using/playing with the Eclipse DTP Bundle.  Anyone got any
hints/tips? 

-- 
Roy

UK Ingres User Association Conference 2009 will be on Tuesday June 9, 2009
Go to  http://www.**--****.com/ 



Similar Threads:

1.[Info-Ingres] Installing and using an Ingres JDBC connection

2.Installing and using an Ingres JDBC connection

Richard,

=================================================
  To test that you have a good JDBC driver, try the following: -
=================================================

1/ Ensure you have the files "JdbcInfo.class" and "iijdbc.jar" inside
your %II_SYSTEM%\ingres\lib directory

2/ At the DOS command prompt use the following command (you can be in
any directory) : -

    java -cp %II_SYSTEM%\ingres\lib;%II_SYSTEM%\ingres\lib\iijdbc.jar
JdbcInfo

    If all is OK, you should see information about the JDBC driver
release

=================================================
  Your Java reporting problem
=================================================

1/ All operating systems have a set of directories they will search to
resolve a command. Java is the same but for programs and classes that
make up programs. For Java this is the CLASSPATH variable which is set
at the operating system level before you start any Java program.

2/ In the case of your reporting program, normally there will be a
configuration file (or screen) that will describe where the program
looks for JDBC drivers (you enter the full path name and .JAR file
name). Think of the .JAR file as a ZIP file because that is what it
is.. you can use 7-zip to explore it :-) Just saves copying lots of
directory structures and keeps things tidy. The classname (driver) you
want from this file is called "com.ingres.jdbc.IngresDriver", which if
you explorer the .JAR file you'll see there's a file called
IngresDriver.class in the sub-directory of com\ingres\jdbc. The report
program will want to know this classname.

3) So now the report program should be configured to load the
iijdbc.jar file in the %II_SYSTEM%\ingres\lib area and use the class
called "com.ingres.jdbc.IngresDriver".

=================================================
  Finally - using the JDBC driver
=================================================

1/ Now you've got the JDBC driver loaded into the reporting program,
you'll have to supply the URL for where it must go to find the Ingres
database (it's name/node/port/password etc)...

    For Ingres you use the following structure: -

    jdbc:ingres://host:port/db

so something like

    jdbc:ingres://host:II7/testdb

    the II7 is usually the default for the JDBC server component on an
ingres system configured with the installation code of II (but use CBF
on the system to see what the real port is).

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

Hope this helps to clarify

Cheers

Gary

3.[Info-ingres] Eclipse Data Tools Platform Project

4.The classic "NEW used in query that is not in a rule" problem again

On Tue, Nov 09, 2004 at 11:00:57PM -0000, John White wrote:
> It seems I'm not the first to ask this question but there seem to be
> very few answers. I am implementing an audit log facility where INSERT's
> or UPDATE's to a number tables get logged to a single table. Each row in
> the logging table stores data on one field change in the tables being
> logged.

This is hard to do with plpgsql, I don't understand why people keeps trying.
It's much easier with PL/Tcl.  An example, if you had these tables

CREATE TABLE usuarios
    (usuario_id int,
	     nombre text);

CREATE TABLE usuarios_audit
    (usuario_id int,
         nombre text,
	         op text,
	      fecha timestamp with time zone);


You could do something like

CREATE OR REPLACE FUNCTION
    audita_usuarios() RETURNS trigger AS '
    spi_exec "INSERT INTO usuarios_audit
        VALUES ($NEW(usuario_id),
        ''[ quote $NEW(nombre) ]'',
        ''[ quote $TG_op ]'',
        now())"
    return [array get NEW]
' LANGUAGE pltcl;

CREATE TRIGGER audita_usuarios
     BEFORE UPDATE OR INSERT OR DELETE
     ON usuarios FOR EACH ROW
     EXECUTE PROCEDURE audita_usuarios();

Note that you can give parameters to the function, as illustrated
by this other example (doing case folding, but should be trivial
to understand how to modify it):


CREATE TABLE a_table (
	column_1	text,
	column_2	text
);

CREATE OR REPLACE FUNCTION minusculas()
RETURNS trigger AS '
foreach key $args {
    if {[info exists NEW($key)]} {
      set NEW($key) [string tolower $NEW($key)]
    }
}
return [array get NEW]
' LANGUAGE pltcl;

CREATE TRIGGER minusculizar
     BEFORE INSERT OR UPDATE ON a_table
     FOR EACH ROW EXECUTE PROCEDURE
     minusculas('column_1', 'column_2');


You should be able to do whatever you want to do by extending
this examples, much more easily than by using plpgsql.
No wonder your eyes were bleeding.

I think the second example is almost verbatim from Elein Mustain's
excellent General Bits column.

-- 
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Pensar que el espectro que vemos es ilusorio no lo despoja de espanto,
so le suma el nuevo terror de la locura" (Perelandra, CSLewis)

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to  XXXX@XXXXX.COM  so that your
      message can get through to the mailing list cleanly

5.(Again) Datacorruption using 7.4.2 on XFS/raid1

6. Bundling Ingres with a proprietary product

7. I suspect Dan is on his "meds" again was I see Dan's off his meds again

8. [Info-Ingres] Installing Ingres 9.1.0 Beta on Windows XP



Return to DATABASE

 

Who is online

Users browsing this forum: No registered users and 66 guest