Re: JDBC: ERROR: portal "C_2" does not exist
| От | David G. Johnston |
|---|---|
| Тема | Re: JDBC: ERROR: portal "C_2" does not exist |
| Дата | |
| Msg-id | CAKFQuwYh56uwTpaPSf_Jp-_Kz9+vRbwBHVcHpHDJ=cVM20nTkQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: JDBC: ERROR: portal "C_2" does not exist (Blake McBride <blake1024@gmail.com>) |
| Ответы |
Re: JDBC: ERROR: portal "C_2" does not exist
|
| Список | pgsql-jdbc |
On Fri, Mar 11, 2022 at 8:47 PM Blake McBride <blake1024@gmail.com> wrote:
conn.setAutoCommit(false)
PreparedStatement pstat = conn.prepareStatement(sql)
pstat.setFetchSize(50)
select all records in a large file
for each record:
read one field from the record
through a second statement, add a record to a different table - XXX
execute the second statement - YYY
commit the change - ZZZ
loop
It seems I can do one or the other but not both - or can I?
Correct. What you are trying to do requires that you open two sessions to the database (conn_read, conn_write) and execute the INSERT command on the conn_write connection while looping through data on the conn_read one.
David J.
В списке pgsql-jdbc по дате отправления: