Messages posted by: mkienenb

Actually, for my limited use, I can stick with specifying everything. But I was just pointing it out in hopes of making it easier for others down the road.
Not having to specify the secondary jars certainly helps, especially for those of us who didn't read the directions before we upgraded

java -Xbootclasspath/a:/pathtodriverjar/ojdbc14_g.jar -jar /pathtojisql2/lib/jisql.jar -user ... -password ... -driver oracle.jdbc.driver.OracleDriver -cstring jdbc:oracle:thin:@...

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

One more bug report:

"-password value" doesn't work anymore.

You are still prompted for a password under 2.0.1 even after specifying it.

Well, I gave it a try with this patch

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"

If you wanted to make it a little bit more automated for end users, you could add this to the manifest (and probably the java csv jar as well), then change the directions to "java -classpath jdbcdriver.jar -jar jisql.jar"

Oops.

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

I grabbed the latest download (2010-01-25 3:45pm EST), and I get this error:

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.