• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Connection problem via jdbc:odbc Ingres 2.6

 
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello Guys,

ERROR: failed to set isolation level: Invalid parameter value.

We have been using OC4J and INGRES DB , USING CARIBOU LAKE DRIVER. But, we have just upgraded the ingre DB to Ingre 2.6, which has its own jdbc driver. I have updated my data-source with the following in the OC4J config:

<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="Ingres"
location="jdbc/Ingres-DS"
xa-location="jdbc/xa/Ingres-XADS"
ejb-location="jdbc/Ingres-DS"
connection-driver="ca.edbc.jdbc.EdbcDriver"
username="user"
password="pass"
url="jdbc:edbc://host:JS0/jsvr/star"
inactivity-timeout="3600"
max-connections="1"

/>

And my data class access class method is :

public Connection getConnection() throws Exception
{
Connection conn = ConnectionManager.getIngresConnection("jdbc/Ingres-DS");
if (conn == null)
throw new RepositoryException("database connection failed");
try
{
conn.setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED);
}
catch (SQLException se)
{
try
{
conn.close();
}
catch (SQLException sse) {}

throw new RepositoryException("failed to set isolation level: " + se.getMessage());
}

return conn;

}

PLEASE, HELP. THANX
[ July 30, 2004: Message edited by: Gabriel Tomoloju ]
 
Ranch Hand
Posts: 823
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
That suggests that your new driver doesn't support dirty reads. I'm not sure if it is required to according to the JDBC spec... Does it support any other isolation levels? Does the connection work OK if you just leave the isolation level at the default and run some test code?

I suggest you take a look at the documentation for the driver to see if it says anything about which features are supported.

Jules
reply
    Bookmark Topic Watch Topic
  • New Topic