Re: Help !! Strange Database Issue - Almost solved

Fri, 15 Dec 2006 04:34:02 -0800

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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/f.jecker%40ch-rouffach.fr

This email sent to [EMAIL PROTECTED]


--


________________________________________

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 PROTECTED]
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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to