Retail Point-of-Service Solutions (MOSC)

MOSC Banner

OJDBC 7 + autoCommitSpecCompliant

edited Oct 28, 2019 12:10PM in Retail Point-of-Service Solutions (MOSC) 8 commentsAnswered

Hi,

I am having some errors in the log (An exception occurred while setting JDBC connection auto-commit to true for Datasource, looking on the internet I saw that in order to avoid that this property has to be set in the oracle connector:

autoCommitSpecCompliant=false

I tried using:

  <DataSource NetworkScope="LAN" name="StorePrimary">

    <Enabled dtype="Boolean">true</Enabled>

    <Strategy dtype="String">jdbcPersistenceStrategy</Strategy>

    <Property key="ConnectionFactoryClassName" value="${dtv.datasource.connectionfactory}"/>

    <Property key="ConnectionUserName" value="dtv"/>

    <Property key="ConnectionPassword" value="dtv"/>

    <Property key="ConnectionURL" value="jdbc:oracle:thin:@localhost:1521:orcl"/>

<!--     <Property key="ConnectionURL" value="jdbc:oracle:thin:@192.168.112.87:1521:orcl"/> -->

    <Property key="jdbc:SetBigStringTryClob" value="true"/>

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