I need a Java load program created which will read in a text file and load it into a Derby database.
The database table is as follows:
TableName: EWSTable
Date : format YYYY-MM-DD
Time : format [login to view URL]
Message ID: 8 Alphanumeric characters - fixed
Identifier: 40 characters
ThresholdType: 15 characters
Operator: 2 characters
ThresholdValue: long
LocalPort: integer
RemoteIP: 40 characters
RemoteIPOctet1: int
RemoteIPOctet2: int
RemoteIPOctet3: int
RemoteIPOctet4: int
RemotePort: integer
ExceededNumber: long
The format of the file is as follows:
2010-03-04 17:06:51.59 ITSWA201W? COMPANY 111? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? CON WINDOW? ? LT? ? ? ? ? 20000 01414:[login to view URL] C=0001
The fields are in fixed columns.
A sample load of the above would create:
Date : 2010-03-04
Time : 17:06:51.59
Message ID: ITSWA201W
Identifier: COMPANY 111
ThresholdType: CON WINDOW
Operator: LT
ThresholdValue: 20000
LocalPort: 1414
RemoteIP: 1.2.11.43
RemoteIPOctet1: 1
RemoteIPOctet2: 2
RemoteIPOctet3: 11
RemoteIPOctet4: 43
RemotePort: 63247
ExceededNumber: 1