Re: Help !! Strange Database Issue - Almost solved
Re: Help !! Strange Database Issue - Almost solved
- Subject: Re: Help !! Strange Database Issue - Almost solved
- From: Frédéric JECKER <email@hidden>
- Date: Fri, 15 Dec 2006 13:36:02 +0100
After some investigations I found the reason of that strange
behaviour
I used the following code to check if the correct driver was loaded by
EOF :
EOModel model = EOModelGroup.defaultGroup().modelNamed("MonEOModel");
EODatabaseContext myEODatabaseContext =
EODatabaseContext.registeredDatabaseContextForModel(model, this.contexte);
JDBCContext myJDBCContext = (JDBCContext)myEODatabaseContext.adaptorContext();
//Attention, il est nécessaire de lancer une recherche avec EOF pour créer la connexion
Connection con = myJDBCContext.connection();
try {
DatabaseMetaData meta = con.getMetaData();
System.out.println("============================================================================================" );
System.out.println( "Database Product Name is.....: " + meta.getDatabaseProductName() );
System.out.println( "Database Product Version is...: " );
System.out.println( meta.getDatabaseProductVersion() );
System.out.println( "" );
System.out.println( "JDBC Driver Name is..........: " + meta.getDriverName() );
System.out.println( "JDBC Driver Version is........: " + meta.getDriverVersion() );
System.out.println( "JDBC Driver Major Version is..: " + meta.getDriverMajorVersion() );
System.out.println( "JDBC Driver Minor Version is..: " + meta.getDriverMinorVersion() );
System.out.println("============================================================================================" );
}catch( Exception ex ) {
System.out.println(ex);
}
EOF is loading the good jdbc driver but it seems to fail analysing the resulting data coming from the DbLink (created on Oracle 10g/AIX 64bit database)
Frédéric JECKER a écrit :
Moin List
I just put my app into production and discovered a strange and very
annoying problem.
In my app, EOF reads a table in my database which in fact is a synonym
on another table through a DbLink.
This runs fine in my developpements env.
On the production system, EOF fetches the records normally but some of
the values stored in the records
are null, others are good and other are simply unreadable (like if
there was a charset problem).
I used EOBuilder to browse the production system data and the result is
the same that my WOApp.
To check if this wasn't a driver issue i did the following:
I created a simple java app that connects throught jdbc to the database
and did a sql query to do the same
things that my WO app, additionnaly I printed the jdbc driver
informations (using databaseMeta)
I also modified my WO app to display the JDBC driver informations :
they are the same.
My WO app doesn't fetched the same results that my java app while
they're using the same JDBC driver and database
Help !
--
________________________________________
Frédéric
JECKER
PFaites
un geste pour l'environnement - avez vous réellement besoin d'imprimer
ce courriel ?
PPlease
consider the environment - do you really need to print this email ?
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
--
________________________________________
Frédéric
JECKER
Direction des systèmes d’information
Centre Hospitalier Rouffach
F- 68250 ROUFFACH
Tél : +33 (0)3 89
78 74
21
Fax : +33 (0)3 89 78 74
35
Courriel :
email@hidden
Web : http://www.ch-rouffach.fr
PFaites
un geste pour l'environnement - avez vous réellement besoin d'imprimer
ce courriel ?
PPlease
consider the environment - do you really need to print this email ?
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden