If you don’t, double check it is installed correctly. You should see that as a selectable option from the drop-down. In Servoy Developer, edit your DB connection settings, and change the Driver property from “.OpenEdgeDriver” to “.NoLockDriver”.Also make sure you have the official openedge.jar in that folder as well.In Servoy Developer, place both of those in your /application_server/drivers folder.The component includes the itech-openedge-nolock.jar driver and the config file, itech-openedge-nolock.properties.After purchase, we’ll send you the fully licensed component. After you sign up for the 30 day trial, you’ll receive an email from us with links to download your trial components. Since this component is a JDBC Driver, it is not part of the Components Installer (IT2BE Manager) like the rest of our components.I have the openedge.jar file already used and gone through and verified the date fields. exception.ComponentException: UNEXPECTED_EXCEPTION:Īt .CommonUtils.newComponentException(CommonUtils.java:583)Īt .(JDBCInputReader.java:241)Īt .(FlowVariablesReader.java:73)Īt local_project.customer_0_1.Customer.tDBInput_1Process(Customer.java:2418)Īt local_project.customer_0_1.nJobInTOS(Customer.java:3314)Īt local_project.customer_0_1.Customer.main(Customer.java:3163)Ĭaused by: .exception.ComponentException: UNEXPECTED_EXCEPTIONĪt .avro.JDBCAvroRegistry$14.convertToAvro(JDBCAvroRegistry.java:492)Īt .avro.JDBCAvroRegistry$14.convertToAvro(JDBCAvroRegistry.java:481)Īt .avro.JDBCResultSetIndexedRecordConverter$ResultSetIndexedRecord.(JDBCResultSetIndexedRecordConverter.java:104)Īt .(JDBCResultSetIndexedRecordConverter.java:82)Īt .(JDBCResultSetIndexedRecordConverter.java:23)Īt .(JDBCInputReader.java:250)Īt .(JDBCInputReader.java:237)Ĭaused by: : Unsupported data conversion.Īt .ddb9.b(Unknown Source)Īt .ddb9.a(Unknown Source)Īt .ddb8.b(Unknown Source)Īt .ddb8.a(Unknown Source)Īt .ddah.a(Unknown Source)Īt .dddm.getBytes(Unknown Source)Īt .avro.JDBCAvroRegistry$14.convertToAvro(JDBCAvroRegistry.java:486)

I have created a simple output just to view the data and am getting Unsupported Data Conversion Errors.Īnd this is the error: Exception in component tDBInput_1 (Customer) The issue I am currently having though is when I am trying to actually utilize the data. I have been able to get the datasources connected successfully and updated the queries so find all the tables. I have just started using Talend Open Studio to migrate data from multiple databases into a single warehouse.Ĭurrently working on migrating data from OpenEdge Progress to Postgres SQL.

Openedge jdbc