All Questions
Tagged with java prepared-statement
5 questions
0
votes
1
answer
267
views
Use quoted schema in an insert statement executed thorough PreparedStatement in Java
I created an unquoted table my_table under a quoted schema "Quoted_User".
When executing the statement
INSERT INTO "Quoted_User".my_table (custom_id) VALUES (DEFAULT)
using the Intellij Oracle ...
-1
votes
2
answers
587
views
executing SQL query with temp tables using 1.6jdk
I created a batch to run a query that has temp tables as the below example
IF OBJECT_ID ('tempdb..#TEMP1') IS NOT NULL
DROP TABLE #TEMP1
select *
into #TEMP1
from cutomer
IF OBJECT_ID ('tempdb..#...
1
vote
2
answers
3k
views
PostgreSQL: PreparedStatement to execute set schema command
I need to execute in a Java application a SET schema ? statement, where the placeholder is replaced by a value provided at runtime by the caller.
I assumed I could use PreparedStatement to overcome ...
1
vote
1
answer
7k
views
Syntax error using preparedstatements with postgresql
I have a Java application connecting to a PostgreSQL database.
Using straightforward code like:
ps = con.prepareStatement(sql);
if (dataTypes != null && dataTypes.size() >...
0
votes
1
answer
1k
views
In MySQL why is the first batch executed through client-side prepared statement slower?
I have around a million lines to be inserted into a MySQL (InnoDB) database, so to speed things up I turned to batch/multi-line insert. To be specific, I connect to the database (I'm using Java, so it'...