Latest topics for the forum "Jisql"

How to catch messages from database server

t603 — GMT

Hello, is there any way how to catch native messages from database server? Like number of rows affected etc. Or is it feature of JDBC driver? Thank You. Stepan

Jisql version 2.0 now available

stdunbar — GMT

Yes, after this many years people are still using Jisql. I've updated it and I've tried to include most suggestions that I've received over the years. I think I've gotten it but don't be afraid to speak up - let me know if something is missing!

Jisql can be downloaded from [url=http://www.xigole.com/software/jisql.jsp]the normal places[/url]. Take a look and give me any feedback.

Looking for help with JiSQl to get data exported from our databases

mdr — GMT

Hello,

we are looking for someone who can help us get our databases from our current ERP system exported as TDF. All we know is that we are supposed to be able to do this using jiSQL but we are at a loss as to how to execute any commands with this. If this is something that you think you can help us with please contact us directly to discuss fees etc. Software is running on a OS X 10.4 server. The database is sybase. Thank you.
marc @ cadencebuilding .com
315-287-2852

output in XML format

anotine — GMT

Hello,

Is it possible to have a XML output with jisql instead of table with columns?

I use this command line:
"%JAVA_HOME%\bin\java" -classpath %JISQL_CLASS% com.xigole.util.sql.Jisql -u %userDB% -p %passDB% -driver %drivDB% -cstring %httpDB% -c ; -w 20 -input sql/%TestName%.sql > result\%TestName%.txt

---
Truly,
@notine

sed script to produce csv file

hansley — GMT

I had the need, so just hacked this out and wanted to save others the pain. These two chained sed scripts will delete the header and footer rows, clean out the 1> bits, get rid of the line between the header and first data row, get rid of all extra whitespace, change pipes to ",", add " to the front of each line, and clean up ugly line endings. The only thing to change is to change ColHeadOne to whatever your first column header is. It dependes on your jisql output being named 'interim_results.csv'.

sed -e 's/^\x0D$//g' \
-e '/^$/d' \
-e '1,2d' \
-e '4d' \
-e '3s/^.*ColHeadOne/ColHeadOne/g' \
-e 'N;$!P;$!D;$d' < interim_results.csv | \
sed -e 's/ */ /g' \
-e 's/ *| */","/g' \
-e 's/^ */"/g' \
-e 's/,"*$//g' > final_results.csv

Enjoy. No warranties, expressed or implied. Your mileage may vary. No whales were harmed in the production of this script. Please recycle when done with it.
-Bill

Connect to another database or user in JISQL

shivanigoyal — GMT

Hi,

I am new to JISQL.
Can anyone tell me how we can connect to another database or another user.
For example we have done create user A;
Now i want to change the user from current user to A.
How shall I do it.

In PSQL we do it like
\connect ot \c [DBNAME [USERNAME]]

Insert unicode data into MySQL using scripts

anilreddyg — GMT

I am trying to apply some database scripts that have some Russian text, to a MySQL database, using JiSQL and it always inserts some wierd characters. If I run the same script using MySQL query browser or any other GUI based tool, data is fine. All the tables are setup as UTF-8 to support Russian data.

Is there any option or switch that I have to use to insert Unicode data? Please advise.

thanks
Anil G

Help with installation

larrys — GMT

Let me start by saying thank you for this app, it fills a very importantant need. I am relatively new to linux, about a year but still pretty adept. I have unzipped the files to a directory and I am trying to connect to a MS SQL server. I am using this command in a shell script but get the same error at the command line.
----------------------------------------------------------------------------
#!/bin/bash

java -classpath .:/opt/msSQLjdbc/lib/jisql.jar:/opt/msSQLjdbc/lib/msbase.jar:/opt/msSQLjdbc/lib/msutil.jar:/opt/msSQLjdbc/lib/mssqlserver.jar com.xigole.util.sql.Jisql -user sa -password myword -driver mssql -cstring jdbc:microsoft:sqlserver://sqldev:1433;DatabaseName=Northwind

actually I have tried it with this also:
-cstring jdbc:microsoft:sqlserver://sqldev:1433/Northwind
------------------------------------------------------------------------------------
I get the error below everytime. What am I missing? any help or guidance is appreciated.

[root@portaldevtest jisql]# ./backuptest
Exception in thread "main" java.lang.AbstractMethodError
at _Jv_MakeVTable(java.lang.Class) (/usr/lib/libgcj.so.5.0.0)
at _Jv_PrepareClass(java.lang.Class) (/usr/lib/libgcj.so.5.0.0)
at _Jv_WaitForState(java.lang.Class, int) (/usr/lib/libgcj.so.5.0.0)
at java.lang.VMClassLoader.linkClass0(java.lang.Class) (/usr/lib/libgcj.so.5.0.0)
at java.lang.VMClassLoader.resolveClass(java.lang.Class) (/usr/lib/libgcj.so.5.0.0)
at java.lang.Class.initializeClass() (/usr/lib/libgcj.so.5.0.0)
at java.lang.Class.forName(java.lang.String, boolean, java.lang.ClassLoader) (/usr/lib/libgcj.so.5.0.0)
at java.lang.Class.forName(java.lang.String) (/usr/lib/libgcj.so.5.0.0)
at com.microsoft.jdbc.base.BaseClassUtility.getConnection(java.lang.String) (Unknown Source)
at com.microsoft.jdbc.base.BaseClassUtility.getConnection(com.microsoft.jdbc.base.BaseDriver) (Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(java.lang.String, java.util.Properties) (Unknown Source)
at java.sql.DriverManager.getConnection(java.lang.String, java.util.Properties) (/usr/lib/libgcj.so.5.0.0)
at com.xigole.util.sql.Jisql.getConnection(java.lang.String, java.util.Properties) (Unknown Source)
at com.xigole.util.sql.Jisql.run() (Unknown Source)
at com.xigole.util.sql.Jisql.main(java.lang.String[]) (Unknown Source)
You have new mail in /var/spool/mail/root
[root@portaldevtest jisql]# echo $PATH
/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin:/usr/lib
[root@portaldevtest jisql]#

Options, output field delimiter

pmurti — GMT

I'm a new user of jisql. Two questions:

1. Are options/preferences stored elsewhere than jisql.prp? For example where is the option on the output field delimiter stored?

2. Related - I can't seem to set the field delimiter using the -spacer command line argument. Is that argument still valid? It also doesn't seem to be preserved from one jisql session to the next.

Thanks!

OutOfMemoryError

gnaryak — GMT

I am running jisql on Linux and connecting to MS SQL Server. I run it with the following command:
$JAVA_HOME/bin/java -classpath ../javalib/database/jisql.jar:../javalib/database/jtds-1.2.jar com.xigole.util.sql.Jisql -driver net.sourceforge.jtds.jdbc.Driver

For the most part, jisql is working great. (Thanks!) I have encountered a problem, however. I wrote a function that separately queries several database tables, then aggregates the results and returns them. I can invoke the function without any problems from SQL Explorer running in Eclipse. I run it as:
select * from healthCheck()

When I run the same function from jisql, I get the following error:
Exception in thread "main" java.lang.OutOfMemoryError: Requested array size exceeds VM limit

I tried adding -Xms64M -Xmx512M parameters to the command that opens jisql but that didn't change anything. When I was trying to run this, there were 0 rows returned by healthCheck() so it does not seem to be caused by the size of the result set.

Thanks in advance for any help you may be able to provide!
-Andrew Guldman

Minor jisql suggestion

mrider — GMT

I've been using jisql for a bit now, and I have a minor suggestion: Change your check for "exit" and "quit" to ignore case. It makes life slightly easier when typing all caps SQL commands.

Need something like WHENEVER SQLERROR EXIT for scripts

dewwalker — GMT

Hello!

First off, this is an awesome tool and a much needed utility.

I was wondering how hard it would be to add either a flag or a command so that if any Exception occurs when reading a script to stop executing the remainder of the script.

Thanks!

Dan

Some future directions

stdunbar — GMT

I've received a few requests for some future directions of Jisql and wanted to post them here so there there are no duplicates. These are in no particular order.

addition of a batch mode (no pretty output)
a column separator can be choosen in batch mode
addition of the JConnect6 shortcut
HTML/XML output
CSV output
Any character that cannot be printed with the current charcter set should print with the unicode code

If anyone has anything else let me know.

Truncated varchar values in jisql

leono — GMT

Hi! I'm using jisql on the command line to connect to a MS SQL Server, and all of my varchar values are truncated to 24 characters. I'm using Microsoft's JDBC driver. Any ideas why this truncation might be happening?

Announce: new version of jisql available

stdunbar — GMT

A new version of [url=http://www.xigole.com/software/jisql.jsp]jisql[/url] is available for download. This version adds the ability to enter passwords on the command line.

jsiql is a command line interactive SQL processor. It passes typed commands onto a database server. You can use any JDBC driver and any database connection URL. Full source code and ant build files are include in the distributions.

jsiql is licensed under the [url=http://www.apache.org/licenses/LICENSE-2.0]Apache License[/url].