I don't know if the use of a DATALINK data type would be relevant in your case. Here are some references. http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/start/c0005450.htm http://www.oracle.com/technology/sample_code/tech/java/codesnippet/jdbc/datalink/readme.html
On 9/9/06, Néstor Boscán <[EMAIL PROTECTED]> wrote:
Tomi thanks for your thoughts. I'm new to Lucene, so coming from an Oracle background my mind is set that everything goes inside the database. Now that I know some of the loses I can have a better picture. Regards, Néstor Boscán -----Mensaje original----- De: Tomi NA [mailto:[EMAIL PROTECTED] Enviado el: Viernes, 08 de Septiembre de 2006 05:21 p.m. Para: java-user@lucene.apache.org Asunto: Re: Using Hibernate to store Lucene Indexes in a Database On 9/8/06, Néstor Boscán <[EMAIL PROTECTED]> wrote: > To reduce administration tasks. If you want to move your application from > server to server you'll have to move the index files. I want to be able to > move my application by just moving my database schema and deploying an ear. > > Regards, > > Néstor Boscán Funny, I felt the same way about file-based storage: you simply pack it up using any of the numerous file transfer tools available and you don't have to worry about any of the database issues (possible uncompressed large dump over the network, is the database server running etc.). On the other hand, if your application utilizes a database anyway, it might be doable, assuming the app can take the performance penalty. I'd be hard pressed to come up with a scenario where the gains (simpler backup) would outweigh the losses (having to learn to store the index into the database, performance, database bloat), though. Still, it might only be my lack of imagination, that's the problem. :) t.n.a. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]