Hot answers tagged

4

The idea behind the large object API is to mimic a file-like API. The OID is like the path of the file, and the file descriptor obtained by lo_open or lo_creat is the equivalent of the POSIX open() and creat() system calls for files. JDBC provides LargeObject.truncate() and the both libpq (in C) and the server have built-in lo_truncate() functions. So yes ...


3

The Instant Client is easier to install and more lightweight. It doesn't even need to be installed, you can just unzip it and use it. You don't need an Oracle Home either. On the other hand, it does not support deprecated features like Oracle Names. If you don't need any feature the instant client omits, I suggest you use it. It looks like you are covered ...


2

In WebLogic console, if you are selected XA Driver then it need additional drivers specific library files like sqljdbc.dll etc. Better to choose Oracle non XA driver(second item from the dropdown list) while you are configuring your datasource. HTH


2

Doesn't look like an issue with SQL Server. Here's a link which talks about connection being forcibly closed by sql server : https://technet.microsoft.com/en-us/library/ms187005(v=sql.105).aspx Also, the following post might help you analyze the error further : http://stackoverflow.com/questions/25611741/java-net-socketexception-connection-reset-by-peer-...


2

Consider batching your commits. A batch size of 1024 is a good starting size. Change batch sizes until you reach your optimum throughput.


2

To answer your question in the title: No. Consecutive queries in the same session (same transaction or not) are never concurrent. And there can only be one transaction at a time in the same session. Concurrency issues are impossible that way, those only happen between transactions in multiple sessions. One possible reason for your error message might be a ...


1

If you are connecting to an Oracle instance 11.2+, you can fetch data from the column temp_space_allocated of the view v$active_session_history, which shows the amount of TEMP memory (in bytes) consumed by your session at the time the sample was taken. Otherwise, you may look at the V$TEMPSEG_USAGE view, column blocks, and convert it to megabytes depending ...


1

Sounds like you are not properly deallocating objects like Statement, ResultSet, etc., so your application is holding open statement handles in the database. This will eventually exhaust "CLI Packages" in the database, resulting in the SQL0805N error. The proper solution is to make sure that you close these as soon as you're done reading them. You may ...


1

Suppose you have a web app with no connection pooling. Now suppose, also, that your web app leaks connections (does not close them properly - for example: by not using finally blocks in java). Leaky connections are much more problematic with a long wait-timeout (the default is 8 hours). The app will quickly run out of connections (mysql's "Too many ...


1

That stored procedure isn't installed on SQL Server by default. Seems like JDBC needs to do some kind of initialization on that server first. Compare the target server with a server where the connection does work - I'll bet you find a difference in some JDBC item in Programs and Features, or hopefully this has already rung a bell about something that had to ...


1

The standard template for a JDBC connection string to SQL Server is jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]] source Please make sure that TCP/IP has been enabled for your instance. By default, only Shared Memory is enabled in the Network Configuration of SQL Server Configuration Manager and only the (...


1

Have you tested or would it be possible to drop indexes on the destination DB table(s) where you are inserting into, insert those into smaller batched chunks (optimal as indicated above), and then rebuild the indexes on the destination table(s) once all inserts are complete? May be something easy enough to test to confirm.



Only top voted, non community-wiki answers of a minimum length are eligible