http://forums.hotjoe.com/posts/list/28.page JForum - http://www.jforum.net
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.]]> http://forums.hotjoe.com/posts/preList/669/2522.page http://forums.hotjoe.com/posts/preList/669/2522.page GMT
Exception in thread "main" java.lang.UnsupportedClassVersionError: Bad version number in .class file
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:620)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:124)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:260)
at java.net.URLClassLoader.access$100(URLClassLoader.java:56)
at java.net.URLClassLoader$1.run(URLClassLoader.java:195)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:18
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:26
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)


I'm trying to run as follows:
/opt/jboss/jdk1.5.0_07/bin/java -classpath lib/jisql.jar:lib/jopt-simple-3.2.jar:lib/javacsv.jar:/lib/jt400-6.0.jar com.xigole.util.sql.Jisql -user %user% -password %pass% -driver com.ibm.as400.access.AS400JDBCDriver -cstring jdbc:as400://%dbname%

I also tried to run against the new version with scripts that were running without issue on the older version that we've been using for a little over a year now. (script exists in jisql/slic_queries, thus classpath ../lib)

JAVA_HOME=/opt/jboss/jdk1.5.0_07
$JAVA_HOME/bin/java -classpath ../lib/jisql.jar:../lib/jt400-6.0.jar \
com.xigole.util.sql.Jisql \
-driver com.ibm.as400.access.AS400JDBCDriver \
-user %user% \
-pf /home/weblogic/jisql/input/3.txt \
-cstring jdbc:as400://%dbname%\
-input check_slic_stop_status.sql

Sorry if this is a rookie mistake. I'll keep working on it to see if I can resolve.

Thanks,
Tamii ]]> http://forums.hotjoe.com/posts/preList/669/2544.page http://forums.hotjoe.com/posts/preList/669/2544.page GMT
Thanks for pointing this out!]]> http://forums.hotjoe.com/posts/preList/669/2545.page http://forums.hotjoe.com/posts/preList/669/2545.page GMT
Thanks again!
Tamii ]]> http://forums.hotjoe.com/posts/preList/669/2546.page http://forums.hotjoe.com/posts/preList/669/2546.page GMT
Older version usage included the following:
-pf specifies the name of a file that contains the password to log into a database server with.
The first line of file should contain the password and nothing else.

However, I don't see it in the usage for the 2.0 release.

This was super useful for cron.

Thanks,
Tamii ]]> http://forums.hotjoe.com/posts/preList/669/2547.page http://forums.hotjoe.com/posts/preList/669/2547.page GMT http://forums.hotjoe.com/posts/preList/669/2548.page http://forums.hotjoe.com/posts/preList/669/2548.page GMT http://forums.hotjoe.com/posts/preList/669/2549.page http://forums.hotjoe.com/posts/preList/669/2549.page GMT
[code]
java.lang.NoClassDefFoundError: joptsimple/OptionParser
at com.xigole.util.sql.Jisql.parseArgs(Jisql.java:495)
at com.xigole.util.sql.Jisql.main(Jisql.java:249)
Caused by: java.lang.ClassNotFoundException: joptsimple.OptionParser
at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
at java.lang.ClassLoader.loadClass(ClassLoader.java:319)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294)
at java.lang.ClassLoader.loadClass(ClassLoader.java:264)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:332)
... 2 more
[/code]

Jisql v2.0.1 copyright (c) 2010 Scott Dunbar (scott@xigole.com)
[...]


java -classpath .../ojdbc14_g.jar:.../jisql_2/lib/jisql.jar com.xigole.util.sql.Jisql -user ... -password ... -driver oracle.jdbc.driver.OracleDriver -cstring jdbc:oracle:thin:@...:1521:...

java -version
java version "1.6.0_0"
OpenJDK Runtime Environment (IcedTea6 1.6.2) (suse-0.1.1-x86_64)
OpenJDK 64-Bit Server VM (build 14.0-b16, mixed mode)

Changing the location of jisql.jar to point to my old jisql from fall 2009 works fine.
]]> http://forums.hotjoe.com/posts/preList/669/2557.page http://forums.hotjoe.com/posts/preList/669/2557.page GMT
If you use the CSV output or if you compile the default formatter it is dependent on [url=http://sourceforge.net/projects/javacsv/]JavaCSV[/url] which is also included in the "lib" directory.

If you add lib/jopt-simple-3.2.jar to your classpath and, optionally, lib/javacsv.jar you should be good to go.]]> http://forums.hotjoe.com/posts/preList/669/2558.page http://forums.hotjoe.com/posts/preList/669/2558.page GMT
Yes, it was obvious from the docs -- once I read them again.

Sorry about that -- I assumed that they hadn't changed since the last time I read them

Thanks for the RTM ]]> http://forums.hotjoe.com/posts/preList/669/2559.page http://forums.hotjoe.com/posts/preList/669/2559.page GMT

[code]
<manifest>
<attribute name="Class-Path" value="${jisql.jar.name} ${jopt-simple-3.2.jar.name}"/>
<attribute name="Main-Class" value="com.xigole.util.sql.Jisql"/>
[/code]]]> http://forums.hotjoe.com/posts/preList/669/2560.page http://forums.hotjoe.com/posts/preList/669/2560.page GMT http://forums.hotjoe.com/posts/preList/669/2561.page http://forums.hotjoe.com/posts/preList/669/2561.page GMT
[code]

--- build.xml 2010-01-12 12:18:05.000000000 -0500
+++ build-new.xml 2010-01-25 16:31:20.000000000 -0500
@@ -71,9 +71,11 @@
<delete dir="${javadoc.dir}"/>
</target>

<target name="jar" depends="compile, get.svn.version">
<jar destfile="${dest.lib.dir}/${dest.lib.name}" basedir="${dest.classes.dir}">
<manifest>
+ <attribute name="Class-Path" value="${dest.lib.name} jopt-simple-3.2.jar javacsv.jar"/>
+ <attribute name="Main-Class" value="com.xigole.util.sql.Jisql"/>
<attribute name="Built-By" value="${user.name}"/>
<attribute name="Built-On" value="${build.start.time}"/>
<attribute name="Subversion-Revision" value="${svn.revision.number}"/>

[/code]

but maybe this won't work due to the driver classpath.

java -jar /home/mkienenb/java/jisql_2/lib/jisql.jar -classpath .../ojdbc14_g.jar -user cis -password cis -driver oracle.jdbc.driver.OracleDriver -cstring jdbc:oracle:thin:@...
Password (hit enter for no password):
Cannot find the driver class "oracle.jdbc.driver.OracleDriver" in the current classpath.


However, it no longer requires specifying the jopt-simple-3.2 jar when I change the manifest and use "java -classpath driver.jar:jisql.jar com.xigole.util.sql.Jisql"
]]> http://forums.hotjoe.com/posts/preList/669/2562.page http://forums.hotjoe.com/posts/preList/669/2562.page GMT
"-password value" doesn't work anymore.

You are still prompted for a password under 2.0.1 even after specifying it.
]]> http://forums.hotjoe.com/posts/preList/669/2563.page http://forums.hotjoe.com/posts/preList/669/2563.page GMT
Well, it's Sun-specific, but it does work to use the -Xbootclasspath/a for the driver and combine it with -jar

It's an alternative ]]> http://forums.hotjoe.com/posts/preList/669/2564.page http://forums.hotjoe.com/posts/preList/669/2564.page GMT
[code]java -cp lib/jisql.jar:/usr/local/tomcatdev/lib/postgresql-8.3-604.jdbc4.jar com.xi.util.sql.Jisql -u user -password pass -driver postgresql -cstring jdbc:postgresql://localhost/dbname[/code]

works just fine for me. Note that I didn't include the JavaCSV nor jopt-simple jars on the command line. Of course, this blows the whole point of Main-Class so I'm not sure that it is super valuable for you.

Anyhow, let me post 2.0.2 and, again, thanks very much for your help.
]]> http://forums.hotjoe.com/posts/preList/669/2565.page http://forums.hotjoe.com/posts/preList/669/2565.page GMT Not having to specify the secondary jars certainly helps, especially for those of us who didn't read the directions before we upgraded
]]> http://forums.hotjoe.com/posts/preList/669/2566.page http://forums.hotjoe.com/posts/preList/669/2566.page GMT
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
at java.util.Arrays.copyOf(Arrays.java:2882)
at java.lang.AbstractStringBuilder.expandCapacity(AbstractStringBuilder.java:100)
at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:390)
at java.lang.StringBuffer.append(StringBuffer.java:224)
at com.xigole.util.sql.Jisql.doIsql(Jisql.java:396)
at com.xigole.util.sql.Jisql.run(Jisql.java:295)
at com.xigole.util.sql.Jisql.main(Jisql.java:270)


Jisql is wrapped around a script like this:

java -Xms128m -Xmx3g \
-classpath lib/jisql-2.0.9.jar:${HOME}/opt/sqljdbc_3.0/enu/sqljdbc4.jar \
com.xigole.util.sql.Jisql \
-user me \
-password apassword \
-driver com.microsoft.sqlserver.jdbc.SQLServerDriver \
-cstring "jdbc:sqlserver://aserver\something;databaseName=adatabase;APP=Database Browser;WSID=${HOSTNAME};DATABASE=Adatamase" "$@"

The runtime is:
jisql-2.0.9$ java -version
java version "1.6.0_26"
Java(TM) SE Runtime Environment (build 1.6.0_26-b03)
Java HotSpot(TM) 64-Bit Server VM (build 20.1-b02, mixed mode)

Any suggestions?]]> http://forums.hotjoe.com/posts/preList/669/4158.page http://forums.hotjoe.com/posts/preList/669/4158.page GMT
Note that the underlying issue is that with text (CLOB in some databases) or binary (BLOB) columns the width of the column comes back as a very large number - usually 2GB. The code was trying to print out a string 2GB in length for the column. Now the formatter defaults to a max column width of 2048. You can override that with the "-w" switch.

Let me know if that helps things any.]]> http://forums.hotjoe.com/posts/preList/669/4159.page http://forums.hotjoe.com/posts/preList/669/4159.page GMT
I tried experimenting with some different queries and especially one field, when selected caused this exception to happen. Excluding it, and everything workes fine. The field is typically one which would contain a long string. I'm not sure if it's size is variable or not.

I'll try Jisql 2.0.10 ASAP.

The -w option sounds like an excellent workaround, but I couldn't get it to work however

myDB.sh -input ../my.sql -delimiter=";" -noheader -trim -left -w1024

:
Additional command line arguments of the com.xigole.util.sql.outputformatter.DefaultFormatter class are
-w specifies the maximum field width for a column. The default is to output the full width of the column
:

I looked into the jisql-2.0.9.jar and DefaultFormatter.class is there.

Minor additional issue:
It seems that -nohead doesn't work either (I can't see any difference with or without it).

Thanks for
/Michael
]]> http://forums.hotjoe.com/posts/preList/669/4160.page http://forums.hotjoe.com/posts/preList/669/4160.page GMT
-w works, but even without it the default is well chosen.

Only -nohead left to fix now.

Regards
/Michael]]> http://forums.hotjoe.com/posts/preList/669/4161.page http://forums.hotjoe.com/posts/preList/669/4161.page GMT http://forums.hotjoe.com/posts/preList/669/4162.page http://forums.hotjoe.com/posts/preList/669/4162.page GMT
2.0.11 is available [url=http://www.xigole.com/software/jisql/jisql.jsp]at the same place[/url].]]> http://forums.hotjoe.com/posts/preList/669/4163.page http://forums.hotjoe.com/posts/preList/669/4163.page GMT
Thanks!

//Michael]]> http://forums.hotjoe.com/posts/preList/669/4164.page http://forums.hotjoe.com/posts/preList/669/4164.page GMT