Search found 4 matches

by rutabuga
29 Jan 2012, 18:13
Forum: SFS2X Questions
Topic: DBManager executeUpdate and null values
Replies: 2
Views: 5508

you mean like this, the following code sets all second names in table to NULL

Code: Select all

sql = "UPDATE `table` SET `secondname`= ?;
    			
    	Object[] array = new Object[1];
    	array[0] = null;
    	dbManager.executeUpdate(sql, array);
by rutabuga
29 Jan 2012, 02:46
Forum: SFS2X Questions
Topic: is it posible to send multiple DB updates in single request
Replies: 1
Views: 4340

is it posible to send multiple DB updates in single request

I'm currently looking for the best way to do an insert into on multiple
un-related tables. say for example

INSERT INTO `tbl1` (`name`) VALUES ('MR x');
INSERT INTO `tbl2` (`a number`) VALUES ('1337');

without having to do multiple calls of dbManager.executeUpdate()
is there a way to send multiple ...
by rutabuga
11 Nov 2011, 15:29
Forum: SFS2X Questions
Topic: Clustering confusion
Replies: 3
Views: 6492

what about running sfs on a beowolf cluster. im not entirely sure what a linux beowolf operating system would allow you. but in theory if it did you could add new nodes when needed with minimal work.
by rutabuga
06 Jun 2011, 18:56
Forum: SFS2X Questions
Topic: request for very simple SQL extension
Replies: 1
Views: 4524

request for very simple SQL extension

can any one give a very simple code snippet that:

conects to an SQL server
querys and a data value

all help is apreciated

ive tryed the following which dosnt seam to work

IDBManager dbManager = getParentExtension().getParentZone().getDBManager();
Connection connection;
try {
connection ...