Re: Fw: Druid problems

Started by Bruce Momjianabout 25 years ago4 messagespatches
Jump to latest
#1Bruce Momjian
bruce@momjian.us

I have applied the following patch that fixes Druid to work with our
jdbc driver. Applied to jdbc1 and jdbc2.

This get's us past the first problem. I have emailed the author for any
other problems.

I also found on the sun site a test suite for 1.2 driver, and the j2see
driver. This will go a long ways to getting the driver solid.
Now the challenge will be getting the j2see stuff to work ;)

Dave

[ Attachment, skipping... ]

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Attachments:

/bjm/8text/plainDownload+2-2
#2Michael Stephenson
mstephenson@tirin.openworld.co.uk
In reply to: Bruce Momjian (#1)
getDate() and getTime() fails with columns of type 'TimeStamp'

In org.postgresql.jdbc2.ResultSet, both getDate() and getTime() fail on
columns of type 'timestamp', which is against the jdbc spec, patch below
fixes it.

Michael Stephenson mstephenson@openworld.co.uk
Developer - Web Applications - Open World
Tel: +44 1225 444 950 Fax: +44 1225 336 738

--- ResultSet.java.old	Wed May 30 16:32:48 2001
+++ ResultSet.java	Wed May 30 16:41:33 2001
@@ -423,6 +423,8 @@
     String s = getString(columnIndex);
     if(s==null)
       return null;
+    if (s.length() > 10)
+	return new java.sql.Date(getTimeStamp(columnIndex).getTime())

return java.sql.Date.valueOf(s);
}
@@ -441,6 +443,8 @@

     if(s==null)
       return null; // SQL NULL
+    if (s.length() > 8)
+	return new java.sql.Time(getTimeStamp(columnIndex).getTime());

return java.sql.Time.valueOf(s);
}

#3tony
tony@animaproductions.com
In reply to: Bruce Momjian (#1)

Thanks!

Now I'll have to dive into the config files again so that it will let me
connect...

Cheers

Tony

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html

#4Bruce Momjian
bruce@momjian.us
In reply to: Michael Stephenson (#2)
Re: getDate() and getTime() fails with columns of type 'TimeStamp'

I just applied this patch sent in by someone else to the current CVS
tree.

In org.postgresql.jdbc2.ResultSet, both getDate() and getTime() fail on
columns of type 'timestamp', which is against the jdbc spec, patch below
fixes it.

Michael Stephenson mstephenson@openworld.co.uk
Developer - Web Applications - Open World
Tel: +44 1225 444 950 Fax: +44 1225 336 738

--- ResultSet.java.old	Wed May 30 16:32:48 2001
+++ ResultSet.java	Wed May 30 16:41:33 2001
@@ -423,6 +423,8 @@
String s = getString(columnIndex);
if(s==null)
return null;
+    if (s.length() > 10)
+	return new java.sql.Date(getTimeStamp(columnIndex).getTime())

return java.sql.Date.valueOf(s);
}
@@ -441,6 +443,8 @@

if(s==null)
return null; // SQL NULL
+    if (s.length() > 8)
+	return new java.sql.Time(getTimeStamp(columnIndex).getTime());

return java.sql.Time.valueOf(s);
}

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Attachments:

/bjm/difftext/plainDownload+14-4