I am trying the managed database service on DigitalOcean.com, having created a Postgres instance. Digital Ocean defaults to requiring remote connections be made with SSL (actually TLS) encryption. How does one configure a JDBC DataSource implementation for providing connections to such a database server? This…
Tag: jdbc
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 Application flow specified on CData website. The first step is to get the OAuth Authorization URL using the GetOAu…
Getting the SQL Server Connection Exception
I am getting below connection exception, when trying to connect to SQL Server using JDBC. Can someone please help, with this issue? I am using sqljdbc4.jar file to connect to SQL Server Code is as below This is the exception. Nov 14, 2020 8:33:01 PM com.microsoft.sqlserver.jdbc.TDSChannel enableSSL INFO: java…
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)? Answer You can open the whole database in read-only mode by appending ;ACCESS_MODE_DATA=r to the JDBC URL (“jdbc:h2:”…
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 createConnection method – I’m using ojdbc6.jar When I call the regPoints function from a webpage in my local RAD or local environment i…
setReadOnly not working on PostgreSQL Connection
I have a problem setting a read-only connection with a PostgreSQL database using JDBC. I’m creating an application which loads queries to execute from a file, and I want to execute only SELECT (read-only) queries. Setting permissions on users who will run the application is not an option, so setting per…
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 database using JDBC. Out of a sudden (no code changes, no deployments, no config changes…) the application can no longer connect to the database. The logs/stacktrace says: Failed to get connection from datasour…
JDBC4 syntax error, but MySQL accepts the query
I’ve tried running the following query with JDBC4, which leads to a syntax error: Strangely enough, when I run the query via mysql (on the same database server), the query is accepted and run. The error message is even more confusing, as there is no closing ) on line 1. The server is running MySQL 5.1. …
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 someone here can help me. I have to do this Project for one of my classes. I am
Java PreparedStatement preserve table name casing
I have this Java snippet, running inside a WildFly server backed by MariaDB: which gives me the following exception: So, apparentally, it decided to uppercase the table name, which I don’t want. How can I turn it off? Answer That is not possible, SQL dialects are – usually – case insensitive…