mikwat code :: 2011 :: February

{ Monthly Archives }

February 2011

MSSQL Bulk Insert from CSV file

http://www.thescripts.com/forum/thread158756.html

BULK INSERT Test FROM 'X:\temp\Test.CSV'
WITH (
DATAFILETYPE = 'char',
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)

Could not bulk insert because file ‘X:\temp\Test.CSV’ could not be opened. Operating system error code 3(The system cannot find the path specified.).

http://support.microsoft.com/kb/316371

objBL.transaction = "FALSE"

2011 02 17

IllegalStateException: getAttribute: Session already invalidated

http://tomcat.apache.org/tomcat-5.5-doc/catalina/docs/api/org/apache/catalina/cluster/session/DeltaSession.html

http://www.mail-archive.com/tomcat-user@jakarta.apache.org/msg124558.html

2011 02 17