Insert date into MS Access DB

Q&A
1

Hi,

I am new to Bonita Soft and using BonitaSoft 5.8 .
I am creating a web form to get some user data and store it in MS access DB using a connector.

I am able to save the text or numerical type data into database. But I am unable to store a DOB of user (Date/Time type defined in MS access DB) . Below is the query that I am using while configuring the MS access connector.
INSERT INTO User (firstName, lastName, sex, dob) VALUES (‘${firstName}’, ‘${lastName}’, ‘${sex}’, ‘${dob}’);

I am getting below error for date field:
SEVERE: Exception caught while executing connector (instance=TestProcess1–1.0–1, process=TestProcess1–1.0, activityId=User_Input) : org.bonitasoft.connectors.database.access.AccessConnector - Exception : [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

Please help me to resolve this issue.

–
Thanks,
Kunal

2

Your date format is probably wrong…

Bonita dates are JAVA dates not MS Access dates so

try doing

INSERT INTO User (firstName, lastName, sex, dob) VALUES (‘${firstName}’, ‘${lastName}’, ‘${sex}’, ‘2015-01-01 10:15’);

first and if this works, then modify dob to be a string value… and try like above…

regards
Seán

3

Hi Sean,

Thanks for the hint. While testing the connector, I used the string as a date and that was working.
Now, I am converting my date to string format and then use in SQL statement and its working.

–
Regards,
Kunal

4

Hi kwatkar,

I saw you could save the text or numerical type data into database and that’s part of what I’m looking for.
Would you help me?

http://community.ofelia.com/questions-and-answers/how-can-i-develop-meeting-room-schedule-software-application

Thank you for considering, Sergio.