Textbausteinverwaltung

Textbausteine suchen

Key
Baustein-Nr.
OE	alle
Sprache	alle
Suchbegriff
Volltextsuche	nein


	Suchen
	Fenster drucken
	Fenster schliessen

Suchergebnis (19)

Textbaustein-Kombinationen

Key

Nr.

Typ

Kurzbezeichnung

ASDASD

DASDASD

BA-1

ASDFASDA

DASDASDSA

BA-1

KOMPLETT NEU!

ALLES NEU

BA-2

AAAA

12345

AAA

CCC

12345

AAAAAAAAA

AAAA

12345

AAA

12345

123232AAAAAAAAAAAAAAAA

AAAA

12345

AAA

12345

123232AAAAAAAAAAAAAAAA

AAAA

12345

AAA

AAAA

12345

AAA

AAAA

12345

AAA

12345

123232AAAAAAAAAAAAAAAA

CCC

12345

AAAAAAAAA

AAAA

12345

AAA

12345

123232AAAAAAAAAAAAAAAA

AAAA

12345

AAA

AAAA

12345

AAA

12345

123232AAAAAAAAAAAAAAAA

CCC

12345

AAAAAAAAA

12345

123232AAAAAAAAAAAAAAAA

AAAA

12345

AAA

AAAA

12345

AAA

12345

123232AAAAAAAAAAAAAAAA

AAAA

12345

AAA

AAAA

12345

AAA

CCC

12345

AAAAAAAAA

AAAA

12345

AAA

12345

123232AAAAAAAAAAAAAAAA

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Test L.Coman

mehr

Test L.Coman

mehr


Test L.Coman

mehr

Test L.Coman

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Well, actually, under Tomcat, I wrote an InitContextListener which 
automagically figures out where the current webapp exists and sets a system 
property which is referenced in log4j.xml and,  viola!, the log files are 
placed in WEB-INF/logs of the current application no matter where it exists 
and without ever hardcoding the actual path.  Of course, this assumes you 
actually have write access to your webapp which is not guaranteed by the 
servlet spec.  In that case, your file appender will not work since it 
won't have a valid location to write to.

See the InitContextListener in the log4j-sandbox.  Instructions are in the 
javadoc.  See info and links here...
http://nagoya.apache.org/wiki/apachewiki.cgi?Log4JProjectPages/AppContainerLoggi
ng

Jake

At 08:35 PM 8/13/2003 +1000, you wrote:
>G'day,
>
>Ummmm, so basically then it is not possible to define a directory path in
>the log4j.xml properties file so that log files are placed relative to the
>web apps root directory?  Or for that matter relative to any known anchor
>point like the server root directory?
>
>A problem we have is that we deploy .war files by sending the package to the
>server gods who then drop it into the webapps directory.  Alas we don't have
>the rights to deploy directly to the server environment and tools like ANT
>whilst are good at building a distributable archive they do not quite make
>the grade when resolving tokens in a dynamic style of deployment.  Another
>issue we have is that most of the development work is done on a Windows
>based machine and the production servers are hosted on a flavor of Unix.
>Hard coding a directory path like "C:\..\" may work when doing the dev work
>under Windows but just don't kind of cut it on a Unix file system when it
>comes time to deployment.
>
>BTW, the last time I looked me was male so I'll opt out for king!
>
>AB
>
>-----Original Message-----
>From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
>Sent: Monday, 11 August 2003 11:14 PM
>To: Log4J Users List
>Subject: RE: Creating log files relative to the web applications root
>directory?
>
>
>
>Howdy,
>I suppose Adrian could be a woman's name as well, so you're right ;)
>
>
>But if you're the server admin, you're king (or queen) ;) 
>
>Yoav Shapira
>Millennium ChemInformatics
>
>
> >-----Original Message-----
> >From: Caroline Wood [mailto:Caroline.Wood@cpp.co.uk]
> >Sent: Monday, August 11, 2003 9:13 AM
> >To: 'Log4J Users List'
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >or Queen! lol ;)
> >
> >-----Original Message-----
> >From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
> >Sent: 11 August 2003 14:05
> >To: Log4J Users List; a.beech@bigpond.net.au
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >
> >
> >Howdy,
> >What I've seen done to achieve this is have my ant deployment script
> >fill the value when copying log4j.xml over.  So in log4j.xml, you'd
>have
> >
> >

> > > >And in your ant script, you set filtering="true" when copying >log4j.xml, > >and replac the logFilePath token with the actual (absolute) path. > > > >As an aside, note that the servlet container is not required to give >you > >write access under your webapp's root. In fact, many server admins > >dislike this, as they prefer a centralized log location for their > >systems. But if you're the server admin, you're king ;) > > > >Yoav Shapira > >Millennium ChemInformatics > > > > > >>-----Original Message----- > >>From: Adrian Beech [mailto:a.beech@bigpond.net.au] > >>Sent: Monday, August 11, 2003 6:42 AM > >>To: 'Log4J Users List' > >>Subject: Creating log files relative to the web applications root > >>directory? > >> > >>G'day, > >> > >>Is it possible to specify a log filename in the XML log4j properties > >file > >>so > >>that it is relative to the web applications root directory? > >> > >>I have the following in a log4j.xml file located in web-inf/classes > >with > >>the > >>log4j jar in the web-inf/lib directory. Logging seems to be fine > >except > >>the > >>"rascal.log" file is being created in the Tomcat application directory > >>under C:\Program Files\ and not in the C:\Tomcat 4.1\webapps\... > >>Directory > >tree. > >>I'd prefer to have the log files in something like > >>../webapps//logs/. Is this possible? > >> > >>BTW, took a while to find the rascal.log file!!! > >> > >>--[log4j.xml]--------------------------------------------------------- > >>?xml version="1.0" encoding="UTF-8" ?> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >>--[End Of File]------------------------------------------------------- > >> > >>I'm using Tomcat 4.1.24 on a Win XP and 2k box for development and > >Tomcat > >>4.1.24 on a Unix box as the production platform. > >> > >>AB > >> > >> > >> > >>--------------------------------------------------------------------- > >>To unsubscribe, e-mail: log4j-user-unsubscribe@jakarta.apache.org > >>For additional commands, e-mail: log4j-user-help@jakarta.apache.org > > > > > > > > > >This e-mail, including any attachments, is a confidential business > >communication, and may contain information that is confidential, > >proprietary and/or privileged. This e-mail is intended only for the > >individual(s) >to > >whom it is addressed, and may not be saved, copied, printed, disclosed >or > >used by anyone else. If you are not the(an) intended recipient, please > >immediately delete this e-mail from your computer system and notify the > >sender. Thank you. > > > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: log4j-user-unsubscribe@jakarta.apache.org > >For additional commands, e-mail: log4j-user-help@jakarta.apache.org > > > > > >_______________________________________________________________________ >_ > >This email has been scanned for all viruses by the MessageLabs Email > >Security System. For more information on a proactive email security > >service working around the clock, around the globe, visit > >http://www.messagelabs.com > >_______________________________________________________________________ >_ > > > >This is an email from The CPP Group, Holgate Park, York, YO26 4GA; > >telephone 01904 544500. This message may contain information that is > >confidential. If you are not the intended recipient, you may not >peruse, > >use, disseminate, distribute or copy this message. If you have received > >this message in error, please notify the sender immediately by email, > >facsimile or telephone and either return or destroy the original >message. > >The CPP Group accept no responsibility for any changes made to this >message > >after it has been sent by the original author. > > > > > >_______________________________________________________________________ >_ > >This email has been scanned for all viruses by the MessageLabs Email > >Security System. For more information on a proactive email security > >service working around the clock, around the globe, visit > >http://www.messagelabs.com > >_______________________________________________________________________ >_ > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: log4j-user-unsubscribe@jakarta.apache.org > >For additional commands, e-mail: log4j-user-help@jakarta.apache.org > > > > >This e-mail, including any attachments, is a confidential business >communication, and may contain information that is confidential, proprietary >and/or privileged. This e-mail is intended only for the individual(s) to >whom it is addressed, and may not be saved, copied, printed, disclosed or >used by anyone else. If you are not the(an) intended recipient, please >immediately delete this e-mail from your computer system and notify the >sender. Thank you. > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: log4j-user-unsubscribe@jakarta.apache.org >For additional commands, e-mail: log4j-user-help@jakarta.apache.org > > > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: log4j-user-unsubscribe@jakarta.apache.org >For additional commands, e-mail: log4j-user-help@jakarta.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: log4j-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: log4j-user-help@jakarta.apache.org

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Well, actually, under Tomcat, I wrote an InitContextListener which 
automagically figures out where the current webapp exists and sets a system 
property which is referenced in log4j.xml and,  viola!, the log files are 
placed in WEB-INF/logs of the current application no matter where it exists 
and without ever hardcoding the actual path.  Of course, this assumes you 
actually have write access to your webapp which is not guaranteed by the 
servlet spec.  In that case, your file appender will not work since it 
won't have a valid location to write to.

See the InitContextListener in the log4j-sandbox.  Instructions are in the 
javadoc.  See info and links here...
http://nagoya.apache.org/wiki/apachewiki.cgi?Log4JProjectPages/AppContainerLoggi
ng

Jake

At 08:35 PM 8/13/2003 +1000, you wrote:
>G'day,
>
>Ummmm, so basically then it is not possible to define a directory path in
>the log4j.xml properties file so that log files are placed relative to the
>web apps root directory?  Or for that matter relative to any known anchor
>point like the server root directory?
>
>A problem we have is that we deploy .war files by sending the package to the
>server gods who then drop it into the webapps directory.  Alas we don't have
>the rights to deploy directly to the server environment and tools like ANT
>whilst are good at building a distributable archive they do not quite make
>the grade when resolving tokens in a dynamic style of deployment.  Another
>issue we have is that most of the development work is done on a Windows
>based machine and the production servers are hosted on a flavor of Unix.
>Hard coding a directory path like "C:\..\" may work when doing the dev work
>under Windows but just don't kind of cut it on a Unix file system when it
>comes time to deployment.
>
>BTW, the last time I looked me was male so I'll opt out for king!
>
>AB
>
>-----Original Message-----
>From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
>Sent: Monday, 11 August 2003 11:14 PM
>To: Log4J Users List
>Subject: RE: Creating log files relative to the web applications root
>directory?
>
>
>
>Howdy,
>I suppose Adrian could be a woman's name as well, so you're right ;)
>
>
>But if you're the server admin, you're king (or queen) ;) 
>
>Yoav Shapira
>Millennium ChemInformatics
>
>
> >-----Original Message-----
> >From: Caroline Wood [mailto:Caroline.Wood@cpp.co.uk]
> >Sent: Monday, August 11, 2003 9:13 AM
> >To: 'Log4J Users List'
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >or Queen! lol ;)
> >
> >-----Original Message-----
> >From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
> >Sent: 11 August 2003 14:05
> >To: Log4J Users List; a.beech@bigpond.net.au
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >
> >
> >Howdy,
> >What I've seen done to achieve this is have my ant deployment script
> >fill the value when copying log4j.xml over.  So in log4j.xml, you'd
>have
> >
> >

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Well, actually, under Tomcat, I wrote an InitContextListener which 
automagically figures out where the current webapp exists and sets a system 
property which is referenced in log4j.xml and,  viola!, the log files are 
placed in WEB-INF/logs of the current application no matter where it exists 
and without ever hardcoding the actual path.  Of course, this assumes you 
actually have write access to your webapp which is not guaranteed by the 
servlet spec.  In that case, your file appender will not work since it 
won't have a valid location to write to.

See the InitContextListener in the log4j-sandbox.  Instructions are in the 
javadoc.  See info and links here...
http://nagoya.apache.org/wiki/apachewiki.cgi?Log4JProjectPages/AppContainerLoggi
ng

Jake

At 08:35 PM 8/13/2003 +1000, you wrote:
>G'day,
>
>Ummmm, so basically then it is not possible to define a directory path in
>the log4j.xml properties file so that log files are placed relative to the
>web apps root directory?  Or for that matter relative to any known anchor
>point like the server root directory?
>
>A problem we have is that we deploy .war files by sending the package to the
>server gods who then drop it into the webapps directory.  Alas we don't have
>the rights to deploy directly to the server environment and tools like ANT
>whilst are good at building a distributable archive they do not quite make
>the grade when resolving tokens in a dynamic style of deployment.  Another
>issue we have is that most of the development work is done on a Windows
>based machine and the production servers are hosted on a flavor of Unix.
>Hard coding a directory path like "C:\..\" may work when doing the dev work
>under Windows but just don't kind of cut it on a Unix file system when it
>comes time to deployment.
>
>BTW, the last time I looked me was male so I'll opt out for king!
>
>AB
>
>-----Original Message-----
>From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
>Sent: Monday, 11 August 2003 11:14 PM
>To: Log4J Users List
>Subject: RE: Creating log files relative to the web applications root
>directory?
>
>
>
>Howdy,
>I suppose Adrian could be a woman's name as well, so you're right ;)
>
>
>But if you're the server admin, you're king (or queen) ;) 
>
>Yoav Shapira
>Millennium ChemInformatics
>
>
> >-----Original Message-----
> >From: Caroline Wood [mailto:Caroline.Wood@cpp.co.uk]
> >Sent: Monday, August 11, 2003 9:13 AM
> >To: 'Log4J Users List'
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >or Queen! lol ;)
> >
> >-----Original Message-----
> >From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
> >Sent: 11 August 2003 14:05
> >To: Log4J Users List; a.beech@bigpond.net.au
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >
> >
> >Howdy,
> >What I've seen done to achieve this is have my ant deployment script
> >fill the value when copying log4j.xml over.  So in log4j.xml, you'd
>have
> >
> >

Test L.Coman

mehr

Test L.Coman

mehr


Test L.Coman

mehr

Test L.Coman

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Well, actually, under Tomcat, I wrote an InitContextListener which 
automagically figures out where the current webapp exists and sets a system 
property which is referenced in log4j.xml and,  viola!, the log files are 
placed in WEB-INF/logs of the current application no matter where it exists 
and without ever hardcoding the actual path.  Of course, this assumes you 
actually have write access to your webapp which is not guaranteed by the 
servlet spec.  In that case, your file appender will not work since it 
won't have a valid location to write to.

See the InitContextListener in the log4j-sandbox.  Instructions are in the 
javadoc.  See info and links here...
http://nagoya.apache.org/wiki/apachewiki.cgi?Log4JProjectPages/AppContainerLoggi
ng

Jake

At 08:35 PM 8/13/2003 +1000, you wrote:
>G'day,
>
>Ummmm, so basically then it is not possible to define a directory path in
>the log4j.xml properties file so that log files are placed relative to the
>web apps root directory?  Or for that matter relative to any known anchor
>point like the server root directory?
>
>A problem we have is that we deploy .war files by sending the package to the
>server gods who then drop it into the webapps directory.  Alas we don't have
>the rights to deploy directly to the server environment and tools like ANT
>whilst are good at building a distributable archive they do not quite make
>the grade when resolving tokens in a dynamic style of deployment.  Another
>issue we have is that most of the development work is done on a Windows
>based machine and the production servers are hosted on a flavor of Unix.
>Hard coding a directory path like "C:\..\" may work when doing the dev work
>under Windows but just don't kind of cut it on a Unix file system when it
>comes time to deployment.
>
>BTW, the last time I looked me was male so I'll opt out for king!
>
>AB
>
>-----Original Message-----
>From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
>Sent: Monday, 11 August 2003 11:14 PM
>To: Log4J Users List
>Subject: RE: Creating log files relative to the web applications root
>directory?
>
>
>
>Howdy,
>I suppose Adrian could be a woman's name as well, so you're right ;)
>
>
>But if you're the server admin, you're king (or queen) ;) 
>
>Yoav Shapira
>Millennium ChemInformatics
>
>
> >-----Original Message-----
> >From: Caroline Wood [mailto:Caroline.Wood@cpp.co.uk]
> >Sent: Monday, August 11, 2003 9:13 AM
> >To: 'Log4J Users List'
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >or Queen! lol ;)
> >
> >-----Original Message-----
> >From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
> >Sent: 11 August 2003 14:05
> >To: Log4J Users List; a.beech@bigpond.net.au
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >
> >
> >Howdy,
> >What I've seen done to achieve this is have my ant deployment script
> >fill the value when copying log4j.xml over.  So in log4j.xml, you'd
>have
> >
> >

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Well, actually, under Tomcat, I wrote an InitContextListener which 
automagically figures out where the current webapp exists and sets a system 
property which is referenced in log4j.xml and,  viola!, the log files are 
placed in WEB-INF/logs of the current application no matter where it exists 
and without ever hardcoding the actual path.  Of course, this assumes you 
actually have write access to your webapp which is not guaranteed by the 
servlet spec.  In that case, your file appender will not work since it 
won't have a valid location to write to.

See the InitContextListener in the log4j-sandbox.  Instructions are in the 
javadoc.  See info and links here...
http://nagoya.apache.org/wiki/apachewiki.cgi?Log4JProjectPages/AppContainerLoggi
ng

Jake

At 08:35 PM 8/13/2003 +1000, you wrote:
>G'day,
>
>Ummmm, so basically then it is not possible to define a directory path in
>the log4j.xml properties file so that log files are placed relative to the
>web apps root directory?  Or for that matter relative to any known anchor
>point like the server root directory?
>
>A problem we have is that we deploy .war files by sending the package to the
>server gods who then drop it into the webapps directory.  Alas we don't have
>the rights to deploy directly to the server environment and tools like ANT
>whilst are good at building a distributable archive they do not quite make
>the grade when resolving tokens in a dynamic style of deployment.  Another
>issue we have is that most of the development work is done on a Windows
>based machine and the production servers are hosted on a flavor of Unix.
>Hard coding a directory path like "C:\..\" may work when doing the dev work
>under Windows but just don't kind of cut it on a Unix file system when it
>comes time to deployment.
>
>BTW, the last time I looked me was male so I'll opt out for king!
>
>AB
>
>-----Original Message-----
>From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
>Sent: Monday, 11 August 2003 11:14 PM
>To: Log4J Users List
>Subject: RE: Creating log files relative to the web applications root
>directory?
>
>
>
>Howdy,
>I suppose Adrian could be a woman's name as well, so you're right ;)
>
>
>But if you're the server admin, you're king (or queen) ;) 
>
>Yoav Shapira
>Millennium ChemInformatics
>
>
> >-----Original Message-----
> >From: Caroline Wood [mailto:Caroline.Wood@cpp.co.uk]
> >Sent: Monday, August 11, 2003 9:13 AM
> >To: 'Log4J Users List'
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >or Queen! lol ;)
> >
> >-----Original Message-----
> >From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
> >Sent: 11 August 2003 14:05
> >To: Log4J Users List; a.beech@bigpond.net.au
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >
> >
> >Howdy,
> >What I've seen done to achieve this is have my ant deployment script
> >fill the value when copying log4j.xml over.  So in log4j.xml, you'd
>have
> >
> >

Test L.Coman

mehr

Test L.Coman

mehr


Test L.Coman

mehr

Test L.Coman

Well, actually, under Tomcat, I wrote an InitContextListener which 
automagically figures out where the current webapp exists and sets a system 
property which is referenced in log4j.xml and,  viola!, the log files are 
placed in WEB-INF/logs of the current application no matter where it exists 
and without ever hardcoding the actual path.  Of course, this assumes you 
actually have write access to your webapp which is not guaranteed by the 
servlet spec.  In that case, your file appender will not work since it 
won't have a valid location to write to.

See the InitContextListener in the log4j-sandbox.  Instructions are in the 
javadoc.  See info and links here...
http://nagoya.apache.org/wiki/apachewiki.cgi?Log4JProjectPages/AppContainerLoggi
ng

Jake

At 08:35 PM 8/13/2003 +1000, you wrote:
>G'day,
>
>Ummmm, so basically then it is not possible to define a directory path in
>the log4j.xml properties file so that log files are placed relative to the
>web apps root directory?  Or for that matter relative to any known anchor
>point like the server root directory?
>
>A problem we have is that we deploy .war files by sending the package to the
>server gods who then drop it into the webapps directory.  Alas we don't have
>the rights to deploy directly to the server environment and tools like ANT
>whilst are good at building a distributable archive they do not quite make
>the grade when resolving tokens in a dynamic style of deployment.  Another
>issue we have is that most of the development work is done on a Windows
>based machine and the production servers are hosted on a flavor of Unix.
>Hard coding a directory path like "C:\..\" may work when doing the dev work
>under Windows but just don't kind of cut it on a Unix file system when it
>comes time to deployment.
>
>BTW, the last time I looked me was male so I'll opt out for king!
>
>AB
>
>-----Original Message-----
>From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
>Sent: Monday, 11 August 2003 11:14 PM
>To: Log4J Users List
>Subject: RE: Creating log files relative to the web applications root
>directory?
>
>
>
>Howdy,
>I suppose Adrian could be a woman's name as well, so you're right ;)
>
>
>But if you're the server admin, you're king (or queen) ;) 
>
>Yoav Shapira
>Millennium ChemInformatics
>
>
> >-----Original Message-----
> >From: Caroline Wood [mailto:Caroline.Wood@cpp.co.uk]
> >Sent: Monday, August 11, 2003 9:13 AM
> >To: 'Log4J Users List'
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >or Queen! lol ;)
> >
> >-----Original Message-----
> >From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
> >Sent: 11 August 2003 14:05
> >To: Log4J Users List; a.beech@bigpond.net.au
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >
> >
> >Howdy,
> >What I've seen done to achieve this is have my ant deployment script
> >fill the value when copying log4j.xml over.  So in log4j.xml, you'd
>have
> >
> >

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Well, actually, under Tomcat, I wrote an InitContextListener which 
automagically figures out where the current webapp exists and sets a system 
property which is referenced in log4j.xml and,  viola!, the log files are 
placed in WEB-INF/logs of the current application no matter where it exists 
and without ever hardcoding the actual path.  Of course, this assumes you 
actually have write access to your webapp which is not guaranteed by the 
servlet spec.  In that case, your file appender will not work since it 
won't have a valid location to write to.

See the InitContextListener in the log4j-sandbox.  Instructions are in the 
javadoc.  See info and links here...
http://nagoya.apache.org/wiki/apachewiki.cgi?Log4JProjectPages/AppContainerLoggi
ng

Jake

At 08:35 PM 8/13/2003 +1000, you wrote:
>G'day,
>
>Ummmm, so basically then it is not possible to define a directory path in
>the log4j.xml properties file so that log files are placed relative to the
>web apps root directory?  Or for that matter relative to any known anchor
>point like the server root directory?
>
>A problem we have is that we deploy .war files by sending the package to the
>server gods who then drop it into the webapps directory.  Alas we don't have
>the rights to deploy directly to the server environment and tools like ANT
>whilst are good at building a distributable archive they do not quite make
>the grade when resolving tokens in a dynamic style of deployment.  Another
>issue we have is that most of the development work is done on a Windows
>based machine and the production servers are hosted on a flavor of Unix.
>Hard coding a directory path like "C:\..\" may work when doing the dev work
>under Windows but just don't kind of cut it on a Unix file system when it
>comes time to deployment.
>
>BTW, the last time I looked me was male so I'll opt out for king!
>
>AB
>
>-----Original Message-----
>From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
>Sent: Monday, 11 August 2003 11:14 PM
>To: Log4J Users List
>Subject: RE: Creating log files relative to the web applications root
>directory?
>
>
>
>Howdy,
>I suppose Adrian could be a woman's name as well, so you're right ;)
>
>
>But if you're the server admin, you're king (or queen) ;) 
>
>Yoav Shapira
>Millennium ChemInformatics
>
>
> >-----Original Message-----
> >From: Caroline Wood [mailto:Caroline.Wood@cpp.co.uk]
> >Sent: Monday, August 11, 2003 9:13 AM
> >To: 'Log4J Users List'
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >or Queen! lol ;)
> >
> >-----Original Message-----
> >From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
> >Sent: 11 August 2003 14:05
> >To: Log4J Users List; a.beech@bigpond.net.au
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >
> >
> >Howdy,
> >What I've seen done to achieve this is have my ant deployment script
> >fill the value when copying log4j.xml over.  So in log4j.xml, you'd
>have
> >
> >

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Test L.Coman

mehr

Test L.Coman

mehr


Test L.Coman

mehr

Test L.Coman

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Well, actually, under Tomcat, I wrote an InitContextListener which 
automagically figures out where the current webapp exists and sets a system 
property which is referenced in log4j.xml and,  viola!, the log files are 
placed in WEB-INF/logs of the current application no matter where it exists 
and without ever hardcoding the actual path.  Of course, this assumes you 
actually have write access to your webapp which is not guaranteed by the 
servlet spec.  In that case, your file appender will not work since it 
won't have a valid location to write to.

See the InitContextListener in the log4j-sandbox.  Instructions are in the 
javadoc.  See info and links here...
http://nagoya.apache.org/wiki/apachewiki.cgi?Log4JProjectPages/AppContainerLoggi
ng

Jake

At 08:35 PM 8/13/2003 +1000, you wrote:
>G'day,
>
>Ummmm, so basically then it is not possible to define a directory path in
>the log4j.xml properties file so that log files are placed relative to the
>web apps root directory?  Or for that matter relative to any known anchor
>point like the server root directory?
>
>A problem we have is that we deploy .war files by sending the package to the
>server gods who then drop it into the webapps directory.  Alas we don't have
>the rights to deploy directly to the server environment and tools like ANT
>whilst are good at building a distributable archive they do not quite make
>the grade when resolving tokens in a dynamic style of deployment.  Another
>issue we have is that most of the development work is done on a Windows
>based machine and the production servers are hosted on a flavor of Unix.
>Hard coding a directory path like "C:\..\" may work when doing the dev work
>under Windows but just don't kind of cut it on a Unix file system when it
>comes time to deployment.
>
>BTW, the last time I looked me was male so I'll opt out for king!
>
>AB
>
>-----Original Message-----
>From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
>Sent: Monday, 11 August 2003 11:14 PM
>To: Log4J Users List
>Subject: RE: Creating log files relative to the web applications root
>directory?
>
>
>
>Howdy,
>I suppose Adrian could be a woman's name as well, so you're right ;)
>
>
>But if you're the server admin, you're king (or queen) ;) 
>
>Yoav Shapira
>Millennium ChemInformatics
>
>
> >-----Original Message-----
> >From: Caroline Wood [mailto:Caroline.Wood@cpp.co.uk]
> >Sent: Monday, August 11, 2003 9:13 AM
> >To: 'Log4J Users List'
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >or Queen! lol ;)
> >
> >-----Original Message-----
> >From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
> >Sent: 11 August 2003 14:05
> >To: Log4J Users List; a.beech@bigpond.net.au
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >
> >
> >Howdy,
> >What I've seen done to achieve this is have my ant deployment script
> >fill the value when copying log4j.xml over.  So in log4j.xml, you'd
>have
> >
> >

TESTA

12345

123232AAAAAAAAAAAAAAAA

AAB

12345

AAB BEZZ

AAAA

12345

AAA

AAAA

12345

AAA

Well, actually, under Tomcat, I wrote an InitContextListener which 
automagically figures out where the current webapp exists and sets a system 
property which is referenced in log4j.xml and,  viola!, the log files are 
placed in WEB-INF/logs of the current application no matter where it exists 
and without ever hardcoding the actual path.  Of course, this assumes you 
actually have write access to your webapp which is not guaranteed by the 
servlet spec.  In that case, your file appender will not work since it 
won't have a valid location to write to.

See the InitContextListener in the log4j-sandbox.  Instructions are in the 
javadoc.  See info and links here...
http://nagoya.apache.org/wiki/apachewiki.cgi?Log4JProjectPages/AppContainerLoggi
ng

Jake

At 08:35 PM 8/13/2003 +1000, you wrote:
>G'day,
>
>Ummmm, so basically then it is not possible to define a directory path in
>the log4j.xml properties file so that log files are placed relative to the
>web apps root directory?  Or for that matter relative to any known anchor
>point like the server root directory?
>
>A problem we have is that we deploy .war files by sending the package to the
>server gods who then drop it into the webapps directory.  Alas we don't have
>the rights to deploy directly to the server environment and tools like ANT
>whilst are good at building a distributable archive they do not quite make
>the grade when resolving tokens in a dynamic style of deployment.  Another
>issue we have is that most of the development work is done on a Windows
>based machine and the production servers are hosted on a flavor of Unix.
>Hard coding a directory path like "C:\..\" may work when doing the dev work
>under Windows but just don't kind of cut it on a Unix file system when it
>comes time to deployment.
>
>BTW, the last time I looked me was male so I'll opt out for king!
>
>AB
>
>-----Original Message-----
>From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
>Sent: Monday, 11 August 2003 11:14 PM
>To: Log4J Users List
>Subject: RE: Creating log files relative to the web applications root
>directory?
>
>
>
>Howdy,
>I suppose Adrian could be a woman's name as well, so you're right ;)
>
>
>But if you're the server admin, you're king (or queen) ;) 
>
>Yoav Shapira
>Millennium ChemInformatics
>
>
> >-----Original Message-----
> >From: Caroline Wood [mailto:Caroline.Wood@cpp.co.uk]
> >Sent: Monday, August 11, 2003 9:13 AM
> >To: 'Log4J Users List'
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >or Queen! lol ;)
> >
> >-----Original Message-----
> >From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
> >Sent: 11 August 2003 14:05
> >To: Log4J Users List; a.beech@bigpond.net.au
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >
> >
> >Howdy,
> >What I've seen done to achieve this is have my ant deployment script
> >fill the value when copying log4j.xml over.  So in log4j.xml, you'd
>have
> >
> >

Hi there,

I'am fairly new to OJB and try to get my feet on it.
My problem is, that I can't get Clobs working. The software I use:

- OJB-1.0.rc4
- postgresql-7.3.3_1
- FreeBSD 5.1-RELEASE
- JDK-1.4.1 (native).

I get the following error when trying to insert Clob data:
org.postgresql.jdbc1.AbstractJdbc1Statement.setObject(AbstractJdbc1Statement.jav
a:1392)
org.postgresql.jdbc1.AbstractJdbc1Statement.setObject(AbstractJdbc1Statement.jav
a:1398)
org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatement(Unknow
n
Source)
org.apache.ojb.broker.platforms.PlatformPostgreSQLImpl.setObjectForStatement(Unk
nown
Source)
org.apache.ojb.broker.accesslayer.StatementManager.bindInsert(Unknown
Source)
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown
Source)
...
Caused by: Unknown Types value.
...

I checked against the junit tests BlobTest, but I can't find any
difference to my setup.

Here is my torque-schema.xml

...

  
  
  
  
    
  

  
...

I verified that the column body results in a bytea type.

My repository-user-xml:
...

	

	

	

	


...

Parts of the VO:
public class Template {
	private int templateId;
	private int userId;
	private String name;
	private char[] body;
...


And finally the code that causes the exception:
WeblogUser user = new WeblogUser();
user.setUsername("foo");
...

char[] body1 = new char[50];
for (int n = 0; n < body1.length; n++)
    body1[n] = 'x';

Template tmp1 = new Template();
tmp1.setName("default template");
tmp1.setBody(body1);

Collection col = new ArrayList();
col.add(templ);
user.setAllTemplatesOfUser(col);

broker.beginTransaction();
broker.store(user);
broker.commitTransaction();

Is there anything I overlooked?
Marcus
-- 
We'll try to make different mistakes this time.
(Larry Wall)






---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

TESTMB

TTTTTTT

BA-1

AAAA

12345

AAA

12345

123232AAAAAAAAAAAAAAAA

AAAA

12345

AAA

12345

TESTMB

AAB

12345

AAB BEZZ

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Well, actually, under Tomcat, I wrote an InitContextListener which 
automagically figures out where the current webapp exists and sets a system 
property which is referenced in log4j.xml and,  viola!, the log files are 
placed in WEB-INF/logs of the current application no matter where it exists 
and without ever hardcoding the actual path.  Of course, this assumes you 
actually have write access to your webapp which is not guaranteed by the 
servlet spec.  In that case, your file appender will not work since it 
won't have a valid location to write to.

See the InitContextListener in the log4j-sandbox.  Instructions are in the 
javadoc.  See info and links here...
http://nagoya.apache.org/wiki/apachewiki.cgi?Log4JProjectPages/AppContainerLoggi
ng

Jake

At 08:35 PM 8/13/2003 +1000, you wrote:
>G'day,
>
>Ummmm, so basically then it is not possible to define a directory path in
>the log4j.xml properties file so that log files are placed relative to the
>web apps root directory?  Or for that matter relative to any known anchor
>point like the server root directory?
>
>A problem we have is that we deploy .war files by sending the package to the
>server gods who then drop it into the webapps directory.  Alas we don't have
>the rights to deploy directly to the server environment and tools like ANT
>whilst are good at building a distributable archive they do not quite make
>the grade when resolving tokens in a dynamic style of deployment.  Another
>issue we have is that most of the development work is done on a Windows
>based machine and the production servers are hosted on a flavor of Unix.
>Hard coding a directory path like "C:\..\" may work when doing the dev work
>under Windows but just don't kind of cut it on a Unix file system when it
>comes time to deployment.
>
>BTW, the last time I looked me was male so I'll opt out for king!
>
>AB
>
>-----Original Message-----
>From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
>Sent: Monday, 11 August 2003 11:14 PM
>To: Log4J Users List
>Subject: RE: Creating log files relative to the web applications root
>directory?
>
>
>
>Howdy,
>I suppose Adrian could be a woman's name as well, so you're right ;)
>
>
>But if you're the server admin, you're king (or queen) ;) 
>
>Yoav Shapira
>Millennium ChemInformatics
>
>
> >-----Original Message-----
> >From: Caroline Wood [mailto:Caroline.Wood@cpp.co.uk]
> >Sent: Monday, August 11, 2003 9:13 AM
> >To: 'Log4J Users List'
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >or Queen! lol ;)
> >
> >-----Original Message-----
> >From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
> >Sent: 11 August 2003 14:05
> >To: Log4J Users List; a.beech@bigpond.net.au
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >
> >
> >Howdy,
> >What I've seen done to achieve this is have my ant deployment script
> >fill the value when copying log4j.xml over.  So in log4j.xml, you'd
>have
> >
> >

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Test L.Coman

mehr

Test L.Coman

mehr


Test L.Coman

mehr

Test L.Coman

Hi there,

I'am fairly new to OJB and try to get my feet on it.
My problem is, that I can't get Clobs working. The software I use:

- OJB-1.0.rc4
- postgresql-7.3.3_1
- FreeBSD 5.1-RELEASE
- JDK-1.4.1 (native).

I get the following error when trying to insert Clob data:
org.postgresql.jdbc1.AbstractJdbc1Statement.setObject(AbstractJdbc1Statement.jav
a:1392)
org.postgresql.jdbc1.AbstractJdbc1Statement.setObject(AbstractJdbc1Statement.jav
a:1398)
org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatement(Unknow
n
Source)
org.apache.ojb.broker.platforms.PlatformPostgreSQLImpl.setObjectForStatement(Unk
nown
Source)
org.apache.ojb.broker.accesslayer.StatementManager.bindInsert(Unknown
Source)
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown
Source)
...
Caused by: Unknown Types value.
...

I checked against the junit tests BlobTest, but I can't find any
difference to my setup.

Here is my torque-schema.xml

...

  
  
  
  
    
  

  
...

I verified that the column body results in a bytea type.

My repository-user-xml:
...

	

	

	

	


...

Parts of the VO:
public class Template {
	private int templateId;
	private int userId;
	private String name;
	private char[] body;
...


And finally the code that causes the exception:
WeblogUser user = new WeblogUser();
user.setUsername("foo");
...

char[] body1 = new char[50];
for (int n = 0; n < body1.length; n++)
    body1[n] = 'x';

Template tmp1 = new Template();
tmp1.setName("default template");
tmp1.setBody(body1);

Collection col = new ArrayList();
col.add(templ);
user.setAllTemplatesOfUser(col);

broker.beginTransaction();
broker.store(user);
broker.commitTransaction();

Is there anything I overlooked?
Marcus
-- 
We'll try to make different mistakes this time.
(Larry Wall)






---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

TESTMBA

TESTETSTETETS

TESTMBMB

MBMBMBMB

12345

123232AAAAAAAAAAAAAAAA

AAAA

12345

AAA

AAB

12345

AAB BEZZ

Well, actually, under Tomcat, I wrote an InitContextListener which 
automagically figures out where the current webapp exists and sets a system 
property which is referenced in log4j.xml and,  viola!, the log files are 
placed in WEB-INF/logs of the current application no matter where it exists 
and without ever hardcoding the actual path.  Of course, this assumes you 
actually have write access to your webapp which is not guaranteed by the 
servlet spec.  In that case, your file appender will not work since it 
won't have a valid location to write to.

See the InitContextListener in the log4j-sandbox.  Instructions are in the 
javadoc.  See info and links here...
http://nagoya.apache.org/wiki/apachewiki.cgi?Log4JProjectPages/AppContainerLoggi
ng

Jake

At 08:35 PM 8/13/2003 +1000, you wrote:
>G'day,
>
>Ummmm, so basically then it is not possible to define a directory path in
>the log4j.xml properties file so that log files are placed relative to the
>web apps root directory?  Or for that matter relative to any known anchor
>point like the server root directory?
>
>A problem we have is that we deploy .war files by sending the package to the
>server gods who then drop it into the webapps directory.  Alas we don't have
>the rights to deploy directly to the server environment and tools like ANT
>whilst are good at building a distributable archive they do not quite make
>the grade when resolving tokens in a dynamic style of deployment.  Another
>issue we have is that most of the development work is done on a Windows
>based machine and the production servers are hosted on a flavor of Unix.
>Hard coding a directory path like "C:\..\" may work when doing the dev work
>under Windows but just don't kind of cut it on a Unix file system when it
>comes time to deployment.
>
>BTW, the last time I looked me was male so I'll opt out for king!
>
>AB
>
>-----Original Message-----
>From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
>Sent: Monday, 11 August 2003 11:14 PM
>To: Log4J Users List
>Subject: RE: Creating log files relative to the web applications root
>directory?
>
>
>
>Howdy,
>I suppose Adrian could be a woman's name as well, so you're right ;)
>
>
>But if you're the server admin, you're king (or queen) ;) 
>
>Yoav Shapira
>Millennium ChemInformatics
>
>
> >-----Original Message-----
> >From: Caroline Wood [mailto:Caroline.Wood@cpp.co.uk]
> >Sent: Monday, August 11, 2003 9:13 AM
> >To: 'Log4J Users List'
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >or Queen! lol ;)
> >
> >-----Original Message-----
> >From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
> >Sent: 11 August 2003 14:05
> >To: Log4J Users List; a.beech@bigpond.net.au
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >
> >
> >Howdy,
> >What I've seen done to achieve this is have my ant deployment script
> >fill the value when copying log4j.xml over.  So in log4j.xml, you'd
>have
> >
> >

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Hi there,

I'am fairly new to OJB and try to get my feet on it.
My problem is, that I can't get Clobs working. The software I use:

- OJB-1.0.rc4
- postgresql-7.3.3_1
- FreeBSD 5.1-RELEASE
- JDK-1.4.1 (native).

I get the following error when trying to insert Clob data:
org.postgresql.jdbc1.AbstractJdbc1Statement.setObject(AbstractJdbc1Statement.jav
a:1392)
org.postgresql.jdbc1.AbstractJdbc1Statement.setObject(AbstractJdbc1Statement.jav
a:1398)
org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatement(Unknow
n
Source)
org.apache.ojb.broker.platforms.PlatformPostgreSQLImpl.setObjectForStatement(Unk
nown
Source)
org.apache.ojb.broker.accesslayer.StatementManager.bindInsert(Unknown
Source)
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown
Source)
...
Caused by: Unknown Types value.
...

I checked against the junit tests BlobTest, but I can't find any
difference to my setup.

Here is my torque-schema.xml

...

  
  
  
  
    
  

  
...

I verified that the column body results in a bytea type.

My repository-user-xml:
...

	

	

	

	


...

Parts of the VO:
public class Template {
	private int templateId;
	private int userId;
	private String name;
	private char[] body;
...


And finally the code that causes the exception:
WeblogUser user = new WeblogUser();
user.setUsername("foo");
...

char[] body1 = new char[50];
for (int n = 0; n < body1.length; n++)
    body1[n] = 'x';

Template tmp1 = new Template();
tmp1.setName("default template");
tmp1.setBody(body1);

Collection col = new ArrayList();
col.add(templ);
user.setAllTemplatesOfUser(col);

broker.beginTransaction();
broker.store(user);
broker.commitTransaction();

Is there anything I overlooked?
Marcus
-- 
We'll try to make different mistakes this time.
(Larry Wall)






---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

122EE122

NOCH MAL

BA-2

AAA

12345

TESTMB

AAAA

12345

AAA

AAB

12345

AAB BEZZ

AACC

12345

AADDAADD

AACD

12345

AAC BEZ

CCC

12345

AAAAAAAAA

12345

123232AAAAAAAAAAAAAAAA

AAAA

12345

AAA

AAAA

12345

AAA

12345

123232AAAAAAAAAAAAAAAA

AAAA

12345

AAA

CCC

12345

AAAAAAAAA

12345

123232AAAAAAAAAAAAAAAA

AAAA

12345

AAA

Test L.Coman

mehr

Test L.Coman

mehr


Test L.Coman

mehr

Test L.Coman

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Hi there,

I'am fairly new to OJB and try to get my feet on it.
My problem is, that I can't get Clobs working. The software I use:

- OJB-1.0.rc4
- postgresql-7.3.3_1
- FreeBSD 5.1-RELEASE
- JDK-1.4.1 (native).

I get the following error when trying to insert Clob data:
org.postgresql.jdbc1.AbstractJdbc1Statement.setObject(AbstractJdbc1Statement.jav
a:1392)
org.postgresql.jdbc1.AbstractJdbc1Statement.setObject(AbstractJdbc1Statement.jav
a:1398)
org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatement(Unknow
n
Source)
org.apache.ojb.broker.platforms.PlatformPostgreSQLImpl.setObjectForStatement(Unk
nown
Source)
org.apache.ojb.broker.accesslayer.StatementManager.bindInsert(Unknown
Source)
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown
Source)
...
Caused by: Unknown Types value.
...

I checked against the junit tests BlobTest, but I can't find any
difference to my setup.

Here is my torque-schema.xml

...

  
  
  
  
    
  

  
...

I verified that the column body results in a bytea type.

My repository-user-xml:
...

	

	

	

	


...

Parts of the VO:
public class Template {
	private int templateId;
	private int userId;
	private String name;
	private char[] body;
...


And finally the code that causes the exception:
WeblogUser user = new WeblogUser();
user.setUsername("foo");
...

char[] body1 = new char[50];
for (int n = 0; n < body1.length; n++)
    body1[n] = 'x';

Template tmp1 = new Template();
tmp1.setName("default template");
tmp1.setBody(body1);

Collection col = new ArrayList();
col.add(templ);
user.setAllTemplatesOfUser(col);

broker.beginTransaction();
broker.store(user);
broker.commitTransaction();

Is there anything I overlooked?
Marcus
-- 
We'll try to make different mistakes this time.
(Larry Wall)






---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Send cvsnt mailing list submissions to
	cvsnt@cvsnt.org

To subscribe or unsubscribe via the World Wide Web, visit
	http://www.cvsnt.org/cgi-bin/mailman/listinfo/cvsnt
or, via email, send a message with subject or body 'help' to
	cvsnt-request@cvsnt.org

You can reach the person managing the list at
	cvsnt-owner@cvsnt.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of cvsnt digest..."


Today's Topics:

   1. setting branch permissions
   2. RE: Re: Mergepoint question (Starrett, Glen (AZ15))
   3. cvs update failes to update files (Sunil Koneru)
   4. Re: Re: Mergepoint question (Tony Hoyle)
   5. cvs server response (shekhar)
   6. read - access restriction to file (Raghuraman)
   7. Re: Re: Mergepoint question (Kevin)
   8. Re: Mergepoint question (Bo Berglund)


----------------------------------------------------------------------

Date: Wed, 23 Jul 2003 15:06:02 +0100
From: tim.webster@bt.com
To: cvsnt@cvsnt.org
Subject: [cvsnt] setting branch permissions
Message-ID: <2469F81E72CEA54E88F405065D9E886E019A517A@i2km10-ukbr.domain1.system
host.net>
Content-Type: text/plain;
	charset="iso-8859-1"
MIME-Version: 1.0
Precedence: list
Message: 1

Hello,

	I've seen more that one reference to the fact that CVSNT can
restrict access to branches/tags by user.  But unfortunately, I can't find
any examples.  I was assuming this is done with the "cvs chacl" command.
Firstly, is this correct? And secondly, how does it work?  I've managed to
restrict access to certain branches allright, but what I'm interested in
doing is restricting access (or not enabling check ins) to the main trunk.
If I use this command to give someone only read access to MAIN or HEAD, they
can still seem to check stuff back in on the main trunk.

Anyone familiar with this?

The command I used was "cvs chacl -r MAIN (or HEAD) user:r " to
give read only access.

To be honest I don't know the different between MAIN, HEAD, and "default
branch".  I just assumed that one is an alias of the other.  Which one
should I be setting permissions on?

Thanks
------------------------------

Date: Wed, 23 Jul 2003 08:43:57 -0700
From: "Starrett, Glen (AZ15)" 
To: Kevin , cvsnt@cvsnt.org
Subject: RE: [cvsnt] Re: Mergepoint question
Message-ID: <52E5BA67EB41D711965600B0D0FC3A7303AEDD79@aZ15m11>
Content-Type: text/plain;
	charset="iso-8859-1"
MIME-Version: 1.0
Precedence: list
Message: 2

Tony--please correct me if I've misstated anything here.

>>>>
If I am getting this right, the mergepoint is stored in the working folder
(sandbox) not in the repository.

If this is the case:
- one user merges 2 branches
- assume that development continues on both branches
- when a different user merges the branches a second time he will get the
conflicts of the first merge too

Or is the mergepoint committed to the repository too?
<<<<

Yes, mergepoints are saved in the sandbox until committed and then to the
server log once committed.  You'll see entries in there with the field
"mergepoint" if you've done merges.  However, from what I've read recently,
I would infer that if you do *2* merges into the same sandbox without
committing in-between then you would loose 1 or both mergepoints.

The better (or at least more detailed) steps of your scenario is:

-- One users merges 1st of 2 branches
-- When conflicts are resolved (if any), commit
-- Same user merges 2nd of 2 branches
-- When conflicts are resolved (if any), commit
-- When a different user merges the branches, CVSNT sees the mergepoint
entries in the log and merges correctly.

The commit in between merges is to primarily to save off the mergepoint
record and also provide a fallback point to go back to without loosing the
1st merge in case the 2nd merge is not completed for any reason.

IMHO merging multiple times without committing in-between is only asking for
trouble, no matter what SCM tool you're using.

>>>>
By the way is there does not seem to be any (or sufficient) documentation
about merge points. If anybody finds or writes something please post a link.
<<<<

I completely agree and I'd volunteer to put this in the wiki but I'm
overloaded as it is (I guess I shouldn't be writing now then, eh?).  If you
could put this information into the CVSNT wiki for everyone's benefit it
would be available for everyone from now on, and your name would be
immortalized in the CVSNT wiki forever.  OK, maybe the last part is a
stretch, but be confident that your efforts will be appreciated.  As a side
benefit you'll solidify your knowledge on how the CVSNT branching and
merging work while you write your article.


Regards,

Glen Starrett
------------------------------

Date: Wed, 23 Jul 2003 08:54:47 -0700
From: Sunil Koneru 
To: "'cvsnt@cvsnt.org'" 
Subject: [cvsnt] cvs update failes to update files
Message-ID: 
Content-Type: text/plain;
	charset="iso-8859-1"
MIME-Version: 1.0
Precedence: list
Message: 3

Hi,

We do a daily update of the files from cvs server and do a build of the
product.
It so happens that sometimes couple of files are not getting updated.
We realize this when we are testing the built product.
This is becoming a big issue because we are not able to figure why the
update works sometimes and why it has issues updating files sometimes.
Here are some commands which we use to update files daily.

cvs update -R -d -C aspen_AppletInstall 
cvs update -R -d -C aspen_cd\aspencd20 
cvs update -R -d -C aspen_db 
cvs update -R -d -C aspen_setup 
cvs update -R -d -C aspen_web 
cvs update -l build 
cvs update -R -d -C build\scripts
cvs update -R -d -C build\public 
cvs update -R -d -C build\built_files\Scripts 
cvs update -R -d -C cds


The version of CVS we use is : CVSNT 1.11.1.3(Build 73)

Any help on this is appreciated.

thanks
Sunil


------------------------------

Date: Wed, 23 Jul 2003 17:44:31 +0100
From: Tony Hoyle 
To: cvsnt@cvsnt.org
Subject: Re: [cvsnt] Re: Mergepoint question
Message-ID: 
References: 
Content-Type: text/plain; charset=us-ascii
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Precedence: list
Message: 4

On Wed, 23 Jul 2003 08:43:57 -0700, "Starrett, Glen (AZ15)"
 wrote:


>I completely agree and I'd volunteer to put this in the wiki but I'm
>overloaded as it is (I guess I shouldn't be writing now then, eh?).  If you
>could put this information into the CVSNT wiki for everyone's benefit it
>would be available for everyone from now on, and your name would be
>immortalized in the CVSNT wiki forever.  OK, maybe the last part is a
>stretch, but be confident that your efforts will be appreciated.  As a side
>benefit you'll solidify your knowledge on how the CVSNT branching and
>merging work while you write your article.
>
At the very least someone needs to go through the bits of the documentation
that mandate tagging merges etc. and put in notes that it's not really
required any more.  I'm unfortunately so snowed under with work I barely get
enough time to work on cvsnt at all at the moment let alone sort the
documentation :(

Tony

------------------------------

Date: Thu, 24 Jul 2003 10:45:01 +0530
From: shekhar 
To: cvsnt@cvsnt.org
Subject: [cvsnt] cvs server response
Message-ID: <3F1F6B55.4010203@cygnus.stpp.soft.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Precedence: list
Message: 5

please someone tell me how to capture cvs servers' responses . Please 
please  please

shekhar


------------------------------

Date: Thu, 24 Jul 2003 11:36:05 +0530
From: Raghuraman 
To: cvsnt@cvsnt.org
Subject: [cvsnt] read - access restriction to file
Message-ID: <43972AA5E132D7118AE000079505604401134706@blrsmx003.india-life.com>
Content-Type: text/plain;
	charset="iso-8859-1"
MIME-Version: 1.0
Precedence: list
Message: 6

Hello,

1. How to restrict users from reading files in a particular folder in
repository.

      Suppose I have 10 files in a folder ABC. Let there be 2 CVS users
"User1" and "User2". I wanted to know if it is possible for User1 to see
some chosen 5 of them and User2 to see some 2 of them. Access to files are
restricted at administrator level.
	
2. Is it possible for us to get a listing of repository files using WinCVS ?

    Can I get a listing of repository files to which i have access using
WinCVS without using "cvs ls -l -R".

If you need clarifications, Pls mail back.

Advanced Thanks,
Raghuraman.
------------------------------

Date: Thu, 24 Jul 2003 08:26:47 +0200
From: "Kevin" 
To: cvsnt@cvsnt.org
Subject: Re: [cvsnt] Re: Mergepoint question
Message-ID: 
References: 
Precedence: list
Message: 7

"Starrett, Glen (AZ15)"  wrote in message
news:mailman.106.1058975080.469.cvsnt@cvsnt.org...
> The better (or at least more detailed) steps of your scenario is:
>
> -- One users merges 1st of 2 branches
> -- When conflicts are resolved (if any), commit
> -- Same user merges 2nd of 2 branches
> -- When conflicts are resolved (if any), commit
> -- When a different user merges the branches, CVSNT sees the mergepoint
> entries in the log and merges correctly.

Just to make thing clear, this is what I meant:
- one user merges 1st of 2 branches and commits (after resolving any
conflicts)
- other developers update/develop/commit their changes on the branch they
are working on (hence both branches get newer revisions checked in)
- when a second user merges the 1st of the 2 branches a second time to
synchronize the branches again he will get the
conflicts of the first merge too (*** this will happen as the mergepoints
are committed in the first step --- see below ***)

>> Or is the mergepoint committed to the repository too?
> Yes, mergepoints are saved in the sandbox until committed and then to the
> server log once committed.

The scenario I was creating shall work fine as long as the mergepoints are
committed along with the merge.

Thanks for the reply, mergepoints are becoming clearer now and hopefully I
shall be making more use of them.

--
Kevin Agius



------------------------------

Date: Thu, 24 Jul 2003 10:40:10 GMT
From: bo.berglund@system3r.se (Bo Berglund)
To: cvsnt@cvsnt.org
Subject: [cvsnt] Re: Mergepoint question
Message-ID: <3f1ee0c8.87886003@news.cvsnt.org>
References: <3f18f417.62843363@news.cvsnt.org>
	
Precedence: list
Reply-To: bo.berglund@removethis.system3r.se
Message: 8

On Wed, 23 Jul 2003 09:25:11 +0200, "Kevin"  wrote:

>"Bo Berglund"  wrote in message
>news:3f18f417.62843363@news.cvsnt.org...
>> So instead I have made
>> some manual adjustments and committed this (basically just replacing
>> the HEAD code with the tip of the branch without merging anything).
>
>Can you give us some more details or a link about what is this and how to do
>it?
>
>--
>Kevin Agius
>HOB Software Ltd. (Malta)
>
Very simple, I just had two checked out copies of the project. One on
HEAD and one on the branch tip.
Then I copied all of the source files from the branch to the HEAD
sandbox overwriting whatever was there before.
Then I issued a cvs status command in the HEAD sandbox so cvs could
figure out which files had actually changed (the timestamps were
different so they all looked changed).
Then I commutted what was left as changed files.
Of course before all of this I put a tag in both TRUNK and Branch so I
could restore the situation if something went bad.
I had to do a followup action too, I had to add the files that were
now in the sandbox but not marked as being under version control.
These had been added on the branch.
There probably is a simple cvs command that does all of this
automatically (promoting the tip of the branch to become the new HEAD
revision), but I don't know this.


/Bo Berglund
------------------------------

_______________________________________________
cvsnt mailing list
cvsnt@cvsnt.org
http://www.cvsnt.org/cgi-bin/mailman/listinfo/cvsnt


End of cvsnt Digest, Vol 7, Issue 36
************************************

In the repository_database.xml file (or where ever you placed the
jdbc-connection-descriptor) is the platform attribute assigned
PostgreSQL or the default Hsqldb?


On Sat, 2003-08-16 at 10:31, CJacobME@aol.com wrote:
> Hi everyone,
> 
> I'm a newbee to OJB, and even my first try led into an exception. When I 
> tried to play tutorial #1, the first attempt to get some data from the databas
e 
> fired this exception:
> java.lang.AbstractMethodError: 
> org.postgresql.jdbc1.Jdbc1DatabaseMetaData.supportsBatchUpdates()Z
>     at 
> org.apache.ojb.broker.platforms.PlatformDefaultImpl.checkForBatchSupport(Platf
ormDefaultImpl.java:100)
>     at 
> org.apache.ojb.broker.platforms.PlatformDefaultImpl.initializeJdbcConnection(P
latformDefaultImpl.java:144)
>     at 
> org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.initializeJdbc
Connection(ConnectionFactoryAbstractImpl.java:137)
>     at 
> org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConnectionF
romDriverManager(ConnectionFactoryAbstractImpl.java:259)
>     at 
> org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ConPoolFactory.m
akeObject(ConnectionFactoryPooledImpl.java:205)
>     at 
> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.
java:710)
>     at 
> org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnectionFro
mPool(ConnectionFactoryPooledImpl.java:65)
>     at 
> org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnecti
on(ConnectionFactoryAbstractImpl.java:101)
>     at 
> org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Connecti
onManagerImpl.java:129)
>     at 
> org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Statem
entManager.java:673)
>     at 
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.j
ava:271)
>     at org.apache.ojb.broker.accesslayer.RsIterator.
> (RsIterator.java:199)
>     at 
> org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFa
ctoryImpl.java:95)
>     at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Persis
tenceBrokerImpl.java:2311)
>     at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Persiste
nceBrokerImpl.java:1657)
>     at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Persiste
nceBrokerImpl.java:1305)
>     at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Persiste
nceBrokerImpl.java:1460)
>     at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Persiste
nceBrokerImpl.java:1496)
>     at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Persiste
nceBrokerImpl.java:1485)
>     at 
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(De
legatingPersistenceBroker.java:302)
>     at 
> org.apache.ojb.tutorial1.UCListAllProducts.apply(UCListAllProducts.java:33)
>     at org.apache.ojb.tutorial1.Application.run(Application.java:91)
>     at org.apache.ojb.tutorial1.Application.main(Application.java:52)
> 
> I'm using PostgreSQL database on Suse Linux 8.0 and JDK 1.4, and AFAIK I'm 
> using the newest JDBC driver for PostgreSQL. So, I have no idea what went wron
g, 
> nor could I find some hints somewhere in the net. 
> 
> Can anybody help me?
> 
> Kind regards,
> Christian
-- 
Eli Anderson
Ecaent Development

Test L.Coman

mehr

Test L.Coman

mehr


Test L.Coman

mehr

Test L.Coman

Well, actually, under Tomcat, I wrote an InitContextListener which 
automagically figures out where the current webapp exists and sets a system 
property which is referenced in log4j.xml and,  viola!, the log files are 
placed in WEB-INF/logs of the current application no matter where it exists 
and without ever hardcoding the actual path.  Of course, this assumes you 
actually have write access to your webapp which is not guaranteed by the 
servlet spec.  In that case, your file appender will not work since it 
won't have a valid location to write to.

See the InitContextListener in the log4j-sandbox.  Instructions are in the 
javadoc.  See info and links here...
http://nagoya.apache.org/wiki/apachewiki.cgi?Log4JProjectPages/AppContainerLoggi
ng

Jake

At 08:35 PM 8/13/2003 +1000, you wrote:
>G'day,
>
>Ummmm, so basically then it is not possible to define a directory path in
>the log4j.xml properties file so that log files are placed relative to the
>web apps root directory?  Or for that matter relative to any known anchor
>point like the server root directory?
>
>A problem we have is that we deploy .war files by sending the package to the
>server gods who then drop it into the webapps directory.  Alas we don't have
>the rights to deploy directly to the server environment and tools like ANT
>whilst are good at building a distributable archive they do not quite make
>the grade when resolving tokens in a dynamic style of deployment.  Another
>issue we have is that most of the development work is done on a Windows
>based machine and the production servers are hosted on a flavor of Unix.
>Hard coding a directory path like "C:\..\" may work when doing the dev work
>under Windows but just don't kind of cut it on a Unix file system when it
>comes time to deployment.
>
>BTW, the last time I looked me was male so I'll opt out for king!
>
>AB
>
>-----Original Message-----
>From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
>Sent: Monday, 11 August 2003 11:14 PM
>To: Log4J Users List
>Subject: RE: Creating log files relative to the web applications root
>directory?
>
>
>
>Howdy,
>I suppose Adrian could be a woman's name as well, so you're right ;)
>
>
>But if you're the server admin, you're king (or queen) ;) 
>
>Yoav Shapira
>Millennium ChemInformatics
>
>
> >-----Original Message-----
> >From: Caroline Wood [mailto:Caroline.Wood@cpp.co.uk]
> >Sent: Monday, August 11, 2003 9:13 AM
> >To: 'Log4J Users List'
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >or Queen! lol ;)
> >
> >-----Original Message-----
> >From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
> >Sent: 11 August 2003 14:05
> >To: Log4J Users List; a.beech@bigpond.net.au
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >
> >
> >Howdy,
> >What I've seen done to achieve this is have my ant deployment script
> >fill the value when copying log4j.xml over.  So in log4j.xml, you'd
>have
> >
> >

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Well, actually, under Tomcat, I wrote an InitContextListener which 
automagically figures out where the current webapp exists and sets a system 
property which is referenced in log4j.xml and,  viola!, the log files are 
placed in WEB-INF/logs of the current application no matter where it exists 
and without ever hardcoding the actual path.  Of course, this assumes you 
actually have write access to your webapp which is not guaranteed by the 
servlet spec.  In that case, your file appender will not work since it 
won't have a valid location to write to.

See the InitContextListener in the log4j-sandbox.  Instructions are in the 
javadoc.  See info and links here...
http://nagoya.apache.org/wiki/apachewiki.cgi?Log4JProjectPages/AppContainerLoggi
ng

Jake

At 08:35 PM 8/13/2003 +1000, you wrote:
>G'day,
>
>Ummmm, so basically then it is not possible to define a directory path in
>the log4j.xml properties file so that log files are placed relative to the
>web apps root directory?  Or for that matter relative to any known anchor
>point like the server root directory?
>
>A problem we have is that we deploy .war files by sending the package to the
>server gods who then drop it into the webapps directory.  Alas we don't have
>the rights to deploy directly to the server environment and tools like ANT
>whilst are good at building a distributable archive they do not quite make
>the grade when resolving tokens in a dynamic style of deployment.  Another
>issue we have is that most of the development work is done on a Windows
>based machine and the production servers are hosted on a flavor of Unix.
>Hard coding a directory path like "C:\..\" may work when doing the dev work
>under Windows but just don't kind of cut it on a Unix file system when it
>comes time to deployment.
>
>BTW, the last time I looked me was male so I'll opt out for king!
>
>AB
>
>-----Original Message-----
>From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
>Sent: Monday, 11 August 2003 11:14 PM
>To: Log4J Users List
>Subject: RE: Creating log files relative to the web applications root
>directory?
>
>
>
>Howdy,
>I suppose Adrian could be a woman's name as well, so you're right ;)
>
>
>But if you're the server admin, you're king (or queen) ;) 
>
>Yoav Shapira
>Millennium ChemInformatics
>
>
> >-----Original Message-----
> >From: Caroline Wood [mailto:Caroline.Wood@cpp.co.uk]
> >Sent: Monday, August 11, 2003 9:13 AM
> >To: 'Log4J Users List'
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >or Queen! lol ;)
> >
> >-----Original Message-----
> >From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
> >Sent: 11 August 2003 14:05
> >To: Log4J Users List; a.beech@bigpond.net.au
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >
> >
> >Howdy,
> >What I've seen done to achieve this is have my ant deployment script
> >fill the value when copying log4j.xml over.  So in log4j.xml, you'd
>have
> >
> >

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Test L.Coman

mehr

Test L.Coman

mehr


Test L.Coman

mehr

Test L.Coman

Well, actually, under Tomcat, I wrote an InitContextListener which 
automagically figures out where the current webapp exists and sets a system 
property which is referenced in log4j.xml and,  viola!, the log files are 
placed in WEB-INF/logs of the current application no matter where it exists 
and without ever hardcoding the actual path.  Of course, this assumes you 
actually have write access to your webapp which is not guaranteed by the 
servlet spec.  In that case, your file appender will not work since it 
won't have a valid location to write to.

See the InitContextListener in the log4j-sandbox.  Instructions are in the 
javadoc.  See info and links here...
http://nagoya.apache.org/wiki/apachewiki.cgi?Log4JProjectPages/AppContainerLoggi
ng

Jake

At 08:35 PM 8/13/2003 +1000, you wrote:
>G'day,
>
>Ummmm, so basically then it is not possible to define a directory path in
>the log4j.xml properties file so that log files are placed relative to the
>web apps root directory?  Or for that matter relative to any known anchor
>point like the server root directory?
>
>A problem we have is that we deploy .war files by sending the package to the
>server gods who then drop it into the webapps directory.  Alas we don't have
>the rights to deploy directly to the server environment and tools like ANT
>whilst are good at building a distributable archive they do not quite make
>the grade when resolving tokens in a dynamic style of deployment.  Another
>issue we have is that most of the development work is done on a Windows
>based machine and the production servers are hosted on a flavor of Unix.
>Hard coding a directory path like "C:\..\" may work when doing the dev work
>under Windows but just don't kind of cut it on a Unix file system when it
>comes time to deployment.
>
>BTW, the last time I looked me was male so I'll opt out for king!
>
>AB
>
>-----Original Message-----
>From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
>Sent: Monday, 11 August 2003 11:14 PM
>To: Log4J Users List
>Subject: RE: Creating log files relative to the web applications root
>directory?
>
>
>
>Howdy,
>I suppose Adrian could be a woman's name as well, so you're right ;)
>
>
>But if you're the server admin, you're king (or queen) ;) 
>
>Yoav Shapira
>Millennium ChemInformatics
>
>
> >-----Original Message-----
> >From: Caroline Wood [mailto:Caroline.Wood@cpp.co.uk]
> >Sent: Monday, August 11, 2003 9:13 AM
> >To: 'Log4J Users List'
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >or Queen! lol ;)
> >
> >-----Original Message-----
> >From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
> >Sent: 11 August 2003 14:05
> >To: Log4J Users List; a.beech@bigpond.net.au
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >
> >
> >Howdy,
> >What I've seen done to achieve this is have my ant deployment script
> >fill the value when copying log4j.xml over.  So in log4j.xml, you'd
>have
> >
> >

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

1234

12345

123232AAAAAAAAAAAAAAAA

AAAA

12345

AAA

12345

123232AAAAAAAAAAAAAAAA

Well, actually, under Tomcat, I wrote an InitContextListener which 
automagically figures out where the current webapp exists and sets a system 
property which is referenced in log4j.xml and,  viola!, the log files are 
placed in WEB-INF/logs of the current application no matter where it exists 
and without ever hardcoding the actual path.  Of course, this assumes you 
actually have write access to your webapp which is not guaranteed by the 
servlet spec.  In that case, your file appender will not work since it 
won't have a valid location to write to.

See the InitContextListener in the log4j-sandbox.  Instructions are in the 
javadoc.  See info and links here...
http://nagoya.apache.org/wiki/apachewiki.cgi?Log4JProjectPages/AppContainerLoggi
ng

Jake

At 08:35 PM 8/13/2003 +1000, you wrote:
>G'day,
>
>Ummmm, so basically then it is not possible to define a directory path in
>the log4j.xml properties file so that log files are placed relative to the
>web apps root directory?  Or for that matter relative to any known anchor
>point like the server root directory?
>
>A problem we have is that we deploy .war files by sending the package to the
>server gods who then drop it into the webapps directory.  Alas we don't have
>the rights to deploy directly to the server environment and tools like ANT
>whilst are good at building a distributable archive they do not quite make
>the grade when resolving tokens in a dynamic style of deployment.  Another
>issue we have is that most of the development work is done on a Windows
>based machine and the production servers are hosted on a flavor of Unix.
>Hard coding a directory path like "C:\..\" may work when doing the dev work
>under Windows but just don't kind of cut it on a Unix file system when it
>comes time to deployment.
>
>BTW, the last time I looked me was male so I'll opt out for king!
>
>AB
>
>-----Original Message-----
>From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
>Sent: Monday, 11 August 2003 11:14 PM
>To: Log4J Users List
>Subject: RE: Creating log files relative to the web applications root
>directory?
>
>
>
>Howdy,
>I suppose Adrian could be a woman's name as well, so you're right ;)
>
>
>But if you're the server admin, you're king (or queen) ;) 
>
>Yoav Shapira
>Millennium ChemInformatics
>
>
> >-----Original Message-----
> >From: Caroline Wood [mailto:Caroline.Wood@cpp.co.uk]
> >Sent: Monday, August 11, 2003 9:13 AM
> >To: 'Log4J Users List'
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >or Queen! lol ;)
> >
> >-----Original Message-----
> >From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
> >Sent: 11 August 2003 14:05
> >To: Log4J Users List; a.beech@bigpond.net.au
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >
> >
> >Howdy,
> >What I've seen done to achieve this is have my ant deployment script
> >fill the value when copying log4j.xml over.  So in log4j.xml, you'd
>have
> >
> >

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Well, actually, under Tomcat, I wrote an InitContextListener which 
automagically figures out where the current webapp exists and sets a system 
property which is referenced in log4j.xml and,  viola!, the log files are 
placed in WEB-INF/logs of the current application no matter where it exists 
and without ever hardcoding the actual path.  Of course, this assumes you 
actually have write access to your webapp which is not guaranteed by the 
servlet spec.  In that case, your file appender will not work since it 
won't have a valid location to write to.

See the InitContextListener in the log4j-sandbox.  Instructions are in the 
javadoc.  See info and links here...
http://nagoya.apache.org/wiki/apachewiki.cgi?Log4JProjectPages/AppContainerLoggi
ng

Jake

At 08:35 PM 8/13/2003 +1000, you wrote:
>G'day,
>
>Ummmm, so basically then it is not possible to define a directory path in
>the log4j.xml properties file so that log files are placed relative to the
>web apps root directory?  Or for that matter relative to any known anchor
>point like the server root directory?
>
>A problem we have is that we deploy .war files by sending the package to the
>server gods who then drop it into the webapps directory.  Alas we don't have
>the rights to deploy directly to the server environment and tools like ANT
>whilst are good at building a distributable archive they do not quite make
>the grade when resolving tokens in a dynamic style of deployment.  Another
>issue we have is that most of the development work is done on a Windows
>based machine and the production servers are hosted on a flavor of Unix.
>Hard coding a directory path like "C:\..\" may work when doing the dev work
>under Windows but just don't kind of cut it on a Unix file system when it
>comes time to deployment.
>
>BTW, the last time I looked me was male so I'll opt out for king!
>
>AB
>
>-----Original Message-----
>From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
>Sent: Monday, 11 August 2003 11:14 PM
>To: Log4J Users List
>Subject: RE: Creating log files relative to the web applications root
>directory?
>
>
>
>Howdy,
>I suppose Adrian could be a woman's name as well, so you're right ;)
>
>
>But if you're the server admin, you're king (or queen) ;) 
>
>Yoav Shapira
>Millennium ChemInformatics
>
>
> >-----Original Message-----
> >From: Caroline Wood [mailto:Caroline.Wood@cpp.co.uk]
> >Sent: Monday, August 11, 2003 9:13 AM
> >To: 'Log4J Users List'
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >or Queen! lol ;)
> >
> >-----Original Message-----
> >From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
> >Sent: 11 August 2003 14:05
> >To: Log4J Users List; a.beech@bigpond.net.au
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >
> >
> >Howdy,
> >What I've seen done to achieve this is have my ant deployment script
> >fill the value when copying log4j.xml over.  So in log4j.xml, you'd
>have
> >
> >

21322312

12313

BA-1

Textbausteine

Key

Nr.

Typ

Kurzbezeichnung

AAA

12345

TESTMB

Test L.Coman

mehr

Test L.Coman

mehr


Test L.Coman

mehr

Test L.Coman

AAAA

12345

AAA

Hello OJB-Users!

I have problems to store objects larger than 2000 bytes into a BLOB or 
VARBINARY with an Oracle database.
If I run the BlobTest program with a size larger than 2000 bytes, the 
byte array is not stored without any error message.
Everything works fine with 2000 bytes or less.

Infos:
ojb version is 1.0-rc4
ORACLE RDBMS Version: 9.2.0.1.0
JDBC ojdbc14.jar (thin)

What is wrong?

Bye, Marcus




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

AAAAAAA

12345

!!!!!

[DBConnection] query(pst): 274036
[22.05.03 06:11:03.553] HCAU44: DEBUG ARSF_DATA FOR SF_ID=77128
[22.05.03 06:11:03.553] HCAU44: DEBUG [DBConnection] query(pst): 4321831
[22.05.03 06:11:03.553] HCAU44: DEBUG GRU2_ID=11
[22.05.03 06:11:03.553] HCAU44: DEBUG [DBConnection] query(pst): 1760951
[22.05.03 06:11:03.553] HCAU44: DEBUG GRU2_ID=11
[22.05.03 06:11:03.553] HCAU44: DEBUG [DBConnection] query(pst): 2285943
[22.05.03 06:11:03.553] HCAU44: DEBUG ANZ_ANLAGEN FOR SF_ID=77128
[22.05.03 06:11:03.553] HCAU44: DEBUG [DBConnection] query(pst): 3676828
[22.05.03 06:11:03.553] HCAU44: DEBUG NOTIZ FOR SF_ID=77128 AND FIRM_ID=2
[22.05.03 06:11:03.553] HCAU44: DEBUG [DBConnection] query(pst): 2483807
[22.05.03 06:11:03.568] HCAU44: DEBUG FIRM_DATA FOR FIRM_ID=2
[22.05.03 06:11:03.568] HCAU44: DEBUG [DBConnection] query(pst): 274036
[22.05.03 06:11:03.568] HCAU44: DEBUG ARSF_DATA FOR SF_ID=76631
[22.05.03 06:11:03.568] HCAU44: DEBUG [DBConnection] query(pst): 4321831
[22.05.03 06:11:03.568] HCAU44: DEBUG GRU2_ID=500
[22.05.03 06:11:03.568] HCAU44: DEBUG [DBConnection] query(pst): 1760951
[22.05.03 06:11:03.568] HCAU44: DEBUG GRU2_ID=500
[22.05.03 06:11:03.568] HCAU44: DEBUG [DBConnection] query(pst): 2285943
[22.05.03 06:11:03.584] HCAU44: DEBUG ANZ_ANLAGEN FOR SF_ID=76631
[22.05.03 06:11:03.584] HCAU44: DEBUG [DBConnection] query(pst): 3676828
[22.05.03 06:11:03.584] HCAU44: DEBUG NOTIZ FOR SF_ID=76631 AND FIRM_ID=2
[22.05.03 06:11:03.584] HCAU44: DEBUG [DBConnection] query(pst): 2483807
[22.05.03 06:11:03.584] HCAU44: DEBUG FIRM_DATA FOR FIRM_ID=2
[22.05.03 06:11:03.584] HCAU44: DEBUG [DBConnection] query(pst): 274036
[22.05.03 06:11:03.584] HCAU44: DEBUG ARSF_DATA FOR SF_ID=76614
[22.05.03 06:11:03.584] HCAU44: DEBUG [DBConnection] query(pst): 4321831
[22.05.03 06:11:03.584] HCAU44: DEBUG GRU2_ID=101
[22.05.03 06:11:03.584] HCAU44: DEBUG [DBConnection] query(pst): 1760951
[22.05.03 06:11:03.584] HCAU44: DEBUG GRU2_ID=101
[22.05.03 06:11:03.584] HCAU44: DEBUG [DBConnection] query(pst): 2285943
[22.05.03 06:11:03.584] HCAU44: DEBUG ANZ_ANLAGEN FOR SF_ID=76614
[22.05.03 06:11:03.584] HCAU44: DEBUG [DBConnection] query(pst): 3676828
[22.05.03 06:11:03.584] HCAU44: DEBUG NOTIZ FOR SF_ID=76614 AND FIRM_ID=2
[22.05.03 06:11:03.584] HCAU44: DEBUG [DBConnection] query(pst): 2483807
[22.05.03 06:11:03.584] HCAU44: DEBUG FIRM_DATA FOR FIRM_ID=2
[22.05.03 06:11:03.584] HCAU44: DEBUG [DBConnection] query(pst): 274036
[22.05.03 06:11:03.584] HCAU44: DEBUG ARSF_DATA FOR SF_ID=76612
[22.05.03 06:11:03.584] HCAU44: DEBUG [DBConnection] query(pst): 4321831
[22.05.03 06:11:03.600] HCAU44: DEBUG GRU2_ID=105
[22.05.03 06:11:03.600] HCAU44: DEBUG [DBConnection] query(pst): 1760951
[22.05.03 06:11:03.600] HCAU44: DEBUG GRU2_ID=105
[22.05.03 06:11:03.600] HCAU44: DEBUG [DBConnection] query(pst): 2285943
[22.05.03 06:11:03.600] HCAU44: DEBUG ANZ_ANLAGEN FOR SF_ID=76612
[22.05.03 06:11:03.600] HCAU44: DEBUG [DBConnection] query(pst): 3676828
[22.05.03 06:11:03.600] HCAU44: DEBUG NOTIZ FOR SF_ID=76612 AND FIRM_ID=2
[22.05.03 06:11:03.600] HCAU44: DEBUG [DBConnection] query(pst): 2483807
[22.05.03 06:11:03.600] HCAU44: DEBUG FIRM_DATA FOR FIRM_ID=2
[22.05.03 06:11:03.600] HCAU44: DEBUG [DBConnection] query(pst): 274036
[22.05.03 06:11:03.600] HCAU44: DEBUG ARSF_DATA FOR SF_ID=74878
[22.05.03 06:11:03.600] HCAU44: DEBUG [DBConnection] query(pst): 4321831
[22.05.03 06:11:03.600] HCAU44: DEBUG GRU2_ID=10
[22.05.03 06:11:03.600] HCAU44: DEBUG [DBConnection] query(pst): 1760951
[22.05.03 06:11:03.600] HCAU44: DEBUG GRU2_ID=10
[22.05.03 06:11:03.600] HCAU44: DEBUG [DBConnection] query(pst): 2285943
[22.05.03 06:11:03.615] HCAU44: DEBUG ANZ_ANLAGEN FOR SF_ID=74878
[22.05.03 06:11:03.615] HCAU44: DEBUG [DBConnection] query(pst): 3676828
[22.05.03 06:11:03.615] HCAU44: DEBUG NOTIZ FOR SF_ID=74878 AND FIRM_ID=2
[22.05.03 06:11:03.615] HCAU44: DEBUG [DBConnection] query(pst): 2483807
[22.05.03 06:11:03.615] HCAU44: DEBUG FIRM_DATA FOR FIRM_ID=2
[22.05.03 06:11:03.615] HCAU44: DEBUG [DBConnection] query(pst): 274036
[22.05.03 06:11:03.615] HCAU44: DEBUG ARSF_DATA FOR SF_ID=65838
[22.05.03 06:11:03.615] HCAU44: DEBUG [DBConnection] query(pst): 4321831
[22.05.03 06:11:03.615] HCAU44: DEBUG GRU2_ID=10
[22.05.03 06:11:03.615] HCAU44: DEBUG [DBConnection] query(pst): 1760951
[22.05.03 06:11:03.615] HCAU44: DEBUG GRU2_ID=10
[22.05.03 06:11:03.615] HCAU44: DEBUG [DBConnection] query(pst): 2285943
[22.05.03 06:11:03.615] HCAU44: DEBUG ANZ_ANLAGEN FOR SF_ID=65838
[22.05.03 06:11:03.615] HCAU44: DEBUG [DBConnection] query(pst): 3676828
[22.05.03 06:11:03.615] HCAU44: DEBUG NOTIZ FOR SF_ID=65838 AND FIRM_ID=2
[22.05.03 06:11:03.615] HCAU44: DEBUG [DBConnection] query(pst): 2483807
[22.05.03 06:11:03.615] HCAU44: DEBUG FIRM_DATA FOR FIRM_ID=2
[22.05.03 06:11:03.631] HCAU44: DEBUG [DBConnection] query(pst): 274036
[22.05.03 06:11:03.631] HCAU44: DEBUG ARSF_DATA FOR SF_ID=64101
[22.05.03 06:11:03.631] HCAU44: DEBUG [DBConnection] query(pst): 4321831
[22.05.03 06:11:03.631] HCAU44: DEBUG GRU2_ID=500
[22.05.03 06:11:03.631] HCAU44: DEBUG [DBConnection] query(pst): 1760951
[22.05.03 06:11:03.631] HCAU44: DEBUG GRU2_ID=500
[22.05.03 06:11:03.631] HCAU44: DEBUG [DBConnection] query(pst): 2285943
[22.05.03 06:11:03.631] HCAU44: DEBUG ANZ_ANLAGEN FOR SF_ID=64101
[22.05.03 06:11:03.631] HCAU44: DEBUG [DBConnection] query(pst): 3676828
[22.05.03 06:11:03.631] HCAU44: DEBUG NOTIZ FOR SF_ID=64101 AND FIRM_ID=2
[22.05.03 06:11:03.631] HCAU44: DEBUG [DBConnection] query(pst): 2483807
[22.05.03 06:11:03.631] HCAU44: DEBUG FIRM_DATA FOR FIRM_ID=2
[22.05.03 06:11:03.631] HCAU44: DEBUG [DBConnection] query(pst): 274036
[22.05.03 06:11:03.631] HCAU44: DEBUG ARSF_DATA FOR SF_ID=67775
[22.05.03 06:11:03.631] HCAU44: DEBUG [DBConnection] query(pst): 4321831
[22.05.03 06:11:03.631] HCAU44: DEBUG GRU2_ID=580
[22.05.03 06:11:03.631] HCAU44: DEBUG [DBConnection] query(pst): 1760951
[22.05.03 06:11:03.631] HCAU44: DEBUG GRU2_ID=580
[22.05.03 06:11:03.631] HCAU44: DEBUG [DBConnection] query(pst): 2285943
[22.05.03 06:11:03.647] HCAU44: DEBUG ANZ_ANLAGEN FOR SF_ID=67775
[22.05.03 06:11:03.647] HCAU44: DEBUG [DBConnection] query(pst): 3676828
[22.05.03 06:11:03.647] HCAU44: DEBUG NOTIZ FOR SF_ID=67775 AND FIRM_ID=2
[22.05.03 06:11:03.647] HCAU44: DEBUG [DBConnection] query(pst): 2483807
[22.05.03 06:11:03.647] HCAU44: DEBUG FIRM_DATA FOR FIRM_ID=2
[22.05.03 06:11:03.647] HCAU44: DEBUG [DBConnection] query(pst): 274036
[22.05.03 06:11:03.647] HCAU44: DEBUG ARSF_DATA FOR SF_ID=65837
[22.05.03 06:11:03.647] HCAU44: DEBUG [DBConnection] query(pst): 4321831
[22.05.03 06:11:03.647] HCAU44: DEBUG GRU2_ID=11
[22.05.03 06:11:03.647] HCAU44: DEBUG [DBConnection] query(pst): 1760951
[22.05.03 06:11:03.647] HCAU44: DEBUG GRU2_ID=11
[22.05.03 06:11:03.647] HCAU44: DEBUG [DBConnection] query(pst): 2285943
[22.05.03 06:11:03.647] HCAU44: DEBUG ANZ_ANLAGEN FOR SF_ID=65837
[22.05.03 06:11:03.647] HCAU44: DEBUG [DBConnection] query(pst): 3676828
[22.05.03 06:11:03.647] HCAU44: DEBUG NOTIZ FOR SF_ID=65837 AND FIRM_ID=2
[22.05.03 06:11:03.647] HCAU44: DEBUG [DBConnection] query(pst): 2483807
[22.05.03 06:11:03.647] HCAU44: DEBUG FIRM_DATA FOR FIRM_ID=2
[22.05.03 06:11:03.647] HCAU44: DEBUG [DBConnection] query(pst): 274036
[22.05.03 06:11:03.662] HCAU44: DEBUG ARSF_DATA FOR SF_ID=33207
[22.05.03 06:11:03.662] HCAU44: DEBUG [DBConnection] query(pst): 4321831
[22.05.03 06:11:03.662] HCAU44: DEBUG GRU2_ID=500
[22.05.03 06:11:03.662] HCAU44: DEBUG [DBConnection] query(pst): 1760951
[22.05.03 06:11:03.662] HCAU44: DEBUG GRU2_ID=500
[22.05.03 06:11:03.662] HCAU44: DEBUG [DBConnection] query(pst): 2285943
[22.05.03 06:11:03.662] HCAU44: DEBUG ANZ_ANLAGEN FOR SF_ID=33207
[22.05.03 06:11:03.662] HCAU44: DEBUG [DBConnection] query(pst): 3676828
[22.05.03 06:11:03.662] HCAU44: DEBUG NOTIZ FOR SF_ID=33207 AND FIRM_ID=2
[22.05.03 06:11:03.662] HCAU44: DEBUG [DBConnection] query(pst): 2483807
[22.05.03 06:11:03.662] HCAU44: DEBUG FIRM_DATA FOR FIRM_ID=2
[22.05.03 06:11:03.662] HCAU44: DEBUG [DBConnection] query(pst): 274036
[22.05.03 06:11:03.662] HCAU44: DEBUG ARSF_DATA FOR SF_ID=32866
[22.05.03 06:11:03.662] HCAU44: DEBUG [DBConnection] query(pst): 4321831
[22.05.03 06:11:03.662] HCAU44: DEBUG GRU2_ID=500
[22.05.03 06:11:03.662] HCAU44: DEBUG [DBConnection] query(pst): 1760951
[22.05.03 06:11:03.662] HCAU44: DEBUG GRU2_ID=500
[22.05.03 06:11:03.662] HCAU44: DEBUG [DBConnection] query(pst): 2285943
[22.05.03 06:11:03.662] HCAU44: DEBUG ANZ_ANLAGEN FOR SF_ID=32866
[22.05.03 06:11:03.662] HCAU44: DEBUG [DBConnection] query(pst): 3676828
[22.05.03 06:11:03.678] HCAU44: DEBUG NOTIZ FOR SF_ID=32866 AND FIRM_ID=2
[22.05.03 06:11:03.678] HCAU44: DEBUG [DBConnection] query(pst): 2483807
[22.05.03 06:11:03.678] HCAU44: DEBUG [DBConnection] Closed traced statement(123
256)
[22.05.03 06:11:03.678] HCAU44: DEBUG [DBConnection] Closed traced statement(793
0258)
[22.05.03 06:11:03.678] HCAU44: DEBUG [DBConnection] Closed traced statement(367
6828)
[22.05.03 06:11:03.725] HCAU44: DEBUG [DBConnection] Closed traced statement(248
3807)
[22.05.03 06:11:03.725] HCAU44: DEBUG [DBConnection] Closed traced statement(176
0951)
[22.05.03 06:11:03.725] HCAU44: DEBUG [DBConnection] Closed traced statement(228
5943)
[22.05.03 06:11:03.725] HCAU44: DEBUG [DBConnection] Closed traced statement(274
036)
[22.05.03 06:11:03.725] HCAU44: DEBUG [DBConnection] Closed traced statement(432
1831)
[22.05.03 06:11:03.725] HCAU44: DEBUG [DBConnection] Commit transaction on conne
ction(3674522)
[22.05.03 06:11:03.725] HCAU44: DEBUG [DBConnection] Closed connection(3674522)
[22.05.03 06:11:05.350] HCAU44: LOG   [GLOB] getSpracheResource(US): enter
[22.05.03 06:11:05.350] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
0)=DE
[22.05.03 06:11:05.350] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
1)=EN
[22.05.03 06:11:05.350] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
2)=ES
[22.05.03 06:11:05.350] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
3)=IT
[22.05.03 06:11:05.350] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
4)=PO
[22.05.03 06:11:05.350] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
5)=US
[22.05.03 06:11:05.350] HCAU44: LOG   [GLOB] getSpracheResource(US): exit: Langu
age supported!
[22.05.03 06:11:05.365] HCAU44: DEBUG [DBConnection] connection(3674522) is okay
[22.05.03 06:11:05.365] HCAU44: DEBUG [DBConnection] query(SQL): traced st 73475
38
[22.05.03 06:11:05.365] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT  HOTL.H
OTL_ID, HOTL.HOTL_BEZ_US  FROM HOTL, V_PROFIL_HOTL   WHERE HOTL.HOTL_AKTIV = 1  
  AND HOTL.HOTL_ID = V_PROFIL_HOTL.HOTL_ID    AND V_PROFIL_HOTL.FIRM_ID = 2  ORD
ER BY HOTL.HOTL_ID 
[22.05.03 06:11:05.381] HCAU44: DEBUG [DBConnection] query(SQL): traced st 20525
6
[22.05.03 06:11:05.381] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT GRU1.GR
U1_ID, GRU1.GRU1_BEZ_US  FROM GRU1, V_PROFIL_HOTL   WHERE V_PROFIL_HOTL.HOTL_ID 
= GRU1.HOTL_ID    AND FIRM_ID = 2   AND GRU1.HOTL_ID = 51  ORDER BY GRU1.GRU1_BE
Z_US
[22.05.03 06:11:05.381] HCAU44: DEBUG [DBConnection] query(SQL): traced st 67017
4
[22.05.03 06:11:05.381] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT GRU2.GR
U2_ID, GRU2.GRU2_BEZ_US  FROM GRU1, GRU2, V_PROFIL_HOTL   WHERE GRU1.GRU1_ID = G
RU2.GRU1_ID    AND V_PROFIL_HOTL.HOTL_ID = GRU1.HOTL_ID    AND GRU2.GRU1_ID = 0 
  AND FIRM_ID = 2   AND GRU1.HOTL_ID = 51  ORDER BY GRU2.GRU2_BEZ_US
[22.05.03 06:11:05.381] HCAU44: DEBUG [DBConnection] query(SQL): traced st 13543
06
[22.05.03 06:11:05.381] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT count(S
F.SF_ID) AS Anzahl  FROM SF, V_PROFIL_HOTL, GRU1, GRU2  WHERE (V_PROFIL_HOTL.HOT
L_ID = SF.HOTL_ID         OR (V_PROFIL_HOTL.HOTL_ID = SF.HOTL_ID             AND
 V_PROFIL_HOTL.FIRM_ID = 2             AND V_PROFIL_HOTL.HOTL_ID = 100))   AND V
_PROFIL_HOTL.FIRM_ID = 2  AND SF.GRU1_ID = GRU1.GRU1_ID (+)   AND SF.GRU2_ID = G
RU2.GRU2_ID (+)  AND  (SF_BEARBEITET_SENDER_ID = 2 OR   SF_BEARBEITET_LEVEL1_ID 
= 2 OR   SF_BEARBEITET_LEVEL2_ID = 2 OR   SF_BEARBEITET_LEVEL3_ID = 2 OR   SF_M4
4_BEARBEITET_LEVEL4_ID = 2 )  AND SF.HOTL_ID = 51 AND (SF_STATUS_SENDER = 'Z' AN
D SF.FIRM_ID = 2 OR  SF_STATUS_LEVEL1 = 'Z' AND SF_LEVEL1_FIRM_ID = 2 OR  SF_STA
TUS_LEVEL2 = 'Z' AND SF_LEVEL2_FIRM_ID = 2 OR  SF_STATUS_LEVEL3 = 'Z' AND SF_LEV
EL3_FIRM_ID = 2 OR  SF_M44_STATUS_LEVEL4 = 'Z' AND SF_M44_LEVEL4_FIRM_ID = 2 ) 
[22.05.03 06:11:06.334] HCAU44: LOG   [GLOB] getSpracheResource(US): enter
[22.05.03 06:11:06.334] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
0)=DE
[22.05.03 06:11:06.334] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
1)=EN
[22.05.03 06:11:06.334] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
2)=ES
[22.05.03 06:11:06.334] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
3)=IT
[22.05.03 06:11:06.334] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
4)=PO
[22.05.03 06:11:06.334] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
5)=US
[22.05.03 06:11:06.334] HCAU44: LOG   [GLOB] getSpracheResource(US): exit: Langu
age supported!
[22.05.03 06:11:06.350] HCAU44: DEBUG [DBConnection] connection(3360326) is okay
[22.05.03 06:11:06.350] HCAU44: DEBUG [DBConnection] query(SQL): traced st 35836
19
[22.05.03 06:11:06.350] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT * FROM 
HOTL, V_PROFIL_HOTL  WHERE HOTL.HOTL_AKTIV = 1 AND HOTL.HOTL_ID = V_PROFIL_HOTL.
HOTL_ID AND V_PROFIL_HOTL.FIRM_ID = 2 ORDER BY HOTL.HOTL_ID 
[22.05.03 06:11:06.350] HCAU44: DEBUG [DBConnection] query(SQL): traced st 73006
3
[22.05.03 06:11:06.350] HCAU44: DEBUG [DBConnection] query(SQL): SELECT count(*)
 AS ANZAHL FROM SF WHERE FIRM_ID = 2 AND SF_STATUS_SENDER = 'E'
[22.05.03 06:11:06.490] HCAU44: DEBUG [DBConnection] Closed traced statement(358
3619)
[22.05.03 06:11:06.490] HCAU44: DEBUG [DBConnection] Closed traced statement(730
063)
[22.05.03 06:11:06.506] HCAU44: DEBUG [DBConnection] Commit transaction on conne
ction(3360326)
[22.05.03 06:11:06.506] HCAU44: DEBUG [DBConnection] Closed connection(3360326)
[22.05.03 06:11:06.897] HCAU44: DEBUG [DBConnection] query(SQL): traced st 74939
91
[22.05.03 06:11:06.897] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT COUNT(*
) AS ANZAHL   FROM FIRM_EMPF   WHERE EMPF_ID = 2   AND EMPF_ART_ID = 9
[22.05.03 06:11:06.897] HCAU44: DEBUG [DBConnection] query(SQL): traced st 72002
07
[22.05.03 06:11:06.897] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT BEKZ_FR
EIGABE_FIRMENARCHIV, BEKZ_FREIGABE_WISSENSDATENBANK   FROM BEKZ   WHERE BEKZ_KZ 
= 'W'
[22.05.03 06:11:06.897] HCAU44: DEBUG [DBConnection] query(SQL): traced st 15662
29
[22.05.03 06:11:06.897] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT COUNT(*
) AS ANZAHL   FROM FIRM_EMPF   WHERE FIRM_ID = 2   AND EMPF_ART_ID = 1
[22.05.03 06:11:06.897] HCAU44: DEBUG [DBConnection] Closed traced statement(734
7538)
[22.05.03 06:11:06.897] HCAU44: DEBUG [DBConnection] Closed traced statement(205
256)
[22.05.03 06:11:06.897] HCAU44: DEBUG [DBConnection] Closed traced statement(670
174)
[22.05.03 06:11:06.912] HCAU44: DEBUG [DBConnection] Closed traced statement(135
4306)
[22.05.03 06:11:06.912] HCAU44: DEBUG [DBConnection] Closed traced statement(749
3991)
[22.05.03 06:11:06.912] HCAU44: DEBUG [DBConnection] Closed traced statement(720
0207)
[22.05.03 06:11:06.912] HCAU44: DEBUG [DBConnection] Closed traced statement(156
6229)
[22.05.03 06:11:06.912] HCAU44: DEBUG [DBConnection] Commit transaction on conne
ction(3674522)
[22.05.03 06:11:06.912] HCAU44: DEBUG [DBConnection] Closed connection(3674522)
[22.05.03 06:11:08.709] HCAU44: DEBUG [DBConnection] finalize cleanup
[22.05.03 06:11:09.615] HCAU44: LOG   [GLOB] getSpracheResource(US): enter
[22.05.03 06:11:09.615] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
0)=DE
[22.05.03 06:11:09.615] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
1)=EN
[22.05.03 06:11:09.615] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
2)=ES
[22.05.03 06:11:09.615] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
3)=IT
[22.05.03 06:11:09.615] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
4)=PO
[22.05.03 06:11:09.615] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
5)=US
[22.05.03 06:11:09.615] HCAU44: LOG   [GLOB] getSpracheResource(US): exit: Langu
age supported!
[22.05.03 06:11:09.615] HCAU44: DEBUG [DBConnection] connection(3674522) is okay
[22.05.03 06:11:09.631] HCAU44: DEBUG [DBConnection] Start transaction on connec
tion(3674522)
[22.05.03 06:11:09.631] HCAU44: DEBUG [DBConnection] query(SQL): traced st 24861
31
[22.05.03 06:11:09.631] HCAU44: DEBUG [DBConnection] query(SQL): SELECT MAX(SF_I
D) AS MaxId FROM SF
[22.05.03 06:11:09.631] HCAU44: DEBUG [DBConnection] execute(SQL): INSERT INTO S
F (SF_ID, PERS_ID, FIRM_ID, HOTL_ID, GRU1_ID, GRU2_ID, GRU3_ID, SF_ERLEDIGT_KZ, 
SF_LEVEL1_URSPRUNG_FIRM_ID, SF_ERSTELLT_AM, SF_ERSTELLT_VON) VALUES (77269, 2, 2
, 51, 0, 0, 0, '0', 0, '22.05.2003 18:11:09', 'S. Haendler')
[22.05.03 06:11:09.631] HCAU44: DEBUG [DBConnection] execute(SQL): created st 72
22090
[22.05.03 06:11:09.631] HCAU44: DEBUG [DBConnection] query(SQL): executed st 722
2090
[22.05.03 06:11:09.631] HCAU44: DEBUG [DBConnection] query(SQL): closed st 72220
90
[22.05.03 06:11:09.631] HCAU44: DEBUG [DBConnection] query(SQL): traced st 68956
09
[22.05.03 06:11:09.631] HCAU44: DEBUG [DBConnection] query(SQL): SELECT MAX(SF_I
D) AS MaxId FROM SF
[22.05.03 06:11:09.647] HCAU44: DEBUG [DBConnection] Commit transaction on conne
ction(3674522)
[22.05.03 06:11:09.647] HCAU44: DEBUG [DBConnection] Closed traced statement(248
6131)
[22.05.03 06:11:09.647] HCAU44: DEBUG [DBConnection] Closed traced statement(689
5609)
[22.05.03 06:11:09.647] HCAU44: DEBUG [DBConnection] Commit transaction on conne
ction(3674522)
[22.05.03 06:11:09.647] HCAU44: DEBUG [DBConnection] Closed connection(3674522)
[22.05.03 06:11:09.725] HCAU44: DEBUG [DBConnection] finalize cleanup
[22.05.03 06:11:12.428] HCAU44: LOG   [GLOB] getSpracheResource(US): enter
[22.05.03 06:11:12.428] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
0)=DE
[22.05.03 06:11:12.428] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
1)=EN
[22.05.03 06:11:12.428] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
2)=ES
[22.05.03 06:11:12.428] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
3)=IT
[22.05.03 06:11:12.428] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
4)=PO
[22.05.03 06:11:12.428] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
5)=US
[22.05.03 06:11:12.428] HCAU44: LOG   [GLOB] getSpracheResource(US): exit: Langu
age supported!
[22.05.03 06:11:12.459] HCAU44: DEBUG [DBConnection] connection(3674522) is okay
[22.05.03 06:11:12.459] HCAU44: DEBUG [DBConnection] query(SQL): traced st 32777
21
[22.05.03 06:11:12.459] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT * FROM 
SF, PERS, FIRM  WHERE SF.PERS_ID = PERS.PERS_ID AND PERS.FIRM_ID = FIRM.FIRM_ID 
 AND SF.SF_ID = 77269
[22.05.03 06:11:12.475] HCAU44: DEBUG [DBConnection] query(SQL): traced st 71701
91
[22.05.03 06:11:12.475] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT * FROM 
HOTL WHERE HOTL_ID = 51
[22.05.03 06:11:12.490] HCAU44: DEBUG [DBConnection] query(SQL): traced st 80171
50
[22.05.03 06:11:12.490] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT COUNT (
*) AS ANZAHL FROM ANLG WHERE ANLG_INTERN <> '1' AND SF_ID = 77269
[22.05.03 06:11:12.490] HCAU44: DEBUG [DBConnection] query(SQL): traced st 45159
28
[22.05.03 06:11:12.490] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT COUNT (
*) AS ANZAHL FROM ANLG, SF WHERE ANLG.SF_ID = SF.SF_ID AND ANLG.SF_ID = 77269 AN
D ANLG_INTERN = '1' AND  (SF.FIRM_ID = 2 OR   SF_LEVEL1_FIRM_ID = 2 OR   SF_LEVE
L2_FIRM_ID = 2 OR   SF_LEVEL3_FIRM_ID = 2 OR   SF_M44_LEVEL4_FIRM_ID = 2 ) 
[22.05.03 06:11:12.490] HCAU44: DEBUG [DBConnection] query(SQL): traced st 18042
78
[22.05.03 06:11:12.490] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT COUNT (
*) AS ANZAHL FROM NOTIZ WHERE SF_ID = 77269 AND FIRM_ID = 2
[22.05.03 06:11:12.506] HCAU44: DEBUG [DBConnection] Closed traced statement(327
7721)
[22.05.03 06:11:12.506] HCAU44: DEBUG [DBConnection] Closed traced statement(717
0191)
[22.05.03 06:11:12.506] HCAU44: DEBUG [DBConnection] Closed traced statement(801
7150)
[22.05.03 06:11:12.506] HCAU44: DEBUG [DBConnection] Closed traced statement(451
5928)
[22.05.03 06:11:12.506] HCAU44: DEBUG [DBConnection] Closed traced statement(180
4278)
[22.05.03 06:11:12.506] HCAU44: DEBUG [DBConnection] Commit transaction on conne
ction(3674522)
[22.05.03 06:11:12.506] HCAU44: DEBUG [DBConnection] Closed connection(3674522)
[22.05.03 06:11:12.834] HCAU44: DEBUG [DBConnection] finalize cleanup
[22.05.03 06:11:12.912] HCAU44: LOG   [GLOB] getSpracheResource(US): enter
[22.05.03 06:11:12.912] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
0)=DE
[22.05.03 06:11:12.912] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
1)=EN
[22.05.03 06:11:12.912] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
2)=ES
[22.05.03 06:11:12.912] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
3)=IT
[22.05.03 06:11:12.912] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
4)=PO
[22.05.03 06:11:12.912] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
5)=US
[22.05.03 06:11:12.912] HCAU44: LOG   [GLOB] getSpracheResource(US): exit: Langu
age supported!
[22.05.03 06:11:12.912] HCAU44: DEBUG [DBConnection] connection(3674522) is okay
[22.05.03 06:11:12.912] HCAU44: DEBUG [DBConnection] query(SQL): traced st 53729
30
[22.05.03 06:11:12.912] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT * FROM 
SF, PERS, FIRM  WHERE SF.PERS_ID = PERS.PERS_ID AND PERS.FIRM_ID = FIRM.FIRM_ID 
 AND SF.SF_ID = 77269
[22.05.03 06:11:12.928] HCAU44: DEBUG [DBConnection] query(SQL): traced st 21348
[22.05.03 06:11:12.928] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT * FROM 
FZGM ORDER BY FZGM_MODELL ASC
[22.05.03 06:11:12.928] HCAU44: DEBUG [DBConnection] query(SQL): traced st 46238
3
[22.05.03 06:11:12.928] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT *  FROM
 HOTL WHERE HOTL_ID = 51
[22.05.03 06:11:12.928] HCAU44: DEBUG [DBConnection] query(SQL): traced st 17816
79
[22.05.03 06:11:12.928] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT GRU1_ID
, GRU1_BEZ_US FROM GRU1, V_FIRM_HOTL  WHERE GRU1.HOTL_ID = V_FIRM_HOTL.HOTL_ID A
ND FIRM_ID = 2 AND GRU1.HOTL_ID = 51 ORDER BY GRU1_ID
[22.05.03 06:11:12.943] HCAU44: DEBUG [DBConnection] query(SQL): traced st 52651
18
[22.05.03 06:11:12.943] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT COUNT(*
) AS ANZAHL FROM WFZG WHERE SF_ID = 77269
[22.05.03 06:11:12.943] HCAU44: DEBUG [DBConnection] query(SQL): traced st 74638
35
[22.05.03 06:11:12.943] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT SYMP_ID
, SYMP_BEZ  FROM SYMP ORDER BY SYMP_ID 
[22.05.03 06:11:12.943] HCAU44: DEBUG [DBConnection] query(SQL): traced st 22132
50
[22.05.03 06:11:12.943] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT * FROM 
COA1 ORDER BY COA1_ID 
[22.05.03 06:11:12.943] HCAU44: DEBUG [DBConnection] query(SQL): traced st 46653
3
[22.05.03 06:11:12.943] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT * FROM 
COA2 ORDER BY COA2_ID 
[22.05.03 06:11:12.959] HCAU44: DEBUG [DBConnection] query(SQL): traced st 62331
60
[22.05.03 06:11:12.959] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT * FROM 
COB1 ORDER BY COB1_ID 
[22.05.03 06:11:12.959] HCAU44: DEBUG [DBConnection] query(SQL): traced st 47464
61
[22.05.03 06:11:12.959] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT * FROM 
COB2 ORDER BY COB2_ID 
[22.05.03 06:11:12.959] HCAU44: DEBUG [DBConnection] query(SQL): traced st 14654
1
[22.05.03 06:11:12.959] HCAU44: DEBUG [DBConnection] query(SQL): SELECT * FROM C
OA3 WHERE COA1_ID = 0 AND COA2_ID = 0
[22.05.03 06:11:12.975] HCAU44: DEBUG [DBConnection] query(SQL): traced st 31633
59
[22.05.03 06:11:12.975] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT *  FROM
 GRU2  WHERE GRU1_ID = 0 AND GRU2_ID != 0  ORDER BY GRU2_ID 
[22.05.03 06:11:12.975] HCAU44: DEBUG [DBConnection] Closed traced statement(537
2930)
[22.05.03 06:11:12.975] HCAU44: DEBUG [DBConnection] Closed traced statement(213
48)
[22.05.03 06:11:12.975] HCAU44: DEBUG [DBConnection] Closed traced statement(462
383)
[22.05.03 06:11:12.975] HCAU44: DEBUG [DBConnection] Closed traced statement(178
1679)
[22.05.03 06:11:12.975] HCAU44: DEBUG [DBConnection] Closed traced statement(526
5118)
[22.05.03 06:11:12.975] HCAU44: DEBUG [DBConnection] Closed traced statement(746
3835)
[22.05.03 06:11:12.975] HCAU44: DEBUG [DBConnection] Closed traced statement(221
3250)
[22.05.03 06:11:12.975] HCAU44: DEBUG [DBConnection] Closed traced statement(466
533)
[22.05.03 06:11:12.975] HCAU44: DEBUG [DBConnection] Closed traced statement(623
3160)
[22.05.03 06:11:12.975] HCAU44: DEBUG [DBConnection] Closed traced statement(474
6461)
[22.05.03 06:11:12.975] HCAU44: DEBUG [DBConnection] Closed traced statement(146
541)
[22.05.03 06:11:12.975] HCAU44: DEBUG [DBConnection] Closed traced statement(316
3359)
[22.05.03 06:11:12.990] HCAU44: DEBUG [DBConnection] Commit transaction on conne
ction(3674522)
[22.05.03 06:11:12.990] HCAU44: DEBUG [DBConnection] Closed connection(3674522)
[22.05.03 06:11:13.084] HCAU44: DEBUG [DBConnection] finalize cleanup
[22.05.03 06:11:26.147] HCAU44: LOG   [GLOB] getSpracheResource(US): enter
[22.05.03 06:11:26.147] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
0)=DE
[22.05.03 06:11:26.147] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
1)=EN
[22.05.03 06:11:26.147] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
2)=ES
[22.05.03 06:11:26.147] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
3)=IT
[22.05.03 06:11:26.147] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
4)=PO
[22.05.03 06:11:26.147] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
5)=US
[22.05.03 06:11:26.147] HCAU44: LOG   [GLOB] getSpracheResource(US): exit: Langu
age supported!
[22.05.03 06:11:33.678] HCAU44: DEBUG [DBConnection] connection(3674522) is okay
[22.05.03 06:11:33.678] HCAU44: DEBUG [DBConnection] query(SQL): traced st 69768
41
[22.05.03 06:11:33.678] HCAU44: DEBUG [DBConnection] query(SQL): select COUNT(*)
 AS ANZAHL FROM PERS WHERE UPPER(PERS_USERNAME) LIKE 'LEVEL1' and UPPER(PERS_PAS
SWORT) LIKE 'LEVEL1'
[22.05.03 06:11:33.740] HCAU44: DEBUG [DBConnection] query(SQL): traced st 55451
95
[22.05.03 06:11:33.740] HCAU44: DEBUG [DBConnection] query(SQL): select PERS_ID,
 FIRM.FIRM_ID, FIRM_NAME, FIRM_BETRIEBSKZ, FIRM_KZ3, FIRM_KZ5, PERS_NAME, PERS_V
ORNAME, PERS_USERNAME, PERS_STATUS, PERS_DEFAULT_HOTLINE AS HOTLINE, PERS_DEFAUL
T_GRUPPE1 AS GRUPPE1, PERS_DEFAULT_GRUPPE2 AS GRUPPE2, PERS_EMAIL FROM PERS, FIR
M WHERE PERS.FIRM_ID = FIRM.FIRM_ID AND UPPER(PERS_USERNAME) LIKE 'LEVEL1' and U
PPER(PERS_PASSWORT) LIKE 'LEVEL1' GROUP BY PERS_ID, FIRM.FIRM_ID, FIRM_NAME, FIR
M_BETRIEBSKZ, FIRM_KZ3, FIRM_KZ5, PERS_NAME, PERS_VORNAME, PERS_USERNAME, PERS_S
TATUS, PERS_DEFAULT_HOTLINE, PERS_DEFAULT_GRUPPE1, PERS_DEFAULT_GRUPPE2, PERS_EM
AIL
[22.05.03 06:11:33.834] HCAU44: DEBUG [DBConnection] query(SQL): traced st 14624
86
[22.05.03 06:11:33.834] HCAU44: DEBUG [DBConnection] query(SQL): SELECT COUNT(*)
 AS ANZAHL FROM FIRM_EMPF WHERE EMPF_ID = 3 AND (EMPF_ART_ID = 1 OR EMPF_ART_ID 
= 2 OR EMPF_ART_ID = 3 OR EMPF_ART_ID = 9)
[22.05.03 06:11:33.850] HCAU44: DEBUG [DBConnection] query(SQL): traced st 46077
04
[22.05.03 06:11:33.850] HCAU44: DEBUG [DBConnection] query(SQL): SELECT COUNT(*)
 AS ANZAHL FROM FIRM_EMPF WHERE EMPF_ID = 3 AND EMPF_ART_ID = 1 
[22.05.03 06:11:33.850] HCAU44: DEBUG [DBConnection] Closed traced statement(697
6841)
[22.05.03 06:11:33.850] HCAU44: DEBUG [DBConnection] Closed traced statement(554
5195)
[22.05.03 06:11:33.850] HCAU44: DEBUG [DBConnection] Closed traced statement(146
2486)
[22.05.03 06:11:33.850] HCAU44: DEBUG [DBConnection] Closed traced statement(460
7704)
[22.05.03 06:11:33.850] HCAU44: DEBUG [DBConnection] Commit transaction on conne
ction(3674522)
[22.05.03 06:11:33.850] HCAU44: DEBUG [DBConnection] Closed connection(3674522)
[22.05.03 06:11:33.865] HCAU44: LOG   [GLOB] getSpracheResource(US): enter
[22.05.03 06:11:33.865] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
0)=DE
[22.05.03 06:11:33.865] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
1)=EN
[22.05.03 06:11:33.865] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
2)=ES
[22.05.03 06:11:33.865] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
3)=IT
[22.05.03 06:11:33.865] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
4)=PO
[22.05.03 06:11:33.865] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
5)=US
[22.05.03 06:11:33.865] HCAU44: LOG   [GLOB] getSpracheResource(US): exit: Langu
age supported!
[22.05.03 06:11:33.865] HCAU44: LOG   [GLOB] getSpracheResource(US): enter
[22.05.03 06:11:33.865] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
0)=DE
[22.05.03 06:11:33.865] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
1)=EN
[22.05.03 06:11:33.865] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
2)=ES
[22.05.03 06:11:33.865] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
3)=IT
[22.05.03 06:11:33.865] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
4)=PO
[22.05.03 06:11:33.865] HCAU44: DEBUG [GLOB] getSpracheResource(US): appSprache(
5)=US
[22.05.03 06:11:33.865] HCAU44: LOG   [GLOB] getSpracheResource(US): exit: Langu
age supported!
[22.05.03 06:11:33.865] HCAU44: DEBUG [DBConnection] connection(3674522) is okay
[22.05.03 06:11:33.881] HCAU44: DEBUG [DBConnection] query(SQL): traced st 46507
9
[22.05.03 06:11:33.881] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT  HOTL.H
OTL_ID, HOTL.HOTL_BEZ_US  FROM HOTL, V_PROFIL_HOTL   WHERE HOTL.HOTL_AKTIV = 1  
  AND HOTL.HOTL_ID = V_PROFIL_HOTL.HOTL_ID    AND V_PROFIL_HOTL.FIRM_ID = 3  ORD
ER BY HOTL.HOTL_ID 
[22.05.03 06:11:33.881] HCAU44: DEBUG [DBConnection] query(SQL): traced st 16443
99
[22.05.03 06:11:33.881] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT GRU1.GR
U1_ID, GRU1.GRU1_BEZ_US  FROM GRU1, V_PROFIL_HOTL   WHERE V_PROFIL_HOTL.HOTL_ID 
= GRU1.HOTL_ID    AND FIRM_ID = 3   AND GRU1.HOTL_ID = 0  ORDER BY GRU1.GRU1_BEZ
_US
[22.05.03 06:11:33.881] HCAU44: DEBUG [DBConnection] connection(3360326) is okay
[22.05.03 06:11:33.881] HCAU44: DEBUG [DBConnection] query(SQL): traced st 42293
91
[22.05.03 06:11:33.881] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT GRU2.GR
U2_ID, GRU2.GRU2_BEZ_US  FROM GRU1, GRU2, V_PROFIL_HOTL   WHERE GRU1.GRU1_ID = G
RU2.GRU1_ID    AND V_PROFIL_HOTL.HOTL_ID = GRU1.HOTL_ID    AND GRU2.GRU1_ID = 0 
  AND FIRM_ID = 3   AND GRU1.HOTL_ID = 0  ORDER BY GRU2.GRU2_BEZ_US
[22.05.03 06:11:33.881] HCAU44: DEBUG [DBConnection] query(SQL): traced st 20849
62
[22.05.03 06:11:33.881] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT SF.SF_I
D, SF.GRU1_ID, SF.GRU2_ID, SF.FIRM_ID,         SF_FGNR, SF_KUNDE,         decode
(sf_bearbeitet_am,                null,                 substr(sf_erstellt_am,7,
4) ||                 substr(sf_erstellt_am,4,2) ||                 substr(sf_er
stellt_am,1,2) ||                 substr(sf_erstellt_am,12,2) ||                
 substr(sf_erstellt_am,15,2) ||                 substr(sf_erstellt_am,18,2)     
         ,                 substr(sf_bearbeitet_am,7,4) ||                 subst
r(sf_bearbeitet_am,4,2) ||                 substr(sf_bearbeitet_am,1,2) ||      
           substr(sf_bearbeitet_am,12,2) ||                 substr(sf_bearbeitet
_am,15,2) ||                 substr(sf_bearbeitet_am,18,2)) AS Sortierung,      
    substr(sf_erstellt_am,7,4) ||          substr(sf_erstellt_am,4,2) ||        
  substr(sf_erstellt_am,1,2) ||          substr(sf_erstellt_am,12,2) ||         
 substr(sf_erstellt_am,15,2) ||          substr(sf_erstellt_am,18,2) AS Sortieru
ng1,          DECODE(TO_NUMBER(TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')) -          
       TO_NUMBER(substr(SF_REAKTIONSZEIT_DIALOG,7,4) ||                         
  substr(SF_REAKTIONSZEIT_DIALOG,4,2) ||                           substr(SF_REA
KTIONSZEIT_DIALOG,1,2) ||                           substr(SF_REAKTIONSZEIT_DIAL
OG,12,2) ||                           substr(SF_REAKTIONSZEIT_DIALOG,15,2) ||   
                        substr(SF_REAKTIONSZEIT_DIALOG,18,2))                 , 
                NULL, -1000000000000,                  TO_NUMBER(TO_CHAR(SYSDATE
, 'YYYYMMDDHH24MISS')) -                  TO_NUMBER(substr(SF_REAKTIONSZEIT_DIAL
OG,7,4) ||                            substr(SF_REAKTIONSZEIT_DIALOG,4,2) ||    
                        substr(SF_REAKTIONSZEIT_DIALOG,1,2) ||                  
          substr(SF_REAKTIONSZEIT_DIALOG,12,2) ||                            sub
str(SF_REAKTIONSZEIT_DIALOG,15,2) ||                            substr(SF_REAKTI
ONSZEIT_DIALOG,18,2))) As Rot  FROM SF, V_PROFIL_HOTL, V_PERS_FIRM, GRU1, GRU2  
WHERE (V_PROFIL_HOTL.HOTL_ID = SF.HOTL_ID         OR (V_PROFIL_HOTL.HOTL_ID = SF
.HOTL_ID             AND V_PROFIL_HOTL.FIRM_ID = 3            AND V_PROFIL_HOTL.
HOTL_ID = 100))   AND V_PROFIL_HOTL.FIRM_ID = 3  AND SF.PERS_ID = V_PERS_FIRM.PE
RS_ID   AND SF.GRU1_ID = GRU1.GRU1_ID (+)   AND SF.GRU2_ID = GRU2.GRU2_ID (+)   
AND (SF_STATUS_SENDER = 'E' AND SF.FIRM_ID = 3 OR        SF_STATUS_LEVEL1 = 'E' 
AND SF_LEVEL1_FIRM_ID = 3 OR        SF_STATUS_LEVEL2 = 'E' AND SF_LEVEL2_FIRM_ID
 = 3 OR        SF_STATUS_LEVEL3 = 'E' AND SF_LEVEL3_FIRM_ID = 3 OR        SF_M44
_STATUS_LEVEL4 = 'E' AND SF_M44_LEVEL4_FIRM_ID = 3 )  GROUP BY    SF.SF_ID, SF.G
RU1_ID, SF.GRU2_ID, SF.FIRM_ID,  SF_FGNR, SF_KUNDE,    SF_ERSTELLT_AM, SF_BEARBE
ITET_AM,  SF_REAKTIONSZEIT_DIALOG order by Sortierung desc 
[22.05.03 06:11:33.881] HCAU44: DEBUG [DBConnection] query(SQL): traced st 27260
87
[22.05.03 06:11:33.881] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT count(S
F.SF_ID) AS Anzahl   FROM SF   WHERE SF_ID IN     (SELECT SF.SF_ID       FROM PE
RS_GRU, SF, V_PROFIL_HOTL, GRU1, GRU2       WHERE (V_PROFIL_HOTL.HOTL_ID = SF.HO
TL_ID              OR (V_PROFIL_HOTL.HOTL_ID = SF.HOTL_ID                  AND V
_PROFIL_HOTL.FIRM_ID = 3                  AND V_PROFIL_HOTL.HOTL_ID = 100))     
   AND V_PROFIL_HOTL.FIRM_ID = 3       AND SF.GRU1_ID = GRU1.GRU1_ID (+)        
AND SF.GRU2_ID = GRU2.GRU2_ID (+)        AND PERS_GRU.PERS_ID = 3       AND SF.G
RU1_ID = PERS_GRU.GRU1_ID        AND SF.GRU2_ID = PERS_GRU.GRU2_ID  AND (SF_STAT
US_SENDER = 'Z' AND SF.FIRM_ID = 3 OR  SF_STATUS_LEVEL1 = 'Z' AND SF_LEVEL1_FIRM
_ID = 3 OR  SF_STATUS_LEVEL2 = 'Z' AND SF_LEVEL2_FIRM_ID = 3 OR  SF_STATUS_LEVEL
3 = 'Z' AND SF_LEVEL3_FIRM_ID = 3 OR  SF_M44_STATUS_LEVEL4 = 'Z' AND SF_M44_LEVE
L4_FIRM_ID = 3 )  UNION  SELECT SF.SF_ID   FROM PERS_FZGM, FZGM, SF, V_PROFIL_HO
TL, GRU1, GRU2   WHERE V_PROFIL_HOTL.HOTL_ID = SF.HOTL_ID    AND V_PROFIL_HOTL.F
IRM_ID = 3   AND SF.GRU1_ID = GRU1.GRU1_ID (+)    AND SF.GRU2_ID = GRU2.GRU2_ID 
(+)    AND PERS_FZGM.PERS_ID = 3   AND FZGM.FZGM_ID = PERS_FZGM.FZGM_ID    AND U
PPER(SF.SF_FZGMODELL) = UPPER(FZGM.FZGM_MODELL)  AND (SF_STATUS_SENDER = 'Z' AND
 SF.FIRM_ID = 3 OR  SF_STATUS_LEVEL1 = 'Z' AND SF_LEVEL1_FIRM_ID = 3 OR  SF_STAT
US_LEVEL2 = 'Z' AND SF_LEVEL2_FIRM_ID = 3 OR  SF_STATUS_LEVEL3 = 'Z' AND SF_LEVE
L3_FIRM_ID = 3 OR  SF_M44_STATUS_LEVEL4 = 'Z' AND SF_M44_LEVEL4_FIRM_ID = 3 ) )
[22.05.03 06:11:35.334] HCAU44: DEBUG [DBConnection] query(SQL): traced st 70501
81
[22.05.03 06:11:35.334] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT COUNT(*
) AS ANZAHL   FROM FIRM_EMPF   WHERE EMPF_ID = 3   AND EMPF_ART_ID = 9
[22.05.03 06:11:35.334] HCAU44: DEBUG [DBConnection] query(SQL): traced st 63776
27
[22.05.03 06:11:35.334] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT BEKZ_FR
EIGABE_FIRMENARCHIV, BEKZ_FREIGABE_WISSENSDATENBANK   FROM BEKZ   WHERE BEKZ_KZ 
= 'A'
[22.05.03 06:11:35.334] HCAU44: DEBUG [DBConnection] query(SQL): traced st 12244
84
[22.05.03 06:11:35.334] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT COUNT(*
) AS ANZAHL   FROM FIRM_EMPF   WHERE FIRM_ID = 3   AND EMPF_ART_ID = 1
[22.05.03 06:11:35.334] HCAU44: DEBUG [DBConnection] query(SQL): traced st 37991
79
[22.05.03 06:11:35.334] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT count(*
) AS Anzahl  FROM ARSF, PERS, FIRM, V_PROFIL_HOTL  WHERE ARSF.PERS_ID = PERS.PER
S_ID   AND PERS.FIRM_ID = FIRM.FIRM_ID   AND V_PROFIL_HOTL.HOTL_ID = ARSF.HOTL_I
D   AND V_PROFIL_HOTL.FIRM_ID = 3  AND ARSF_FREIGABE_ARCHIV = 0  AND  (SF_BEARBE
ITET_SENDER_ID = 3 OR   SF_BEARBEITET_LEVEL1_ID = 3 OR   SF_BEARBEITET_LEVEL2_ID
 = 3 OR   SF_BEARBEITET_LEVEL3_ID = 3 OR   ARSF_BEARBEITET_VON_ID = 3)
[22.05.03 06:11:35.818] HCAU44: DEBUG [DBConnection] Closed traced statement(465
079)
[22.05.03 06:11:35.818] HCAU44: DEBUG [DBConnection] Closed traced statement(164
4399)
[22.05.03 06:11:35.818] HCAU44: DEBUG [DBConnection] Closed traced statement(422
9391)
[22.05.03 06:11:35.818] HCAU44: DEBUG [DBConnection] Closed traced statement(272
6087)
[22.05.03 06:11:35.818] HCAU44: DEBUG [DBConnection] Closed traced statement(705
0181)
[22.05.03 06:11:35.818] HCAU44: DEBUG [DBConnection] Closed traced statement(637
7627)
[22.05.03 06:11:35.818] HCAU44: DEBUG [DBConnection] Closed traced statement(122
4484)
[22.05.03 06:11:35.818] HCAU44: DEBUG [DBConnection] Closed traced statement(379
9179)
[22.05.03 06:11:35.818] HCAU44: DEBUG [DBConnection] Commit transaction on conne
ction(3674522)
[22.05.03 06:11:35.818] HCAU44: DEBUG [DBConnection] Closed connection(3674522)
[22.05.03 06:11:36.006] HCAU44: DEBUG [DBConnection] query(SQL): traced st 54336
97
[22.05.03 06:11:36.006] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT *   FRO
M FZGM   ORDER BY FZGM_MODELL ASC
[22.05.03 06:11:36.006] HCAU44: DEBUG [DBConnection] prepareStatement: SELECT AN
Z_ANLAGEN FROM V_ANLAGEN WHERE SF_ID=?
[22.05.03 06:11:36.006] HCAU44: DEBUG [DBConnection] prepareStament: returned 35
75310
[22.05.03 06:11:36.006] HCAU44: DEBUG [DBConnection] prepareStatement: SELECT NO
TIZ_BESCHREIBUNG FROM NOTIZ WHERE SF_ID=? AND FIRM_ID=?
[22.05.03 06:11:36.006] HCAU44: DEBUG [DBConnection] prepareStament: returned 83
02342
[22.05.03 06:11:36.006] HCAU44: DEBUG [DBConnection] prepareStatement: SELECT GR
U1_BEZ_US FROM GRU1 WHERE GRU1_ID=?
[22.05.03 06:11:36.006] HCAU44: DEBUG [DBConnection] prepareStament: returned 45
47269
[22.05.03 06:11:36.006] HCAU44: DEBUG [DBConnection] prepareStatement: SELECT GR
U2_BEZ_US FROM GRU2 WHERE GRU2_ID=?
[22.05.03 06:11:36.022] HCAU44: DEBUG [DBConnection] prepareStament: returned 25
03106
[22.05.03 06:11:36.022] HCAU44: DEBUG [DBConnection] prepareStatement: SELECT FI
RM_REGIONSNR, FIRM_NAME, FIRM_BETRIEBSKZ, FIRM_BETRIEBSNR1  FROM FIRM WHERE FIRM
_ID=?
[22.05.03 06:11:36.022] HCAU44: DEBUG [DBConnection] prepareStament: returned 36
90197
[22.05.03 06:11:36.022] HCAU44: DEBUG [DBConnection] prepareStatement: SELECT SF
_M44, SF_LEVEL1_BESITZ_ID, SF_STATUS_ANSTEHEND, SF_STATUS_SENDER,  SF_STATUS_LEV
EL1, SF_STATUS_LEVEL2, SF_STATUS_LEVEL3, SF_LEVEL1_FIRM_ID,  SF_LEVEL2_FIRM_ID, 
SF_LEVEL3_FIRM_ID, SF_LIEGENBLEIBER, SF_MELDEPFLICHT,  SF_BEANSTANDUNG, SF_FZGMO
DELL, SF_FZGTYP,  SF_BEARBEITET_SENDER_VON, SF_BEARBEITET_SENDER_AM,  SF_BEARBEI
TET_LEVEL1_VON, SF_BEARBEITET_LEVEL1_AM,  SF_REAKTIONSZEIT, SF_REAKTIONSZEIT_DIA
LOG, SF.HOTL_ID,  SF_VERBR_STUETZPUNKT_L2, SF_SAP_NR1, SF_SAP_NR2, SF_SAP_NR3,  
SF_SAP_NR4, SF_SAP_NR5, SF_POS1, SF_POS2, SF_POS3, SF_POS4, SF_POS5,  SF_FGNR2, 
SF_FGNR3, SF_FGNR4, SF_FGNR5, SF_ERSTELLT_AM,  SF_BEARBEITET_AM, SF_TEILENR  FRO
M SF WHERE SF_ID=?
[22.05.03 06:11:36.022] HCAU44: DEBUG [DBConnection] prepareStament: returned 36
06088
[22.05.03 06:11:36.022] HCAU44: DEBUG [DBConnection] Closed traced statement(208
4962)
[22.05.03 06:11:36.022] HCAU44: DEBUG [DBConnection] Closed traced statement(543
3697)
[22.05.03 06:11:36.022] HCAU44: DEBUG [DBConnection] Closed traced statement(357
5310)
[22.05.03 06:11:36.022] HCAU44: DEBUG [DBConnection] Closed traced statement(830
2342)
[22.05.03 06:11:36.022] HCAU44: DEBUG [DBConnection] Closed traced statement(454
7269)
[22.05.03 06:11:36.022] HCAU44: DEBUG [DBConnection] Closed traced statement(250
3106)
[22.05.03 06:11:36.022] HCAU44: DEBUG [DBConnection] Closed traced statement(369
0197)
[22.05.03 06:11:36.022] HCAU44: DEBUG [DBConnection] Closed traced statement(360
6088)
[22.05.03 06:11:36.022] HCAU44: DEBUG [DBConnection] Commit transaction on conne
ction(3360326)
[22.05.03 06:11:36.022] HCAU44: DEBUG [DBConnection] Closed connection(3360326)
[22.05.03 06:11:36.553] HCAU44: DEBUG [DBConnection] finalize cleanup
[22.05.03 06:11:36.553] HCAU44: DEBUG [DBConnection] finalize cleanup
[22.05.03 06:11:36.553] HCAU44: DEBUG [DBConnection] finalize cleanup
[22.05.03 06:11:38.303] HCAU44: LOG   [GLOB] getSpracheResource(DE): enter
[22.05.03 06:11:38.303] HCAU44: DEBUG [GLOB] getSpracheResource(DE): appSprache(
0)=DE
[22.05.03 06:11:38.303] HCAU44: LOG   [GLOB] getSpracheResource(DE): exit: Langu
age supported!
[22.05.03 06:11:46.115] HCAU44: DEBUG [DBConnection] connection(3360326) is okay
[22.05.03 06:11:46.115] HCAU44: DEBUG [DBConnection] query(SQL): traced st 30524
47
[22.05.03 06:11:46.115] HCAU44: DEBUG [DBConnection] query(SQL): select COUNT(*)
 AS ANZAHL FROM PERS WHERE UPPER(PERS_USERNAME) LIKE 'HAENDLER' and UPPER(PERS_P
ASSWORT) LIKE 'HAENDLER'
[22.05.03 06:11:46.193] HCAU44: DEBUG [DBConnection] query(SQL): traced st 58423
68
[22.05.03 06:11:46.193] HCAU44: DEBUG [DBConnection] query(SQL): select PERS_ID,
 FIRM.FIRM_ID, FIRM_NAME, FIRM_BETRIEBSKZ, FIRM_KZ3, FIRM_KZ5, PERS_NAME, PERS_V
ORNAME, PERS_USERNAME, PERS_STATUS, PERS_DEFAULT_HOTLINE AS HOTLINE, PERS_DEFAUL
T_GRUPPE1 AS GRUPPE1, PERS_DEFAULT_GRUPPE2 AS GRUPPE2, PERS_EMAIL FROM PERS, FIR
M WHERE PERS.FIRM_ID = FIRM.FIRM_ID AND UPPER(PERS_USERNAME) LIKE 'HAENDLER' and
 UPPER(PERS_PASSWORT) LIKE 'HAENDLER' GROUP BY PERS_ID, FIRM.FIRM_ID, FIRM_NAME,
 FIRM_BETRIEBSKZ, FIRM_KZ3, FIRM_KZ5, PERS_NAME, PERS_VORNAME, PERS_USERNAME, PE
RS_STATUS, PERS_DEFAULT_HOTLINE, PERS_DEFAULT_GRUPPE1, PERS_DEFAULT_GRUPPE2, PER
S_EMAIL
[22.05.03 06:11:46.287] HCAU44: DEBUG [DBConnection] query(SQL): traced st 29446
32
[22.05.03 06:11:46.287] HCAU44: DEBUG [DBConnection] query(SQL): SELECT COUNT(*)
 AS ANZAHL FROM FIRM_EMPF WHERE EMPF_ID = 2 AND (EMPF_ART_ID = 1 OR EMPF_ART_ID 
= 2 OR EMPF_ART_ID = 3 OR EMPF_ART_ID = 9)
[22.05.03 06:11:46.287] HCAU44: DEBUG [DBConnection] query(SQL): traced st 64486
42
[22.05.03 06:11:46.287] HCAU44: DEBUG [DBConnection] query(SQL): SELECT COUNT(*)
 AS ANZAHL FROM FIRM_EMPF WHERE EMPF_ID = 2 AND EMPF_ART_ID = 1 
[22.05.03 06:11:46.287] HCAU44: DEBUG [DBConnection] Closed traced statement(305
2447)
[22.05.03 06:11:46.287] HCAU44: DEBUG [DBConnection] Closed traced statement(584
2368)
[22.05.03 06:11:46.287] HCAU44: DEBUG [DBConnection] Closed traced statement(294
4632)
[22.05.03 06:11:46.287] HCAU44: DEBUG [DBConnection] Closed traced statement(644
8642)
[22.05.03 06:11:46.287] HCAU44: DEBUG [DBConnection] Commit transaction on conne
ction(3360326)
[22.05.03 06:11:46.287] HCAU44: DEBUG [DBConnection] Closed connection(3360326)
[22.05.03 06:11:46.303] HCAU44: LOG   [GLOB] getSpracheResource(DE): enter
[22.05.03 06:11:46.303] HCAU44: DEBUG [GLOB] getSpracheResource(DE): appSprache(
0)=DE
[22.05.03 06:11:46.303] HCAU44: LOG   [GLOB] getSpracheResource(DE): exit: Langu
age supported!
[22.05.03 06:11:46.318] HCAU44: LOG   [GLOB] getSpracheResource(DE): enter
[22.05.03 06:11:46.318] HCAU44: DEBUG [GLOB] getSpracheResource(DE): appSprache(
0)=DE
[22.05.03 06:11:46.318] HCAU44: LOG   [GLOB] getSpracheResource(DE): exit: Langu
age supported!
[22.05.03 06:11:46.318] HCAU44: DEBUG [DBConnection] connection(3360326) is okay
[22.05.03 06:11:46.318] HCAU44: DEBUG [DBConnection] query(SQL): traced st 19404
93
[22.05.03 06:11:46.318] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT  HOTL.H
OTL_ID, HOTL.HOTL_BEZ_DE  FROM HOTL, V_PROFIL_HOTL   WHERE HOTL.HOTL_AKTIV = 1  
  AND HOTL.HOTL_ID = V_PROFIL_HOTL.HOTL_ID    AND V_PROFIL_HOTL.FIRM_ID = 2  ORD
ER BY HOTL.HOTL_ID 
[22.05.03 06:11:46.318] HCAU44: DEBUG [DBConnection] connection(3674522) is okay
[22.05.03 06:11:46.334] HCAU44: DEBUG [DBConnection] query(SQL): traced st 37890
77
[22.05.03 06:11:46.334] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT GRU1.GR
U1_ID, GRU1.GRU1_BEZ_DE  FROM GRU1, V_PROFIL_HOTL   WHERE V_PROFIL_HOTL.HOTL_ID 
= GRU1.HOTL_ID    AND FIRM_ID = 2   AND GRU1.HOTL_ID = 51  ORDER BY GRU1.GRU1_BE
Z_DE
[22.05.03 06:11:46.334] HCAU44: DEBUG [DBConnection] query(SQL): traced st 25347
3
[22.05.03 06:11:46.334] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT SF.SF_I
D, SF.GRU1_ID, SF.GRU2_ID, SF.FIRM_ID,         SF_FGNR, SF_KUNDE,         decode
(sf_bearbeitet_am,                null,                 substr(sf_erstellt_am,7,
4) ||                 substr(sf_erstellt_am,4,2) ||                 substr(sf_er
stellt_am,1,2) ||                 substr(sf_erstellt_am,12,2) ||                
 substr(sf_erstellt_am,15,2) ||                 substr(sf_erstellt_am,18,2)     
         ,                 substr(sf_bearbeitet_am,7,4) ||                 subst
r(sf_bearbeitet_am,4,2) ||                 substr(sf_bearbeitet_am,1,2) ||      
           substr(sf_bearbeitet_am,12,2) ||                 substr(sf_bearbeitet
_am,15,2) ||                 substr(sf_bearbeitet_am,18,2)) AS Sortierung,      
    substr(sf_erstellt_am,7,4) ||          substr(sf_erstellt_am,4,2) ||        
  substr(sf_erstellt_am,1,2) ||          substr(sf_erstellt_am,12,2) ||         
 substr(sf_erstellt_am,15,2) ||          substr(sf_erstellt_am,18,2) AS Sortieru
ng1,          DECODE(TO_NUMBER(TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')) -          
       TO_NUMBER(substr(SF_REAKTIONSZEIT_DIALOG,7,4) ||                         
  substr(SF_REAKTIONSZEIT_DIALOG,4,2) ||                           substr(SF_REA
KTIONSZEIT_DIALOG,1,2) ||                           substr(SF_REAKTIONSZEIT_DIAL
OG,12,2) ||                           substr(SF_REAKTIONSZEIT_DIALOG,15,2) ||   
                        substr(SF_REAKTIONSZEIT_DIALOG,18,2))                 , 
                NULL, -1000000000000,                  TO_NUMBER(TO_CHAR(SYSDATE
, 'YYYYMMDDHH24MISS')) -                  TO_NUMBER(substr(SF_REAKTIONSZEIT_DIAL
OG,7,4) ||                            substr(SF_REAKTIONSZEIT_DIALOG,4,2) ||    
                        substr(SF_REAKTIONSZEIT_DIALOG,1,2) ||                  
          substr(SF_REAKTIONSZEIT_DIALOG,12,2) ||                            sub
str(SF_REAKTIONSZEIT_DIALOG,15,2) ||                            substr(SF_REAKTI
ONSZEIT_DIALOG,18,2))) As Rot  FROM SF, V_PROFIL_HOTL, V_PERS_FIRM, GRU1, GRU2  
WHERE (V_PROFIL_HOTL.HOTL_ID = SF.HOTL_ID         OR (V_PROFIL_HOTL.HOTL_ID = SF
.HOTL_ID             AND V_PROFIL_HOTL.FIRM_ID = 2            AND V_PROFIL_HOTL.
HOTL_ID = 100))   AND V_PROFIL_HOTL.FIRM_ID = 2  AND SF.PERS_ID = V_PERS_FIRM.PE
RS_ID   AND SF.GRU1_ID = GRU1.GRU1_ID (+)   AND SF.GRU2_ID = GRU2.GRU2_ID (+)   
AND (SF_STATUS_SENDER = 'E' AND SF.FIRM_ID = 2 OR        SF_STATUS_LEVEL1 = 'E' 
AND SF_LEVEL1_FIRM_ID = 2 OR        SF_STATUS_LEVEL2 = 'E' AND SF_LEVEL2_FIRM_ID
 = 2 OR        SF_STATUS_LEVEL3 = 'E' AND SF_LEVEL3_FIRM_ID = 2 OR        SF_M44
_STATUS_LEVEL4 = 'E' AND SF_M44_LEVEL4_FIRM_ID = 2 )  AND SF.HOTL_ID = 51 GROUP 
BY    SF.SF_ID, SF.GRU1_ID, SF.GRU2_ID, SF.FIRM_ID,  SF_FGNR, SF_KUNDE,    SF_ER
STELLT_AM, SF_BEARBEITET_AM,  SF_REAKTIONSZEIT_DIALOG order by Sortierung desc 
[22.05.03 06:11:46.334] HCAU44: DEBUG [DBConnection] query(SQL): traced st 47677
91
[22.05.03 06:11:46.334] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT GRU2.GR
U2_ID, GRU2.GRU2_BEZ_DE  FROM GRU1, GRU2, V_PROFIL_HOTL   WHERE GRU1.GRU1_ID = G
RU2.GRU1_ID    AND V_PROFIL_HOTL.HOTL_ID = GRU1.HOTL_ID    AND GRU2.GRU1_ID = 0 
  AND FIRM_ID = 2   AND GRU1.HOTL_ID = 51  ORDER BY GRU2.GRU2_BEZ_DE
[22.05.03 06:11:46.365] HCAU44: DEBUG [DBConnection] finalize cleanup
[22.05.03 06:11:46.490] HCAU44: DEBUG [DBConnection] query(SQL): traced st 41261
84
[22.05.03 06:11:46.490] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT count(S
F.SF_ID) AS Anzahl  FROM SF, V_PROFIL_HOTL, GRU1, GRU2  WHERE (V_PROFIL_HOTL.HOT
L_ID = SF.HOTL_ID         OR (V_PROFIL_HOTL.HOTL_ID = SF.HOTL_ID             AND
 V_PROFIL_HOTL.FIRM_ID = 2             AND V_PROFIL_HOTL.HOTL_ID = 100))   AND V
_PROFIL_HOTL.FIRM_ID = 2  AND SF.GRU1_ID = GRU1.GRU1_ID (+)   AND SF.GRU2_ID = G
RU2.GRU2_ID (+)  AND  (SF_BEARBEITET_SENDER_ID = 2 OR   SF_BEARBEITET_LEVEL1_ID 
= 2 OR   SF_BEARBEITET_LEVEL2_ID = 2 OR   SF_BEARBEITET_LEVEL3_ID = 2 OR   SF_M4
4_BEARBEITET_LEVEL4_ID = 2 )  AND SF.HOTL_ID = 51 AND (SF_STATUS_SENDER = 'Z' AN
D SF.FIRM_ID = 2 OR  SF_STATUS_LEVEL1 = 'Z' AND SF_LEVEL1_FIRM_ID = 2 OR  SF_STA
TUS_LEVEL2 = 'Z' AND SF_LEVEL2_FIRM_ID = 2 OR  SF_STATUS_LEVEL3 = 'Z' AND SF_LEV
EL3_FIRM_ID = 2 OR  SF_M44_STATUS_LEVEL4 = 'Z' AND SF_M44_LEVEL4_FIRM_ID = 2 ) 
[22.05.03 06:11:49.115] HCAU44: DEBUG [DBConnection] query(SQL): traced st 78373
92
[22.05.03 06:11:49.115] HCAU44: DEBUG [DBConnection] query(SQL):  SELECT *   FRO
M FZGM   ORDER BY FZGM_MODELL ASC
[22.05.03 06:11:49.115] HCAU44: DEBUG [DBConnection] prepareStatement: SELECT AN
Z_ANLAGEN FROM V_ANLAGEN WHERE SF_ID=?
[22.05.03 06:11:49.115] HCAU44: DEBUG [DBConnection] prepareStament: returned 46
11234
[22.05.03 06:11:49.115] HCAU44: DEBUG [DBConnection] prepareStatement: SELECT NO
TIZ_BESCHREIBUNG FROM NOTIZ WHERE SF_ID=? AND FIRM_ID=?
[22.05.03 06:11:49.115] HCAU44: DEBUG [DBConnection] prepareStament: returned 17
09073
[22.05.03 06:11:49.115] HCAU44: DEBUG [DBConnection] prepareStatement: SELECT GR
U1_BEZ_DE FROM GRU1 WHERE GRU1_ID=?
[22.05.03 06:11:49.115] HCAU44: DEBUG [DBConnection] prepareStament: returned 19
96278
[22.05.03 06:11:49.115] HCAU44: DEBUG [DBConnection] prepareStatement: SELECT GR
U2_BEZ_DE FROM GRU2 WHERE GRU2_ID=?
[22.05.03 06:11:49.115] HCAU44: DEBUG [DBConnection] prepareStament: returned 64
33909
[22.05.03 06:11:49.115] HCAU44: DEBUG [DBConnection] prepareStatement: SELECT FI
RM_REGIONSNR, FIRM_NAME, FIRM_BETRIEBSKZ, FIRM_BETRIEBSNR1  FROM FIRM WHERE FIRM
_ID=?
[22.05.03 06:11:49.115] HCAU44: DEBUG [DBConnection] prepareStament: returned 25
4811
[22.05.03 06:11:49.115] HCAU44: DEBUG [DBConnection] prepareStatement: SELECT SF
_M44, SF_LEVEL1_BESITZ_ID, SF_STATUS_ANSTEHEND, SF_STATUS_SENDER,  SF_STATUS_LEV
EL1, SF_STATUS_LEVEL2, SF_STATUS_LEVEL3, SF_LEVEL1_FIRM_ID,  SF_LEVEL2_FIRM_ID, 
SF_LEVEL3_FIRM_ID, SF_LIEGENBLEIBER, SF_MELDEPFLICHT,  SF_BEANSTANDUNG, SF_FZGMO
DELL, SF_FZGTYP,  SF_BEARBEITET_SENDER_VON, SF_BEARBEITET_SENDER_AM,  SF_BEARBEI
TET_LEVEL1_VON, SF_BEARBEITET_LEVEL1_AM,  SF_REAKTIONSZEIT, SF_REAKTIONSZEIT_DIA
LOG, SF.HOTL_ID,  SF_VERBR_STUETZPUNKT_L2, SF_SAP_NR1, SF_SAP_NR2, SF_SAP_NR3,  
SF_SAP_NR4, SF_SAP_NR5, SF_POS1, SF_POS2, SF_POS3, SF_POS4, SF_POS5,  SF_FGNR2, 
SF_FGNR3, SF_FGNR4, SF_FGNR5, SF_ERSTELLT_AM,  SF_BEARBEITET_AM, SF_TEILENR  FRO
M SF WHERE SF_ID=?
[22.05.03 06:11:49.115] HCAU44: DEBUG [DBConnection] prepareStament: returned 22
82244
[22.05.03 06:11:49.115] HCAU44: DEBUG FIRM_DATA FOR FIRM_ID=2
[22.05.03 06:11:49.115] HCAU44: DEBUG [DBConnection] query(pst): 254811
[22.05.03 06:11:49.131] HCAU44: DEBUG ARSF_DATA FOR SF_ID=77047
[22.05.03 06:11:49.131] HCAU44: DEBUG [DBConnection] query(pst): 2282244
[22.05.03 06:11:49.131] HCAU44: DEBUG GRU2_ID=64
[22.05.03 06:11:49.131] HCAU44: DEBUG

AAB

12345

AAB BEZZ

Hi there,

I'am fairly new to OJB and try to get my feet on it.
My problem is, that I can't get Clobs working. The software I use:

- OJB-1.0.rc4
- postgresql-7.3.3_1
- FreeBSD 5.1-RELEASE
- JDK-1.4.1 (native).

I get the following error when trying to insert Clob data:
org.postgresql.jdbc1.AbstractJdbc1Statement.setObject(AbstractJdbc1Statement.jav
a:1392)
org.postgresql.jdbc1.AbstractJdbc1Statement.setObject(AbstractJdbc1Statement.jav
a:1398)
org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatement(Unknow
n
Source)
org.apache.ojb.broker.platforms.PlatformPostgreSQLImpl.setObjectForStatement(Unk
nown
Source)
org.apache.ojb.broker.accesslayer.StatementManager.bindInsert(Unknown
Source)
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(Unknown
Source)
...
Caused by: Unknown Types value.
...

I checked against the junit tests BlobTest, but I can't find any
difference to my setup.

Here is my torque-schema.xml

...

  
  
  
  
    
  

  
...

I verified that the column body results in a bytea type.

My repository-user-xml:
...

	

	

	

	


...

Parts of the VO:
public class Template {
	private int templateId;
	private int userId;
	private String name;
	private char[] body;
...


And finally the code that causes the exception:
WeblogUser user = new WeblogUser();
user.setUsername("foo");
...

char[] body1 = new char[50];
for (int n = 0; n < body1.length; n++)
    body1[n] = 'x';

Template tmp1 = new Template();
tmp1.setName("default template");
tmp1.setBody(body1);

Collection col = new ArrayList();
col.add(templ);
user.setAllTemplatesOfUser(col);

broker.beginTransaction();
broker.store(user);
broker.commitTransaction();

Is there anything I overlooked?
Marcus
-- 
We'll try to make different mistakes this time.
(Larry Wall)






---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

AACC

12345

AADDAADD

Send cvsnt mailing list submissions to
	cvsnt@cvsnt.org

To subscribe or unsubscribe via the World Wide Web, visit
	http://www.cvsnt.org/cgi-bin/mailman/listinfo/cvsnt
or, via email, send a message with subject or body 'help' to
	cvsnt-request@cvsnt.org

You can reach the person managing the list at
	cvsnt-owner@cvsnt.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of cvsnt digest..."


Today's Topics:

   1. setting branch permissions
   2. RE: Re: Mergepoint question (Starrett, Glen (AZ15))
   3. cvs update failes to update files (Sunil Koneru)
   4. Re: Re: Mergepoint question (Tony Hoyle)
   5. cvs server response (shekhar)
   6. read - access restriction to file (Raghuraman)
   7. Re: Re: Mergepoint question (Kevin)
   8. Re: Mergepoint question (Bo Berglund)


----------------------------------------------------------------------

Date: Wed, 23 Jul 2003 15:06:02 +0100
From: tim.webster@bt.com
To: cvsnt@cvsnt.org
Subject: [cvsnt] setting branch permissions
Message-ID: <2469F81E72CEA54E88F405065D9E886E019A517A@i2km10-ukbr.domain1.system
host.net>
Content-Type: text/plain;
	charset="iso-8859-1"
MIME-Version: 1.0
Precedence: list
Message: 1

Hello,

	I've seen more that one reference to the fact that CVSNT can
restrict access to branches/tags by user.  But unfortunately, I can't find
any examples.  I was assuming this is done with the "cvs chacl" command.
Firstly, is this correct? And secondly, how does it work?  I've managed to
restrict access to certain branches allright, but what I'm interested in
doing is restricting access (or not enabling check ins) to the main trunk.
If I use this command to give someone only read access to MAIN or HEAD, they
can still seem to check stuff back in on the main trunk.

Anyone familiar with this?

The command I used was "cvs chacl -r MAIN (or HEAD) user:r " to
give read only access.

To be honest I don't know the different between MAIN, HEAD, and "default
branch".  I just assumed that one is an alias of the other.  Which one
should I be setting permissions on?

Thanks
------------------------------

Date: Wed, 23 Jul 2003 08:43:57 -0700
From: "Starrett, Glen (AZ15)" 
To: Kevin , cvsnt@cvsnt.org
Subject: RE: [cvsnt] Re: Mergepoint question
Message-ID: <52E5BA67EB41D711965600B0D0FC3A7303AEDD79@aZ15m11>
Content-Type: text/plain;
	charset="iso-8859-1"
MIME-Version: 1.0
Precedence: list
Message: 2

Tony--please correct me if I've misstated anything here.

>>>>
If I am getting this right, the mergepoint is stored in the working folder
(sandbox) not in the repository.

If this is the case:
- one user merges 2 branches
- assume that development continues on both branches
- when a different user merges the branches a second time he will get the
conflicts of the first merge too

Or is the mergepoint committed to the repository too?
<<<<

Yes, mergepoints are saved in the sandbox until committed and then to the
server log once committed.  You'll see entries in there with the field
"mergepoint" if you've done merges.  However, from what I've read recently,
I would infer that if you do *2* merges into the same sandbox without
committing in-between then you would loose 1 or both mergepoints.

The better (or at least more detailed) steps of your scenario is:

-- One users merges 1st of 2 branches
-- When conflicts are resolved (if any), commit
-- Same user merges 2nd of 2 branches
-- When conflicts are resolved (if any), commit
-- When a different user merges the branches, CVSNT sees the mergepoint
entries in the log and merges correctly.

The commit in between merges is to primarily to save off the mergepoint
record and also provide a fallback point to go back to without loosing the
1st merge in case the 2nd merge is not completed for any reason.

IMHO merging multiple times without committing in-between is only asking for
trouble, no matter what SCM tool you're using.

>>>>
By the way is there does not seem to be any (or sufficient) documentation
about merge points. If anybody finds or writes something please post a link.
<<<<

I completely agree and I'd volunteer to put this in the wiki but I'm
overloaded as it is (I guess I shouldn't be writing now then, eh?).  If you
could put this information into the CVSNT wiki for everyone's benefit it
would be available for everyone from now on, and your name would be
immortalized in the CVSNT wiki forever.  OK, maybe the last part is a
stretch, but be confident that your efforts will be appreciated.  As a side
benefit you'll solidify your knowledge on how the CVSNT branching and
merging work while you write your article.


Regards,

Glen Starrett
------------------------------

Date: Wed, 23 Jul 2003 08:54:47 -0700
From: Sunil Koneru 
To: "'cvsnt@cvsnt.org'" 
Subject: [cvsnt] cvs update failes to update files
Message-ID: 
Content-Type: text/plain;
	charset="iso-8859-1"
MIME-Version: 1.0
Precedence: list
Message: 3

Hi,

We do a daily update of the files from cvs server and do a build of the
product.
It so happens that sometimes couple of files are not getting updated.
We realize this when we are testing the built product.
This is becoming a big issue because we are not able to figure why the
update works sometimes and why it has issues updating files sometimes.
Here are some commands which we use to update files daily.

cvs update -R -d -C aspen_AppletInstall 
cvs update -R -d -C aspen_cd\aspencd20 
cvs update -R -d -C aspen_db 
cvs update -R -d -C aspen_setup 
cvs update -R -d -C aspen_web 
cvs update -l build 
cvs update -R -d -C build\scripts
cvs update -R -d -C build\public 
cvs update -R -d -C build\built_files\Scripts 
cvs update -R -d -C cds


The version of CVS we use is : CVSNT 1.11.1.3(Build 73)

Any help on this is appreciated.

thanks
Sunil


------------------------------

Date: Wed, 23 Jul 2003 17:44:31 +0100
From: Tony Hoyle 
To: cvsnt@cvsnt.org
Subject: Re: [cvsnt] Re: Mergepoint question
Message-ID: 
References: 
Content-Type: text/plain; charset=us-ascii
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Precedence: list
Message: 4

On Wed, 23 Jul 2003 08:43:57 -0700, "Starrett, Glen (AZ15)"
 wrote:


>I completely agree and I'd volunteer to put this in the wiki but I'm
>overloaded as it is (I guess I shouldn't be writing now then, eh?).  If you
>could put this information into the CVSNT wiki for everyone's benefit it
>would be available for everyone from now on, and your name would be
>immortalized in the CVSNT wiki forever.  OK, maybe the last part is a
>stretch, but be confident that your efforts will be appreciated.  As a side
>benefit you'll solidify your knowledge on how the CVSNT branching and
>merging work while you write your article.
>
At the very least someone needs to go through the bits of the documentation
that mandate tagging merges etc. and put in notes that it's not really
required any more.  I'm unfortunately so snowed under with work I barely get
enough time to work on cvsnt at all at the moment let alone sort the
documentation :(

Tony

------------------------------

Date: Thu, 24 Jul 2003 10:45:01 +0530
From: shekhar 
To: cvsnt@cvsnt.org
Subject: [cvsnt] cvs server response
Message-ID: <3F1F6B55.4010203@cygnus.stpp.soft.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Precedence: list
Message: 5

please someone tell me how to capture cvs servers' responses . Please 
please  please

shekhar


------------------------------

Date: Thu, 24 Jul 2003 11:36:05 +0530
From: Raghuraman 
To: cvsnt@cvsnt.org
Subject: [cvsnt] read - access restriction to file
Message-ID: <43972AA5E132D7118AE000079505604401134706@blrsmx003.india-life.com>
Content-Type: text/plain;
	charset="iso-8859-1"
MIME-Version: 1.0
Precedence: list
Message: 6

Hello,

1. How to restrict users from reading files in a particular folder in
repository.

      Suppose I have 10 files in a folder ABC. Let there be 2 CVS users
"User1" and "User2". I wanted to know if it is possible for User1 to see
some chosen 5 of them and User2 to see some 2 of them. Access to files are
restricted at administrator level.
	
2. Is it possible for us to get a listing of repository files using WinCVS ?

    Can I get a listing of repository files to which i have access using
WinCVS without using "cvs ls -l -R".

If you need clarifications, Pls mail back.

Advanced Thanks,
Raghuraman.
------------------------------

Date: Thu, 24 Jul 2003 08:26:47 +0200
From: "Kevin" 
To: cvsnt@cvsnt.org
Subject: Re: [cvsnt] Re: Mergepoint question
Message-ID: 
References: 
Precedence: list
Message: 7

"Starrett, Glen (AZ15)"  wrote in message
news:mailman.106.1058975080.469.cvsnt@cvsnt.org...
> The better (or at least more detailed) steps of your scenario is:
>
> -- One users merges 1st of 2 branches
> -- When conflicts are resolved (if any), commit
> -- Same user merges 2nd of 2 branches
> -- When conflicts are resolved (if any), commit
> -- When a different user merges the branches, CVSNT sees the mergepoint
> entries in the log and merges correctly.

Just to make thing clear, this is what I meant:
- one user merges 1st of 2 branches and commits (after resolving any
conflicts)
- other developers update/develop/commit their changes on the branch they
are working on (hence both branches get newer revisions checked in)
- when a second user merges the 1st of the 2 branches a second time to
synchronize the branches again he will get the
conflicts of the first merge too (*** this will happen as the mergepoints
are committed in the first step --- see below ***)

>> Or is the mergepoint committed to the repository too?
> Yes, mergepoints are saved in the sandbox until committed and then to the
> server log once committed.

The scenario I was creating shall work fine as long as the mergepoints are
committed along with the merge.

Thanks for the reply, mergepoints are becoming clearer now and hopefully I
shall be making more use of them.

--
Kevin Agius



------------------------------

Date: Thu, 24 Jul 2003 10:40:10 GMT
From: bo.berglund@system3r.se (Bo Berglund)
To: cvsnt@cvsnt.org
Subject: [cvsnt] Re: Mergepoint question
Message-ID: <3f1ee0c8.87886003@news.cvsnt.org>
References: <3f18f417.62843363@news.cvsnt.org>
	
Precedence: list
Reply-To: bo.berglund@removethis.system3r.se
Message: 8

On Wed, 23 Jul 2003 09:25:11 +0200, "Kevin"  wrote:

>"Bo Berglund"  wrote in message
>news:3f18f417.62843363@news.cvsnt.org...
>> So instead I have made
>> some manual adjustments and committed this (basically just replacing
>> the HEAD code with the tip of the branch without merging anything).
>
>Can you give us some more details or a link about what is this and how to do
>it?
>
>--
>Kevin Agius
>HOB Software Ltd. (Malta)
>
Very simple, I just had two checked out copies of the project. One on
HEAD and one on the branch tip.
Then I copied all of the source files from the branch to the HEAD
sandbox overwriting whatever was there before.
Then I issued a cvs status command in the HEAD sandbox so cvs could
figure out which files had actually changed (the timestamps were
different so they all looked changed).
Then I commutted what was left as changed files.
Of course before all of this I put a tag in both TRUNK and Branch so I
could restore the situation if something went bad.
I had to do a followup action too, I had to add the files that were
now in the sandbox but not marked as being under version control.
These had been added on the branch.
There probably is a simple cvs command that does all of this
automatically (promoting the tip of the branch to become the new HEAD
revision), but I don't know this.


/Bo Berglund
------------------------------

_______________________________________________
cvsnt mailing list
cvsnt@cvsnt.org
http://www.cvsnt.org/cgi-bin/mailman/listinfo/cvsnt


End of cvsnt Digest, Vol 7, Issue 36
************************************

AACD

12345

AAC BEZ

In the repository_database.xml file (or where ever you placed the
jdbc-connection-descriptor) is the platform attribute assigned
PostgreSQL or the default Hsqldb?


On Sat, 2003-08-16 at 10:31, CJacobME@aol.com wrote:
> Hi everyone,
> 
> I'm a newbee to OJB, and even my first try led into an exception. When I 
> tried to play tutorial #1, the first attempt to get some data from the databas
e 
> fired this exception:
> java.lang.AbstractMethodError: 
> org.postgresql.jdbc1.Jdbc1DatabaseMetaData.supportsBatchUpdates()Z
>     at 
> org.apache.ojb.broker.platforms.PlatformDefaultImpl.checkForBatchSupport(Platf
ormDefaultImpl.java:100)
>     at 
> org.apache.ojb.broker.platforms.PlatformDefaultImpl.initializeJdbcConnection(P
latformDefaultImpl.java:144)
>     at 
> org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.initializeJdbc
Connection(ConnectionFactoryAbstractImpl.java:137)
>     at 
> org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConnectionF
romDriverManager(ConnectionFactoryAbstractImpl.java:259)
>     at 
> org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ConPoolFactory.m
akeObject(ConnectionFactoryPooledImpl.java:205)
>     at 
> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.
java:710)
>     at 
> org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnectionFro
mPool(ConnectionFactoryPooledImpl.java:65)
>     at 
> org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnecti
on(ConnectionFactoryAbstractImpl.java:101)
>     at 
> org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Connecti
onManagerImpl.java:129)
>     at 
> org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Statem
entManager.java:673)
>     at 
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.j
ava:271)
>     at org.apache.ojb.broker.accesslayer.RsIterator.
> (RsIterator.java:199)
>     at 
> org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFa
ctoryImpl.java:95)
>     at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Persis
tenceBrokerImpl.java:2311)
>     at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Persiste
nceBrokerImpl.java:1657)
>     at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Persiste
nceBrokerImpl.java:1305)
>     at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Persiste
nceBrokerImpl.java:1460)
>     at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Persiste
nceBrokerImpl.java:1496)
>     at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Persiste
nceBrokerImpl.java:1485)
>     at 
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(De
legatingPersistenceBroker.java:302)
>     at 
> org.apache.ojb.tutorial1.UCListAllProducts.apply(UCListAllProducts.java:33)
>     at org.apache.ojb.tutorial1.Application.run(Application.java:91)
>     at org.apache.ojb.tutorial1.Application.main(Application.java:52)
> 
> I'm using PostgreSQL database on Suse Linux 8.0 and JDK 1.4, and AFAIK I'm 
> using the newest JDBC driver for PostgreSQL. So, I have no idea what went wron
g, 
> nor could I find some hints somewhere in the net. 
> 
> Can anybody help me?
> 
> Kind regards,
> Christian
-- 
Eli Anderson
Ecaent Development

CCC

12345

AAAAAAAAA

Test L.Coman

mehr

Test L.Coman

mehr


Test L.Coman

mehr

Test L.Coman

121

12222

2121

In the repository_database.xml file (or where ever you placed the
jdbc-connection-descriptor) is the platform attribute assigned
PostgreSQL or the default Hsqldb?


On Sat, 2003-08-16 at 10:31, CJacobME@aol.com wrote:
> Hi everyone,
> 
> I'm a newbee to OJB, and even my first try led into an exception. When I 
> tried to play tutorial #1, the first attempt to get some data from the databas
e 
> fired this exception:
> java.lang.AbstractMethodError: 
> org.postgresql.jdbc1.Jdbc1DatabaseMetaData.supportsBatchUpdates()Z
>     at 
> org.apache.ojb.broker.platforms.PlatformDefaultImpl.checkForBatchSupport(Platf
ormDefaultImpl.java:100)
>     at 
> org.apache.ojb.broker.platforms.PlatformDefaultImpl.initializeJdbcConnection(P
latformDefaultImpl.java:144)
>     at 
> org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.initializeJdbc
Connection(ConnectionFactoryAbstractImpl.java:137)
>     at 
> org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConnectionF
romDriverManager(ConnectionFactoryAbstractImpl.java:259)
>     at 
> org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ConPoolFactory.m
akeObject(ConnectionFactoryPooledImpl.java:205)
>     at 
> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.
java:710)
>     at 
> org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnectionFro
mPool(ConnectionFactoryPooledImpl.java:65)
>     at 
> org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnecti
on(ConnectionFactoryAbstractImpl.java:101)
>     at 
> org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Connecti
onManagerImpl.java:129)
>     at 
> org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Statem
entManager.java:673)
>     at 
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.j
ava:271)
>     at org.apache.ojb.broker.accesslayer.RsIterator.
> (RsIterator.java:199)
>     at 
> org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFa
ctoryImpl.java:95)
>     at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Persis
tenceBrokerImpl.java:2311)
>     at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Persiste
nceBrokerImpl.java:1657)
>     at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Persiste
nceBrokerImpl.java:1305)
>     at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Persiste
nceBrokerImpl.java:1460)
>     at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Persiste
nceBrokerImpl.java:1496)
>     at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Persiste
nceBrokerImpl.java:1485)
>     at 
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(De
legatingPersistenceBroker.java:302)
>     at 
> org.apache.ojb.tutorial1.UCListAllProducts.apply(UCListAllProducts.java:33)
>     at org.apache.ojb.tutorial1.Application.run(Application.java:91)
>     at org.apache.ojb.tutorial1.Application.main(Application.java:52)
> 
> I'm using PostgreSQL database on Suse Linux 8.0 and JDK 1.4, and AFAIK I'm 
> using the newest JDBC driver for PostgreSQL. So, I have no idea what went wron
g, 
> nor could I find some hints somewhere in the net. 
> 
> Can anybody help me?
> 
> Kind regards,
> Christian
-- 
Eli Anderson
Ecaent Development

12345

123232AAAAAAAAAAAAAAAA

Well, actually, under Tomcat, I wrote an InitContextListener which 
automagically figures out where the current webapp exists and sets a system 
property which is referenced in log4j.xml and,  viola!, the log files are 
placed in WEB-INF/logs of the current application no matter where it exists 
and without ever hardcoding the actual path.  Of course, this assumes you 
actually have write access to your webapp which is not guaranteed by the 
servlet spec.  In that case, your file appender will not work since it 
won't have a valid location to write to.

See the InitContextListener in the log4j-sandbox.  Instructions are in the 
javadoc.  See info and links here...
http://nagoya.apache.org/wiki/apachewiki.cgi?Log4JProjectPages/AppContainerLoggi
ng

Jake

At 08:35 PM 8/13/2003 +1000, you wrote:
>G'day,
>
>Ummmm, so basically then it is not possible to define a directory path in
>the log4j.xml properties file so that log files are placed relative to the
>web apps root directory?  Or for that matter relative to any known anchor
>point like the server root directory?
>
>A problem we have is that we deploy .war files by sending the package to the
>server gods who then drop it into the webapps directory.  Alas we don't have
>the rights to deploy directly to the server environment and tools like ANT
>whilst are good at building a distributable archive they do not quite make
>the grade when resolving tokens in a dynamic style of deployment.  Another
>issue we have is that most of the development work is done on a Windows
>based machine and the production servers are hosted on a flavor of Unix.
>Hard coding a directory path like "C:\..\" may work when doing the dev work
>under Windows but just don't kind of cut it on a Unix file system when it
>comes time to deployment.
>
>BTW, the last time I looked me was male so I'll opt out for king!
>
>AB
>
>-----Original Message-----
>From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
>Sent: Monday, 11 August 2003 11:14 PM
>To: Log4J Users List
>Subject: RE: Creating log files relative to the web applications root
>directory?
>
>
>
>Howdy,
>I suppose Adrian could be a woman's name as well, so you're right ;)
>
>
>But if you're the server admin, you're king (or queen) ;) 
>
>Yoav Shapira
>Millennium ChemInformatics
>
>
> >-----Original Message-----
> >From: Caroline Wood [mailto:Caroline.Wood@cpp.co.uk]
> >Sent: Monday, August 11, 2003 9:13 AM
> >To: 'Log4J Users List'
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >or Queen! lol ;)
> >
> >-----Original Message-----
> >From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
> >Sent: 11 August 2003 14:05
> >To: Log4J Users List; a.beech@bigpond.net.au
> >Subject: RE: Creating log files relative to the web applications root
> >directory?
> >
> >
> >
> >Howdy,
> >What I've seen done to achieve this is have my ant deployment script
> >fill the value when copying log4j.xml over.  So in log4j.xml, you'd
>have
> >
> >