Hi guys,
Ok, so I treid and tried with the drivers / JAR files etc and nothing.....seems to be something with the Java source files on the server only being 1.3 compatible...
Here is a workaround for those who are desperate like me to get the generated key back....please see some basic code below to give you an idea how to do it....I have tried it in the Webdynpro and it works 100%.
package db.test;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import net.sourceforge.jtds.*;
public class TestConnection {
public static void main(String[] args) {
try{
Class.forName("net.sourceforge.jtds.jdbc.Driver");
Connection conn= java.sql.DriverManager.getConnection("jdbc:jtds:sqlserver://<server>:1433/<database>", "username", "password");
conn.setAutoCommit(false);
String sql = "INSERT Z_IDEA_ATTACHMENTS(FileName, FilePath, FileURL, FileSize, FolderName, IdeaNumber )VALUES(?,?,?,?,?,?)";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, "hello.txt");
ps.setString(2, "path");
ps.setString(3, "url");
ps.setString(4, "120 Bytes");
ps.setString(5, "folder");
ps.setInt(6, 1);
int rows = ps.executeUpdate();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select @@IDENTITY");
rs.next();
int value = rs.getInt(1);
System.out.println(new Integer(value).toString());
rs.close();
stmt.close();
conn.commit();
conn.close();
System.out.println("done");
}catch (Exception e){
e.printStackTrace();
}
}
}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.