问:
Spring Boot Print Full Stacktrace for ExceptionInInitializerError
For a springboot project, I have a bean in a class:

```<code>@Container
static LocalStackContainer localStack = new LocalStackContainer(DockerImageName.parse("localstack/localstack:0.13.0"))
.withEnv("AWS_ACCESS_KEY_ID", "accesskey")
.withEnv("AWS_SECRET_ACCESS_KEY", "secretkey")
.withServices(LocalStackContainer.Service.SQS);
</code>```

This code initiates normally for my regular computer, but causes a ExceptionInInitializerError in my docker container (centos, openjdk11). However, my stacktrace only prints this:

```<code>java.lang.ExceptionInInitializerError
    at com.{redacted}.testclass.<clinit>(testclass.java:88)
</code>```

How do I get maven to print out the full stacktrace so I can debug?

Body:
For a springboot project, I have a bean in a class:

@Container
static LocalStackContainer localStack = new LocalStackContainer(DockerImageName.parse("localstack/localstack:0.13.0"))
.withEnv("AWS_ACCESS_KEY_ID", "accesskey")
.withEnv("AWS_SECRET_ACCESS_KEY", "secretkey")
.withServices(LocalStackContainer.Service.SQS);

This code initiates normally for my regular computer, but causes a ExceptionInInitializerError in my docker container (centos, openjdk11). However, my stacktrace only prints this:

java.lang.ExceptionInInitializerError
    at com.{redacted}.testclass.<clinit>(testclass.java:88)

How do I get maven to print out the full stacktrace so I can debug?


来源: stackexchange

问:
Wrong Months in chart.js in Laravel
Hi I am trying to insert a chart by the use of chart.js.
https://www.chartjs.org/
I followed the steps in their website I got this drawing:

https://i.stack.imgur.com/uGlE8.png

The problem is that :
the user's data represented rightly but the other data jobs, jobseekers and consultants are not.

the mistake is in the months for example :  one of the job were created in January the diagram shows in October . This is the controller:

```<code>public function statistics()
    {

 $users = User::select(DB::raw("COUNT(*) as count"), DB::raw("MONTHNAME(created_at) as month_name"))
                    ->whereYear('created_at', date('Y'))
                    ->groupBy(DB::raw("month_name"))
                    ->orderBy('id','ASC')
                    ->pluck('count', 'month_name');

        $labels = $users->keys();
        $data = $users->values();

$jobs = Job::select(DB::raw("COUNT(*) as count1"), DB::raw("MONTHNAME(created_at) as month_name1"))
        ->whereYear('created_at', date('Y'))
        ->groupBy(DB::raw("month_name1"))
        ->orderBy('id','ASC')
        ->pluck('count1', 'month_name1');
        $labels1 = $jobs->keys();
        $data1 = $jobs->values();
 $Jobseeker = cv::select(DB::raw("COUNT(*) as count"), DB::raw("MONTHNAME(created_at) as month_name"))
->whereYear('created_at', date('Y'))
->groupBy(DB::raw("month_name"))
->orderBy('id','ASC')
->pluck('count', 'month_name');

$labels2 = $Jobseeker->keys();
$data2 = $Jobseeker->values();

$Consult = Consult::select(DB::raw("COUNT(*) as count"), DB::raw("MONTHNAME(created_at) as month_name"))
->whereYear('created_at', date('Y'))
->groupBy(DB::raw("month_name"))
->orderBy('id','ASC')
->pluck('count', 'month_name');

$labels3 = $Consult->keys();
$data3 = $Consult->values();

        return view('statistics.report',compact('users1','consultants','jobsekers','jobs1','labels','data','labels1','data1','labels2','data2','labels3','data3'));
    }
</code>```

This is my script:

```<code>    <script type="text/javascript">
          var labels =  {{ Js::from($labels) }};
          var users =  {{ Js::from($data) }};
          var labels1 =  {{ Js::from($labels1) }};
          var jobs =  {{ Js::from($data1) }};
          var labels2 =  {{ Js::from($labels2) }};
          var Jobseeker =  {{ Js::from($data2) }};

          var labels3 =  {{ Js::from($labels3) }};
          var Consult =  {{ Js::from($data3) }};

        const data = {
       labels:labels,//here is the problem how can I show in y all months and pick  the needed one

        datasets: [
          {
            label: ['Users'],
            labels:labels,
            data: users,
            borderColor: '#2db5b5',
            backgroundColor: '#2db5b5',
          },
          {
            label: ['Jobs'],
            data: jobs,
            borderColor: '#0024ff',
            backgroundColor: '#0024ff',
          }, {
            label: ['Jobseeker'],
            data: Jobseeker,
            borderColor: 'rgb(255, 99, 132)',
            backgroundColor: 'rgb(255, 99, 132)',
          },
          {
            label: ['Consultants'],
            data: Consult,
            borderColor: '#ffaf00',
            backgroundColor: '#ffaf00',
          },

        ]
      };
          const config = {
              type: 'line',
              data: data,

              options: {
          responsive: true,
          plugins: {

            title: {
              display: true,
              text: 'Website statistics'
            }
          }
        },
          };
   const myChart = new Chart(
              document.getElementById('myChart'),
              config
          );
      </script>
</code>```

I want to find a way so I control the x to show all months and specify the points correctly.

ContentLicense: CC BY-SA 4.0

Title: Wrong Months in chart.js in Laravel

Body:
Hi I am trying to insert a chart by the use of chart.js.
https://www.chartjs.org/
I followed the steps in their website I got this drawing:

https://i.stack.imgur.com/uGlE8.png

The problem is that :
the user's data represented rightly but the other data jobs, jobseekers and consultants are not.

the mistake is in the months for example :  one of the job were created in January the diagram shows in October . This is the controller:

public function statistics()
    {

 $users = User::select(DB::raw("COUNT(*) as count"), DB::raw("MONTHNAME(created_at) as month_name"))
                    ->whereYear('created_at', date('Y'))
                    ->groupBy(DB::raw("month_name"))
                    ->orderBy('id','ASC')
                    ->pluck('count', 'month_name');

        $labels = $users->keys();
        $data = $users->values();

$jobs = Job::select(DB::raw("COUNT(*) as count1"), DB::raw("MONTHNAME(created_at) as month_name1"))
        ->whereYear('created_at', date('Y'))
        ->groupBy(DB::raw("month_name1"))
        ->orderBy('id','ASC')
        ->pluck('count1', 'month_name1');
        $labels1 = $jobs->keys();
        $data1 = $jobs->values();
 $Jobseeker = cv::select(DB::raw("COUNT(*) as count"), DB::raw("MONTHNAME(created_at) as month_name"))
->whereYear('created_at', date('Y'))
->groupBy(DB::raw("month_name"))
->orderBy('id','ASC')
->pluck('count', 'month_name');

$labels2 = $Jobseeker->keys();
$data2 = $Jobseeker->values();

$Consult = Consult::select(DB::raw("COUNT(*) as count"), DB::raw("MONTHNAME(created_at) as month_name"))
->whereYear('created_at', date('Y'))
->groupBy(DB::raw("month_name"))
->orderBy('id','ASC')
->pluck('count', 'month_name');

$labels3 = $Consult->keys();
$data3 = $Consult->values();

        return view('statistics.report',compact('users1','consultants','jobsekers','jobs1','labels','data','labels1','data1','labels2','data2','labels3','data3'));
    }

This is my script:

I want to find a way so I control the x to show all months and specify the points correctly.


问:
copy files to a remote server with credentials from inside a docker container in .Net 6.0
I have a requirement where I need to copy files to a remote server with credentials from a .Net 6.0 application hosted in a docker container.
I can do this easily by impersonating the service account in VS (using WindowsIdentity.RunImpersonated) but this fails when application is running inside the docker container.
I cannot access advapi32.dll from inside the container. So, I cannot use LogonUser to generate token handle to impersonate the service account (which has access to the remote server).

Is there a way I can use impersonation inside docker container without being dependent on advapi32.dll OR if I can copy the files to remote server without using impersonation at all.

I tried the following C# code which works locally but not inside a container

```<code> [DllImport("advapi32.dll", SetLastError = true, CharSet = CharSet.Unicode)]
        public static extern bool LogonUser(String lpszUsername, String lpszDomain, String lpszPassword,
        int dwLogonType, int dwLogonProvider, out SafeAccessTokenHandle phToken);

bool returnValue = LogonUser(username, domainname, password,
            LOGON32_LOGON_INTERACTIVE, LOGON32_PROVIDER_DEFAULT,
            out safeAccessTokenHandle);

WindowsIdentity.RunImpersonated(
                safeAccessTokenHandle,
                // User action
                () => {
                    // Check the identity.
                    Console.WriteLine("During impersonation: " + WindowsIdentity.GetCurrent().Name);
               });
</code>```

Body:
I have a requirement where I need to copy files to a remote server with credentials from a .Net 6.0 application hosted in a docker container.
I can do this easily by impersonating the service account in VS (using WindowsIdentity.RunImpersonated) but this fails when application is running inside the docker container.
I cannot access advapi32.dll from inside the container. So, I cannot use LogonUser to generate token handle to impersonate the service account (which has access to the remote server).

Is there a way I can use impersonation inside docker container without being dependent on advapi32.dll OR if I can copy the files to remote server without using impersonation at all.

I tried the following C# code which works locally but not inside a container

 [DllImport("advapi32.dll", SetLastError = true, CharSet = CharSet.Unicode)]
        public static extern bool LogonUser(String lpszUsername, String lpszDomain, String lpszPassword,
        int dwLogonType, int dwLogonProvider, out SafeAccessTokenHandle phToken);

bool returnValue = LogonUser(username, domainname, password,
            LOGON32_LOGON_INTERACTIVE, LOGON32_PROVIDER_DEFAULT,
            out safeAccessTokenHandle);

WindowsIdentity.RunImpersonated(
                safeAccessTokenHandle,
                // User action
                () => {
                    // Check the identity.
                    Console.WriteLine("During impersonation: " + WindowsIdentity.GetCurrent().Name);
               });


问:
How to correctly pass argument to script from command line with NX15
With the given script in package.json :

```<code>"deploy": "nx deploy --verbose --"
</code>```

If we run npm run deploy my-application using NX 13.4.5 (@nrwl/nx) it produces the following output (and it works as we expect):

```<code>> nx deploy --verbose -- my-application

> nx run my-application:deploy --verbose
</code>```

But, since we have updated our monorepo to NX 15.0.10 - the behaviour of invoking the same script has changed. Running npm run deploy my-application now produces:

```<code>> nx deploy --verbose -- my-application

> nx run some-other-application:deploy my-application
</code>```

(even though i think it should not be related)
The script block in the project.json for the particular my-application is:

```<code>    "deploy": {
      "executor": "@genexus/ngx-aws-deploy:deploy",
      "options": {
        "subFolder": "my-application",
        "noBuild": true
      },
      "configurations": {
        "production": {}
      }
    },
</code>```

I have tried to search NX documentation and change log but i was not able to find anything related.

As I understand - with the new version of NX - there is (should be?) a difference in the way the argument is being passed to the script...

What is the correct way to pass application argument to this NX script? (while preserving the script as it is)

Additional info:

the script is also being invoked from cicd pipeline.

the same behaviour discrepancy between the two nx versions is also valid for other scripts than deploy like build e.t.c

if i update the script removing the --verbose -- part (with only nx deploy) - then it works as expected - producing: nx run my-application:deploy - but i would like to keep the --verbose part.

according to NX docs - the syntax should be correct:

```<code>To run the command, use the usual Nx syntax:

nx run my-app:make

or

nx make my-app
</code>```

...so i am thinking - possibly the my-application argument is not being '~correctly' passed to the script...

Possible solution:
Possible solution might be to pass the --verbose argument last and update any existing scripts to do so - but i would still like to know what is going on. And eventually any other ways to overcome the case.

Body:
With the given script in package.json :

"deploy": "nx deploy --verbose --"

If we run npm run deploy my-application using NX 13.4.5 (@nrwl/nx) it produces the following output (and it works as we expect):

> nx deploy --verbose -- my-application

> nx run my-application:deploy --verbose

But, since we have updated our monorepo to NX 15.0.10 - the behaviour of invoking the same script has changed. Running npm run deploy my-application now produces:

> nx deploy --verbose -- my-application

> nx run some-other-application:deploy my-application

(even though i think it should not be related)
The script block in the project.json for the particular my-application is:

    "deploy": {
      "executor": "@genexus/ngx-aws-deploy:deploy",
      "options": {
        "subFolder": "my-application",
        "noBuild": true
      },
      "configurations": {
        "production": {}
      }
    },

I have tried to search NX documentation and change log but i was not able to find anything related.

As I understand - with the new version of NX - there is (should be?) a difference in the way the argument is being passed to the script...

What is the correct way to pass application argument to this NX script? (while preserving the script as it is)

Additional info:

the script is also being invoked from cicd pipeline.

the same behaviour discrepancy between the two nx versions is also valid for other scripts than deploy like build e.t.c

if i update the script removing the --verbose -- part (with only nx deploy) - then it works as expected - producing: nx run my-application:deploy - but i would like to keep the --verbose part.

according to NX docs - the syntax should be correct:

To run the command, use the usual Nx syntax:

nx run my-app:make

or

nx make my-app

...so i am thinking - possibly the my-application argument is not being '~correctly' passed to the script...

Possible solution:
Possible solution might be to pass the --verbose argument last and update any existing scripts to do so - but i would still like to know what is going on. And eventually any other ways to overcome the case.


问:
Remove space at the end of html in electron
My electron application shows me a space at the end of the HTML. I am not able to adjust it to the size of the window. I think the problem is in the electron configuration and not in the HTML.

I have already tried with:

```<code>html,
body {
  height: 100vh;
}
</code>```

But it seems that the window ends before the end space.
My Electron window configuration is:

```<code>const win = new BrowserWindow({
    // fullscreen: true,
    alwaysOnTop: !isDevelopment,
    frame: isDevelopment,
    autoHideMenuBar: true,
    transparent: true,
    webPreferences: {
      // Use pluginOptions.nodeIntegration, leave this alone
      // See nklayman.github.io/vue-cli-plugin-electron-builder/guide/security.html#node-integration for more info
      nodeIntegration: process.env.ELECTRON_NODE_INTEGRATION,
      contextIsolation: !process.env.ELECTRON_NODE_INTEGRATION,
      devTools: isDevelopment
    }
  })
</code>```

I need to adjust the height of the html to the entire window, removing the scroll.

Body:
My electron application shows me a space at the end of the HTML. I am not able to adjust it to the size of the window. I think the problem is in the electron configuration and not in the HTML.

I have already tried with:

html,
body {
  height: 100vh;
}

But it seems that the window ends before the end space.
My Electron window configuration is:

const win = new BrowserWindow({
    // fullscreen: true,
    alwaysOnTop: !isDevelopment,
    frame: isDevelopment,
    autoHideMenuBar: true,
    transparent: true,
    webPreferences: {
      // Use pluginOptions.nodeIntegration, leave this alone
      // See nklayman.github.io/vue-cli-plugin-electron-builder/guide/security.html#node-integration for more info
      nodeIntegration: process.env.ELECTRON_NODE_INTEGRATION,
      contextIsolation: !process.env.ELECTRON_NODE_INTEGRATION,
      devTools: isDevelopment
    }
  })

I need to adjust the height of the html to the entire window, removing the scroll.


问:
Row-level-security not working for Postgres internal tables
I wanted a work-around for the PostgreSQL limitation (Hide unrelated schema/tables structure for a user).

I decided to go with the Row-Level-Security(RLS). The RLS seems working as expected for the user tables but did work for the internal tables such as pg_catalog.pg_namespace.

The screenshot shows the original data in the pg_catalog.pg_namespace table without RLS enbled.

--logged-in as a SUPERUSER(postgres)

SET allow_system_table_mods=on;
ALTER TABLE pg_catalog.pgnamespace ENABLE ROW LEVEL SECURITY;
ALTER TABLE pg_catalog.pg_namespace FORCE ROW LEVEL SECURITY;

REVOKE ALL ON TABLE pg_catalog.pg_namespace FROM public, utkarsh;
GRANT ALL ON TABLE pg_catalog.pg_namespace TO utkarsh;

CREATE POLICY ensure_right_table ON pg_catalog.pg_namespace
FOR ALL
USING ((pg_catalog.pg_namespace.nspacl::text = '{postgres=UC/postgres,utkarsh=UC/postgres}'));
--nspacl is not an unique column.

SET ROLE utkarsh;

SELECT * FROM pg_catalog.pg_namespace;
--I can still see all the rows
```


问:
Transferring the query to the xml file
enter image description config xml

enter image description for use  xml file in code

This program uses "jpa", but for a series of tasks, I had to write a query, and as long as the queries were above the method, the program was executed, but after
Transferring the query to the program's xml program failed

My goal is to transfer the queries to the xml file in the spring boot jpa project

my error is

```<code>Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
2022-12-13T12:00:43.357+03:30 ERROR 16100 --- [           main] o.s.boot.SpringApplication               : Application run failed

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'employerController': Unsatisfied dependency expressed through field 'employerService': Error creating bean with name 'employerService': Unsatisfied dependency expressed through field 'employerDao': Error creating bean with name 'employerDao' defined in com.example.house_cleaning_service_company.employer.dao.EmployerDao defined in @EnableJpaRepositories declared on JpaRepositoriesRegistrar.EnableJpaRepositoriesConfiguration: Could not create query for public abstract void com.example.house_cleaning_service_company.employer.dao.EmployerDao.update(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long); Reason: Failed to create query for method public abstract void com.example.house_cleaning_service_company.employer.dao.EmployerDao.update(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long); No property 'update' found for type 'Employer'
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:712) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:692) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:127) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:481) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1397) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:598) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:521) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:961) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:915) ~[spring-context-6.0.2.jar:6.0.2]
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:584) ~[spring-context-6.0.2.jar:6.0.2]
    at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146) ~[spring-boot-3.0.0.jar:3.0.0]
    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:730) ~[spring-boot-3.0.0.jar:3.0.0]
    at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:432) ~[spring-boot-3.0.0.jar:3.0.0]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:308) ~[spring-boot-3.0.0.jar:3.0.0]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1302) ~[spring-boot-3.0.0.jar:3.0.0]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1291) ~[spring-boot-3.0.0.jar:3.0.0]
    at com.example.house_cleaning_service_company.HouseCleaningServiceCompanyApplication.main(HouseCleaningServiceCompanyApplication.java:12) ~[classes/:na]
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'employerService': Unsatisfied dependency expressed through field 'employerDao': Error creating bean with name 'employerDao' defined in com.example.house_cleaning_service_company.employer.dao.EmployerDao defined in @EnableJpaRepositories declared on JpaRepositoriesRegistrar.EnableJpaRepositoriesConfiguration: Could not create query for public abstract void com.example.house_cleaning_service_company.employer.dao.EmployerDao.update(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long); Reason: Failed to create query for method public abstract void com.example.house_cleaning_service_company.employer.dao.EmployerDao.update(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long); No property 'update' found for type 'Employer'
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:712) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:692) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:127) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:481) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1397) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:598) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:521) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1405) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1325) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:709) ~[spring-beans-6.0.2.jar:6.0.2]
    ... 20 common frames omitted
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'employerDao' defined in com.example.house_cleaning_service_company.employer.dao.EmployerDao defined in @EnableJpaRepositories declared on JpaRepositoriesRegistrar.EnableJpaRepositoriesConfiguration: Could not create query for public abstract void com.example.house_cleaning_service_company.employer.dao.EmployerDao.update(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long); Reason: Failed to create query for method public abstract void com.example.house_cleaning_service_company.employer.dao.EmployerDao.update(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long); No property 'update' found for type 'Employer'
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1751) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:599) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:521) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1405) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1325) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:709) ~[spring-beans-6.0.2.jar:6.0.2]
    ... 34 common frames omitted
Caused by: org.springframework.data.repository.query.QueryCreationException: Could not create query for public abstract void com.example.house_cleaning_service_company.employer.dao.EmployerDao.update(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long); Reason: Failed to create query for method public abstract void com.example.house_cleaning_service_company.employer.dao.EmployerDao.update(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long); No property 'update' found for type 'Employer'
    at org.springframework.data.repository.query.QueryCreationException.create(QueryCreationException.java:101) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.lookupQuery(QueryExecutorMethodInterceptor.java:115) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.mapMethodsToQuery(QueryExecutorMethodInterceptor.java:99) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.lambda$new$0(QueryExecutorMethodInterceptor.java:88) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at java.base/java.util.Optional.map(Optional.java:260) ~[na:na]
    at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.<init>(QueryExecutorMethodInterceptor.java:88) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.repository.core.support.RepositoryFactorySupport.getRepository(RepositoryFactorySupport.java:357) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.repository.core.support.RepositoryFactoryBeanSupport.lambda$afterPropertiesSet$5(RepositoryFactoryBeanSupport.java:279) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.util.Lazy.getNullable(Lazy.java:229) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.util.Lazy.get(Lazy.java:113) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.repository.core.support.RepositoryFactoryBeanSupport.afterPropertiesSet(RepositoryFactoryBeanSupport.java:285) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.jpa.repository.support.JpaRepositoryFactoryBean.afterPropertiesSet(JpaRepositoryFactoryBean.java:132) ~[spring-data-jpa-3.0.0.jar:3.0.0]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1797) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1747) ~[spring-beans-6.0.2.jar:6.0.2]
    ... 44 common frames omitted
Caused by: java.lang.IllegalArgumentException: Failed to create query for method public abstract void com.example.house_cleaning_service_company.employer.dao.EmployerDao.update(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long); No property 'update' found for type 'Employer'
    at org.springframework.data.jpa.repository.query.PartTreeJpaQuery.<init>(PartTreeJpaQuery.java:96) ~[spring-data-jpa-3.0.0.jar:3.0.0]
    at org.springframework.data.jpa.repository.query.JpaQueryLookupStrategy$CreateQueryLookupStrategy.resolveQuery(JpaQueryLookupStrategy.java:124) ~[spring-data-jpa-3.0.0.jar:3.0.0]
    at org.springframework.data.jpa.repository.query.JpaQueryLookupStrategy$CreateIfNotFoundQueryLookupStrategy.resolveQuery(JpaQueryLookupStrategy.java:258) ~[spring-data-jpa-3.0.0.jar:3.0.0]
    at org.springframework.data.jpa.repository.query.JpaQueryLookupStrategy$AbstractQueryLookupStrategy.resolveQuery(JpaQueryLookupStrategy.java:95) ~[spring-data-jpa-3.0.0.jar:3.0.0]
    at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.lookupQuery(QueryExecutorMethodInterceptor.java:111) ~[spring-data-commons-3.0.0.jar:3.0.0]
    ... 56 common frames omitted
Caused by: org.springframework.data.mapping.PropertyReferenceException: No property 'update' found for type 'Employer'
    at org.springframework.data.mapping.PropertyPath.<init>(PropertyPath.java:90) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.mapping.PropertyPath.create(PropertyPath.java:423) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.mapping.PropertyPath.create(PropertyPath.java:399) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.mapping.PropertyPath.lambda$from$0(PropertyPath.java:352) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at java.base/java.util.concurrent.ConcurrentMap.computeIfAbsent(ConcurrentMap.java:330) ~[na:na]
    at org.springframework.data.mapping.PropertyPath.from(PropertyPath.java:334) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.mapping.PropertyPath.from(PropertyPath.java:317) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.repository.query.parser.Part.<init>(Part.java:81) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.repository.query.parser.PartTree$OrPart.lambda$new$0(PartTree.java:242) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197) ~[na:na]
    at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:179) ~[na:na]
    at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:992) ~[na:na]
    at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) ~[na:na]
    at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499) ~[na:na]
    at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:921) ~[na:na]
    at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) ~[na:na]
    at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:682) ~[na:na]
    at org.springframework.data.repository.query.parser.PartTree$OrPart.<init>(PartTree.java:243) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.repository.query.parser.PartTree$Predicate.lambda$new$0(PartTree.java:372) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197) ~[na:na]
    at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:179) ~[na:na]
    at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:992) ~[na:na]
    at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) ~[na:na]
    at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499) ~[na:na]
    at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:921) ~[na:na]
    at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) ~[na:na]
    at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:682) ~[na:na]
    at org.springframework.data.repository.query.parser.PartTree$Predicate.<init>(PartTree.java:373) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.repository.query.parser.PartTree.<init>(PartTree.java:93) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.jpa.repository.query.PartTreeJpaQuery.<init>(PartTreeJpaQuery.java:89) ~[spring-data-jpa-3.0.0.jar:3.0.0]
    ... 60 common frames omitted

Process finished with exit code 1

  [1]: https://i.stack.imgur.com/25agP.png
</code>```

Title: Transferring the query to the xml file

Body:
enter image description config xml

enter image description for use  xml file in code

This program uses "jpa", but for a series of tasks, I had to write a query, and as long as the queries were above the method, the program was executed, but after
Transferring the query to the program's xml program failed

My goal is to transfer the queries to the xml file in the spring boot jpa project

my error is

Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
2022-12-13T12:00:43.357+03:30 ERROR 16100 --- [           main] o.s.boot.SpringApplication               : Application run failed

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'employerController': Unsatisfied dependency expressed through field 'employerService': Error creating bean with name 'employerService': Unsatisfied dependency expressed through field 'employerDao': Error creating bean with name 'employerDao' defined in com.example.house_cleaning_service_company.employer.dao.EmployerDao defined in @EnableJpaRepositories declared on JpaRepositoriesRegistrar.EnableJpaRepositoriesConfiguration: Could not create query for public abstract void com.example.house_cleaning_service_company.employer.dao.EmployerDao.update(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long); Reason: Failed to create query for method public abstract void com.example.house_cleaning_service_company.employer.dao.EmployerDao.update(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long); No property 'update' found for type 'Employer'
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:712) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:692) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:127) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:481) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1397) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:598) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:521) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:961) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:915) ~[spring-context-6.0.2.jar:6.0.2]
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:584) ~[spring-context-6.0.2.jar:6.0.2]
    at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146) ~[spring-boot-3.0.0.jar:3.0.0]
    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:730) ~[spring-boot-3.0.0.jar:3.0.0]
    at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:432) ~[spring-boot-3.0.0.jar:3.0.0]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:308) ~[spring-boot-3.0.0.jar:3.0.0]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1302) ~[spring-boot-3.0.0.jar:3.0.0]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1291) ~[spring-boot-3.0.0.jar:3.0.0]
    at com.example.house_cleaning_service_company.HouseCleaningServiceCompanyApplication.main(HouseCleaningServiceCompanyApplication.java:12) ~[classes/:na]
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'employerService': Unsatisfied dependency expressed through field 'employerDao': Error creating bean with name 'employerDao' defined in com.example.house_cleaning_service_company.employer.dao.EmployerDao defined in @EnableJpaRepositories declared on JpaRepositoriesRegistrar.EnableJpaRepositoriesConfiguration: Could not create query for public abstract void com.example.house_cleaning_service_company.employer.dao.EmployerDao.update(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long); Reason: Failed to create query for method public abstract void com.example.house_cleaning_service_company.employer.dao.EmployerDao.update(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long); No property 'update' found for type 'Employer'
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:712) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:692) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:127) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:481) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1397) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:598) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:521) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1405) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1325) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:709) ~[spring-beans-6.0.2.jar:6.0.2]
    ... 20 common frames omitted
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'employerDao' defined in com.example.house_cleaning_service_company.employer.dao.EmployerDao defined in @EnableJpaRepositories declared on JpaRepositoriesRegistrar.EnableJpaRepositoriesConfiguration: Could not create query for public abstract void com.example.house_cleaning_service_company.employer.dao.EmployerDao.update(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long); Reason: Failed to create query for method public abstract void com.example.house_cleaning_service_company.employer.dao.EmployerDao.update(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long); No property 'update' found for type 'Employer'
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1751) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:599) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:521) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1405) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1325) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:709) ~[spring-beans-6.0.2.jar:6.0.2]
    ... 34 common frames omitted
Caused by: org.springframework.data.repository.query.QueryCreationException: Could not create query for public abstract void com.example.house_cleaning_service_company.employer.dao.EmployerDao.update(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long); Reason: Failed to create query for method public abstract void com.example.house_cleaning_service_company.employer.dao.EmployerDao.update(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long); No property 'update' found for type 'Employer'
    at org.springframework.data.repository.query.QueryCreationException.create(QueryCreationException.java:101) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.lookupQuery(QueryExecutorMethodInterceptor.java:115) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.mapMethodsToQuery(QueryExecutorMethodInterceptor.java:99) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.lambda$new$0(QueryExecutorMethodInterceptor.java:88) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at java.base/java.util.Optional.map(Optional.java:260) ~[na:na]
    at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.<init>(QueryExecutorMethodInterceptor.java:88) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.repository.core.support.RepositoryFactorySupport.getRepository(RepositoryFactorySupport.java:357) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.repository.core.support.RepositoryFactoryBeanSupport.lambda$afterPropertiesSet$5(RepositoryFactoryBeanSupport.java:279) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.util.Lazy.getNullable(Lazy.java:229) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.util.Lazy.get(Lazy.java:113) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.repository.core.support.RepositoryFactoryBeanSupport.afterPropertiesSet(RepositoryFactoryBeanSupport.java:285) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.jpa.repository.support.JpaRepositoryFactoryBean.afterPropertiesSet(JpaRepositoryFactoryBean.java:132) ~[spring-data-jpa-3.0.0.jar:3.0.0]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1797) ~[spring-beans-6.0.2.jar:6.0.2]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1747) ~[spring-beans-6.0.2.jar:6.0.2]
    ... 44 common frames omitted
Caused by: java.lang.IllegalArgumentException: Failed to create query for method public abstract void com.example.house_cleaning_service_company.employer.dao.EmployerDao.update(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long); No property 'update' found for type 'Employer'
    at org.springframework.data.jpa.repository.query.PartTreeJpaQuery.<init>(PartTreeJpaQuery.java:96) ~[spring-data-jpa-3.0.0.jar:3.0.0]
    at org.springframework.data.jpa.repository.query.JpaQueryLookupStrategy$CreateQueryLookupStrategy.resolveQuery(JpaQueryLookupStrategy.java:124) ~[spring-data-jpa-3.0.0.jar:3.0.0]
    at org.springframework.data.jpa.repository.query.JpaQueryLookupStrategy$CreateIfNotFoundQueryLookupStrategy.resolveQuery(JpaQueryLookupStrategy.java:258) ~[spring-data-jpa-3.0.0.jar:3.0.0]
    at org.springframework.data.jpa.repository.query.JpaQueryLookupStrategy$AbstractQueryLookupStrategy.resolveQuery(JpaQueryLookupStrategy.java:95) ~[spring-data-jpa-3.0.0.jar:3.0.0]
    at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.lookupQuery(QueryExecutorMethodInterceptor.java:111) ~[spring-data-commons-3.0.0.jar:3.0.0]
    ... 56 common frames omitted
Caused by: org.springframework.data.mapping.PropertyReferenceException: No property 'update' found for type 'Employer'
    at org.springframework.data.mapping.PropertyPath.<init>(PropertyPath.java:90) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.mapping.PropertyPath.create(PropertyPath.java:423) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.mapping.PropertyPath.create(PropertyPath.java:399) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.mapping.PropertyPath.lambda$from$0(PropertyPath.java:352) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at java.base/java.util.concurrent.ConcurrentMap.computeIfAbsent(ConcurrentMap.java:330) ~[na:na]
    at org.springframework.data.mapping.PropertyPath.from(PropertyPath.java:334) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.mapping.PropertyPath.from(PropertyPath.java:317) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.repository.query.parser.Part.<init>(Part.java:81) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.repository.query.parser.PartTree$OrPart.lambda$new$0(PartTree.java:242) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197) ~[na:na]
    at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:179) ~[na:na]
    at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:992) ~[na:na]
    at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) ~[na:na]
    at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499) ~[na:na]
    at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:921) ~[na:na]
    at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) ~[na:na]
    at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:682) ~[na:na]
    at org.springframework.data.repository.query.parser.PartTree$OrPart.<init>(PartTree.java:243) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.repository.query.parser.PartTree$Predicate.lambda$new$0(PartTree.java:372) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197) ~[na:na]
    at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:179) ~[na:na]
    at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:992) ~[na:na]
    at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) ~[na:na]
    at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499) ~[na:na]
    at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:921) ~[na:na]
    at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) ~[na:na]
    at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:682) ~[na:na]
    at org.springframework.data.repository.query.parser.PartTree$Predicate.<init>(PartTree.java:373) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.repository.query.parser.PartTree.<init>(PartTree.java:93) ~[spring-data-commons-3.0.0.jar:3.0.0]
    at org.springframework.data.jpa.repository.query.PartTreeJpaQuery.<init>(PartTreeJpaQuery.java:89) ~[spring-data-jpa-3.0.0.jar:3.0.0]
    ... 60 common frames omitted

Process finished with exit code 1

  [1]: https://i.stack.imgur.com/25agP.png


问:
Finding fourth vertex of rectangle
Given three points (x1,y1),(x2,y2),(x3,y3) on a Cartesian plane can u find a fourth point such that these four points form a rectangle using c program

Tha code I am expecting

Title: Finding fourth vertex of rectangle


问:
Puzzling Polymorphism
Can someone explain the reason for the non-polymorphic behavior of this piece of simple C++ code?

```<code>// src/main.cpp
#include <iostream>

class Base {
public:
    Base() {
        std::cout << "Making Base" << std::endl;
    }
    virtual void hello() {
        std::cout << "Hello Base" << std::endl;
    }
};

class Derived : public Base {
public:
    Derived() {
        std::cout << "Making Derived" << std::endl;
    }
    void  hello() override {
        std::cout << "Hello Derived" << std::endl;
    }
};

int main() {
    Base* bp = new Derived();
    // Making Base
    // Making Derived
    bp->hello();
    // Hello Derived

    Base b = Derived();
    // Making Base
    // Making Derived
    b.hello();
    // Hello Base
}
</code>```

Compile and run:

```<code>% g++ -std=c++14 -Wall -o obj/main.o -c src/main.cpp
% g++ -std=c++14 -Wall -o app obj/main.o
% ./app
Making Base
Making Derived
Hello Derived
Making Base
Making Derived
Hello Base
</code>```

I would have expected b.hello() to generate output Hello Derived, or cause a compiler warning/error.

Title: Puzzling Polymorphism

Body:
Can someone explain the reason for the non-polymorphic behavior of this piece of simple C++ code?

// src/main.cpp
#include <iostream>

class Base {
public:
    Base() {
        std::cout << "Making Base" << std::endl;
    }
    virtual void hello() {
        std::cout << "Hello Base" << std::endl;
    }
};

class Derived : public Base {
public:
    Derived() {
        std::cout << "Making Derived" << std::endl;
    }
    void  hello() override {
        std::cout << "Hello Derived" << std::endl;
    }
};

int main() {
    Base* bp = new Derived();
    // Making Base
    // Making Derived
    bp->hello();
    // Hello Derived

    Base b = Derived();
    // Making Base
    // Making Derived
    b.hello();
    // Hello Base
}

Compile and run:

% g++ -std=c++14 -Wall -o obj/main.o -c src/main.cpp
% g++ -std=c++14 -Wall -o app obj/main.o
% ./app
Making Base
Making Derived
Hello Derived
Making Base
Making Derived
Hello Base

I would have expected b.hello() to generate output Hello Derived, or cause a compiler warning/error.


问:
How to ask user for file Path in Java
I actually have to do a program which create a QR Code with some information.
To generate it, I use a html/JavaScript interface who call a java function.
For now, I use a specific path, but I want the user to choose where I want to save it.

The question is, how can I ask the user where to save the file?

(I'm actually new in java so any advice is good :) )

Here is the function:

```<code>public static void generateQrcode(String check) throws WriterException, IOException
{
    try {
        UUID uuid = UUID.randomUUID();
        String str = "qr-code-" + uuid.toString();
        String path = "/qr-code/" + str + ".png";
        String charset = "UTF-8";

        Map<EncodeHintType, ErrorCorrectionLevel> hashMap = new HashMap<>();
        hashMap.put(EncodeHintType.ERROR_CORRECTION, ErrorCorrectionLevel.L);
        qrcode(check, path, charset, 250, 250);
    } catch (Exception e) {
        System.out.println("An error occurred : " + e);
    }
}
</code>```
```<code>public static void qrcode(String data, String path, String charset, int h, int w) throws WriterException, IOException
{
    BitMatrix matrix = new MultiFormatWriter().encode(new String(data.getBytes(charset), charset), BarcodeFormat.QR_CODE, w, h);
    MatrixToImageWriter.writeToFile(matrix, path.substring(path.lastIndexOf('.') + 1), new File(path));
}
</code>```

I tried to use the File() method, but I think it doesn't help me.

Title: How to ask user for file Path in Java

Body:
I actually have to do a program which create a QR Code with some information.
To generate it, I use a html/JavaScript interface who call a java function.
For now, I use a specific path, but I want the user to choose where I want to save it.

The question is, how can I ask the user where to save the file?

(I'm actually new in java so any advice is good :) )

Here is the function:

public static void generateQrcode(String check) throws WriterException, IOException
{
    try {
        UUID uuid = UUID.randomUUID();
        String str = "qr-code-" + uuid.toString();
        String path = "/qr-code/" + str + ".png";
        String charset = "UTF-8";

        Map<EncodeHintType, ErrorCorrectionLevel> hashMap = new HashMap<>();
        hashMap.put(EncodeHintType.ERROR_CORRECTION, ErrorCorrectionLevel.L);
        qrcode(check, path, charset, 250, 250);
    } catch (Exception e) {
        System.out.println("An error occurred : " + e);
    }
}

public static void qrcode(String data, String path, String charset, int h, int w) throws WriterException, IOException
{
    BitMatrix matrix = new MultiFormatWriter().encode(new String(data.getBytes(charset), charset), BarcodeFormat.QR_CODE, w, h);
    MatrixToImageWriter.writeToFile(matrix, path.substring(path.lastIndexOf('.') + 1), new File(path));
}

I tried to use the File() method, but I think it doesn't help me.


问:
Align start drawable icon with edit text hint in android studio to the top
I want to align the start drawable icon to the top left corner as per the description. I have used gravity= "top|left" but it doesn't work. Please help

```<code><com.google.android.material.textfield.TextInputLayout
            android:id="@+id/descriptionLayout"
            style="@style/CustomTextInputLayout"
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            android:layout_marginTop="16dp"
            android:paddingStart="-12dp"
            android:gravity="top|start"
            app:errorIconDrawable="@null"
            app:hintEnabled="false"
            app:startIconDrawable="@drawable/ic_message"
            app:startIconTint="@color/primary"
            tools:ignore="RtlSymmetry">

            <com.google.android.material.textfield.TextInputEditText
                android:id="@+id/descriptionEt"
                style="@style/CustomTextInputEditText"
                android:gravity="top|start"
                android:layout_width="match_parent"
                android:layout_height="wrap_content"
                android:background="@color/white"
                android:hint="@string/description"
                android:inputType="textMultiLine"
                android:scrollbars="vertical"
                android:overScrollMode="always"
                android:lines="10"
                android:paddingVertical="0dp"
                tools:ignore="LabelFor" />

        </com.google.android.material.textfield.TextInputLayout>
</code>```

Body:
I want to align the start drawable icon to the top left corner as per the description. I have used gravity= "top|left" but it doesn't work. Please help

<com.google.android.material.textfield.TextInputLayout
            android:id="@+id/descriptionLayout"
            style="@style/CustomTextInputLayout"
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            android:layout_marginTop="16dp"
            android:paddingStart="-12dp"
            android:gravity="top|start"
            app:errorIconDrawable="@null"
            app:hintEnabled="false"
            app:startIconDrawable="@drawable/ic_message"
            app:startIconTint="@color/primary"
            tools:ignore="RtlSymmetry">

            <com.google.android.material.textfield.TextInputEditText
                android:id="@+id/descriptionEt"
                style="@style/CustomTextInputEditText"
                android:gravity="top|start"
                android:layout_width="match_parent"
                android:layout_height="wrap_content"
                android:background="@color/white"
                android:hint="@string/description"
                android:inputType="textMultiLine"
                android:scrollbars="vertical"
                android:overScrollMode="always"
                android:lines="10"
                android:paddingVertical="0dp"
                tools:ignore="LabelFor" />

        </com.google.android.material.textfield.TextInputLayout>


问:
How can i merge 2 rows with same value into 1 rows in Tableau Worksheet?
Image1

As image above, how can i make it into 1 row only so it will not looks like duplicate. The ww should be merge.

Below image is is the example that i want. Is it possible to do it? Please help..Thanks!
Image2


问:
ArcGIS excel add-on not picking up data updates in excel table
I used a few months ago ARCGis MAPS to produce maps from excel data. One of the things that annoyed me back then was that whatever change happened to the data affected the produced layer in the excel add-on of ArcGIS in Excel (not the webclient, I wasn't using it yet at that point). Like, filtering the table containing the data would make it so all filtered values would disappear from the map and so on, changing a zipcode/city name would move the dot, etc.

While it did cost me lots of credits back when I wasn't aware about it, now that I want to make use of it to correct a few  mistakes, it won't update the layer! I have billing addresses that don't match the delivery addresses that I couldn't spot ahead of creating the layer. So I thought of just updating them and be done with it, just like the tool itself does when it can't find a location due to wrong zipcodes/city names etc. Recreating the layers (there are a few) would cost me a lot of credits so I'd like to avoid it.

I looked around in the webclient parameters, but couldn't find anything. I did not upload the map and layers yet, and the data format used is table (not designated/named range).

Can anyone help me?


问:
How to let an Apache (Ubuntu) Proxy Server redirect/pass http to https (using VirtualHost tag in .conf file)

Hello all,

i have set up a proxy server on ubuntu that redirects a subdomain to an ip adress (target server).

It works, but only with https.

How can i make it work in http, so that it redirects as https (the target server only works with https) ?

Here are a few (fake-)data:

the subdomain is "mysub.mydomain.de"

the IP of the Proxy-Server is "101.102.103.104"

the IP of the target server is "106.107.108.109"

the subdomain gets redirected via A-record to the proxy-server-IP

My config file under /etc/apache2/sites-available/000-default.conf looks like this:

```<code><VirtualHost mysub.mydomain.de:443>
    ServerName mysub.mydomain.de

    SSLEngine on
    SSLProxyEngine on
    SSLProxyVerify none
    SSLProxyCheckPeerCN off
    SSLProxyCheckPeerName off
    SSLProxyCheckPeerExpire off
    ProxyPreserveHost on
    ProxyRequests off

    SSLCertificateFile /etc/apache2/sites-available/Zert/public.crt
    SSLCertificateKeyFile /etc/apache2/sites-available/Zert/private.key
    SSLCertificateChainFile /etc/apache2/sites-available/Zert/intermediate.crt

    ProxyPass "/" "https://106.107.108.109:443"
    ProxyPassReverse "/" "https://106.107.108.109:443"
</VirtualHost>

<VirtualHost mysub.mydomain.de:80>
    ServerName mysub.mydomain.de

    SSLEngine on
    SSLProxyEngine on
    SSLProxyVerify none
    SSLProxyCheckPeerCN off
    SSLProxyCheckPeerName off
    SSLProxyCheckPeerExpire off
    ProxyPreserveHost on
    ProxyRequests off

    SSLCertificateFile /etc/apache2/sites-available/Zert/public.crt
    SSLCertificateKeyFile /etc/apache2/sites-available/Zert/private.key
    SSLCertificateChainFile /etc/apache2/sites-available/Zert/intermediate.crt

    ProxyPass "/" "https://106.107.108.109:443"
    ProxyPassReverse "/" "https://106.107.108.109:443"
</VirtualHost>
</code>```

What i don't understand is: even if the second VirtualHost-block redirects from port 80 to https, will it also change the port to 443 ?

Thanks!
Tim

Body:
Hello all,

i have set up a proxy server on ubuntu that redirects a subdomain to an ip adress (target server).

It works, but only with https.

How can i make it work in http, so that it redirects as https (the target server only works with https) ?

Here are a few (fake-)data:

the subdomain is "mysub.mydomain.de"

the IP of the Proxy-Server is "101.102.103.104"

the IP of the target server is "106.107.108.109"

the subdomain gets redirected via A-record to the proxy-server-IP

My config file under /etc/apache2/sites-available/000-default.conf looks like this:

<VirtualHost mysub.mydomain.de:443>
    ServerName mysub.mydomain.de

    SSLEngine on
    SSLProxyEngine on
    SSLProxyVerify none
    SSLProxyCheckPeerCN off
    SSLProxyCheckPeerName off
    SSLProxyCheckPeerExpire off
    ProxyPreserveHost on
    ProxyRequests off

    SSLCertificateFile /etc/apache2/sites-available/Zert/public.crt
    SSLCertificateKeyFile /etc/apache2/sites-available/Zert/private.key
    SSLCertificateChainFile /etc/apache2/sites-available/Zert/intermediate.crt

    ProxyPass "/" "https://106.107.108.109:443"
    ProxyPassReverse "/" "https://106.107.108.109:443"
</VirtualHost>

<VirtualHost mysub.mydomain.de:80>
    ServerName mysub.mydomain.de

    SSLEngine on
    SSLProxyEngine on
    SSLProxyVerify none
    SSLProxyCheckPeerCN off
    SSLProxyCheckPeerName off
    SSLProxyCheckPeerExpire off
    ProxyPreserveHost on
    ProxyRequests off

    SSLCertificateFile /etc/apache2/sites-available/Zert/public.crt
    SSLCertificateKeyFile /etc/apache2/sites-available/Zert/private.key
    SSLCertificateChainFile /etc/apache2/sites-available/Zert/intermediate.crt

    ProxyPass "/" "https://106.107.108.109:443"
    ProxyPassReverse "/" "https://106.107.108.109:443"
</VirtualHost>

What i don't understand is: even if the second VirtualHost-block redirects from port 80 to https, will it also change the port to 443 ?

Thanks!
Tim


问:
Max does not calculate 100vh at all (css)
I am trying to set the height of a div (verticalFlexContainer) to the max value between 100vh and 100%. However, it is not properly calculating this.
I have a fiddle ready for perusal.

https://jsfiddle.net/cwLqapfn/

I'm trying to have a background image repeat in the background and an opacity on everything but the preview window. The tiling should be seamless into the preview window (which will house a transparent png, which can be of arbitrary sizes depending on the image that's in it). For ease of use in the example code, I've just used a static background color.

I've been testing images of size 1860x520 and 1344x1216 - one of which requires verticalFlexContainer to be set to 100vh and the other to be set to 100% to be rendered correctly. Whichever is greater (hence why I thought to use max).

See the below images for the problem:

preview: 1344x1216 (scrolled to bottom of screen), verticalFlexContainer: 100% - https://i.imgur.com/cbUl4Au.png (correct)

preview: 1344x1216 (scrolled to bottom of screen), verticalFlexContainer: 100vh - https://i.imgur.com/6bsQ6nr.png (see the broken part on the right)

preview: 1860x520, verticalFlexContainer: 100% - https://i.imgur.com/jAj5w44.png (see the broken part on bottom)

preview: 1860x520, verticalFlexContainer: 100vh - https://i.imgur.com/9dJOGcd.png (correct)

```<code><!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta http-equiv="X-UA-Compatible" content="ie=edge">
        <title>Broken Calculations</title>
    </head>
    <body>
        <div id="horizontalFlexContainer">
            <div id="verticalFlexContainer">
                <div id="previewContainer">
                    <div id="preview"></div>
                </div>
                <div class="opacityContent"></div>
            </div>
            <div class="opacityContent"></div>
        </div>
    </body>
</html>
</code>```
```<code>body {
    background-color: lightblue;
    background-repeat: repeat;
    margin: 0px;
    overflow: auto;
}
#horizontalFlexContainer {
    width: 100vw;
    height: fit-content;
    display: flex;
    flex-direction: row;
}
#verticalFlexContainer {
    height: max(100vh, 100%);
    width: fit-content;
    display: flex;
    flex-direction: column;
}
#previewContainer {
    border: 10px solid yellow;
    display: flex;
    outline: 20px solid rgba(0, 0, 0, 0.5);
    margin: 20px;
}
#preview {
    width: 1860px;
    height: 520px;
}
.opacityContent {
    flex: 1;
    background-color: rgba(0, 0, 0, 0.5);
}
</code>```

I expected the greater of 100% and 100vh to be selected by height: max(100%, 100vh). However, this is not the case. In instances when I use height: 100vh, it ends up with a greater calculated height than when I select height: 100%.

Body:
I am trying to set the height of a div (verticalFlexContainer) to the max value between 100vh and 100%. However, it is not properly calculating this.
I have a fiddle ready for perusal.

https://jsfiddle.net/cwLqapfn/

I'm trying to have a background image repeat in the background and an opacity on everything but the preview window. The tiling should be seamless into the preview window (which will house a transparent png, which can be of arbitrary sizes depending on the image that's in it). For ease of use in the example code, I've just used a static background color.

I've been testing images of size 1860x520 and 1344x1216 - one of which requires verticalFlexContainer to be set to 100vh and the other to be set to 100% to be rendered correctly. Whichever is greater (hence why I thought to use max).

See the below images for the problem:

preview: 1344x1216 (scrolled to bottom of screen), verticalFlexContainer: 100% - https://i.imgur.com/cbUl4Au.png (correct)

preview: 1344x1216 (scrolled to bottom of screen), verticalFlexContainer: 100vh - https://i.imgur.com/6bsQ6nr.png (see the broken part on the right)

preview: 1860x520, verticalFlexContainer: 100% - https://i.imgur.com/jAj5w44.png (see the broken part on bottom)

preview: 1860x520, verticalFlexContainer: 100vh - https://i.imgur.com/9dJOGcd.png (correct)

<!DOCTYPE html>

        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta http-equiv="X-UA-Compatible" content="ie=edge">
        <title>Broken Calculations</title>

body {
    background-color: lightblue;
    background-repeat: repeat;
    margin: 0px;
    overflow: auto;
}
#horizontalFlexContainer {
    width: 100vw;
    height: fit-content;
    display: flex;
    flex-direction: row;
}
#verticalFlexContainer {
    height: max(100vh, 100%);
    width: fit-content;
    display: flex;
    flex-direction: column;
}
#previewContainer {
    border: 10px solid yellow;
    display: flex;
    outline: 20px solid rgba(0, 0, 0, 0.5);
    margin: 20px;
}
#preview {
    width: 1860px;
    height: 520px;
}
.opacityContent {
    flex: 1;
    background-color: rgba(0, 0, 0, 0.5);
}

I expected the greater of 100% and 100vh to be selected by height: max(100%, 100vh). However, this is not the case. In instances when I use height: 100vh, it ends up with a greater calculated height than when I select height: 100%.


问:
Is there any chance to divide Swagger paths into separated files without fetching all at once?
My swagger.json (paths) file looks like

```<code>"paths": {
    "/auth/forgot-password": {
        "$ref": "../auth/forgot-password/post.json"
    }
}
</code>```

and inside forgot-password/post.json there are included files

```<code>"responses": {
    "200": {
        "$ref": "../responses/default.json#/success"
    },
    "403": {
        "$ref": "../responses/default.json#/forbidden"
    },
    "404": {
        "$ref": "../responses/default.json#/notFound"
    }
}
</code>```

I am curious if there is any chance to divide Swagger paths into separated files without fetching all on rendering page. Actually I made it to work but now I have a problem with response time because as I mentioned it will fetch all included files (one by one) which I don't want/need. (as more included files I have as bigger response time will be).

So my question should be: is there any way for this case to fetch only swagger.json not and forgot-password/post.json and responses/default.json?
These two files should be fetched only if user clicks to extend accordion to see specific endpoint.

Body:
My swagger.json (paths) file looks like

"paths": {
    "/auth/forgot-password": {
        "$ref": "../auth/forgot-password/post.json"
    }
}

and inside forgot-password/post.json there are included files

"responses": {
    "200": {
        "$ref": "../responses/default.json#/success"
    },
    "403": {
        "$ref": "../responses/default.json#/forbidden"
    },
    "404": {
        "$ref": "../responses/default.json#/notFound"
    }
}

I am curious if there is any chance to divide Swagger paths into separated files without fetching all on rendering page. Actually I made it to work but now I have a problem with response time because as I mentioned it will fetch all included files (one by one) which I don't want/need. (as more included files I have as bigger response time will be).

So my question should be: is there any way for this case to fetch only swagger.json not and forgot-password/post.json and responses/default.json?
These two files should be fetched only if user clicks to extend accordion to see specific endpoint.


问:
How to access AKENEO REST API WITH OAuth 2.0 ACCESS TOKEN with power Query
I am trying to access AKENEO REST API WITH OAuth 2.0 ACCESS TOKEN with power Query and after a long day of looking for the solution myself reading a lot of articles about the subject I have to say I’m dry on this one

Here is the documentation I am using from https://api.akeneo.com/documentation, my PIM version is V5 :

Here is my M code :

Here is my response:

As far as I understood:

I encoded the “client_id:secret” in B64 to fill the Authorisation header

I try to do a POST so I use Content in the url

I specify the header “Content-Type” as “application.json” and I send Json format value in the postData

I use anonymous authentication with Power BI considering that the authentication informations are imbembed into the url

I suppose that there is something wrong here but I can’t figure it out …

If you can help me on this one I would be grateful, also I am very interested in understanding what’s wrong here so don’t hesitate to explain !

Regards

Sylvain CHARLETY


问:
I am making an ERP system in Node and PostgreSQL. I want to create task , and no other task should be created in that minute
`

```<code>exports.addTask = ErrorAsyncCatch(async(req, res) => {
    // const task_code = await bcrypt.hash(req.body.task_code, 10);
    const {task_name, task_description, task_code, dept_id} = req.body;
    if(dept_id > 3 || dept_id < 0)
    {
        res.status(400).json({
            success: false,
            message: "No such department exists"
        })
        return
    }
    await client.query("INSERT INTO tasks (task_name, task_description, task_code, dept_id) VALUES ($1, $2, $3, $4) RETURNING *;",
    [task_name, task_description, task_code, dept_id],
    (err, result)=> {
        if(err){
            res.status(err.status).json({
                success: false,
                message: err.message
            })
        }
        else{
            res.status(200).json({
                message: "Data created Successfully",
                data: result.rows[0],
            });
        }
    }
    );
});
</code>```

`
Can anyone tell me How can I do it?

I am totally new in Node Js I try to use Node-cron but it runs after minutes automatically and dont stop.

Body:
`

exports.addTask = ErrorAsyncCatch(async(req, res) => {
    // const task_code = await bcrypt.hash(req.body.task_code, 10);
    const {task_name, task_description, task_code, dept_id} = req.body;
    if(dept_id > 3 || dept_id < 0)
    {
        res.status(400).json({
            success: false,
            message: "No such department exists"
        })
        return
    }
    await client.query("INSERT INTO tasks (task_name, task_description, task_code, dept_id) VALUES ($1, $2, $3, $4) RETURNING *;",
    [task_name, task_description, task_code, dept_id],
    (err, result)=> {
        if(err){
            res.status(err.status).json({
                success: false,
                message: err.message
            })
        }
        else{
            res.status(200).json({
                message: "Data created Successfully",
                data: result.rows[0],
            });
        }
    }
    );
});

`
Can anyone tell me How can I do it?

I am totally new in Node Js I try to use Node-cron but it runs after minutes automatically and dont stop.


问:
mongodb aggregation limit infinity
I use mongodb aggragetor pipeline with limit.

```<code>{ $limit:limit }
</code>```

Problem is, i am handlling dynamic limit. There are some time when I need all my data. Previously when i use find({}).limit(0) I get all data. But now when I use limit = 0 in my aggregator limit, Its responding

```<code>MongoServerError: the limit must be positive
</code>```

How can I use limit aggregator and also can retrieve all documents ??

Thank you.

Title: mongodb aggregation limit infinity

Body:
I use mongodb aggragetor pipeline with limit.

{ $limit:limit }

Problem is, i am handlling dynamic limit. There are some time when I need all my data. Previously when i use find({}).limit(0) I get all data. But now when I use limit = 0 in my aggregator limit, Its responding

MongoServerError: the limit must be positive

How can I use limit aggregator and also can retrieve all documents ??

Thank you.


问:
Getting undefined on returning values after reading content from a zip file

Library : node-stream-zip

I am using this library for unzipping the file and extracting one id from the manifest file.
In the other function, where I am calling this function, I am collecting this value but I am getting undefined. While printing the value of ID inside the function, it's printing. I am running this function for at least x times.

```<code>zip.on("ready", () => {
        let zipDotTxtContents = JSON.parse(
            zip.entryDataSync("manifest.json").toString("utf8")
        );
        id = zipDotTxtContents?.id;
        fs.unlinkSync(`./files/package${productId}.zip`, (err) => {
            if (err) {
                throw err;
            } else console.log("File Deleted");
        });
        zip.close();
        return id;
    });
</code>```

Body:
Library : node-stream-zip

I am using this library for unzipping the file and extracting one id from the manifest file.
In the other function, where I am calling this function, I am collecting this value but I am getting undefined. While printing the value of ID inside the function, it's printing. I am running this function for at least x times.

zip.on("ready", () => {
        let zipDotTxtContents = JSON.parse(
            zip.entryDataSync("manifest.json").toString("utf8")
        );
        id = zipDotTxtContents?.id;
        fs.unlinkSync(`./files/package${productId}.zip`, (err) => {
            if (err) {
                throw err;
            } else console.log("File Deleted");
        });
        zip.close();
        return id;
    });


问:
Mongo Helpers - Filters.in() within Filters.expr()
I'm constructing an aggregation lookup pipeline using the helper functions.

The aim is

In the batches table is an entry per list of 'primary batch for this list'

In the table of list items is a large collection of lists

I want

All the items with a particular status

Where the given userId is in the owners or readers

And where it is in the primary batch

Given the last bullet, a lookup seemed sensible.

Here's my pipeline, which was generated in new Document() style in Compass, but I altered to use helpers for readability.

```<code>MongoCollection<Document> batches = mongoTemplate.getCollection("batches")

Bson lookup = Aggregates.lookup("listItems", // from
    Arrays.asList(
       new Variable<>("listId", "$listId"),
       new Variable<>("batchId", "$latestBatch")),  // let
    Arrays.asList(
       Aggregates.match(Filters.expr(Filters.eq("status"), statusVar))),
       Aggregates.match(Filters.expr(Filters.or(
           Filters.in("owners", userId),
           Filters.in("readers", userId)
       ))),
       Aggregates.match(Filters.expr(Filters.and(
           Filters.eq("listId", "$$listId"),
           Filters.eq("batch", "$$batchId")
       )))
    ), // pipeline
    "listItems"); // as

Bson project = Aggregates.project(new Document("listItems", 1L));

batches.aggregate(Arrays.asList(lookup, project));
</code>```

One thing I've noticed is that Filters.in doesn't work and I have to use new Document("$in", Arrays.asList(userId, "$owners))

Is there a separate helper function for "Aggregate in", and are there any other errors or improvements I could make?

Body:
I'm constructing an aggregation lookup pipeline using the helper functions.

The aim is

In the batches table is an entry per list of 'primary batch for this list'

In the table of list items is a large collection of lists

I want

All the items with a particular status

Where the given userId is in the owners or readers

And where it is in the primary batch

Given the last bullet, a lookup seemed sensible.

Here's my pipeline, which was generated in new Document() style in Compass, but I altered to use helpers for readability.

MongoCollection<Document> batches = mongoTemplate.getCollection("batches")

Bson lookup = Aggregates.lookup("listItems", // from
    Arrays.asList(
       new Variable<>("listId", "$listId"),
       new Variable<>("batchId", "$latestBatch")),  // let
    Arrays.asList(
       Aggregates.match(Filters.expr(Filters.eq("status"), statusVar))),
       Aggregates.match(Filters.expr(Filters.or(
           Filters.in("owners", userId),
           Filters.in("readers", userId)
       ))),
       Aggregates.match(Filters.expr(Filters.and(
           Filters.eq("listId", "$$listId"),
           Filters.eq("batch", "$$batchId")
       )))
    ), // pipeline
    "listItems"); // as

Bson project = Aggregates.project(new Document("listItems", 1L));

batches.aggregate(Arrays.asList(lookup, project));

One thing I've noticed is that Filters.in doesn't work and I have to use new Document("$in", Arrays.asList(userId, "$owners))

Is there a separate helper function for "Aggregate in", and are there any other errors or improvements I could make?


问:
how can I connect my react js app to firebase 9?
I have been practicing on this react js app and wanted to connect to firebase for authentication of account creating and signing. but I get this error message,

Module not found: Error: Package path . is not exported from package /Users/feysel/roum/node_modules/firebase (see exports field in /Users/feysel/roum/node_modules/firebase/package.json). and I couldn't find the fix.

this is the firebase.js code
`

```<code>import firebase from "firebase";

const firebaseConfig = {
  apiKey: "AIzaSyAXdZmTDJjxY1cxn2QkNaqh2FzbGDPjds8",
  authDomain: "roum-34c72.firebaseapp.com",
  projectId: "roum-34c72",
  storageBucket: "roum-34c72.appspot.com",
  messagingSenderId: "509648148482",
  appId: "1:509648148482:web:6d66ae1678c1ddfd3baf1b",
  measurementId: "G-Z9EK18CBH0",
};

const firebaseApp = firebase.initializeApp(firebaseConfig);

const db = firebaseApp.firestore();
const auth = firebase.auth();

export { db, auth };

</code>```

and this one is from login.js

```<code>import React, { useState } from "react";
import "./Login.css";
import { Link } from "react-router-dom";
import { auth } from "./firebase";

function Login() {
  const [email, setEmail] = useState("");
  const [password, setPassword] = useState("");
  const signIn = (e) => {
    e.preventDefault();
  };
  const register = (e) => {
    e.preventDefault();
    auth
      .createUserWithEmailAndPassword(email, password)
      .then((auth) => {
        //new user creation successful with username & password
        console.log(auth);
      })
      .catch((error) => alert(error.message));
  };
</code>```

`

Body:
I have been practicing on this react js app and wanted to connect to firebase for authentication of account creating and signing. but I get this error message,

Module not found: Error: Package path . is not exported from package /Users/feysel/roum/node_modules/firebase (see exports field in /Users/feysel/roum/node_modules/firebase/package.json). and I couldn't find the fix.

this is the firebase.js code
`

import firebase from "firebase";

const firebaseConfig = {
  apiKey: "AIzaSyAXdZmTDJjxY1cxn2QkNaqh2FzbGDPjds8",
  authDomain: "roum-34c72.firebaseapp.com",
  projectId: "roum-34c72",
  storageBucket: "roum-34c72.appspot.com",
  messagingSenderId: "509648148482",
  appId: "1:509648148482:web:6d66ae1678c1ddfd3baf1b",
  measurementId: "G-Z9EK18CBH0",
};

const firebaseApp = firebase.initializeApp(firebaseConfig);

const db = firebaseApp.firestore();
const auth = firebase.auth();

export { db, auth };

and this one is from login.js

import React, { useState } from "react";
import "./Login.css";
import { Link } from "react-router-dom";
import { auth } from "./firebase";

function Login() {
  const [email, setEmail] = useState("");
  const [password, setPassword] = useState("");
  const signIn = (e) => {
    e.preventDefault();
  };
  const register = (e) => {
    e.preventDefault();
    auth
      .createUserWithEmailAndPassword(email, password)
      .then((auth) => {
        //new user creation successful with username & password
        console.log(auth);
      })
      .catch((error) => alert(error.message));
  };

`


问:
How i can create my own SDP- scalable size unit library for android?
Instead of using the SDP library I want to create my own styling for size units but because I am beginner I am looking for step by step guidance.

I am looking for step by step guidance.


问:
JS file is not loading on iphone
I have a problem that external scripts are not loaded on iphone, on ather devices it works good, on windows and android.

This is how I'm including the script

In dev tools it shows me that script was deleted.

Can someone help me?

I tried to add domain befor script url, to connect script at the bottom of html and at the top and it doesn't work.

Title: JS file is not loading on iphone


问:
Using Azure KV with GitLab CI
I try to implement Azure KeyVault for using its secrets in pipeline. For now there is question how to use it in pipeline cause gitlab uses hashicorp vault as vault for secrets.

Any idea how we can use it in GitLab CI?

Title: Using Azure KV with GitLab CI


问:
rerun issue on a dashboard using dash from plotly
```<code>I have a problem with dash, in which the dash.py file is executed over and over again instead of once and making the callbacks on the first execution. My problem is that I have a file that takes about a minute to run, but if it reruns every time I refresh the dashboard or every time it refreshes, it keeps loading.
</code>```

So I can't see it because it doesn't stop loading

```<code>
</code>```
```<code>I have not known what to change
</code>```

Body:
I have a problem with dash, in which the dash.py file is executed over and over again instead of once and making the callbacks on the first execution. My problem is that I have a file that takes about a minute to run, but if it reruns every time I refresh the dashboard or every time it refreshes, it keeps loading.

So I can't see it because it doesn't stop loading

I have not known what to change


问:
Django shell can't see apps(directories with files) that are in the current working directory
I'm fairly new, trying to learn Django. I'm not sure when this issue started, or what caused it, since I used Django shell before and everything worked fine.

I've tried different approaches, one of which I saw several times - open Django project from the project folder, not from the outer folder. I did it, and it still doesn't work(pic related)

(https://i.stack.imgur.com/swM1J.png)

I want to be able to import 'news' app within Django shell since it contains my models, so I can populate my db


Title: Decompressing bytes in C#

Body:
I have a simple program which is decompressing a byte array in C#.
There is the code of "Decompress" func:

private byte[] Decompress(byte[] compressed)
        {
            using var from = new MemoryStream(compressed);
            using var to = new MemoryStream();
            using var gZipStream = new GZipStream(from, CompressionMode.Decompress);
            gZipStream.CopyTo(to);
            return to.ToArray();
        }

and I have two byte arrays

var first = new byte[] { 31, 139, 8, 0, 0, 0, 0, 0, 0, 10, 45, 202, 65, 10, 128, 48, 12, 5, 209, 171, 132, 28, 195, 219, 68, 251, 91, 11, 38, 41, 105, 92, 137, 119, 23, 197, 221, 240, 152, 139, 39, 80, 120, 185, 88, 13, 234, 214, 55, 94, 88, 197, 154, 83, 115, 73, 154, 103, 84, 217, 64, 56, 48, 118, 177, 164, 130, 57, 164, 7, 5, 20, 186, 226, 141, 22, 72, 90, 97, 168, 61, 41, 251, 167, 7, 124, 72, 20, 250, 167, 233, 145, 124, 223, 15, 199, 8, 21, 161, 110, 0, 0, 0 };

var second = new byte[] { 31, 139, 8, 0, 0, 0, 0, 0, 0, 10, 1, 80, 0, 175, 255, 34, 127, 33, 66, 194, 252, 100, 6, 77, 155, 56, 146, 208, 225, 255, 219, 203, 33, 122, 153, 14, 246, 130, 28, 163, 183, 127, 145, 96, 71, 208, 206, 123, 9, 122, 133, 204, 255, 86, 191, 73, 197, 91, 247, 121, 156, 180, 101, 176, 125, 158, 123, 114, 192, 252, 70, 193, 148, 180, 183, 200, 146, 79, 121, 135, 152, 90, 247, 107, 168, 157, 128, 84, 121, 4, 122, 92, 145, 45, 223, 177, 179, 189, 149, 80, 0, 0, 0 }

my next step is:

var decompressed = Decompress(first);
var result = Encoding.UTF8.GetString(decompressed);

Output: {"seed":{"mnemonic":"mango goat surface elephant despair remember regret benefit timber leopard member sort"}}

var decompressed = Decompress(second);
var result = Encoding.UTF8.GetString(decompressed);

Output: "!B??d♠M?8??????!z???∟???`G??{  z???V?I?[?y??e?}?{r??F?????Oy??Z?k???Ty♦z\?-?

The structure of these arrays is the same... length (103), first 10 elements and last 3 elements. But first array decompresses with func Decompress fine and the second one is very bad. I don't know why it's happening. Someone explain where is my mistake.

I tried to decompress with python using gzip but I have the same result. There is the code

import gzip

first = [31, 139, 8, 0, 0, 0, 0, 0, 0, 10, 45, 202, 65, 10, 128, 48, 12, 5, 209, 171, 132, 28, 195, 219, 68, 251, 91, 11, 38, 41, 105, 92, 137, 119, 23, 197, 221, 240, 152, 139, 39, 80, 120, 185, 88, 13, 234, 214, 55, 94, 88, 197, 154, 83, 115, 73, 154, 103, 84, 217, 64, 56, 48, 118, 177, 164, 130, 57, 164, 7, 5, 20, 186, 226, 141, 22, 72, 90, 97, 168, 61, 41, 251, 167, 7, 124, 72, 20, 250, 167, 233, 145, 124, 223, 15, 199, 8, 21, 161, 110, 0, 0, 0 ];

second = [31, 139, 8, 0, 0, 0, 0, 0, 0, 10, 1, 80, 0, 175, 255, 34, 127, 33, 66, 194, 252, 100, 6, 77, 155, 56, 146, 208, 225, 255, 219, 203, 33, 122, 153, 14, 246, 130, 28, 163, 183, 127, 145, 96, 71, 208, 206, 123, 9, 122, 133, 204, 255, 86, 191, 73, 197, 91, 247, 121, 156, 180, 101, 176, 125, 158, 123, 114, 192, 252, 70, 193, 148, 180, 183, 200, 146, 79, 121, 135, 152, 90, 247, 107, 168, 157, 128, 84, 121, 4, 122, 92, 145, 45, 223, 177, 179, 189, 149, 80, 0, 0, 0 ];

bytes_of_values = bytes(first)
decompressed_block = gzip.decompress(bytes_of_values)
print(decompressed_block.decode('utf8', 'ignore'))
#Output: {"seed":{"mnemonic":"mango goat surface elephant despair remember regret benefit timber leopard member sort"}}

bytes_of_values = bytes(second)
decompressed_block = gzip.decompress(bytes_of_values)
print(decompressed_block.decode('utf8', 'ignore'))
#Output: "!Bd♠M8!z∟`G{   zVI[ye}{rFȒOyZkTy♦z\-

UPDATE #1
FIRST ARRAY was expanded with this JS function.

const crypto = require('crypto')

module.exports = function (size        )         {
  return {
    expand (data        )         {
      const buffer = crypto.randomBytes(data.length < size - 4 ? size : data.length + 4)
      buffer.writeUInt32BE(data.length, 0)
      data.copy(buffer, 4, 0)
      return buffer
    },
    shrink (buffer        )         {
      const dataLen = buffer.readUInt32BE(0)
      return buffer.slice(4, dataLen + 4)
    }
  }
}

Where size = 2 ** 15 (2^15 = 32768); data = {"seed":{"mnemonic":"mango goat surface elephant despair remember regret benefit timber leopard member sort"}}. In output we have a Buffer with size 32768. After that I take this Buffer and convert to string like "[1, 2, 3 ,4 ,5, etc.]" (remind that size is 32768) and pass this to C#. In C# I use this code:

var shrink = BinaryPrimitives.ReadUInt32BigEndian(data); //data == array with size 32768 (string from JS)
//shrink == 103 (integer)
var segment = new ArraySegment<byte>(data, 4, (int)shrink).ToArray();
// segment == FIRST ARRAY

after following these steps I get the FIRST ARRAY and it decompresses fine. The structure of the first array are identical to SECOND ARRAY. And I understood that SECOND ARRAY uses the same algorithm. But it doesn't unpack.


问:
logstash convert existing timestamp format to another timestamp format
I have 2 different application logs.

OUTPUT:

```<code><135>1 2022-12-12T16:28:02Z HOSTNAME EvntSLog - - - Le service Service de licences de client (ClipSVC) est entré dans l’état : arrêté.

<134>Dec 12 16:28:02 HOSTNAME CEF:0|Trend Micro|Deep Security Manager|20.0.703|602|User Timed Out|
</code>```

Here, both timestamp is different and I want to convert both timestamp format to standard timestamp format
which would be "dd-mm-yyyy-HH-MM-SS".

My filter setting is

```<code>grok {
      match => { "message" => "%{TIMESTAMP_ISO8601:timestamp}" }
    }
    date {
        match => ["timestamp", "yyyy-mm-dd HH:mm:ss,SSS", "yyyy-mm-dd HH:mm:ss a"]
    }
</code>```

Thanks in advance.

Body:
I have 2 different application logs.

OUTPUT:

<135>1 2022-12-12T16:28:02Z HOSTNAME EvntSLog - - - Le service Service de licences de client (ClipSVC) est entré dans l’état : arrêté.

<134>Dec 12 16:28:02 HOSTNAME CEF:0|Trend Micro|Deep Security Manager|20.0.703|602|User Timed Out|

Here, both timestamp is different and I want to convert both timestamp format to standard timestamp format
which would be "dd-mm-yyyy-HH-MM-SS".

My filter setting is

grok {
      match => { "message" => "%{TIMESTAMP_ISO8601:timestamp}" }
    }
    date {
        match => ["timestamp", "yyyy-mm-dd HH:mm:ss,SSS", "yyyy-mm-dd HH:mm:ss a"]
    }

Thanks in advance.