You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Component creation
- » Creating Access DB's from an Oracle Select
#1 2009-04-10 00:31:42
- Cindy
- Guest
Creating Access DB's from an Oracle Select
I am trying to learn what compents I need to use to create an Access DB and Table from an Oracle select. It seems that I have to pre-define the Access DB but ultimate I would like to create it Dynamically. Even with pre-defining the DB I still can not get the data to insert into a table. I have tried using Tmaps but with or without it does not work. Can anyone tell me what I am doing wrong and what the next step would be to dynamically to create it on the fly?
I have tried both the following but wind up with the same errors:
tOracleInput ==> tAccessOutput
tOracleInput ==> tMap ==> tAccessOutput
Starting job Select_from_RSD at 18:03 09/04/2009.
[statistics] connecting to socket on port 3530
[statistics] connected
Exception in component tAccessOutput_1
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLBindInParameterBigint(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setLong(Unknown Source)
at Cindy.select_from_rsd_0_1.Select_from_RSD.tOracleInput_1Process(Select_from_RSD.java:598)
at Cindy.select_from_rsd_0_1.Select_from_RSD.runJobInTOS(Select_from_RSD.java:813)
at Cindy.select_from_rsd_0_1.Select_from_RSD.main(Select_from_RSD.java:715)
[statistics] disconnected
Job Select_from_RSD ended at 18:03 09/04/2009. [exit code=1]
#3 2009-04-17 10:44:56
Re: Creating Access DB's from an Oracle Select
Hello
There was a [Bugtracker, bug 6927, fixed] tAccessInput can't support Access 2003 driver. when you connect to access 2003.
Best regards
shong
Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!
Offline
#4 2010-01-29 15:26:45
- Tom
- Guest
Re: Creating Access DB's from an Oracle Select
What are you trying to say, shong? That there's a bug? That there was a bug? Does the tAccessOutput component work or not?
#5 2010-01-29 16:26:04
Re: Creating Access DB's from an Oracle Select
Hello
Does the tAccessOutput component work or not?
There was a bug on tAccessInput component, but it have been fixed, Both tAccessInput and tAccessOutput works fine now.
Best regards
shong
Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!
Offline
#6 2010-07-22 12:42:23
- Marc_neuilly
- Guest
Re: Creating Access DB's from an Oracle Select
same problem:
Exception in component tAccessOutput_1
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLBindInParameterBigint(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setLong(Unknown Source)
at startdw.dayly_0_1.dayly.tOracleInput_1Process(dayly.java:827)
at startdw.dayly_0_1.dayly.runJobInTOS(dayly.java:1101)
I guess ther is something missing regarding ODBC access driver but can't figure what.
#7 2010-08-06 05:12:54
- thurka
- Guest
Re: Creating Access DB's from an Oracle Select
hi dear all what mean buy this error,when i create job using infobrigthoutput_1 its show this error,
Exception in component tInfobrightOutput_1
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Too many key parts specified; max 0 parts allowed
#8 2010-08-06 06:39:55
- thurka
- Guest
Re: Creating Access DB's from an Oracle Select
hi dear frens can any body explain me y this error,.......asap
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Too many key parts specified; max 0 parts allowed
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
at com.mysql.jdbc.Util.getInstance(Util.java:336)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1031)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2938)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1601)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1710)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2430)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2359)
at com.mysql.jdbc.Statement.execute(Statement.java:719)
at talenddemosjava.ptruser_role_ref_0_1.ptruser_role_ref.tOracleInput_1Process(ptruser_role_ref.java:968)
at talenddemosjava.ptruser_role_ref_0_1.ptruser_role_ref.runJobInTOS(ptruser_role_ref.java:4199)
at talenddemosjava.ptruser_role_ref_0_1.ptruser_role_ref.main(ptruser_role_ref.java:3993)
2010-06-06 12:38:11|D1iCzf|D1iCzf|D1iCzf|TALENDDEMOSJAVA|ptruser_role_ref|Default|6|Java Exception|tInfobrightOutput_1|com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:Too many key parts specified; max 0 parts allowed|1
2010-06-06 12:38:11|D1iCzf|D1iCzf|D1iCzf|23466|TALENDDEMOSJAVA|ptruser_role_ref|_beTfwKEXEd-3YtBOLZz-pw|0.1|Default||end|failure|262
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Component creation
- » Creating Access DB's from an Oracle Select