Problem: Danish specific characters are displayed improperly(as non readable chars) Given: Database is Microsoft SQL server 2019, database collation is: Danish_Greenlandic_100_CS_AS. Data has been …
Tag: jdbc
JPA Hibernate Annotation Issue
I have three Entities i’m modeling and am having issues with the associated annotations. I basically have a class that I intend on returning to the caller, a nested listed of Project’s and the Project …
OAuth with CData JDBC Driver for XML – Files on Google Drive – CallbackURL not Used
I am using the CData JDBC Driver for XML to read XML files to my java application and some of those files are on google drive so OAuth is needed. I am following the Authenticate to XML from a Web …
How close possibility to add new data in H2?
I have a problem. After adding some data to database, I need to set read-only mode for whole DB. What is the easiest way to do that using h2 embedded DB with driver manager (jdbc)? Class.forName(“…
WAS gets hung WSVR0605W due to jdbc preparedstatement execute WCS
I’m trying to execute three different prepared statements inside a function which basically does an insert in three different tables. File registration.java public String regPoints(Timestamp time2, …
SAP DBTech JDBC: Cannot connect to jdbc:sap://… on SCP
I’m running a Java application in the SAP Cloud Platform that connects to a shared HANA DB using JDBC. Out of a sudden (no code changes, no deployments, no config changes…) the application can no …
JDBC4 syntax error, but MySQL accepts the query
I’ve tried running the following query with JDBC4, which leads to a syntax error: SELECT m.* FROM schema.table m INNER JOIN ( SELECT :id0 as id, :from0 as date_from, :to0 as date_to UNION …
Parameter index out of range (1 > number of parameters, which is 0) When trying to read SQL Table
So I am trying to get some data out of my SQL Table with this servlet and output it in a JSP file. I found some articles with similar problems to mine but none of them helped in my case. I Hoped …
Java PreparedStatement preserve table name casing
I have this Java snippet, running inside a WildFly server backed by MariaDB: var stmt = conn.prepareStatement(“SELECT * FROM vehicles;”); ResultSet rs = stmt.executeQuery(); which gives me the …
UnsupportedOperationException with DriverManager.getConnection() on Android
I am unable to connect JDBC to my database, getting following error Answer According to the stacktrace, the MySQL Connector/J version you are using is using a java.util.regex.Matcher feature not supported on Android (probably named groups). The workaround is to use a 5.1.x version of MySQL Connector/J instead of a 8.0.x version. However, you shouldn’t use JDBC from Android applications.