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.

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]