<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3314" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=725274307-01062009>It also appears that
the OpenDBConnector needs to be updated too. The previous version of the
driver class required a connection string which was prefixed with
jdbc:microsoft:sqlserver, however the new driver requires
jdbc:sqlserver. The OpenDBConnector actor automatically appends this
prefix when trying to connect to a SQL server database, however it still uses
the old connection string which currently makes it impossible to connect to a
SQL Server database.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>
<HR>
<!--beginarticle--><PRE>Hi Peter,
I have updated the actor to use the driver class
com.microsoft.sqlserver.jdbc.SQLServerDriver.
However, the MS SQL Server JDBC jars included in Kepler appear to
be from "MS SQL Server 2000 Driver for JDBC", which does not
support Java 1.5. I have removed these jars since Kepler requires
Java 1.5.
The license for "MS SQL Server 2005 JDBC Driver 1.2" (which does
support Java 1.5) does not permit redistribution. You will need to
download the jars and place them in $KEPLER/lib/jar/. The Kepler
loader will automatically add them to the classpath. If you are
using Eclipse, you might need to add them to the .classpath file.
Let me know if you have questions,
--dan
<A href="http://mercury.nceas.ucsb.edu/kepler/mailman/listinfo/kepler-users">Peter.Fitch at csiro.au</A> wrote:
><I> Hi Kepler users,
</I>><I>
</I>><I> I have found a problem with using the open database connector actor with MS SQL Server. When you set the database format to MS SQL Server you get an exception class not found com.microsoft.jdbc.sqlserver.SQLServerDriver.
</I>><I>
</I>><I> Unfortunately the class is correct for Java 1.4 but not for 1.5 which is the current recommended version. In Java 1.5 the driver class is com.microsoft.sqlserver.jdbc.SQLServerDriver.
</I>><I>
</I>><I> Anyone else found this?
</I>><I>
</I>><I> Cheers
</I>><I> Peter
</I>><I>
</I>><I>
</I>><I>
</I>><I> _______________________________________________
</I>><I> Kepler-users mailing list
</I>><I> <A href="http://mercury.nceas.ucsb.edu/kepler/mailman/listinfo/kepler-users">Kepler-users at ecoinformatics.org</A>
</I>><I> <A href="http://mercury.nceas.ucsb.edu/ecoinformatics/mailman/listinfo/kepler-users">http://mercury.nceas.ucsb.edu/ecoinformatics/mailman/listinfo/kepler-users</A>
</I>><I>
</I>
</PRE></DIV><FONT face=tahoma size=2>
<DIV class=Section1><SPAN style="COLOR: windowtext">
<P class=MsoNormal align=left><FONT face=Arial
size=2></FONT><BR>Cheers<BR><BR>Jamie<BR><BR><BR><BR
style="mso-special-character: line-break"><BR
style="mso-special-character: line-break"></P><?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN>
<TABLE class=MsoNormalTable
style="BORDER-COLLAPSE: collapse; mso-padding-alt: 0cm 0cm 0cm 0cm"
cellSpacing=0 cellPadding=0 border=0>
<TBODY>
<TR style="mso-yfti-irow: 0; mso-yfti-firstrow: yes">
<TD
style="PADDING-RIGHT: 0cm; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; WIDTH: 810pt; PADDING-TOP: 0cm"
vAlign=top width=1080 colSpan=2>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 7.5pt; COLOR: #003366; FONT-FAMILY: Arial">To be, or
what?- Sylvester Stallone<QUOTE will be inserted here></SPAN></P></TD></TR>
<TR style="mso-yfti-irow: 1">
<TD
style="PADDING-RIGHT: 0cm; PADDING-LEFT: 0cm; BACKGROUND: #003366; PADDING-BOTTOM: 0cm; WIDTH: 71.6pt; PADDING-TOP: 0cm"
vAlign=top width=95>
<P class=MsoNormal><SPAN style="FONT-SIZE: 5pt">
<o:p></o:p></SPAN></P></TD>
<TD
style="PADDING-RIGHT: 0cm; PADDING-LEFT: 0cm; BACKGROUND: #a0a0a0; PADDING-BOTTOM: 0cm; WIDTH: 738.4pt; PADDING-TOP: 0cm"
vAlign=top width=985>
<P class=MsoNormal><SPAN style="FONT-SIZE: 5pt">
<o:p></o:p></SPAN></P></TD></TR>
<TR style="mso-yfti-irow: 2; mso-yfti-lastrow: yes">
<TD
style="PADDING-RIGHT: 0cm; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; WIDTH: 71.6pt; PADDING-TOP: 1.4pt"
vAlign=top width=95>
<P class=MsoNormal style="TEXT-ALIGN: center" align=center><IMG
id=_x0000_i1025 height=89 src="cid:725274307@01062009-1FC1"
width=75></P></TD>
<TD
style="PADDING-RIGHT: 0cm; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; WIDTH: 738.4pt; PADDING-TOP: 1.4pt"
vAlign=top width=985>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 7.5pt; COLOR: #003366; FONT-FAMILY: Arial">Jamie
Vleeshouwer<BR>Software Developer<BR>CSIRO Land and Water<BR>Long Pocket
Laboratories<BR>120 Meiers Road, Indooroopilly QLD 4068, Australia<BR>Ph:
+61-7-3214 2785 Fax: +61-7-3214 2855 Mobile: 0437
531 125<BR>Web: <SPAN
class=SpellE>www.clw.csiro.au</SPAN></SPAN></P></TD></TR></TBODY></TABLE>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><SPAN
style="COLOR: windowtext"><BR><BR style="mso-special-character: line-break"><BR
style="mso-special-character: line-break"><o:p></o:p></SPAN></P></DIV>
<P><BR><BR> </P></FONT>
<DIV> </DIV></BODY></HTML>