[newbie] Configure Simple Sql Resource.

[Epo Jemba]

Hi I am very new to babeldoc, I find the product very very usefull for my case.

Sorry if my question looks trivial !

I looked in all documents (userguide, whitepage, etc) in order to configure a sql resource but I do not understand how. What I get is :

- "The resources are defined in the config/resource/config.xml" :  I do not see a sample of config.xml.

- "Each of the named resources are defined in the config/resources as resource-name.properties". Where does that files might be located.

Again sorry if that is simple but what I want to do is :
1 . define a simple sql resource to define an oracle connection
2 . make a simple pipeline SqlWriter

I missed something in the step 1. can you help me :)

Thanks in advance :>

[Martin Logan]

Basically the named directories drive this.

So, pipeline configuration lives under pipeline directory, resources live under the resource directory.

Under my resource directory I have a file jdbc.properties for connecting to my Oracle DB which looks as follows:

type=jdbc
dbUser={User name}
dbPassword={Password}
dbDriver=oracle.jdbc.driver.OracleDriver
dbUrl=jdbc:oracle:thin:@tnsname:1521:instancename

My pipeline refers to this as follows:

# Write SQL
emptyLoadDb.stageType=SqlWriter
emptyLoadDb.nextStage=createSQL
emptyLoadDb.resourceName=jdbc
emptyLoadDb.sql=delete from load_emp;

[Epo Jemba]

Thank you Martin for your precision

I'll test on monday, where I have my environment.