Re: [JDBC]

2001-03-12 Thread Peter Mount
At 11:09 08/03/01 -0600, Dax Duskin wrote: >Hello all. > >I was hoping someone could help me with the following: > >I am trying to install jdbc and I am having some trouble. I am using the >Linux-Mandrake Distribution (7.2). > >First I installed the postgresql-jdbc rpm, but I couldn't find my >

Re: [JDBC] DatabaseMetaData and ResultSetMetaData

2001-03-12 Thread Peter Mount
At 20:22 09/03/01 +0100, Alberto Otero GarcĂ­a wrote: >Hello everybody, > > I'm planning to do a tool in order to reverse engineer from a > database >already created to a UML diagram. I'd like to do the test with a PostgreSQL >database, but I've found that DatabaseMetaData and ResultSetMet

Re: [JDBC] JDBC build patches

2001-03-12 Thread Peter Mount
At 23:42 09/03/01 +0100, Peter Eisentraut wrote: >These are the follow-up patches to Peter Mount's recent Java build >improvements. > >* implement 'make uninstall' for the java directories What's the difference between uninstall and clean? >* pick up the version information from Makefile.global

Re: [JDBC] getTables is this right?

2001-03-12 Thread Peter Mount
At 23:39 09/03/01 -0800, Eric Frazier wrote: >Hi, > >I am having problems getting info on tables with getTables. I get null >returned all of the time. Where is it returning null? It should always return a result set. >I was using this code > >snip: > >//String [] onlytables = new String[3]; >

Re: [JDBC] callable statements, latest snapshot

2001-03-12 Thread Peter Mount
At 19:46 11/03/01 -0500, Gregory Bittar wrote: >The last I heard, CallableStatements were going to be >part of the 7.1 release. I downloaded the latest 7.1 >snapshot (March 10th's) and was surprised to find that >the Connection objects for both JDBC1 and JDBC2 drivers >are hardcoded to throw an e

Re: [JDBC] JDBC build patches

2001-03-12 Thread Peter Eisentraut
Peter Mount writes: > What's the difference between uninstall and clean? 'clean' undoes 'all', 'uninstall' undoes 'install'. > >* honour the default port as specified to configure > > Hmm, not a good idea. The driver should be as globally useable (part of > write once run anywhere), so this wou

Re: [JDBC] JDBC build patches

2001-03-12 Thread Peter Mount
At 17:47 12/03/01 +0100, Peter Eisentraut wrote: >Peter Mount writes: > > > What's the difference between uninstall and clean? > >'clean' undoes 'all', 'uninstall' undoes 'install'. Ah ok. > > >* honour the default port as specified to configure > > > > Hmm, not a good idea. The driver should b

[JDBC] Re: [INTERFACES] object id

2001-03-12 Thread Peter Mount
At 19:22 12/03/01 +0100, [EMAIL PROTECTED] wrote: > >Hmm, not really. The only oid you can get is one from an Insert, but thats > >for the most recent row inserted. > > >How do i get the oid from the blob of the most recent row inserted? The only way is to re-query the row as only the oid of the

Re: [JDBC] callable statements, latest snapshot

2001-03-12 Thread Gregory Bittar
Thanks for your really timely response. It is appreciated. Forging ahead, are there any workarounds for this process? I was thinking about reorganizing things around log/event tables. An insert to a log table would trigger my stored procs, which would in turn apply more complicated business

[JDBC] jdbc and large objects and oid column

2001-03-12 Thread Stuart Barlow
I am running postgresql 7.0.2 on redhat linux and connecting using the jdbc7.0-1.2.jar Is this the latest jdbc jar? On another subject... I am trying to store Serialized objects, taking the byte array and storing in a table with an OID column. I believe that Postgresql uses this OID as a refere

[JDBC] Re: [INTERFACES] JDBC: can't set transaction isolation level

2001-03-12 Thread Peter Mount
At 14:29 12/03/01 -0300, [EMAIL PROTECTED] wrote: redirecting to jdbc list: > Hi, > > I need to set transaction isolation level to SERIALIZABLE in a java > program. >Calling the method setTransationIsolation of class Connection has no >effect: the >isolation level still remains READ_COMM

Re: [JDBC] getTables is this right?

2001-03-12 Thread Eric Frazier
Hi, Thanks greatly for all of your help. I found that my "unexplained error" with building 7.1 with ant was because I already had a database named test in postgress. I just renamed the db in the Build.xml to test2 and everything went just fine. I still can not return a result set with non nul

[JDBC]

2001-03-12 Thread Stuart Barlow
I am running postgresql 7.0.2 on redhat linux and connecting using the jdbc7.0-1.2.jar Is this the latest jdbc jar? On another subject... I am trying to store Serialized objects, taking the byte array and storing in a table with an OID column. I believe that Postgresql uses this OID as a referen

[JDBC] Re: connection pooling in JDBC driver

2001-03-12 Thread arkin
Richard Bullington-McGuire wrote: > > On 9 Mar 2001, Gunnar R|nning wrote: > > > [snip] Of course your milage may vary, but this is not really a pgsql > > related question... ;-D Unless of course we are talking about implementing > > pooling for the DataSource class, but that is somewhat unrelat