[JDBC] Re: [Fwd: JDBC Timestamp problem]

2001-02-22 Thread Joseph Shraibman
touching to my data ? Thank you for answering that quickly Antonio Fiol W3ping -- Joseph Shraibman [EMAIL PROTECTED] Increase signal to noise ratio. http://www.targabot.com

[JDBC] Re: Combo box

2001-03-28 Thread Joseph Shraibman
a drop-down. -- Joseph Shraibman [EMAIL PROTECTED] Increase signal to noise ratio. http://www.targabot.com ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED

[JDBC] BigDecimal instead of Integer in 7.1

2001-04-30 Thread Joseph Shraibman
of the subselect used to return an Integer now returns a BigInteger and is causing classCastExceptions in my code. What gives? -- Joseph Shraibman [EMAIL PROTECTED] Increase signal to noise ratio. http://www.targabot.com ---(end of broadcast)--- TIP 4

[JDBC] Vectors in 7.1 ResultSets

2001-04-30 Thread Joseph Shraibman
Why do the 7.1 ResultSets use Vectors where they used arrays in 7.0.x? Vectors are slower and create more garbage and have the overhead of synchronization for every method call. If there is some reason pre-sized arrays can't be used then ArrayLists should be used instead. -- Joseph

Re: [JDBC] BigDecimal instead of Integer in 7.1

2001-04-30 Thread Joseph Shraibman
Tom Lane wrote: Joseph Shraibman [EMAIL PROTECTED] writes: The problem is suddenly in 7.1 the result of the subselect used to return an Integer now returns a BigInteger and is causing classCastExceptions in my code. What gives? sum() and avg() return NUMERIC now for integer input

[JDBC] Re: Patch to remove connection hook and JDK 1.3 dependencies

2001-07-06 Thread Joseph Shraibman
to code my own shutdown hooks. -- Joseph Shraibman [EMAIL PROTECTED] Increase signal to noise ratio. http://www.targabot.com ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister

[JDBC] Re: prepared statement performance

2001-07-09 Thread Joseph Shraibman
the statements into prepared statements? -- Joseph Shraibman [EMAIL PROTECTED] Increase signal to noise ratio. http://www.targabot.com ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge

[JDBC] Re: Patch to remove connection hook and JDK 1.3 dependencies

2001-07-09 Thread Joseph Shraibman
Joseph Shraibman wrote: snip to do Bad Things. The java.policy file can have an entry to allow only code in org.postgres to add shutdown hooks (maybe we should put this in the documentation). grant codeBase file:///usr/local/pgsql/share/java/ { permission java.lang.RuntimePermission

Re: [JDBC] Re: Patch to remove connection hook and JDK 1.3 depen

2001-07-09 Thread Joseph Shraibman
Ned Wolpert wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09-Jul-2001 Joseph Shraibman wrote: BTW having to add a line to your permission file for shutdown hooks is not a good reason to get rid of this feature. It most cases it would be Very true. However, having

[JDBC] Re: Patch to remove connection hook and JDK 1.3 dependencies

2001-07-09 Thread Joseph Shraibman
Joseph Shraibman wrote: snip OK I looked at ConnectionHook in the cvs and there is obviously code there to close the connections, but where is the code that calls ConnectionHook.open()? That's probably the problem. Also a Vector should be used instead of an ArrayList because there could

[JDBC] Shutdown hook imp

2001-07-09 Thread Joseph Shraibman
of) but the java files are free of syntax errors. -- Joseph Shraibman [EMAIL PROTECTED] Increase signal to noise ratio. http://www.targabot.com jdbc_shutdown_hook_diffs.zip ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send

[JDBC] Re: Help! Driver cannot be loaded.

2001-07-24 Thread Joseph Shraibman
---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- Joseph Shraibman [EMAIL PROTECTED] Increase signal to noise ratio. http

[JDBC] Re: JDBC Performance

2001-08-09 Thread Joseph Shraibman
between 3-5 ms/record. Performance on the updates continue to decrease until I vacuum analyze the database again. Is this normal? Mike -- Joseph Shraibman [EMAIL PROTECTED] Increase signal to noise ratio. http://www.targabot.com ---(end of broadcast

[JDBC] NullPointerException on next()

2001-08-09 Thread Joseph Shraibman
Using the jdbc 7.1.2 drivers: Exception in thread main java.lang.NullPointerException at org.postgresql.jdbc2.ResultSet.next(ResultSet.java:116) that line is: if (++current_row = rows.size()) -- Joseph Shraibman [EMAIL PROTECTED] Increase signal to noise ratio. http

[JDBC] Patch for jdbc2 ResultSet.java

2001-09-04 Thread Joseph Shraibman
rows_size = rows.size(); ! if (rows_size = 0) return false; ! current_row = rows_size - 1; this_row = (byte [][])rows.elementAt(current_row); return true; } *** *** 1480,1483 } } } - --- 1485,1487 -- Joseph

Re: [JDBC] Patch for jdbc2 ResultSet.java

2001-09-05 Thread Joseph Shraibman
} } } - --- 1485,1487 -- Joseph Shraibman [EMAIL PROTECTED] Increase signal to noise ratio. http://www.targabot.com ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [JDBC] JDBC 2 ResultSet and cursors

2001-10-18 Thread Joseph Shraibman
g? Are we talking about the same driver? -Original Message----- From: Joseph Shraibman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 17, 2001 11:36 PM To: Kovcs Pter Cc: [EMAIL PROTECTED] Subject: Re: JDBC 2 ResultSet and cursors To use a cursor behind the scenes would require the jd

Re: [JDBC] J2SE 1.4 and other patches

2001-10-16 Thread Joseph Shraibman
FYI To see what's new: http://java.sun.com/j2se/1.4/docs/relnotes/features.html#jdbc -- Joseph Shraibman [EMAIL PROTECTED] Increase signal to noise ratio. http://www.targabot.com ---(end of broadcast)--- TIP 5: Have you checked our extensive

Re: [JDBC] J2SE 1.4 and other patches

2001-10-16 Thread Joseph Shraibman
] [mailto:[EMAIL PROTECTED]] On Behalf Of Joseph Shraibman Sent: October 16, 2001 5:45 PM To: Rene Pijlman Cc: Mark Lillywhite (pg-jdbc); [EMAIL PROTECTED] Subject: Re: [JDBC] J2SE 1.4 and other patches I think what most needs to be done is for someone to update the build process, so people

Re: [JDBC] JDBC 2 ResultSet and cursors

2001-10-17 Thread Joseph Shraibman
d 2 in myc; close myc; rollback; (or if you did some update in the same transaction: commit;) -Original Message----- From: Joseph Shraibman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 16, 2001 11:54 PM To: Kovcs Pter Cc: [EMAIL PROTECTED] Subject: Re: JDBC 2 ResultSet and cursors

Re: [JDBC] J2SE 1.4 and other patches

2001-10-17 Thread Joseph Shraibman
Don't you need execute cvs commands to add new files? I guess I don't know. Barry Lind wrote: Anyone can do that by submitting a patch. I don't see anything special that needs to be done. --Barry Joseph Shraibman wrote: Right. And a maintainer needs to make a jdbc3 direcotry

Re: [JDBC] J2SE 1.4 and other patches

2001-10-16 Thread Joseph Shraibman
be on this list. Regards, René Pijlman [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Joseph Shraibman [EMAIL PROTECTED] Increase signal to noise ratio. http://www.targabot.com ---(end