Selon Brian O'Halloran <bohalloran@...>:
>
> 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
|