[hotjoe.com] HotJoe Java Help Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Visit java.com
Please send email if you are having login problems - see the posts below for more info.
Hotmail and Yahoo! users - please see the Hotmail post or the Yahoo! post for information on lost emails.
Help with installation  XML
Forum Index » Jisql
Author Message
larrys

Newbie

Joined: 11/14/2006 13:52:44
Messages: 2
Offline

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]#


stdunbar

Newbie
[Avatar]

Joined: 06/22/2005 14:51:37
Messages: 703
Location: Superior, CO, USA
Online

From what I can find online it looks like this is a problem with GNU Java. Can you try the Sun JVM? I'm not sure what Linux you're on but take a look at the Java download page and download the "JDK 5.0 Update 9" (if you think you might ever compile Java code) or the "Java Runtime Environment (JRE) 5.0 Update 9" if you just want to run it.

Thanks for using the forums at hotjoe.com
[WWW] [Yahoo!] [ICQ]
larrys

Newbie

Joined: 11/14/2006 13:52:44
Messages: 2
Offline

Thanks a lot. Red Hat was using the Free Software Foundation's implementation of Java by default. I changed the script to call the sun java that was installed in /usr/java and it worked like a charm. I think it is worth noteing that I had to put the -input option before the -cstring option for it to run.

Thanks again. This app is perfect for the task at hand.

I actually cringe when I have to use DOS now!
stdunbar

Newbie
[Avatar]

Joined: 06/22/2005 14:51:37
Messages: 703
Location: Superior, CO, USA
Online

larrys wrote: I think it is worth noteing that I had to put the -input option before the -cstring option for it to run.


I'll take a look at that as it shouldn't be required but thanks for letting me know!

Thanks for using the forums at hotjoe.com
[WWW] [Yahoo!] [ICQ]
 
Forum Index » Jisql
Go to:   
Powered by JForum 2.1.8 © JForum Team
This site built by Scott Dunbar of Xigole Systems. © 2005-2010 - Scott Dunbar
Java and the Java Get Powered logo are trademarks or registered trademarks of Sun Microsystems, Inc. in the United States and other countries.
hotjoe.com and xigole.com have no affiliation with Sun Microsystems, Inc.