for the g.fillRect(int x,int y, int width, height); method
g.fillRect(50,50,80,70);
the height is 70 right? so the bottom left co-ordinate should be 50,120 right?
apparently the bottom y-co-ordinate is 80 and not 120, could someone explain it to me? (I get 80 as a value because a rectangle is properly placed when I draw another rectangle on top of this rectangle)
It is outside the program, the error (in one of the imported packages) but when i comment the last (//after) part it works. So definitely something in the last part of the code, I don't understand what though
Hey I got my mistake. In the last fragment i was using while(rs.next()) where it should have been (Ars.next());
after changing that I am getting this error:
Exception in thread "AWT-EventQueue-0" java.lang.ArrayIndexOutOfBoundsException: 0 >= 0
here i am using 2 jtables and the first one gets populated from the db table but the second one does not. it gives this error : com.microsoft.sqlserver.jdbc.SQLServerException: The result set is closed.
Thanks everyone for your replies. I have started the prject. I am taking input from 1 ms sql server DB, 1 MS access DB and 1 excel file. I need to have 3 buttons on my GUI - Extract, Transform and Load.
Now when I click on extract, I need to populate a jtable from all the 3 sources (I am able to extract each source individually onto the jtable- how to extract them simultaneously is where I am stuck at). When I click on transform on it should clean this intermediate data of nulls and duplicates. When I click on load, it should load it onto a new database
hey guys, I have to make an ETL mini project for my data warehousing course. It is very simple as such, however I do not know where to start.
What I have to do is take 3 different data sources, and combine them into one, cleaning them of all duplicates and adding defaults and then inserting this into one database.
However, I do not know from where to start. If someone can guide me on that?