[JDBC] JDBC Performance

2001-08-07 Thread mike
decrease until I vacuum analyze the database again. Is this normal? Mike ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[JDBC] Mismatched JDBC and Java Type

2001-04-27 Thread Mike Finn
uot; + obj + "\tvalueClass=" + obj.getClass().getName() ); will produce ... 10 columnName=active columnType=5 columnTypeName=int2 value=8 valueClass=java.lang.Integer ... note that md.getColumnClassName() is not implemented so I don't know what it wou

[JDBC] Updateable ResultSet

2001-05-03 Thread Mike D'Agosta
Hello, I am brand new to this list. I looked through the mailing list archive, but couldn't determine if ResultSets are Updateable yet. I'm using some old drivers for pgsql-jdbc. Are there drivers out now that have Updateable ResultSets? Thanks! Mike

Re: [JDBC] "No results" exception on insert

2001-05-08 Thread Mike D'Agosta
>Statement stmt; >ResultSet rs = stmt.executeQuery("insert into users values ( 'joe', 'blow' >)"); > >The problem is that the executeQuery throws an Exception. The message >is "No results were returned by the query":

Re: [JDBC] [GENERAL] Regarding Vacuumdb

2001-09-04 Thread Mike Mascari
commit, so the file was gone, but the entries in the system cataloge remained. This is fixed in newer versions. Hope that helps, Mike Mascari [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[JDBC] reteptools.jar

2001-02-22 Thread Mike Cannon-Brookes
What is this for? Anything useful in it Peter? I assume some purpose but it just seems to compile and sit around ? ;) -mike

[JDBC] Compiling

2001-03-22 Thread Mike Cannon-Brookes
Guys, tried to pull down the latest src and compile it but I can't. The build file seems to filter properties like MAJORVERISON, MINORVERSION etc with ant properties that don't exist? I've hard coded them all in my current SRC now, where are they supposed to co

[JDBC] DatabaseMetaData.getTables()

2001-03-22 Thread Mike Cannon-Brookes
rom reading the comments is a) a VIEW table type and b) not a valid option? (at least I think not valid, it's a confusing long comment ;)). I've patched it locally to add 'v' as a "VIEW" table type and it seems to now run fine. What to do? -mike

[JDBC] RE: Compiling

2001-03-25 Thread Mike Cannon-Brookes
IMHO make should not be needed at all? I've hard coded the numbers into the Ant script now and it works fine. Java users like myself have brains that go "ooh, build.xml, let me run ant" to compile things. Why do we need make? (I'm sure there's a reason I can'

[JDBC] RE: Compiling

2001-03-26 Thread Mike Cannon-Brookes
cause it arbitrarily changes version without regard to what's changed in the JDBC driver. Why not split it off to have it's own versioning scheme? (This would get rid of any dependency on make as a nice consequence) -mike > -Original Message- > From: [EMAIL PROTECTED] >

[JDBC] JDBC Driver under load

2001-04-18 Thread Mike Cannon-Brookes
er.connect(Driver.java:122) any ideas where to start looking? -mike ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

[JDBC] RE: JDBC Driver under load

2001-04-18 Thread Mike Cannon-Brookes
ng for the time taken for each query to also be logged) -mike > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Tom Lane > Sent: Thursday, April 19, 2001 10:55 AM > To: Mike Cannon-Brookes > Cc: [EMAIL PROTECTED] > Subject: Re: JD

[JDBC] Compiling JDBC Driver - impossible!

2001-05-13 Thread Mike Cannon-Brookes
ment the JDBC build process ? (Or simplify it!) IMHO (and I know we've had this argument before ;)) it should just be a single 'ant' call in the right place, I see no reason this couldn't work. -mike Mike Cannon-Brookes - Founder, Core Developer OpenSymphony - http://www.opens

RE: [JDBC] Compiling JDBC Driver - impossible!

2001-05-13 Thread Mike Cannon-Brookes
file', which makes automated builds hard. Why can't we just use ant? I see no reason the functionality of the JDBC Makefile can't be done purely in Ant. -mike Mike Cannon-Brookes - Founder, Core Developer OpenSymphony - http://www.opensymphony.com "The Open Source J2EE Component Pr

[JDBC] RE: Compiling JDBC Driver - impossible!

2001-05-13 Thread Mike Cannon-Brookes
I agree, this is an excellent idea. A repository of JDBC driver JARs for each different Postgres release - good thinking. Is there somewhere on the Postgres site we can store these / get them mirrored? -mike Mike Cannon-Brookes - Founder, Core Developer OpenSymphony - http

RE: [JDBC] Compiling JDBC Driver - impossible!

2001-05-14 Thread Mike Cannon-Brookes
ll work, I haven't had time to try any of them. (This might be useful for someone to summarise somewhere on jdbc.postgresql.org) This seems a very convoluted build process IMHO. -mike Mike Cannon-Brookes - Founder, Core Developer OpenSymphony - http://www.opensymphony.com "The Open S