From: Lyndon C. V. <lyn...@gm...> - 2007-01-05 20:04:39
|
Ken, Thanks for the input. I checked my .jython , and things were correct there; but not on the actual command line for java. I've changed it to include the ms*.jar files (msbase.jar, msutil.jar, mssqlserver.jar) in "-classpath"; and added the directories to "-Djava.ext.dir=" on the command line. Now I get a statement that it can't locate "java" from the following line: java.lang.Class.forName(<driver>) --Lyndon ======================================================== Lyndon Van Wagner home email: lcv...@al..., lcv...@ho..., lva...@ro..., lyn...@ma..., lyn...@gm... ======================================================== Getting old isn't for sissies. ======================================================== > > Message: 5 > Date: Thu, 04 Jan 2007 13:35:20 -0500 > From: Kent Johnson <ke...@td...> > Subject: Re: [Jython-users] zxJDBC won't connect to SQLServer ? > > lyn...@th... wrote: >> Jython-users: >> >> I was hoping someone could help out here... >> >> (BTW, I fixed my problem with the missing zxJDBC in jython-2.2a1 by >> downloading it (v2.1) from sourceforge and placing >> it into classpath and extdirs.) >> >> I'm trying to port some java JDBC code to jython and zxJDBC... and >> previous used the following driver and URL: >> driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver" >> url = "jdbc:microsoft:sqlserver://%s:1440" % (remotehost, ) >> >> However, I keep getting the following Exception: >> DatabaseError: driver >> [com.microsoft.jdbc.sqlserver.SQLServerDriver] >> not found >> >> Can someone please shed light on this? >> Am I supposed to import something like >> com.microsoft.jdbc.sqlserver so >> the correct DriverManager is found? > > Try > java.lang.Class.forName(driver) > > and make sure the microsoft jar is in your classpath. > > Kent |
From: Kent J. <ke...@td...> - 2007-01-05 20:15:18
|
Lyndon Craig VanWagner wrote: > Now I get a statement that it can't locate "java" from the following line: > java.lang.Class.forName(<driver>) You have to import java Kent |
From: <lyn...@th...> - 2007-04-08 02:03:38
|
All, Finally, I have success connecting to databases using Jython and zxJDBC ! I'm presently running Jython v2.2b1 on Solaris 10 x86 with Java 6u1, mySQL v5.0.27-standard and Connector/J v5.0.5 . I've removed the old zxJDBC.jar, and am using the one built into jython.jar.=20 The last show-stopper appeared to be this: python.home (Jython installation directory) wasn't in my extensions (java.ext.dirs property) list. Therefore, I was getting java NameErrors, etc when trying to import com.ziclix.python.sql.zxJDBC. It only took me a day to figure this one out; I guess my dev skills have gotten rusty. Just a FYI, I had to table my development due to other work tasks; so only just got back to this. Of course, that time and now I took the time to install mySQL, vmware workstation, solaris 10 x86, java 6, etc. And BTW, I'm running jython.jar directly, so my java command line looks something like: java -Dpython.home=3D<installdir> -Djava.ext.dirs=3D<extension dirs> -jar <installdir>/jython.jar $@ This way, I don't have to list each and every jar file in my classpath. Thanks for all the help! --Lyndon -----Original Message----- From: Kent Johnson [mailto:ke...@td...]=20 Sent: Friday, January 05, 2007 3:15 PM To: Lyndon Craig VanWagner Cc: jyt...@li...; Vanwagner (Van Wagner), Lyndon C. (Thomson) Subject: Re: [Jython-users] zxJDBC won't connect to SQLServer ? Lyndon Craig VanWagner wrote: > Now I get a statement that it can't locate "java" from the following line: > java.lang.Class.forName(<driver>) You have to import java Kent |