leeoo / hisql Goto Github PK

What steps will reproduce the problem?
1. MySQL5.1 -> Postgres 9.1
2. MySQL table having tinyInt as column type
3. transfer to postgres

What is the expected output? What do you see instead?
tinyInt should be modified to smallInt will be good

java.lang.Exception: org.postgresql.util.PSQLException: ERROR: type "tinyint" 
does not exist
  Position: 300
    at com.sql9.db.DBConnection._$1(Unknown Source:112)
    at com.sql9.db.DBConnection.importTo(Unknown Source:353)
    at com.sql9.db.CommonDB.importDataToTargetDB(Unknown Source:221)
    at com.sql9.jmetl.IIlIllIlIlIIIllI.run(Unknown Source:45)
    at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
Caused by: org.postgresql.util.PSQLException: ERROR: type "tinyint" does not 
exist
  Position: 300
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:302)
    at com.sql9.db.DBConnection._$1(Unknown Source:109)
    ... 11 more




What version of the product are you using? On what operating system?
1.0.6 on Windows 7

Please provide any additional information below.

"Test Connect" doesn't sound right. It's better to translate it as "Test 
Connection". This is what other DB applications use.

What steps will reproduce the problem?

1. When JMyETL is started, choose "Help" -> "About". You can see JMyETL version 
number is "1.0.". It should be something like "1.0.6".

Using JMyETL v1.0.6 on JDK 7u7 x86.

What steps will reproduce the problem?
1. Start JMyETL.
2. Enter SourceDB info, then press "Tab" key. The focus will go to "Username" 
field. But the field won't empty. "{UserName}" value will still be there. Same 
with "password" field.

1. When "Tab" is pressed, the corresponding field should become empty.

2. Also, if focus is removed and if the field is empty, the placeholder value 
such as "{UserName}" should be placed again.

3. If no value is entered and the existing placeholders are present, and user 
clicks on "Test Connection" button, username and password values that are 
passed to the JDBC driver should be empty values, NOT those placeholder values.

Using JMyETL v1.0.6.

I've downloaded JMyETL 1.0.5 and using it on Windows 7 x64, JDK 7u7 x86 with 
the following config:

main.class=com.sql9.jmetl.MainFrame
classpath.1=*.jar;.
splash.image=SplashScreen.bmp
vm.location=c:\Program Files (x86)\Java\jdk1.7.0_07\jre\bin\server\jvm.dll
vmarg.1=-Xms64M
vmarg.2=-Xmx512M

1. I followed this tutorial at 
http://www.cubrid.org/wiki_apps/entry/jmyetl-cubrid-tutorial.
2. Successfully connected to CUBRID *demodb* database as source and Mysql 
database as target.
3. When I choose *athlete* table and press on *Start Import* button, JMyETL 
correctly creates the same table in MySQL, and imports all 6667 rows of data. I 
checked in MySQL, and everything is correct.
4. But the problem is that JMyETL is not responding any more. Even I can't 
close the window.

I expect it to be functional even after the data has been exported.

What steps will reproduce the problem?

1. Successfully connected to CUBRID *demodb* database as source and Mysql 
database as target.
2. When I choose *athlete* table and press on *Start Import* button, JMyETL 
correctly creates the same table in MySQL, and imports all 6677 rows of data. 
But in targetDB schema PK is not set.

SourceDB schema with primary key:

CREATE TABLE "athlete"(
"code" integer AUTO_INCREMENT(16693,1),
"name" character varying(40) NOT NULL,
"gender" character(1),
"nation_code" character(3),
"event" character varying(30),
CONSTRAINT pk_athlete_code PRIMARY KEY("code")
);

TargetDB schema without primary key:

CREATE TABLE `athlete` (
  `code` int(11) NOT NULL,
  `name` varchar(40) NOT NULL,
  `gender` char(1) DEFAULT NULL,
  `nation_code` char(3) DEFAULT NULL,
  `event` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8$$

Using JMyETL 1.0.6, JDK 7u7 x86.