Chintan A. Shah

Greenhorn
+ Follow
since Apr 08, 2014
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Chintan A. Shah

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)
9 years ago
Ok sorry even this is solved.

I changed this


to




Sorry. All solved
9 years ago
Ok the console output is:


9 years ago
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
9 years ago
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
9 years ago



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.

where i am wrong?
9 years ago
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
9 years ago
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?
9 years ago