myriah wind

Greenhorn
+ Follow
since Mar 04, 2005
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by myriah wind

I don't believe there is one. WebSphere 5.0 has a number of fixpaks as high 5.06 that I know of but 5.1 is a new install(almost a separate product), it does the usual upgrade from previous version, but I don't know what issues you may encounter if you try it.
18 years ago
Are you using WebSphere or WebSphere portal?
In WebSphere the logging params are cinfigured in the config files (XML) in ..\AppServer\config\server\cell
18 years ago
what are you using for a driver?
there are differences in JDBC drivers and you should check the documentation
for drivers you're using, but something like this should work
insert into database

int rows=0;
PreparedStatement pstmt = null;
try
{
pstmt = conn.prepareStatement("insert into PROVIDERS ( "+
" party_id, "+
"image ) "+
"values( "+
"?, "+
"?)");
pstmt.setInt(1,112);
File file = new File("pilo.png");
long fileLength = file.length();
FileInputStream fis = new FileInputStream(file);
pstmt.setBinaryStream(2,fis, (int)fileLength);
rows = pstmt.executeUpdate();
fis.close();
pstmt.close();
pstmt =null;
conn.commit();
}
catch (FileNotFoundException e) {
...
}
catch (IOException e) {
...
}
catch (SQLException e) {
...
}
finally {
if (stmt != null){ stmt.close();
catch Exception e) {
... }
}
}

to retrieve from database



[added code tags]
[ September 13, 2005: Message edited by: Jeanne Boyarsky ]
no quick way, but there are some good books on it in pdf form

try something from here

http://www.redbooks.ibm.com/cgi-bin/searchsite.cgi?query=WebSphere
18 years ago
just log in to websphere admin the info is in the top right pane
18 years ago
1. websphere connectJDBC drivers will work adequately and are part of WebSphere.
2. If the ear file that you have was packaged properly the DD should be part of it. Go to the websphere administration and install the ear as an application, then select ressources and add the databases. The source may be useful to find out what data source and jndi names you need if you don't have external configuration files for these
18 years ago
com.mysql.jdbc.Driver
is the class used for jdbc with MySQL dbms you can get the archive and documentation at

http://dev.mysql.com/downloads/connector/
public void setPers_id(int rows, int uid, String persId); {
natPersId[index] = "XX:"+uid+":"+persId+":08";
}
is the method.
I'm getting StringBuffer.<init>(String) line: 145 [local variables unavailable] message out of WebSphere Studio's debugging facility.
just running it produces a java.lang.NullPointerException

it behaves the same even if I hard cose values into
setPers_id(123, 456, "rnp");
i'm trying to persist jdbc data from a ResultSet and have this for a problem:
class Collector extends Thread {
...
DateWriter writer = new DateWriter ();
String selectQuery = "SELECT * from xxxData";
+ "WHERE "
+ "serv_prov_type_id == 'BC'";
Statement stmt = con.createStatement();
rset = stmt.executeQuery(selectQuery);

//writer is an instance of DateWriter
// DateWriter is the class that starts Colector
writer.setUniqueMessageChid(String.valueOf(now));
writer.setMessageDateTime(date);

int col = 0;
while(rset.next()) {
rows++;

uid = rset.getInt(1);
pers_id = rset.getInt(2);
serv_prov_type_id = rset.getInt(3);
writer.setPers_id(rows, uid, pers_id); // error
name_last = rset.getString(4);
name_1st = rset.getString(5);
name_cmmn = rset.getString(6);
sex = rset.getString(7);
born_date = rset.getDate(8);
}
writer.getMessageDateTime(); //this works

the error is thrown only within the loop.
StringBuffer.<init>(String) line: 145 [local variables unavailable]

does anyone know what's going on here??? better yet how to make it work?