http://forums.hotjoe.com/posts/list/28.page JForum - http://www.jforum.net ----------------------------------------------------------------------------
#!/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]#


]]> http://forums.hotjoe.com/posts/preList/329/1420.page http://forums.hotjoe.com/posts/preList/329/1420.page GMT http://forums.hotjoe.com/posts/preList/329/1421.page http://forums.hotjoe.com/posts/preList/329/1421.page GMT
Thanks again. This app is perfect for the task at hand.

I actually cringe when I have to use DOS now!]]> http://forums.hotjoe.com/posts/preList/329/1425.page http://forums.hotjoe.com/posts/preList/329/1425.page GMT
I'll take a look at that as it shouldn't be required but thanks for letting me know!]]> http://forums.hotjoe.com/posts/preList/329/1428.page http://forums.hotjoe.com/posts/preList/329/1428.page GMT