|

»

»

java.net - Quartz

»

java.net - quartz users

Need to redefine BIGINT to INTEGER...

View: New views

4 Messages — Rating Filter: Alert me

	Need to redefine BIGINT to INTEGER... by seema-7 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message We're targeting DB2 on os/390 and the version of DB2 that they have does not support BIGINT column types- is it ok to re-define the columns as INTEGER (max value +/- 2,147,483,648) - what's the risk? Could someone please comment - Thanks, James --------------------------------------------------------------------- Posted via Jive Forums http://forums.opensymphony.com/thread.jspa?threadID=394801&messageID=481857#481857 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@...
	Re: Need to redefine BIGINT to INTEGER... by seema-7 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Can anyone comment, please ?! --------------------------------------------------------------------- Posted via Jive Forums http://forums.opensymphony.com/thread.jspa?threadID=394801&messageID=483670#483670 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@...
	Re: Need to redefine BIGINT to INTEGER... by seema-7 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Maybe a different question then: Would anyone comment/clarify on why the date/time related fields are implemented as large INTEGER values in the database (i.e. BIGINT) as opposed to more common TIMESTAMP types? I'm getting grilled on this and need some help here... --------------------------------------------------------------------- Posted via Jive Forums http://forums.opensymphony.com/thread.jspa?threadID=394801&messageID=483713#483713 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@...
	Re: Need to redefine BIGINT to INTEGER... by seema-7 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message The time stored as UNIX timestamp (sec. since 01.01.1970). May redefine the data type and write your own DriverDelegate. BUT: Modifications of quartz table structure are not supported. --------------------------------------------------------------------- Posted via Jive Forums http://forums.opensymphony.com/thread.jspa?threadID=394801&messageID=489002#489002 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@...

LightInTheBox - Buy quality products at wholesale price