<div>
The problem with AlarmOptons is that it is more than a data change; the appointment document also needs to move into a hidden ($Alarms) folder, or the Notes client will not process the alarm. &nbsp;So you can set the alarm data all you want, but it will be useless without this additional change.<br />
<br />
So, what to do? &nbsp;Don't use JDBC. &nbsp;Use the Domino Object Model, which is available to Java. &nbsp;On a Notes workstation, it uses, I think, NCSO.jar, as a JNI implementation. &nbsp;If Notes is not installed on teh workstation, you would need to remote a call to a Domino server to do this, via IIOP/CORBA. &nbsp;(The JDBC driver requires a local Notes workstation, so this should not be an issue for you.)<br />
<br />

</div>


The problem with AlarmOptons is that it is more than a data change; the appointment document also needs to move into a hidden ($Alarms) folder, or the Notes client will not process the alarm.  So you can set the alarm data all you want, but it will be useless without this additional change.

So, what to do?  Don't use JDBC.  Use the Domino Object Model, which is available to Java.  On a Notes workstation, it uses, I think, NCSO.jar, as a JNI implementation.  If Notes is not installed on teh workstation, you would need to remote a call to a Domino server to do this, via IIOP/CORBA.  (The JDBC driver requires a local Notes workstation, so this should not be an issue for you.)



<div>
Thanks qwaletee,<br />
I used the remote calls via Corba and it worked fine (you helped with VB Samples).<br />
But what I need is a solution without starting a Corba-process on the Domino Server.<br />
I have a standalone Java-app and Notes installed on the workstation.<br />
Thanks in advance.
</div>


Thanks qwaletee,
I used the remote calls via Corba and it worked fine (you helped with VB Samples).
But what I need is a solution without starting a Corba-process on the Domino Server.
I have a standalone Java-app and Notes installed on the workstation.
Thanks in advance.

<div>
<div class="content wysiwyg-content">
Hi,<br />
i´m trying to insert an appointment (type 4) and alarm into the maildb via jdbc.<br />
I don´t know how to insert the alarmoptions.<br />
Any help ?<br />
Thanks
</div>
</div>


Hi,
i´m trying to insert an appointment (type 4) and alarm into the maildb via jdbc.
I don´t know how to insert the alarmoptions.
Any help ?
Thanks

Lotus Reminder via SQL

Lotus Software produced the Lotus 1-2-3 spreadsheet program, and later developed Lotus Notes, a groupware and email system. Following its acquisition by IBM, the Notes and Domino client/server collaborative platform were expanded to include functions such as email, calendars, to-do lists, contacts management, teamrooms, discussion forums, file sharing, microblogging, instant messaging, blogs, and user directories. IBM also release SmartSuite, a comprehensive office suite, and followed that with Symphony, unrelated to the Lotus suite of the same name.