Hi,
I want run talend batch file from asp .net to store data in DB. It shows an exception like this below ..
can anyone help how to resolve this??
Exception in component tDBOutput_1
java.sql.SQLException: Data source name not fou
nd and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at talenddemosjava.store2res_1_0_1.Store2Res_1.tFileInputDelimited_1Proc
ess(Store2Res_1.java:15960)
at talenddemosjava.store2res_1_0_1.Store2Res_1.runJobInTOS(Store2Res_1.j
ava:17588)
at talenddemosjava.store2res_1_0_1.Store2Res_1.runJob(Store2Res_1.java:1
7495)
at talenddemosjava.combinedoasisc_0_1.CombinedOasisC.tRunJob_2Process(Co
mbinedOasisC.java:534)
at talenddemosjava.combinedoasisc_0_1.CombinedOasisC.tRunJob_4Process(Co
mbinedOasisC.java:460)
at talenddemosjava.combinedoasisc_0_1.CombinedOasisC.tRunJob_1Process(Co
mbinedOasisC.java:334)
at talenddemosjava.combinedoasisc_0_1.CombinedOasisC.runJobInTOS(Combine
dOasisC.java:847)
at talenddemosjava.combinedoasisc_0_1.CombinedOasisC.main(CombinedOasisC
.java:747)
Exception in component tRunJob_2
java.lang.RuntimeException: Child job running failed
at talenddemosjava.combinedoasisc_0_1.CombinedOasisC.tRunJob_2Process(Co
mbinedOasisC.java:554)
at talenddemosjava.combinedoasisc_0_1.CombinedOasisC.tRunJob_4Process(Co
mbinedOasisC.java:460)
at talenddemosjava.combinedoasisc_0_1.CombinedOasisC.tRunJob_1Process(Co
mbinedOasisC.java:334)
at talenddemosjava.combinedoasisc_0_1.CombinedOasisC.runJobInTOS(Combine
dOasisC.java:847)
at talenddemosjava.combinedoasisc_0_1.CombinedOasisC.main(CombinedOasisC
.java:747)
I created dsn also.
Thanks in Advance.
