Re: [Babeldoc-devel] retrieving a document from the journal

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

I was struggling on a similar problem running the console for one hour
when I discovered that commons-dbcp and commons-pool are in
tomcat/commons/lib
So I MUST copy the mysql/oracle/... jar there as well.
Having them in babeldoc-console/web-inf/lib or in tomcat/shared/lib does
not help because of the hierarchies of classloaders in tomcat.

I am not sure it is linked to your problem but if you are inside a J2EE
server be aware of these stupidities (and it is a small word)

Cheers,

Vincent

> I am using oracle journal without problems. However, I haven't stored
> documents into journal so I guess you are right about missing statement.
> All my configuration for one project is stored in one folder. In that
> folder I have folders scanner, pipeline, journal, resource, env. I don't
> use BABELDOC_USER env property. Instead when I want to run some project
> (I always use scanners) I just run "babeldoc scanner" in that project's
> directory. Babeldoc will merge properties defined for that specific
> folder with its internal configuration. So
>
> 1. You don't need to use -d option when starting babeldoc for setting
> system properties. All these properties can be set as name=value pairs
> in folder env/config.properties. So, if you want to use Oracle first you
> should do is to put this line in env/config.properites.
>
> jdbc.drivers=oracle.jdbc.driver.OracleDriver
>
> If you want to use more than one database (for example MySQL and Oracle)
> you can set this:
> jdbc.drivers=oracle.jdbc.driver.OracleDriver:org.gjt.mm.mysql.Driver
>
> 2. You must have define database connection as resource. This is done by
> putting file conName.properties where conName is name of the connection.
> You can have define many different connections and each should be
> defined in separate file. Here is configuration for one of mine Oracle
> connections. The file name is resource/babel.properties:
>
> type=pooled
>
> dbUser=babel
> dbPassword=babel
> dbUrl=jdbc:oracle:thin:@10.2.16.10:1521:DAF1
>
> 3. By default Babeldoc use SimpleJournal. If you want to change this
> default you should change file journal/config.properties. This is the
> line that should exist here:
>
> journal=oracle
>
> 4. You need to tell Babeldoc which connection it should use for journal.
> Since oracle journal is subtype of sql journal, configuration is stored
> inside journal/sql/config.properties. This file should have following
> line:
>
> resourceName=babel
>
>
>
> This is all configuration you need to use oracle journal. I hope this
> will help. Note that you don't need to recompile Babeldoc. Every project
> can have different configuration. Just like you can have different
> scanner and pipeline configuration for every project.
>
> Dejan
>
> P.S.
>
> Stefan, if you have made Oracle journal document retreiving work, could
> you send us statement(s) you added in query.properties!
>
>
>
>
>
> ----- Original Message -----
> From: "Leech, Jonathan" <jl...@vi...>
> To: <bab...@li...>
> Sent: Thursday, June 26, 2003 12:09 AM
> Subject: RE: [Babeldoc-devel] retrieving a document from the journal
>
>
>> Stefan,
>>
>> I tried the system property approach
>> (-Djdbc.drivers=oracle.jdbc.driver.OracleDriver), on the command line
>> to babeldoc, but that didn't work.  Where did you add your JVM system
> property?
>>
>> -Jonathan
>>
>> -----Original Message-----
>> From: Stefan Krieger [mailto:ste...@co...]
>> Sent: Wednesday, June 25, 2003 4:55 PM
>> To: bab...@li...
>> Subject: Re: [Babeldoc-devel] retrieving a document from the journal
>>
>>
>> Jonathan,
>>
>> we had the same problems with the query.properties und driver.
>> Obviously, the property is missing.
>> A workmate added a statement, but I don't know which. I will post our
>> query.properties for Oracle tomorrow.
>>
>> We added the driver as system property to the JVM. Anyway, in
>> production
> we
>> will retrieve a preconfigured datastore from JNDI.
>>
>> Regards,
>> Stefan
>>
>> ----- Original Message -----
>> From: "Leech, Jonathan" <jl...@vi...>
>> To: <bab...@li...>
>> Sent: Wednesday, June 25, 2003 10:35 PM
>> Subject: RE: [Babeldoc-devel] retrieving a document from the journal
>>
>>
>> > Thanks Dejan,
>> > That makes sense and I found the spot in the userguide that says
>> that.
> I
>> > tested it out with the SimpleJournal and I can retrieve documents
>> just
>> fine.
>> >
>> > However, now I'm trying out the Oracle journal and I am having
>> problems.
>> It
>> > looks to me like the code in CVS isn't quite in sync with the
>> > query.properties in CVS, because the
>> journalSelectBlobForUpdate-oracle property doesn't exist in
>> query.properties, but OracleJournal.java needs
>> it.
>> > This causes a SQLException.  Can somebody tell me what the value
>> should
> be
>> > for this?
>> >
>> > I had another problem with OracleJournal that I got past, which was
>> a No Suitable driver exception.  I suspect whoever uses the
>> OracleJournal has
>> the
>> > code that fixes the problem and it just isn't checked in, or is
>> using babeldoc in an environment that registers the Oracle driver
>> for them.  I would be happy to check the code in, what do I need to
>> do to get CVS
>> commit
>> > access?  Here's the code I would add to OracleJournal.java:
>> >
>> > static {
>> >    try {
>> >       DriverManager.registerDriver(new
> oracle.jdbc.driver.OracleDriver());
>> >    }
>> >    catch (SQLException sqle) {
>> >       throw new RuntimeException(sqle);
>> >    }
>> > }
>> >
>> > Sincerely,
>> > Jonathan Leech
>> > Senior Software Engineer
>> > Virtela Communications, Inc.
>> >
>> > -----Original Message-----
>> > From: Dejan Krsmanovic [mailto:dej...@ya...]
>> > Sent: Wednesday, June 25, 2003 1:47 PM
>> > To: 'bab...@li...'
>> > Subject: Re: [Babeldoc-devel] retrieving a document from the journal
>> >
>> >
>> > By default document are NOT stored into jjournal
>> > because it is time-consuming operation. If you want to
>> > store document into journal, you should set tracked
>> > property to true (tracked=true) for pipeline stage in
>> > which you want to store document.
>> >
>> > Dejan
>> >
>> >
>> > --- "Leech, Jonathan" <jl...@vi...> wrote:
>> > > Hi,
>> > >
>> > > I am getting started with babeldoc and trying to
>> > > understand the journal
>> > > capabilities.  From what I've read in the
>> > > documentation, I should be able to
>> > > retrieve a document from the journal, and even
>> > > replay tickets etc.  However,
>> > > if I run the svg-transcode example, and then try
>> > > babeldoc journal -D
>> > > 1056495510901.2, I get a JornalException: No
>> > > document stored at (
>> > >
>> > com.babeldoc.core.journal.JournalTicket@763f5d[value=1056495510901],2
>> > >
>> >
>>
> <mailto:com.babeldoc.core.journal.JournalTicket@763f5d[value=1056495510901],
>> > > 2> ).  I added some debug code and rebuilt it, and
>> > > the cause is a
>> > > ClassCastException trying to cast a String into a
>> > > PipelineDocument.  I have
>> > > looked through the code to some extent, and I am
>> > > quite confused.  I am
>> > > getting the same problem in babeldoc-1.0.1 and the
>> > > current version I checked
>> > > out from CVS yesterday.  What am I doing wrong?
>> > >
>> > > Sincerely,
>> > > Jonathan Leech
>> > > Senior Software Engineer
>> > > Virtela Communications, Inc.
>> > >
>> >
>> >
>> > __________________________________
>> > Do you Yahoo!?
>> > SBC Yahoo! DSL - Now only $29.95 per month!
>> > http://sbc.yahoo.com
>> >
>> >
>> > -------------------------------------------------------
>> > This SF.Net email is sponsored by: INetU
>> > Attention Web Developers & Consultants: Become An INetU Hosting
>> Partner. Refer Dedicated Servers. We Manage Them. You Get 10%
>> Monthly Commission! INetU Dedicated Managed Hosting
>> http://www.inetu.net/partner/index.php
>> _______________________________________________
>> > Babeldoc-devel mailing list
>> > Bab...@li...
>> > https://lists.sourceforge.net/lists/listinfo/babeldoc-devel
>> >
>> >
>> > -------------------------------------------------------
>> > This SF.Net email is sponsored by: INetU
>> > Attention Web Developers & Consultants: Become An INetU Hosting
>> Partner. Refer Dedicated Servers. We Manage Them. You Get 10%
>> Monthly Commission! INetU Dedicated Managed Hosting
>> http://www.inetu.net/partner/index.php
>> _______________________________________________
>> > Babeldoc-devel mailing list
>> > Bab...@li...
>> > https://lists.sourceforge.net/lists/listinfo/babeldoc-devel
>> >
>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by: INetU
>> Attention Web Developers & Consultants: Become An INetU Hosting
>> Partner. Refer Dedicated Servers. We Manage Them. You Get 10% Monthly
>> Commission! INetU Dedicated Managed Hosting
>> http://www.inetu.net/partner/index.php
>> _______________________________________________
>> Babeldoc-devel mailing list
>> Bab...@li...
>> https://lists.sourceforge.net/lists/listinfo/babeldoc-devel
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by: INetU
>> Attention Web Developers & Consultants: Become An INetU Hosting
>> Partner. Refer Dedicated Servers. We Manage Them. You Get 10% Monthly
>> Commission! INetU Dedicated Managed Hosting
>> http://www.inetu.net/partner/index.php
>> _______________________________________________
>> Babeldoc-devel mailing list
>> Bab...@li...
>> https://lists.sourceforge.net/lists/listinfo/babeldoc-devel
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: INetU
> Attention Web Developers & Consultants: Become An INetU Hosting Partner.
> Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission!
> INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php
> _______________________________________________
> Babeldoc-devel mailing list
> Bab...@li...
> https://lists.sourceforge.net/lists/listinfo/babeldoc-devel