Activity for jdbc2csv.jar
-
jdbc2csv.jar released /jdbc/ojdbc8-12.2.0.1.jar
-
-
-
-
-
Atanas Dichev committed [ab823e]
Possibility for reading SQL from stdin
-
Added mysql example
-
-
Improved source code
-
Added Oracle example
-
Improved source code
-
Added README
-
it is difficult to add new drivers
-
no support for JDBC URL (connection string)
-
--csv-format option doesn't work
-
--csv-format option doesn't work
-
no support for JDBC URL (connection string)
-
rename jdbcsql.zip to jdbcsql-1.0.jar
-
-
-
-
Remove eclipse folder .setttings/
-
Using only JDBC url for connection to DBMS
-
Congratulation for the brilliant decision. I promise when I have enough time I'll added option for custom url.
-
no support for JDBC URL (connection string)
-
Petr Slansky modified a comment on ticket #4
This tool is just a toy! Everything is hardcoded and difficult to change by end user... :-( An example of JDBC string to connect to AWS Aurora cluster (https://stackoverflow.com/questions/56403686/aurora-mysql-jdbc-fail-over) jdbc:mysql:replication://master.xxxx.rds.amazonaws.com:3306,read.xxxx.rds.amazonaws.com:3306/dbnamerhere?autoReconnect=true&logger=com.mysql.jdbc.log.Slf4JLogger&allowSlavesDownConnections=true&readFromMasterWhenNoSlaves=true&loadBalanceBlacklistTimeout=5000 This JDBC url is...
-
This tool is just a toy! Everything is hardcoded and difficult to change by end user... :-( An example of JDBC string to connect to AWS Aurora cluster (https://stackoverflow.com/questions/56403686/aurora-mysql-jdbc-fail-over) jdbc:mysql:replication://master.xxxx.rds.amazonaws.com:3306,read.xxxx.rds.amazonaws.com:3306/dbnamerhere?autoReconnect=true&logger=com.mysql.jdbc.log.Slf4JLogger&allowSlavesDownConnections=true&readFromMasterWhenNoSlaves=true&loadBalanceBlacklistTimeout=5000 This JDBC url is...
-
This tool is just a toy! Everything is hardcoded and difficult to change by end user... :-( An example of JDBC string to connect to AWS Aurora cluster (https://stackoverflow.com/questions/56403686/aurora-mysql-jdbc-fail-over) jdbc:mysql:replication://master.xxxx.rds.amazonaws.com:3306,read.xxxx.rds.amazonaws.com:3306/dbnamerhere?autoReconnect=true&logger=com.mysql.jdbc.log.Slf4JLogger&allowSlavesDownConnections=true&readFromMasterWhenNoSlaves=true&loadBalanceBlacklistTimeout=5000 This JDBC url is...
-
This tool is just a toy! Everything is hardcoded and difficult to change by end user... :-( An example of JDBC string to connect to AWS Aurora cluster (https://stackoverflow.com/questions/56403686/aurora-mysql-jdbc-fail-over) jdbc:mysql:replication://master.xxxx.rds.amazonaws.com:3306,read.xxxx.rds.amazonaws.com:3306/dbnamerhere?autoReconnect=true&logger=com.mysql.jdbc.log.Slf4JLogger&allowSlavesDownConnections=true&readFromMasterWhenNoSlaves=true&loadBalanceBlacklistTimeout=5000 This JDBC url is...
-
This tool is just a toy! Everything is hardcoded and difficult to change by end user... :-( An example of JDBC string to connect to AWS Aurora cluster (https://stackoverflow.com/questions/56403686/aurora-mysql-jdbc-fail-over) jdbc:mysql:replication://master.xxxx.rds.amazonaws.com:3306,read.xxxx.rds.amazonaws.com:3306/dbnamerhere?autoReconnect=true&logger=com.mysql.jdbc.log.Slf4JLogger&allowSlavesDownConnections=true&readFromMasterWhenNoSlaves=true&loadBalanceBlacklistTimeout=5000 This JDBC url is...
-
This tool is just a toy! Everything is hardcoded and difficult to change by end user... :-( An example of JDBC string to connect to AWS Aurora cluster (https://stackoverflow.com/questions/56403686/aurora-mysql-jdbc-fail-over) jdbc:mysql:replication://master.xxxx.rds.amazonaws.com:3306,read.xxxx.rds.amazonaws.com:3306/dbnamerhere?autoReconnect=true&logger=com.mysql.jdbc.log.Slf4JLogger&allowSlavesDownConnections=true&readFromMasterWhenNoSlaves=true&loadBalanceBlacklistTimeout=5000 This JDBC url is...
-
This tool is just a toy! Everything is hardcoded and difficult to change by end user... :-( An example of JDBC string to connect to AWS Aurora cluster (https://stackoverflow.com/questions/56403686/aurora-mysql-jdbc-fail-over) jdbc:mysql:replication://master.xxxx.rds.amazonaws.com:3306,read.xxxx.rds.amazonaws.com:3306/dbnamerhere?autoReconnect=true&logger=com.mysql.jdbc.log.Slf4JLogger&allowSlavesDownConnections=true&readFromMasterWhenNoSlaves=true&loadBalanceBlacklistTimeout=5000 This JDBC url is...
-
This tool is just a toy! Everything is hardcoded and difficult to change by end user... :-( An example of JDBC string to connect to AWS Aurora cluster (https://stackoverflow.com/questions/56403686/aurora-mysql-jdbc-fail-over) jdbc:mysql:replication://master.xxxx.rds.amazonaws.com:3306,read.xxxx.rds.amazonaws.com:3306/dbnamerhere?autoReconnect=true&logger=com.mysql.jdbc.log.Slf4JLogger&allowSlavesDownConnections=true&readFromMasterWhenNoSlaves=true&loadBalanceBlacklistTimeout=5000 With your design,...
-
This tool is just a toy! Everything is hardcoded and difficult to change by end user... :-(
-
Major idea is all files to be encapsulated in one jar/zip. It's ready for deploy.
-
no support for JDBC URL (connection string)
-
Look in the documenation how to configure JDBCConfig.properties file. The content of JDBCConfig.properties file is database urls.
-
Thе version jdbcsql-1.0.zip is compatible with jdk 11.
-
Download the new version jdbcsql-1.0.zip. This version is compatible with jdk 11.
-
I am not java programmer and I needed several tries to find that I can experiement with different JDBC drivers without modification of "jar" archive. An example, how to test the latest postgresql JDBC driver. I extracted jdbcsql.zip to new directory (like jdbcsql-test) and I moved to that directory: mkdir jdbcsql-test; cd jdbcsql-test; unzip ../jdbcsql.zip I can start jdbcsql directly and I can test my new postgresql JDBC driver (that is in ../jisql/jdbc directory) java -cp .:commons-cli-1.2.jar:commons-csv-1.1.jar:../jisql/jdbc/postgresql-42.2.6.jar...
-
I am not java programmer and I needed several tries to find that I can experiement with different JDBC drivers without modification of "jar" archive. An example, how to test the latest postgresql JDBC driver. I extracted jdbcsql.zip to new directory (like jdbcsql-test) and I moved to that directory: mkdir jdbcsql-test; cd jdbcsql-test; unzip ../jdbcsql.zip I can start jdbcsql directly and I can test my new postgresql JDBC driver (that is in ../jisql/jdbc directory) java -cp .:commons-cli-1.2.jar:commons-csv-1.1.jar:../jisql/jdbc/postgresql-42.2.6.jar...
-
I am not java programmer and I needed several tries to find that I can experiement with different JDBC drivers without modification of "jar" archive. An example, how to test the latest postgresql JDBC driver. I extracted jdbcsql.zip to new directory (like jdbcsql-test) and I moved to that directory: mkdir jdbcsql-test; cd jdbcsql-test; unzip ../jdbcsql.zip I can start jdbcsql directly and I can test my new postgresql JDBC driver (that is in ../jisql/jdbc directory) java -cp .:commons-cli-1.2.jar:commons-csv-1.1.jar:../jisql/jdbc/postgresql-42.2.6.jar...
-
I am not java programmer and I needed several tries to find that I can experiement with different JDBC drivers without modification of "jar" archive. An example, how to test the latest postgresql JDBC driver. I extracted jdbcsql.zip to new directory (like jdbcsql-test) and I moved to that directory: mkdir jdbcsql-test; cd jdbcsql-test; unzip ../jdbcsql.zip I can start jdbcsql directly and I can test my new postgresql JDBC driber (that is in ../jisql/jdbc directory) java -cp .:commons-cli-1.2.jar:commons-csv-1.1.jar:../jisql/jdbc/postgresql-42.2.6.jar...
-
I am not java programmer and I needed several tries to find that I can experiement with different JDBC drivers without "jar" archive. An example, test the latest postgresql JDBC driver. I extracted jdbcsql.zip to new directory (like jdbcsql-test) and I moved to that directory: mkdir jdbcsql-test; cd jdbcsql-test; unzip ../jdbcsql.zip I can start jdbcsql directly and I can test my new postgresql JDBC driber (that is in ../jisql/jdbc directory) java -cp .:commons-cli-1.2.jar:commons-csv-1.1.jar:../jisql/jdbc/postgresql-42.2.6.jar...
-
I am not java programmer and I needed several tries to find that I can experiement with different JDBC drivers without "jar" archive. An example, test the latest postgresql JDBC driver. I extracted jdbcsql.zip to new directory (like jdbcsql-test) and I moved to that directory: mkdir jdbcsql-test; cd jdbcsql-test; unzip ../jdbcsql.zip I can start jdbcsql directly and I can test my new postgresql JDBC driber (that is in ../jisql/jdbc directory) ~~~ java -cp .:commons-cli-1.2.jar:commons-csv-1.1.jar:../jisql/jdbc/postgresql-42.2.6.jar...
-
I understand that idea. Anyway, there could be an optional parameters that will allow to use external JDBC driver. It will allow easy test of newer version of JDBC driver or to allow to work in situation that part of servers were already updated to newer version of database and need different version of JDBC driver. With current design man has to create several versions of jdbcsql archive.
-
ZIP extension is more convenient to open archive than that is true for GUI, Windows GUI. When you work with CLI zip/unzip, "jar" extension is not a problem and "jar" extension clearly express that this is java JAR file. Some shells with autocompletion will not offer "jdbssql.zip after "java -jar" because they offer only ".jar" files (you can try bash at Ubuntu). In most cases user don't need to extract/modify jar archives. Unfortuentay, design of jdbcsql requires modification of jar archive to add/update/change...
-
no support for JDBC URL (connection string)
-
--csv-format option doesn't work
-
--csv-format option doesn't work
-
--csv-format option doesn't work
-
no support for JDBC URL (connection string)
-
it is difficult to add new drivers
-
My idea is all files to be capsulate in one jar/zip. It's easy to copy, move and etc.
-
rename jdbcsql.zip to jdbcsql-1.0.jar
-
ZIP extension is more convenient to open archive than jar
-
jdbcsql doesn't work with OpenJDK 11
-
-
no support for JDBC URL (connection string)
-
it is difficult to add new drivers
-
rename jdbcsql.zip to jdbcsql-1.0.jar
-
jdbcsql doesn't work with OpenJDK 11
-
At.Dichev committed [c0b33b]
Add output CSV formats: EXCEL, MYSQL, RFC-4180 ...
-
At.Dichev committed [ca08af]
Fix groupId
-
At.Dichev committed [13b9a4]
Add maven configure for compile
-
At.Dichev committed [89982f]
* improve err msg
-
At.Dichev committed [694874]
* improve err msg for SQL
-
At.Dichev committed [474a74]
* improve doc
-
At.Dichev committed [adeeb4]
* improve source code
-
At.Dichev committed [e7ca54]
- oracle default port
-
At.Dichev committed [965f02]
* database -> dbname for replace ambiguous
-
At.Dichev committed [2dfae8]
+ mysql and oracle jdbc
-
At.Dichev committed [dda908]
* improve source code
-
At.Dichev committed [19e058]
+ sql input
-
At.Dichev committed [a69988]
* improve description
-
At.Dichev committed [ef8a2d]
* improve control of seperator
-
At.Dichev committed [9e2c28]
* improve source code
-
-
At.Dichev committed [d27618]
+ execute query method
-
At.Dichev committed [6ff40a]
+ init project
1
