bonsanto/db-component

A component to connect to any data base using web services.

db-component's Issues

Test the performance

Make all the load tests for the app, drawing graphics and tables.

Add DataSet class

Incorporate DataTable class to the project to simulate the manipulation of the ResultSet by the WS client.

Handle port bind exception

Add a way to handle the exception showed in the case the port is already in use.

Add connections.xml

Connections.xml stores all the connections with the information related to that.

Handle StringIndexOutOfBoundsException in JSON

Actually there are some cases when the JSON class crashes

Create a better testing client

Create a better and more interactive testing client to make different evaluations to the app.

Write a better README.MD

Write a better README.MD, including the way how it works and other stuff.

Add IOException in the client

Add a IOException for the client, to handle the exceptions trowed by the server.

Fix the Log name maker

There is a problem where the .csv file gets an incorrect number for the month.

Improve the performance of CSVWriter

Improve the performance of the CSVWriter by using a String buffer and not the "+" concatenation, with the binary data takes several seconds.

Incorporate all the supported drivers.

The Supported DBs must be:

• MySQL.
• Oracle.
• SqlServer.
• PostgreSQL.
• DB2

Modify the settings.xml for the app

The xml should have a tag to store the port that will be used as the listening port of the app, and the dispatcher name.

Create launcher

Option 1. Create a .bat and .sh file to run the app automatically in Window, Linux and Mac, to avoid java -jar.
Option 2. Find a way to show the console using a .jar by just double clicking.

Add detailed LOGs for warning, severe and debug.

The information showed in the logs must be more expressive and be able to be set or not in the .xml file. Probably the debug is related to fine.

Add logs

Option 1. Use Log4J
Option 2. Create a Log system to leave a witness of the different processes that occur during the app executing, writing important events.

About port settings

Realize a way to set a different Port in case if it is already in use...
Option 1. By an argument in the java -jar app.jar 8080.
Option 2. Rewriting the Settings.xml.

Not found settings.xml and queries.xml handler

Add a better way to handle the Exception in case of these files aren't found.

Create stress client

Create a stress client that sends multiple requests to the server and writes a log with the performance (times elapsed) in a .csv file. Uses the time to send the queries.

Write as json

Currently the app doesn't have a writeJSON method, it must be added to the dispatcher.

Fix bad formatted .csv for binary

Fix the bad .csv generated from the binary data.

Fix paths for Linux and OSX

When you try to run the app in those Operating System the app crashes because they use different separators.

Add all DB drivers

Define drivers for all the DB managers.

Solve problem when the passed Array is not empty

When the the passed argument is not empty and the necessary ArrayList must be empty the app shows a weird error.

Error: "The column index is out of range: 1, number of columns: 0.".

Add support for binary data

Actually the application tennis in an infinite loop when the data retrieved from the database is of type binary plus the client can't process it, something similar happens when the data is a date the data sent isn't a string.