Date calculation

[Anonymous]

Hello Community,

I want to produce an etl process for sales. I have Input asc file with Informations, one of them must be calculated. In Pentaho we had used the Calculator for it, I think in Talend Studio the right transformer is tjavarow. In the asc. file date is in this form (string) 19990816. With this Information I want to calculate quarter, month and year. After this procedure I Need a combination lookup and at last the Information should be written in an Oracle table. Is all them possible in Talend Studio. I'm trying since days and reading in different Forums, but don't find any Option.

Thank you.

[Anonymous]

Hi "Detail Message: Type mismatch: cannot convert from int to String"

Type mismatch from input table to output table on tMap, please show us a screenshot of tMap.

"(Detail Message: oracle.jdbc cannot be resolved to a type"

You don't need put manually driver jar file to lib folder. You should be asked to download and install it in studio for the first time you use oracle components. Are you able to extract data from oracle table with a simple job, such as

tOracleInput--main--tLogRow

If you still have this error, let me know which version of studio are you using.

Regards

Shong

[Anonymous]

I have installed all requiremend plug-ins, but get this error. After I read in forums, that I should use version 6 of jdbc and put it myself in te folder. But it doesn't work. I have installed the latest version 6.3.1. I've tried it wirh tLog and have an error.

[Anonymous]

What is your Oracle version? You should install the corresponding driver for your DB version.

[Anonymous]

I have installed all versions of oracle, my db version is 11, don't we have a workarround for this?

[Anonymous]

For Oracle 11, you should install driver ojdbc6.jar, open the Module view (if it does not exist, go to Windows-->Show view and open it) and check if the required jar is installed correctly, see below

If you still have the error even the jar is installed well, please export the job items and upload it. I guess it might be a design issue in your job?

Regards

Shong

[Anonymous]

Hello, I've checked it, not any module is shown on this view and if I click on Install additional packages, no required plug-in is shown. 

[Anonymous]

Hi
The Module view lists all of the required jars information, you can install the required jars from the Module view, there are two buttons on the upper right corner:
1. Import external jar: install the jar files from local machine.
2. Download external jar: download and install jar file from internet, make sure your network is available.

Do you meant the module view is blank? It sounds like there is a problem with the studio installation. Can you please give us some information about your studio environment? Such as:
OS
32bit or 64bit?
JDK version
Studio installation path

Regards
Shong

[Anonymous]

Hello,

I will try to reinstall everything new. I'll install it on Partition C, Java Version installed is 1.8. Yes, it was blank no modules were listed. I will write a new response after reinstalling and testing it. Thanks for your help again. 

Update: I've tried it and get the same message: 

Job compile errors
At least job "Copy_of_Umsatz_test" has a compile errors, please fix and export again.
Error Line: 3333
Detail Message: oracle.jdbc cannot be resolved to a type
There may be some other errors caused by JVM compatibility. Make sure your JVM setup is similar to the studio.
tMap2

The Screenshoot are the values in my tMap2 for lookup with tOracleOutput.

For tOracleInput I have my Db connection as metadata and test it before. Do I make something false ?

[Anonymous]

Is the Module view still blank after you reinstall studio? Maybe you need to close and open it again. Do you see the required ojdbc6 jar is installed? Can you please upload a screenshot of job design?

[Anonymous]

Hello,

I think I have fixed the problem i've deinstalled it two times with the plugins. I think an important plug-in was missed and the process failed. I don't use "Accept all and install" button for some plug-ins I choose only "download install". I can't check the oracleoutput, because I don't want to delete my db, if something goes bad, but I have tried it with mysql and it was okey. If something goes fail with oracle I will write back. Thanks you all for your help.