On Thu, 21 Nov 2002 02:19, Artur Filipiak wrote:
> hi,
> i'm trying to setup JDBC target for logkit using
> JDBCTargetFactory. according to excalibur logger
> doc api sample config could look like this:
>
>   <jdbc id="database">
>       <datasource>java:/LogTargetDataSource</datasource>
>       <normalized>true</normalized>
>       <table name="LOG">
>          <sequence>ID</sequence>
>           <category>CATEGORY</category>
>           <priority>PRIORITY</priority>
>           <message>MESSAGE</message>
>           <time>TIME</time>
>           <rtime>RTIME</rtime>
>           <throwable>THROWABLE</throwable>
>           <hostname>HOSTNAME</hostname>
>           <static aux="-">STATIC</static>
>           <context aux="principal">PRINCIPAL</context>
>           <context aux="ipaddress">IPADDRESS</context>
>           <context aux="username">USERNAME</context>
>       </table>
>   </jdbc>
>
>
> this factory uses avalon's logkit DefaultJDBCTarget/NormalizedJDBCTarget,
> but there's no option for column of type "sequence"! moreover, i still
> cannot
> determine how DefaultJDBCTarget calculates id for database row.
>
> any ideas?

It looks like the documentation is wrong. <sequence/> was unused in the code.

As to id. When people are setting up logging to a database they usually 
precreate the table that has the ID column of type sequence / autonumber / 
autoincrement (or whatever your database supports). So it usually doesn't 
appear in the configuration for the target.

-- 
Cheers,

Peter Donald
*-----------------------------------------------------*
* "Faced with the choice between changing one's mind, *
* and proving that there is no need to do so - almost *
* everyone gets busy on the proof."                   *
*              - John Kenneth Galbraith               *
*-----------------------------------------------------* 


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to