Zsuzsa Pocsai

I have created a new database on mysql database. However I can not get my code to connect to it. I keep getting the problem that my tables have not got primary keys. However, the same code and the same driver works on the northwind databse. I am going mad with this problem. Any suggestions would be greatly apprechiated.
Thank you

Unfortunately the stack trace does not help at all. What happens is that it takes about seven updates to the screen for it to crash. Slowling the used memory is going up and eventually it runs out of memory, when it is trying to refresh the screen after me adding new data to it. I have absolutely no idea what coulc cause this. All my other screen are working with the same pricipal, same structure to the tags etc and they all work fine.

I have a problem with running a servlet on Tomcat, it keeps running out of memory in certain pages. The jsp page, using tags, displays a list of Peoples details, name address etc. This particular page that I have the most problem with crashes after me added 7-8 new people to the list and re-load the page. When I rip out most of the tags, the page loads fine. I can no see what could possibly cause the problem as the tags on this page use the exact same structure as other tags on other pages, which work fine. Anyone help would be greatly apprechiated. Thank you.

Can anyone advise me on what to do? I have added the following code to my build.xml so that it can get the latest verion of code from VSS.
and it stops at trying to logg into the database. ( i think) I can see the "username: pocsaizs " written to the command line then the whole thing hangs.
<target name="source-control"
depends="init"
description="source control">
<vssget localPath="C:\VSS\PC\PC System\Current Version"
ssdir="C:\Program Files\Microsoft Visual Studio\Common\VSS\win32"
recursive="true"
login="pocsaizs,password"
vsspath="/PC/PC System/Current Version"
writable="false"/>
</target>

I have put the following code in but it is looking for a db on my local machine.
<target name="source-control"
depends="init"
description="source control">
<vssget localPath="C:\VSS\PCFG\PCFG System\Current Version"
ssdir="C:\Program Files\Microsoft Visual Studio\Common\VSS\win32"
serverPath="C:\program\zsuzsa"
recursive="true"
login="zsuzsa,password"
vsspath="/PCFG/PCFG System/Current Version"
writable="false"/>
</target>
I am not sure which parameter would have to hold the pass and how for the database on another machine on the network. Any help would be very much apprechiated. Thank you

I have put the following code in but it is looking for a db on my local machine.
<target name="source-control"
depends="init"
description="source control">
<vssget localPath="C:\VSS\PCFG\PCFG System\Current Version"
ssdir="C:\Program Files\Microsoft Visual Studio\Common\VSS\win32"
serverPath="C:\program\zsuzsa"
recursive="true"
login="zsuzsa,password"
vsspath="/PCFG/PCFG System/Current Version"
writable="false"/>
</target>
I am not sure which parameter would have to hold the pass and how for the database on another machine on the network. Any help would be very much apprechiated. Thank you

Harri,
Could you please give a helping hand with this.
I need to be able to connect to a network database and not a db on my local machine. And I just do not seem to be able to re-direct it. Any idea why that could be? Thank you

Thank you!

I am a beginer in ANT, and I was wondering if anyone would be able to tell me how I could use ANT to get the latest version of code out of Visual SourceSafe (verion 6) before deployment?
Thank u for your help.

I need help please,
I have got an object which has a creation date time parameter which is of type calendar. When I save the object to the database it is 14pm 34 sec. When I read it back it is always one hour behind I have no idea why. I have managed to locate that it goes wrong when I put the Date opject into the Calendars consturctor. The code is the following. Can anyone please tell me what is wrong with it? Thank you

private void getDateTime(String columnName, ResultSet rs, Calendar calendar) throws IntException
{
java.sql.Date date;
java.sql.Time time;
java.sql.Date datetime;
long longTime;
try {
date = rs.getDate(columnName);
time = rs.getTime(columnName);
System.out.println(time.getHours());
System.out.println(time.getMinutes());
if (date != null)
{
longTime = date.getTime();
if (time != null)
longTime += time.getTime();
longTime = date.getTime() + time.getTime();
System.out.println(time.getTime());
datetime = new java.sql.Date(longTime);
int offset = datetime.getTimezoneOffset();
//System.out.println(datetime.getHours());
//System.out.println(datetime.getMinutes());
calendar.setTime(datetime);
}
else
{
// Zero the date
setZeroDate(calendar);
}
}
catch (SQLException sqle)
{ "Error obtaining Oracle Date and Time. " + sqle.toString();
}

Can anyone please tell me if it is better to use JPSs with tags or XML/XSL to format the output?
I can not tell which one would be a better option to display reprots for a java servlet. In terms of performance, extensibiltiy, etc.
Thank you for your help
Z