java java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date. How to set zeroDateTimeBehavior=convertToNull

[japochino1]

Hello

My environment: Eclipse Indigo, Jboss AS 7, mysql-connector-java-5.1.17-bin.jar

I'm receiving this message:

java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date

I know this is because the mysql driver don't accept the '0000-00-00' as a null value and by defult it throws this exception. I have been investigating in the Internet and I found often the solution of adding to the connection url the following text: ?zeroDateTimeBehavior=convertToNull. For example, jdbc:mysql://localhost:3306/databasename?zeroDateTimeBehavior=convertToNull.

I tried to do this in the datasource configuration in the administrator area of jboss as7 but doesn't work. I think I can't configura that this way.

Where can I configure zeroDateTimeBehavior value to convertToNull?

Thanks

[sfcoy]

You should be able to add this as a connection property to your data source from the admin console.

[japochino1]

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

[sfcoy]

[japochino1]

I don't have those tabs in my admin console!

[sfcoy]

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.

[japochino1]

Stephen, I owe you a beer!

That´s right!

Thanks so much!