You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Enterprise Data Integration » General questions
- » problem with load data from ms access
#1 2010-04-04 00:24:57
- luis
- Guest
problem with load data from ms access
hello friends, I tell you that I get the following error when I want to sample input data from MS Access, we detail below the code.
Note: the connection is OK, because when you run queries or data rescue me
best regards from Chile.
Starting job DataMet_CMCC at 19:21 03/04/2010.
[statistics] connecting to socket on port 3473
[statistics] connected
Exception in component tAccessInput_1
java.sql.SQLException: No data found
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataStringTimestamp(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataStringTimestamp(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getTimestamp(Unknown Source)
at datamet_cmcc.datamet_cmcc_0_1.DataMet_CMCC.tAccessInput_1Process(DataMet_CMCC.java:593)
at datamet_cmcc.datamet_cmcc_0_1.DataMet_CMCC.runJobInTOS(DataMet_CMCC.java:999)
357 milliseconds
[statistics] disconnected
at datamet_cmcc.datamet_cmcc_0_1.DataMet_CMCC.main(DataMet_CMCC.java:874)
Job DataMet_CMCC ended at 19:21 03/04/2010. [exit code=1]
#2 2010-04-05 12:26:24
- veronica.vnukova
- New member
- Company: BI Consulting
- Registered: 2010-03-30
- Posts: 2
Re: problem with load data from ms access
Does some other application work with your database in the same time? Or may be your database is opened in MS Access?
Offline
#3 2010-04-05 14:26:48
- Luis
- Guest
Re: problem with load data from ms access
veronica.vnukova wrote:
Does some other application work with your database in the same time? Or may be your database is opened in MS Access?
Dear Veronica,
This problem this OK, the problem was generated for shemas.
Taking this instance, I would like to ask you if you know a method for transforming columns to rows, I have read other post about this, but I find none = (.
I have this
tag | val
------------
0 | 200
1 | 300
2 | 400
3 | 500
4 | 600
I want this:
0 | 1 | 2 | 3 | 4
-------------------------------
200 | 300 | 400 | 500 | 600
Please your help would be greatly appreciated.
#4 2010-04-05 14:26:49
- Luis
- Guest
Re: problem with load data from ms access
veronica.vnukova wrote:
Does some other application work with your database in the same time? Or may be your database is opened in MS Access?
Dear Veronica,
This problem this OK, the problem was generated for shemas.
Taking this instance, I would like to ask you if you know a method for transforming columns to rows, I have read other post about this, but I find none = (.
I have this
tag | val
------------
0 | 200
1 | 300
2 | 400
3 | 500
4 | 600
I want this:
0 | 1 | 2 | 3 | 4
-------------------------------
200 | 300 | 400 | 500 | 600
Please your help would be greatly appreciated.
Pages: 1
- Index
- » Talend Enterprise Data Integration » General questions
- » problem with load data from ms access