Talend community forum / [resolved] Bad format for number tmysqlInput.

baddy_sik · 2012-05-24 11:53:09

Hi folks,

I am trying to run a query in tmysqlInput which pulls a field OracleID from DB .
Sample value for OracleID- 250000736H.00.09

It throws an error - "Bad format for number '250000736H.00.09' in column 45" when I run the job.

Field type in DB- varchar
Field type in talend schema- String.

P.S the query runs fine in the MySQL client but throws the error when run in talend.

Any suggestions??

Thanks in adv,
Baddy

Last edited by baddy_sik (2012-05-24 11:54:11)

pedro · 2012-05-24 11:59:16

Hi Baddy

Are you sure the data type of this column is String(varchar)?
Please paste the entire error log.

Regards,
Pedro

baddy_sik · 2012-05-24 12:01:39

Hey Pedro ,

here you go.

Exception in component tMysqlInput_5
java.sql.SQLException: Bad format for number '250000736H.00.09' in column 45.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
at com.mysql.jdbc.ResultSetImpl.getDoubleInternal(ResultSetImpl.java:2522)
at com.mysql.jdbc.ResultSetImpl.getDoubleInternal(ResultSetImpl.java:2461)
at com.mysql.jdbc.ResultSetImpl.getDouble(ResultSetImpl.java:2422)
at entf.webdb_bhe_orders_feed_0_1.WebDB_BHE_Orders_Feed.tMysqlInput_2Process(WebDB_BHE_Orders_Feed.java:6682)
at entf.webdb_bhe_orders_feed_0_1.WebDB_BHE_Orders_Feed.runJobInTOS(WebDB_BHE_Orders_Feed.java:12360)
at entf.webdb_bhe_orders_feed_0_1.WebDB_BHE_Orders_Feed.main(WebDB_BHE_Orders_Feed.java:12164)
2012-05-24 15:19:03|VIUYlA|VIUYlA|VIUYlA|ENTF|WebDB_BHE_Orders_Feed|DEV|6|Java Exception|tMysqlInput_5|java.sql.SQLException:Bad format for number '250000736H.00.09' in column 45.|1
2012-05-24 15:19:10|VIUYlA|VIUYlA|VIUYlA|3972|ENTF|WebDB_BHE_Orders_Feed|_YnQssJofEeGSCfB9ZSjSYg|0.1|DEV||end|success|18438
[statistics] disconnected

baddy_sik · 2012-05-24 12:17:37

Hi Pedro,

Waiting for your suggestion! Kinda urgent!

thanks,
Baddy

janhess · 2012-05-24 12:28:16

Can you post an image of your schema.

baddy_sik · 2012-05-24 12:33:03

Hi Janhess,

Here is the tmysqlinput schema.

The last row is the OracleID field which is errorneous!

Uploaded Images

Last edited by baddy_sik (2012-05-24 12:34:24)

janhess · 2012-05-24 12:37:13

Are you sure your schema matches your query? Did you create it using guess schema?

baddy_sik · 2012-05-24 12:38:59

No I wrote the query manually and tested on the MySQL client.
Also, if I give '000000000000000' as the default value in query to OracleID field , it runs fine.

janhess · 2012-05-24 12:41:58

I don't think your schema matches the query. I think the data is mapping to one of the doubles. Thr selecting guess query. It should work then.

baddy_sik · 2012-05-24 12:46:38

Thanks Janhess,

I rechecked the query . It missed one one column and hence was not matching the query,

Thanks for your help. You guys rock!

Announcement

Unanswered posts

#1 2012-05-24 11:53:09

[resolved] Bad format for number tmysqlInput.

#2 2012-05-24 11:59:16

Re: [resolved] Bad format for number tmysqlInput.

#3 2012-05-24 12:01:39

Re: [resolved] Bad format for number tmysqlInput.

#4 2012-05-24 12:17:37

Re: [resolved] Bad format for number tmysqlInput.

#5 2012-05-24 12:28:16

Re: [resolved] Bad format for number tmysqlInput.

#6 2012-05-24 12:33:03

Re: [resolved] Bad format for number tmysqlInput.

#7 2012-05-24 12:37:13

Re: [resolved] Bad format for number tmysqlInput.

#8 2012-05-24 12:38:59

Re: [resolved] Bad format for number tmysqlInput.

#9 2012-05-24 12:41:58

Re: [resolved] Bad format for number tmysqlInput.

#10 2012-05-24 12:46:38

Re: [resolved] Bad format for number tmysqlInput.

Board footer