Hi
We are currently piloting using ofbiz as the back end to some of our
systems. One of these is a web site for an association. What we need
to do is to allow that web site to access the data in ofbiz. Not only
read, but also write new data to it. The web site is a java/jsp
application.
We have created the entities and services required in Ofbiz, and can get
access to the services. I have tried using the web service interface to
add data, and this works fine as long as I only use simple types such as
String (xsd:string). However, one of the things that we have is a date
field. We have set this up as a java.sql.Date as defined in the
'fieldtypemysql.xml' file. However, when sending this as soap ofbiz
thinks that the java.sql.Date is a java.util.Date, and so throws an
error. This is due to roundtripping issues.
We have then tried changing the type to java.util.Date in the entity and
fieldtype defs. This results in the web service working. However, then
when creating the entity through the ofbiz interface I get...
The Following Errors Occurred:
* Type conversion of field [dateSetup] to type [java.util.Date]
failed for value "2007-14-14": org.ofbiz.base.util.GeneralException:
Conversion from String to java.util.Date not currently supported
* Type conversion of field [dateSetup] to type [java.util.Date]
failed for value "2007-14-14": org.ofbiz.base.util.GeneralException:
Conversion from String to java.util.Date not currently supported
I'm also concerned with this approach as it is altering the core defs
and will break everything else!
Looking at other ofbiz services it uses java.sql.Timestamp objects for
the type. However, this will also not roundtrip, and comes back as a
Calendar object!
I have also tried to get the wsdl to use for services that use types
other than 'string', but an error is thrown saying that ofbiz cant
handle them!
So the question really is.... How do I set up the web service (ofbiz
and cremote client) to use the correct data type that will work to
create the date? There are a lot of examples I have found, but they
only deal with strings!
I have also tried RMI, but I could not get this to work from the remote
application.
If anyone has any information on how best to call an ofbiz service from
a remote application (including dates) then I would be most gratefull
Many thanks in advance
