Re: [JDBC] How to set numeric in PreparedStatement

2001-03-22 Thread Juhan-Peep Ernits
On Wed, 21 Mar 2001, Aaron Brashears wrote: > PreparedStatement pstmt = connectoin.prepareStatement( > "select id from account where balance > ? and balance < ?"; > pstmt.setDouble( 1, 10.0 ); > pstmt.setDouble( 2, 100.0 ); > ResultSet rs = pstmt.executeQuery(); > ... > > And fin

[JDBC] Re: patches for jdbc1 (fwd)

2001-03-22 Thread Peter T Mount
Quoting Peter Eisentraut <[EMAIL PROTECTED]>: > Peter M., can you examine this patch? Hmmm, looks ok although I'm not sure by reading this if the warning target gets executed if jdk1.2+ is not set, because of the if="jdk1.2+" in the compile target. I'll have to try it with ant, but I think an

Re: [JDBC] I can't connect

2001-03-22 Thread Peter T Mount
Quoting Bart <[EMAIL PROTECTED]>: > Hi, > > I installed debian 2.2r2 with _all_ the postgres-packages, I created a > database and via psql I can do whatever I want with the DB. Now I'm > trying to make a connection via a Java-program. I downloaded the > jdbc-6.5-1.2.jar file and renamed it to

Re: [JDBC] How to set numeric in PreparedStatement

2001-03-22 Thread Aaron Brashears
On Thu, Mar 22, 2001 at 10:12:16AM +0200, Juhan-Peep Ernits wrote: > > May be this would help? > > "select id from account where balance > ?::numeric(10,2) and > balance < ?::numeric(10,2)"; > > > Juhan Ernits > Perfect! Thank you, it works great. I've never seen that syntax before, i

[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 come from? -mike -

[JDBC] DatabaseMetaData.getTables()

2001-03-22 Thread Mike Cannon-Brookes
I'm having problems with this method at the moment on one DB. I get a null pointer at the line... (1707 in the latest src) tuple[3] = relKind.getBytes(); // table type tracing it back it seems like this is because the switch statement above gives a result of 'v' which from reading the c