luize casaretti

I tried with:

callableStatement.setDate(3, new java.sql.Date(DateUtils.parseDate(formatDate, Constants.DATE_PATTERN_DDMMYYYY).getTime()));

but this new java.sql.Date(DateUtils.parseDate(formatDate, "ddMMyyyy").getTime() still returns yyyyMMdd

I just need to save the dd-MM-yyyy format

Hi!

When I execute this in SQL, it works fine:
call  EX.PROC_EXAMPLE ('09876','001234','18-04-2024',10000, 888);

Note 1: The third field ('18-04-2024) is a DATE in SQL.
Note 2: The third field has the format DD-MM-YYYY.

However, when I try to execute with a CallableStatement, it returns ORA-01843: not a valid month:
public void executeProcedureX(ParamsX params) throws Exception { CallableStatement callableStatement = null; Connection connection = null; try {                       // params.getDate() = "20240418"  - the yyyyMMdd format that I need to change SimpleDateFormat inputFormat = new SimpleDateFormat("yyyyMMdd"); SimpleDateFormat outputFormat = new SimpleDateFormat("dd-MM-yyyy"); Date utilDate = inputFormat.parse(params.getDate()); String formatDate = outputFormat.format(utilDate);                                               //formatDate =18-04-2024  - the right format dd-MM-yyyy that I need is ok and I need to store. connection = getConnection(); StringBuilder sqlBuilder = new StringBuilder(); sqlBuilder.append("call EX.PROC_EXAMPLE(?,?,?,?,?)"); callableStatement = connection.prepareCall(sqlBuilder.toString()); callableStatement.setString(1, params.getContract());  //params.getContract() is a String callableStatement.setString(2, String.valueOf(params.getCode()));  // params.getCode() is an Integer callableStatement.setString(3, formatDate); // formatDate is an String callableStatement.setBigDecimal(4, params.getValue()); // params.getValue() is a BigDecimal callableStatement.setBigDecimal(5, params.getValueAnt()); // params.getValueAnt() is a BigDecimal logger.info("sqlBuilder:" +sqlBuilder); callableStatement.execute(); }catch (Exception e) { logger.error(e.getMessage(),e); throw new Exception(e); } finally { DatabaseConnectionManager.getInstance().closeResources(null, null, connection, callableStatement); } }

I don't understand why it returns  ORA-01843: not a valid month once the setString is being set with a String and the field is a DATE in SQL, I read it was supposed to work with the setString().

I tried also with setDate() passing a Date as params, but it didn't work also.


Could you help me?

it worked! Thank you so much

Hi all,

I'm having some difficulty in generating multiple logs, now it generates all log files but the content in all of them is the content of fileThree (last one) only. I need to generate each file with its content.

Here is what I have:

private static Logger logger = LogManager.getLogger("fileOne"); private static Logger logger = LogManager.getLogger("fileTwo"); private static Logger logger = LogManager.getLogger("fileThree");

status=trace appender.rolling3.type = RollingFile appender.rolling3.name = fileOne appender.rolling3.fileName = path/fileOne.log appender.rolling3.filePattern = path/fileOne-%d{yyyy-MM-dd}.log appender.rolling3.layout.type = PatternLayout appender.rolling3.layout.pattern = %d %5p %m%n appender.rolling3.policies.type = Policies appender.rolling3.policies.size.type = SizeBasedTriggeringPolicy appender.rolling3.policies.size.size = 10 MB appender.rolling3.strategy.type = DefaultRolloverStrategy appender.rolling3.strategy.max = 10 logger.app.name=fileOne logger.app.level=debug logger.app.additivity=false logger.app.appenderRef.rolling3.ref=fileOne #AMC appender.rolling2.type = RollingFile appender.rolling2.name = fileTwo appender.rolling2.fileName = path/fileTwo.log appender.rolling2.filePattern = path/fileTwo-%d{yyyy-MM-dd}.log appender.rolling2.layout.type = PatternLayout appender.rolling2.layout.pattern = %d %5p %m%n appender.rolling2.policies.type = Policies appender.rolling2.policies.size.type = SizeBasedTriggeringPolicy appender.rolling2.policies.size.size = 10 MB appender.rolling2.strategy.type = DefaultRolloverStrategy appender.rolling2.strategy.max = 10 logger.app.name = fileTwo logger.app.level = debug logger.app.additivity = false logger.app.appenderRef.rolling2.ref=fileTwo #KYC appender.rolling.type = RollingFile appender.rolling.name = fileThree appender.rolling.fileName = path/fileThree.log appender.rolling.filePattern = path/fileThree-%d{yyyy-MM-dd}.log appender.rolling.layout.type = PatternLayout appender.rolling.layout.pattern = %d %5p %m%n appender.rolling.policies.type = Policies appender.rolling.policies.size.type = SizeBasedTriggeringPolicy appender.rolling.policies.size.size = 10 MB appender.rolling.strategy.type = DefaultRolloverStrategy appender.rolling.strategy.max = 10 logger.app.name = fileThree logger.app.level = debug logger.app.additivity = false logger.app.appenderRef.rolling.ref=fileThree # Configure root logger rootLogger.level = debug

Could you help me?

Hey guys!

Is my first time using HttpsURLConnection  and I've been trying to send a XML request but I'm getting 500 code as response and  the response message returns NULL.
I read that this could be encoding problems and I tried to set some connection properties but in all tests it kept returning 500 and null message.
OBS: When I get the same URL and the same xml message and test it via SoapUI it works fine.

Do you know if I'm missing some property?

XML example:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <a:ExampleRequest xmlns:a="http://test/schema/1.0/example"> <ExampleRequestDetails> <Id>1</Id> <ClientId>9999</ClientId> </ExampleRequestDetails> </a:ExampleRequest>

HttpsURLConnection:
                       String xml= "<xml-example>";                        String endpointUrl = "https://test/example"; byte[] postData       = xml.getBytes( StandardCharsets.UTF_8 ); int    postDataLength = postData.length; URL url = new URL(endpointUrl); HttpsURLConnection connection = (HttpsURLConnection) url.openConnection(); connection.setRequestMethod("POST"); connection.setDoOutput(true); connection.addRequestProperty("Accept-Charset", "UTF-8"); connection.setRequestProperty("Content-Type", "application/xml; charset=utf-8"); connection.setRequestProperty( "Content-Length", Integer.toString( postDataLength )); //                     connection.addRequestProperty("Accept-Encoding", "gzip, deflate"); // I tried to add this as a test //                 connection.setRequestProperty("Content-Type", "text/xml; charset=utf-8"); // I tried to change it to text/xml, but in SoapUI is working with application/xml // connection.setRequestProperty("Connection", "Keep-Alive"); // I tried to use it as a test // connection.setReadTimeout(10000); // I tried to use it as a test // connection.setConnectTimeout(15000); // I tried to use it as a test // connection.setUseCaches( false );  // I tried to use it as a test         //write XML data to request body try(OutputStream os = connection.getOutputStream()){ DataOutputStream dos = new DataOutputStream(os); dos.write(postData); }                        int responseCode =  connection.getResponseCode(); //returns 500 String responseResult =  connection.getResponseMessage(); //returns null

Thank you.

Hi guys,

I'm trying to make a HttpsURLConnection request with SSL Certificates and receiving 403 always - the certificates doesn't have .key.

I have two certificates .cer and I created a Keystore for them in a folder locally:
keytool -importcert -file "<certificate1>.cer" -keystore <keystorename>.jks -alias "<certificate1>" keytool -importcert -file "<certificate2>.cer" -keystore <keystorename>.jks -alias "<certificate2>"

When I list them, I can see them:
keytool -list -v -keystore <keystorename>.jks

The problem is that when I run locally I always get 403 here: connection.getResponseCode()
My java code is:
                       System.setProperty("javax.net.ssl.trustStore","<path/to/file.jks>"); System.setProperty("javax.net.ssl.trustStorePassword", "<password>"); char[] keypassword = "<password>".toCharArray(); String keystorepath = "<path/to/file.jks>"; KeyStore keystore = KeyStore.getInstance(KeyStore.getDefaultType()); FileInputStream inputStream = new FileInputStream(keystorepath); keystore.load(inputStream, keypassword); KeyManagerFactory keymManagerfactory = KeyManagerFactory.getInstance(KeyManagerFactory.getDefaultAlgorithm()); keymManagerfactory.init(keystore, keypassword); //Build SSL context with keystore //SSLContext sslContext = SSLContext.getInstance("TLSv1.2"); //sslContext.init(keymManagerfactory.getKeyManagers(), null, new SecureRandom()); //sslContext.init(null, null, null); String endpointUrl = "https://example/example"; URL url = new URL(endpointUrl); HttpsURLConnection connection = (HttpsURLConnection) url.openConnection(); HttpsURLConnection.setDefaultHostnameVerifier(jvmHostnameVerifier); HttpsURLConnection.setDefaultSSLSocketFactory(sslContext.getSocketFactory()); connection.setRequestMethod("POST"); connection.setDoOutput(true); connection.setRequestProperty("Content-Type", "application/xml"); //write XML data to request body try(OutputStream os = connection.getOutputStream()){ os.write(xml.getBytes("UTF-8")); } //GET RESPONSE int responseCode =  connection.getResponseCode();


I tried different things such as create an X509Certificate for each certificate and X509TrustManager with both certificates but still didn't work.

Websphere 8.5.5
Dynamic web module 2.5
javaee 7


What is working locally is:
Dynamic web module 3.0 (upgraded)
jax rs 2.0 (included)
build.xml: didn't add any jar

Resource.java
package com.example; import javax.ws.rs.GET; import javax.ws.rs.Path; import javax.ws.rs.core.MediaType; import javax.ws.rs.core.Response; @Path("resource") public class Resource {    @GET    @Path("/ping")    public Response ping() {        return Response.ok().entity("Service online").build();    } }

AppApplication.java
package com.example; import javax.ws.rs.ApplicationPath; import javax.ws.rs.GET; import javax.ws.rs.core.Application; import javax.ws.rs.core.Response; @ApplicationPath("app") public class AppApplication extends Application { @GET    public Response pingApp() {        return Response.ok().entity("Application Online").build();    }   }

It works fine locally when I post or get
However, when I try to compile to deploy, I get  error: package javax.ws.rs does not exist
If I add jax rs jar it compiles.. but I do have this feature enabled on server.xml, I thought I didn't need this jar.
server.xml
 <!-- Enable features -->    <featureManager>        <feature>javaee-7.0</feature>        <feature>jaxb-2.2</feature>        <feature>jaxrs-2.0</feature>        <feature>localConnector-1.0</feature>        <feature>mpOpenAPI-1.0</feature>    </featureManager>

Properties:
-Eclipse 4.16
-Websphere 18.0.0.4
-Dynamic web project - Dynamic web Module 2.5v
-Web Application
-Java: 1.8v
-I do not have MAVEN or Spring boot.

I have this application and my goal is to include a JAX-RS API in it.

When I try to access another servlet that reads an MQ line: http://localhost:9080/<contextroot>/<other_servlet>;  -> it works
When I try to access API that I included (JAX-RS):        
http://localhost:9080/<contextroot>/webapi/resource/ping -> I get SRVE0190E: File not found: /webapi/resource/ping not found
http://localhost:9080/<contextroot>/webapi/resource -> I get SRVE0190E: File not found: /webapi/resource not found

I tried to follow this tutorial: https://www.youtube.com/watch?v=d5SD4bKaOFU&list=PLqq-6Pq4lTTY40IcG584ynNqibMc1heIa&index=3 at first but I failed.
As I was searching on the internet I started adding some dependencies and trying to make this work. However, I could not do it.

Do you have any ideias?

Build.xml
<pathelement location="${libs_external_dir}/jaxrs-ri-3.1.0.jar"/>    <pathelement location="${libs_external_dir}/jersey-media-moxy-3.1.0.jar"/>    <pathelement location="${libs_external_dir}/javax.json-api-1.1.4.jar"/>    <pathelement location="${libs_external_dir}/javax.json-1.1.4.jar"/>    <pathelement location="${libs_external_dir}/javaee-api-7.0.jar"/>    <pathelement location="${libs_external_dir}/javax.ws.rs-api-2.0.jar"/>    <pathelement location="${libs_external_dir}/jakarta.servlet-api-5.0.0"/>    <pathelement location="${libs_external_dir}/jersey-container-servlet-core-3.1.0"/>

Application.java
package com.citibank.test.example; import javax.ws.rs.ApplicationPath; import javax.ws.rs.core.Application; import javax.ws.rs.core.Context; import javax.ws.rs.core.UriInfo; @ApplicationPath("/webapi") public class TestApplication extends Application {    @Context    private UriInfo context;    /**     * Creates a new instance of SimetPersistence     */    public TestApplication() {    }     }



Resource.java
package com.citibank.test.example; import javax.management.Notification; import javax.ws.rs.Consumes; import javax.ws.rs.GET; import javax.ws.rs.POST; import javax.ws.rs.Path; import javax.ws.rs.PathParam; import javax.ws.rs.Produces; import javax.ws.rs.core.MediaType; import javax.ws.rs.core.Response; @Path("resource") public class TestResource {     @GET    @Path("/ping")    public Response ping() {        return Response.ok().entity("Service online").build();    }    @POST    @Path("/post")    @Consumes(MediaType.APPLICATION_JSON)    @Produces(MediaType.APPLICATION_JSON)    public Response postNotification(Notification notification) {        return Response.status(201).entity(notification).build();    } }

Build.xml
<pathelement location="${libs_external_dir}/jaxrs-ri-3.1.0.jar"/> <pathelement location="${libs_external_dir}/jersey-media-moxy-3.1.0.jar"/> <pathelement location="${libs_external_dir}/javax.json-api-1.1.4.jar"/> <pathelement location="${libs_external_dir}/javax.json-1.1.4.jar"/> <pathelement location="${libs_external_dir}/javaee-api-7.0.jar"/> <pathelement location="${libs_external_dir}/javax.ws.rs-api-2.0.jar"/> <pathelement location="${libs_external_dir}/jakarta.servlet-api-5.0.0"/> <pathelement location="${libs_external_dir}/jersey-container-servlet-core-3.1.0"/>

Application.java
package com.citibank.test.example; import javax.ws.rs.ApplicationPath; import javax.ws.rs.core.Application; import javax.ws.rs.core.Context; import javax.ws.rs.core.UriInfo; @ApplicationPath("/webapi") public class TestApplication extends Application { @Context    private UriInfo context;    /**     * Creates a new instance of SimetPersistence     */    public TestApplication() {    } }


Resource
package com.citibank.test.example; import javax.management.Notification; import javax.ws.rs.Consumes; import javax.ws.rs.GET; import javax.ws.rs.POST; import javax.ws.rs.Path; import javax.ws.rs.PathParam; import javax.ws.rs.Produces; import javax.ws.rs.core.MediaType; import javax.ws.rs.core.Response; @Path("resource") public class TestResource { @GET    @Path("/ping")    public Response ping() {        return Response.ok().entity("Service online").build();    }    @POST    @Path("/post/")    @Consumes(MediaType.APPLICATION_JSON)    @Produces(MediaType.APPLICATION_JSON)    public Response postNotification(Notification notification) {        return Response.status(201).entity(notification).build();    } }

When I access: http://localhost:9080/<contextroot>/<other_servlet>;  - it works
When I access http://localhost:9080/<contextroot>/webapi/resource/ping - I get SRVE0190E: File not found: /webapi/resource/ping not found

Hi, guys!
I have an application with Websphere 8.5, I upgraded spring boot version from 2.4.0 to 2.5.0 locally and it worked, however, when I tried to deploy it I got the error:
    NoClassDefFoundError: javax.servlet.http.HttpSessionIdListener.
I was wondering if there is any way to fix it, other than upgrading Websphere 9.0.

Hi guys, I'm trying to open a view in a new tab.
Now the page opens in the same tab.

I tried with th:target="_blank" too but still got it opening in the same page.

HTML
<a th:href="@{/example/{code}/{version}(code=${item.code}, version=${item.version})}" target="_blank"  rel="noopener noreferrer" title="Example View"> </a>

Controller
@GetMapping(value = "example/{code}/{version}/{source}")    public String showExamplePage(@PathVariable(ModelAttributes.CODE) Long code, @PathVariable(ModelAttributes.VERSION) Long version,@PathVariable String source, Model model) throws Exception {        ... model.addAttribute(ModelAttributes.EX_HTML, exHtml); ...        return Views.VIEW_EXAMPLE;    }

In my C:\Project\target\surefire-reports I get:
Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 1.244 s <<< FAILURE! - in <class> <class>  Time elapsed: 1.243 s  <<< ERROR! java.lang.NoClassDefFoundError: org/springframework/test/context/TestContextAnnotationUtils Caused by: java.lang.ClassNotFoundException: org.springframework.test.context.TestContextAnnotationUtils
However, no imports presented problem.