From: Brian O'H. <boh...@re...> - 2003-12-11 22:06:50
|
How can I convert a Python time object to java.sql.Timestamp? Here's code I'm running w/in jython. >>> import time >>> from com.ris.build.model import Build >>> build = Build.create() >>> from com.ris.build.model import BuildExtent >>> buildExtent = BuildExtent() >>> from java.sql import DriverManager >>> from java.sql import Driver >>> driver = Driver.forName("org.postgresql.Driver").newInstance() >>> connection = DriverManager.getConnection("jdbc:postgresql://192.168.100.215:5432/ris", "ris", "ris") >>> buildExtent.useConnection(connection) >>> build.buildId(buildExtent.nextBuildId().value()) >>> buildStartTime = time.ctime(time.time()) >>> build.buildEnd(buildStartTime) Traceback (innermost last): File "<console>", line 1, in ? TypeError: buildEnd(): 1st arg can't be coerced to java.sql.Timestamp Ideas? Brian O'Halloran |
From: L. <fl...@op...> - 2003-12-12 08:11:03
|
Selon Brian O'Halloran <boh...@re...>: > > How can I convert a Python time object to java.sql.Timestamp? why don't you get time with a java Date object ? >>> from java.util import * >>> Timestamp(Date().getTime()) 2003-12-12 09:07:56.781 If you want to use time python function, you can have >>> (y,m,d,h,min,s,wd,yd,i)=time.localtime(time.time()) >>> Timestamp(y,m,d,h,min,s,0) 3904-01-12 09:10:24.0 >>> but this constructor is deprecated... > > Here's code I'm running w/in jython. > >>> import time > >>> from com.ris.build.model import Build > >>> build = Build.create() > >>> from com.ris.build.model import BuildExtent > >>> buildExtent = BuildExtent() > >>> from java.sql import DriverManager > >>> from java.sql import Driver > >>> driver = Driver.forName("org.postgresql.Driver").newInstance() > >>> connection = > DriverManager.getConnection("jdbc:postgresql://192.168.100.215:5432/ris", > "ris", "ris") > >>> buildExtent.useConnection(connection) > >>> build.buildId(buildExtent.nextBuildId().value()) > >>> buildStartTime = time.ctime(time.time()) > >>> build.buildEnd(buildStartTime) > Traceback (innermost last): > File "<console>", line 1, in ? > TypeError: buildEnd(): 1st arg can't be coerced to java.sql.Timestamp > Fred -- XPath free testing software : http://lantern.sourceforge.net Frédéric Laurent http://www.opikanoba.org |