Annotation of FM2SQL/export/log.txt, revision 1.2
1.1 rogo 1: source
2: useMapper false
3: url jdbc:fmpro:http://pythia:8050
4: user rogo
5: password
6: number of tables 1
1.2 ! rogo 7: table false
1.1 rogo 8: select select * from "Zeitabrechnung-Einzelposten.fp5"
9: id was intid
10: Kunde, Taetigkeit, Betrag
11: jdbc:postgresql://foxridge/test
12: bin in synchronize!!!
13: url jdbc:fmpro:http://pythia:8050
14: odbc with properties inited
1.2 ! rogo 15: added layout select * from "Zeitabrechnung-Einzelposten.fp5" layout "Liste"
! 16: time to execute 225
1.1 rogo 17: url jdbc:postgresql://foxridge/test
1.2 ! rogo 18: new Query select * from "zeitabrechnung_einzelposten" layout "Liste"
! 19: subQuery layout "Liste"
! 20: time to execute 44
! 21: subQuery layout "Liste"
! 22: linesToAppend [1, 2, 3, 4, 6, 7, 8, 9] zeitabrechnung_einzelposten
1.1 rogo 23: linesToDelete [] zeitabrechnung_einzelposten
1.2 ! rogo 24: ID LIST SIZE 2 8
! 25: 1 3 9
! 26: select * from "Zeitabrechnung-Einzelposten.fp5" layout "Liste" where "intid">='1' and "intid"<='3'
! 27: time to execute 406
1.1 rogo 28: Date 20.05.2000
1.2 ! rogo 29: Rows 2 9
! 30: Time needed for query and data retrieval 680 ms
! 31: line true 1
! 32: line true 2
! 33: 3 6 9
! 34: select * from "Zeitabrechnung-Einzelposten.fp5" layout "Liste" where "intid">='3' and "intid"<='6'
! 35: time to execute 282
! 36: Rows 2 9
! 37: Time needed for query and data retrieval 298 ms
! 38: line true 3
! 39: line true 4
! 40: 6 8 9
! 41: select * from "Zeitabrechnung-Einzelposten.fp5" layout "Liste" where "intid">='6' and "intid"<='8'
! 42: time to execute 302
1.1 rogo 43: Date 22.10.2005
1.2 ! rogo 44: Rows 2 9
! 45: Time needed for query and data retrieval 314 ms
! 46: line true 6
! 47: line true 7
! 48: 6
! 49: last intervall from 8 9
! 50: select * from "Zeitabrechnung-Einzelposten.fp5" layout "Liste" where "intid">='8' and "intid"<='9'
! 51: time to execute 407
1.1 rogo 52: Date 20.05.2000
53: Date 20.05.2003
1.2 ! rogo 54: Rows 2 9
! 55: Time needed for query and data retrieval 427 ms
! 56: line true 8
! 57: line true 9
! 58: subQuery layout "Liste" where "intid">'9'
! 59: time to execute 364
! 60: subQuery layout "Liste"
1.1 rogo 61: found list Kunde, Taetigkeit, Betrag
1.2 ! rogo 62: Error while connecting to database java.lang.NullPointerException
! 63: java.lang.NullPointerException
! 64: at DBBean.getColumnType(DBBean.java:1585)
! 65: at Convert.synchronize(Convert.java:2182)
! 66: at Convert.parseXMLConfig(Convert.java:1313)
! 67: at Convert.readXMLFile(Convert.java:1572)
! 68: at Convert.main(Convert.java:111)
! 69: DBBean$ConnectionPool@105bd58
! 70: DBBean$ConnectionPool@1d1e730
1.1 rogo 71: Finished!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>