SQL Language (MOSC)

MOSC Banner

uncategorized SQLException

edited Dec 31, 2014 10:02AM in SQL Language (MOSC) 2 commentsAnswered

We have a query that looks like this:

1, (select 2 from dual) from dual

The imbedded select is causing the problem.

We use ojdbc5.jar.  We use JdbcTemplate, org.springframework.jdbc.core.jdbcTemplate.

When run, we get the message below. 

INFO : [main] org.apache.solr.client.solrj.impl.HttpClientUtil - Creating new http client, config:maxConnections=128&maxConnectionsPerHost=32&followRedirects=false

now executing myWork()... class com.replacements.orion.BulkLoad1.BulkLoad1 2014-12-05 12:39:22.033

INFO : [main] org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]

INFO : [main] org.springframework.jdbc.support.SQLErrorCodesFactory - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center