This content has been marked as final.
Show 6 replies
-
1. Re: java java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date. How to set zeroDateTimeBehavior=convertToNull
sfcoy Mar 26, 2012 9:18 PM (in response to japochino1)You should be able to add this as a connection property to your data source from the admin console.
-
2. Re: java java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date. How to set zeroDateTimeBehavior=convertToNull
japochino1 Mar 27, 2012 4:15 AM (in response to sfcoy)Yes I hoped so but in the admin console I don't see nothing about it in Connector > Datasources.
When I am in this section I select my datasource but in the Attributes tab I don't know the way to do this. I think it has to be in other location, but where?
Thanks
-
5. Re: java java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date. How to set zeroDateTimeBehavior=convertToNull
sfcoy Mar 28, 2012 4:24 AM (in response to japochino1)My apologies. I was assuming JBoss 7.1.1.
Try adding:
{code:xml}
<datasource>
...
<connection-property name="zeroDateTimeBehavior">convertToNull</connection-property>
</datasource>
{code}
to your standalone.xml file.
-
6. Re: java java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date. How to set zeroDateTimeBehavior=convertToNull
japochino1 Mar 28, 2012 5:58 AM (in response to sfcoy)Stephen, I owe you a beer!
That´s right!
Thanks so much!